I'm currently researching how to migrate the built-out Sqlite database to Postgres!
I discovered pgloader to help with this. I also need to figure out the kinks when dealing with pg + knex... and should i look into objection? I'll keep this in mind...
I managed to install and start setting up pgloader. I realized I had to have pg running for it to work lol... Last thing I worked on here was an error in the formation of my pg uri so I need to figure that out next.