search

matthieu-foucault / postgit

Integrate declarative PostgreSQL schema migrations with Git
GNU General Public License v3.0
8 stars 0 forks source link

Project status #22

Closed FelixZY closed 6 months ago

FelixZY commented 6 months ago

I was looking around for a good way of declaratively managing my pure-sql Supabase project and found your blog post and this project.

However, I see that there has been next to no activity for the past 2 years - I therefore wanted to ask what the status of this project is?

jonkurtis commented 6 months ago

We need something like this @kiwicopple. The DX of prisma migrations with the power of @supabase postgres

matthieu-foucault commented 6 months ago

As you can tell from the commit history and the README, this was a short proof-of-concept (and a way to learn Rust) more than anything.

Is it usable?

Somewhat. The commands in the README worked at the time, but you'd still need to figure out how to track which commit is deployed in your database, so that you know what to the source commit is when you run your diff

Is it maintained?

I have not maintained it at all. The diff tool I chose to use (migra) seems to be unmaintained as well.

Are there any known issues? Should I be worried about the time since last commit or can the project be safely used several years out-of-date?

If I was evaluating a tool to use in a project, this would be a red flag. I probably wouldn't recommend using this unless you're willing to fork the repo and fix issues yourself if you find any. I'm not aware of any issue, but then I haven't looked at this project, or used it since 2022

Is there an installation guide? It would be really nice if the project could be installed directly via cargo install f.ex..

No, sorry. Only what's in the README

Are there any similar tools you'd recommend /instead/?

When I worked on this (Nov 2022), there was no other tool I could find for declarative SQL migrations.

I know supabase did look into this space (https://supabase.com/blog/supabase-cli#choosing-the-best-diff-tool), but not sure if that went anywhere.

FelixZY commented 6 months ago

Thank you very much @matthieu-foucault . Given the research I've done in the past few days, I'm pretty sure there is still space for a tool like this in the SQL programming world, if you (or somebody else) would be willing to maintain it. Personally, I'm not familiar enough with the domains involved at this time unfortunately.

I agree with @jonkurtis that a tool like this would be great addition for Supabase. It would also be nice to see development without vendor lock-in. Perhaps the maintainers of pgdiff or sqitch could be convinced to integrate functionality similar to this project in their projects? 🤔