Deploy to CloudFlare Pages and using D1 & R2
Hi, I just fall in love with Manifest at first sight, what a cool idea to start define backend with yml config.
Is there anyway I can deploy this to CloudFlare and use D1 (Sqlite) as database? Or do we have any plugins/integration api that allow adding support for this?
3 Replies
Hello @Toàn thank you for your message. Currently the sqlite DB is used only in local, but you can use any MySQL or Postgres remoteDB like https://neon.tech/ for example. I didn't know about the D1 service, it seams like a managed SQLite like Turso right ?
Neon
Neon Serverless Postgres — Ship faster
The database you love, on a serverless platform designed to help you build reliable and scalable applications faster.
Yeah exactly. It mostly the same as SQLite, its usage is a bit different from tradtional DB: you have to get the DB instance from the context (called "bindings"), instead of creating one using connection string. That's why I'm asking if we have any plugin API to extends the database adapter, since using env
DB_CONNECTION will not workI will have a look on this @Toàn and I'll let you know