How should i self host a sqlite server for a turborepo project?

[ridhwaans]

I am using drizzle-orm/sqlite-core as the database provider for a turborepo project. In the turborepo project, the following services will need the database for reads and writes:

• @turborepo/apps/web
• @turborepo/packages/api
• @turborepo/packages/auth
• @turborepo/packages/core

At the moment, the sqlite db lives in @turborepo/packages/db. It has a set of drizzle commands like generate and migrate, and it has the connection string with the file prefix

DATABASE_URL='file:../../packages/db/local.db'

export default {
  dialect: 'sqlite',
  schema: './src/schema/index.ts',
  out: './drizzle',
  dbCredentials: {
    url: env.DATABASE_URL,
  },
} satisfies Config;

I am having a hard time deploying the db for the services in docker containers in staging and prod.

how should i rewrite the db? Should it lose the file url and become an http server with a query endpoint?

I am not interested in cloud db as a service like turso, libsql, flyio. I want to self-host

Thanks in advance