News for hackers. Stuff that matters.

A comment on Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses. Parent comment

Re:Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses by kall on Thursday February 04, 2021 @09:17AM (#26025462)
> there is a ton of already built tooling

Diving more into postgres recently, I‘m kind of surprised there is not the kind of tooling I know from (frontend) development. I would have expected there to be a number of tools for: version control, CI/CD, (integration) testing, performance monitoring, safe migration, developing stored procedures (in vscode, with hot reload), data shuffling (snaphshots, rollbacks...). Both open source and startups, SaaS services with online dashboards etc.

There are some ok options in these categories but nothing like the explosion of open source tooling out of bigcos and devtools/SaaS startups you see elsewhere.

There‘s... aurora, prisma, some pg extensions to get performance info?

[ Parent | on HN ]
Re:Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses by underbluewaters on Thursday February 04, 2021 @10:04AM (#26025878)
Absolutely! I evaluated a bunch of migration management tools recently and was very disappointed. I needed something to develop and version stored procedures and just didn't find much. Ended up using graphile-migrate which has been great but also tightly bound to other parts of my stack. Would have expected more options from a 30+ year old technology.
[ Parent | on HN ]
Re:Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses by FrancoisBosun on Thursday February 04, 2021 @12:08PM (#26027340)
If you haven't, Sqitch[1] is a great tool.

[1] https://sqitch.org

[ Parent | on HN ]
Re:Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses by ncrmro on Thursday February 04, 2021 @10:11AM (#26025944)
Just started using graphile migrate after hand rolling some shell scripts initially

And working pretty nicely so far

[ Parent | on HN ]