To keep things simple I've created a new Payload website with create-payload-app and chose Sqlite for a db. I accepted the default connection string/url, of file:./panda-payload-sqlite.db. Now when I start the app up I get this error:
ERROR: Error: cannot connect to SQLite: URL_INVALID: The URL 'host=127.0.0.1 port=5432 dbname=postgres user=postgres connect_timeout=10 sslmode=prefer' is not in a valid format
My .env file only has this:
# Database connection string
DATABASE_URL=file:./panda-payload-sqlite.db
# Or use a PG connection string
#DATABASE_URL=postgresql://127.0.0.1:5432/your-database-name
File payload.config.ts contains this
db: sqliteAdapter({
client: {
url: process.env.DATABASE_URL || '',
},
}),
Why is whatever it is trying to use a phantom Postgres connection string?