SQLite

[zubricks]

We’ve built out the adapter pattern for SQLite and will be able to finish support for SQLite once Drizzle completes the work on their end. From there we’ll perform thorough testing before merging in to core.

[rednithin]

Will this support Turso?

[nathanaelphilip]

This is the big brain move.

[Xadoy]

Or better: astro db

[oskbor]

Excited for sqlite support! Any update on when it might be released?

[sammwashere]

Would also love an update on this, excited to use Payload with Turso!

[mrdankuta]

Hi! Any updates on this? I am eager to see this released.

[kimstewartca]

Hi @zubricks
Just following up on your post from last year.
Would you happen to know if there are any updates on this?
Thank you!

[janus-reith]

It would be nice to get an idea of the actual steps involved — Would this just work out of the box using drizzle or are there additional changes necessary, are they any hard blockers where some Postgres specific features are required that don't work the same way with sqlite?

[zubricks]

Hey everyone—before we can make this happen we need to get postgres stable. We’re aiming to have postgres complete for 3.0 launch (early next week). From there we can abstract the core logic to make it reusable across other relational dbs including SQLite—likely a couple of weeks after 3.0 launch.

We’re aiming for feature parity with postgres and keeping as much code unified as possible through the adapter. Our expectation is that everything will be able to work the same way.