kevinoconnell

whats the easiest way to set up postgres DB migrations in typescript if you already have a working database and you were too lazy to set them up initially?

(speaking for a friend, totally not me guys don't worry)

ideally can dump a given DB schema and run a command to generate them so others can run it locally much easier

i use this https://www.npmjs.com/package/pg for my db

I ended up using https://orm.drizzle.team/

It was really easy to set up, one great part about it for me was that I didn’t have to convert my whole db to drizzle right away, i converted small functions to use drizzle and the more dangerous changes i can wait to do later. It was also super easy to introspect.

s/o @alexgrover.eth for the suggestion 🙂

likes building things • https://alexgrover.me