3 ms·
> compilation to native code, graphical debugger. You have this on postgresql. > RAC and distributed transactions across a database cluster Needed only in te
by thda 6y ago
> compilation to native code, graphical debugger.
You have this on postgresql.
> RAC and distributed transactions across a database cluster
Needed only in telcos where galera would be enough
- pjmlp 6y agoSo where is the graphical debugging support and how do I single step a stored procedure? I have used distributed transactions at life sciences.
- thda 6y agodbeaver and plugin_debugger. For distributed transactions, it all depends on why you need them in the first place but there are multiple solutions in postgres to handle them.
- pjmlp 6y agoSo some third party solution, and not first class support from the RDMS vendor. That is not the same as using Oracle.
- thda 6y agoPlugin_debugger is availlable on postgresql.org's repo. And supported by our postgresql support provider. You can of course use pgadmin, the official tool, with this plugin. You should reassess your critics before posting, I think. The evolution of postgresql is faster and faster.
- pjmlp 6y agoI have spent 2014 to 2018 doing PostgresSQL deployments alongside Oracle, I know how good those offerings are versus Oracle. Pushing for those plugins as alternative just shows how little one knows about the feature level of Oracle capabilities.
- thda 6y agoIndeed and the last two years in postgresql history have been very rich feature wise. I have managed teams of database administrators for roughly 10 years. And I know that using those arcane features or depending too much on those capabilities has cost millions to my company. Avoid implementing everything in a database.
- derefr 6y agoPostgres isn't an RDBMS "vendor." Third-party service providers are who you have relationships with. It's like Linux vs. Windows. You don't have a relationship with "Linux"; you have a relationship with RedHat or Canonical, who take responsibility for integration, support, and maintenance of their upstreams (kernel, core libraries, userland packages, etc.)
- pjmlp 6y agoApparently not, otherwise there wouldn't exist something like "The PostgreSQL Global Development Group". Anyone trying others to adopt their products is a vendor, regardless if they are commercial or open source. Also Linux is just a kernel, naturally it needs a vendor like RedHat or Canonical to provide an actual product. Postgres is a RDMS already out of the box.
- thda 6y agoAs answered, pgadmin is first class and supports debugging.
- derefr 6y agoPGDG is effectively an industry consortium of the aligned interests of corporate members—i.e., the vendors. Things don’t “happen” at the level of PGDG, any more than things happen at the level of the UN. Both organizations are there to create opportunities for consensus between members; but in both organizations, it’s the individual members that then go on to actually do things, mostly without one-another’s help.