Migrating in JS & JSON (no filesytem)
👋 we're big fans (and sponsors) of Drizzle at Val Town. We use it internally and love it.
We just shipped an integration with Turso to give every Val Town user a SQLIte database, and I'm happy to report that I got Drizzle working in that environment!
Integration: https://www.val.town/v/std.turso
Working with Drizzle: https://www.val.town/v/stevekrouse.tursoDrizzleExample
We'd love to get DrizzleKit working for migrations (our users are already asking for it) but it seems like DrizzleKit requires files and a filesystem for your migrations. Val Town doesn't have files or a filesystem – is there any way you could supply your migrations as an array of some json objects?
Val Town
@std.turso
Turso – a SQLite database for every Val Town user turso (2).png Turso is a serverless SQLite platform designed for the edge. It runs libSQL , their open contribution fork of SQLite. Every Val Town user automatically gets their own Turso SQLite database! It's great for >100kb data (ie bigger than a val) or when you need SQL: relations, ACID tr...
4 Replies
hey, @steve
just got back from work
let me check everything
second link doesn't work
I see, yes, our migrator is supposed to be used from an environment with files, since it expects files with SQL migrations in the file system