drizzle with DO SQLite
sort of, i use drizzle kit to manage migrations and a custom query proxy which applies the same types used in drizzle kit to queried results (i.e. int to js date, etc.)
2 Replies
Unknown User•2mo ago
Message Not Public
Sign In & Join Server To View
no, since DO is running off a separate worker, whether i make an rpc call or a fetch call (locally) to the DO, my main app which owns the schema for the DO processes all SQL query responses with the aforementioned type handler before my app can use them, saves me the trouble of worrying about 0/1 for bool, json parsing etc. manually.
I still have to remember to run inserts/updates with the right data types being int for date and boolean, and to stringify my json.