8 ms·
Is this an observation or have you done/seen this in action? I ask because for my next project I'd like to tackle the issue of having to keep lots of Databases
by flannell 10y ago
Is this an observation or have you done/seen this in action?
I ask because for my next project I'd like to tackle the issue of having to keep lots of Databases up to date with their stored procedures. Kind of wanted a common library of procs that any DB can access. I've seen third party Software do DB versioning etc but too expensive for me. A few do it via package management, but keen to see how others are doing it!
- tiffanyh 10y agoI don't know if Postgres can do what you're describing but I know Oracle can and it's called Pluggable Databases (PDB) and it's designed exactly for this use case. (Now I just hope I don't get flammed)
- flannell 10y agoInteresting thanks, I'll look into it. Your earlier comment has sent me down a Postgresql logicdecode/Kafka/Hadoop rabbit hole. Funny where you end up.
- snuxoll 10y agoIn PostgreSQL extensions are the common way to solve it, you still have to manually install/uninstall in each database but writing them is pretty straightforward and a quick call to CREATE EXTENSION/DROP EXTENSION in your migrations isn't too much to ask in most cases.