Enterprise content management DctmAPI.py revisited 31.12.2020 by Middleware Team 2 years ago, I proposed a ctypes-based Documentum extension for python, DctmAPI.py. While it did the job, it was quite basic. For example, its select2dict() function, as inferred from its name, returned the documents from a dql query into(…)
Database Administration & Monitoring Easy failover and switchover with pg_auto_failover 10.12.2020 by Daniel Westermann One the really cool things with PostgreSQL is, that you have plenty of choices when it comes to tooling. For high availability we usually go with Patroni, but there is also pg_auto_failover(…)
DevOps, Docker, Kubernetes Deploy GitLab on Kubernetes using Helm 10.11.2020 by DevOps Over the last years GitLab became one of the most popular and powerful open source git source code platform. From pure source code repository to a DevOps platform, it’s interesting to see how GitLab has evolved and(…)
Database Administration & Monitoring What is EDB? 01.11.2020 by Open source Team Last few days I played around with EDB tools. In this Blog I will introduce you to EDB. What is EDB? PostgreSQL is Open Source and has no owner. The owner of PostgreSQL is the community itself. That means, if(…)
Cloud, Database Administration & Monitoring, NoSQL YCSB (NoSQL benchmark) on Oracle Database 12.10.2020 by Oracle Team By Franck Pachot . The NoSQL technologies emerged for Big Data workloads where eventual consistency is acceptable and scaling out to multiple server nodes is an easy answer to increase throughput. With cloud services rising, those key-value document datastores(…)
Database Administration & Monitoring Patroni 2.0: New features – Patroni on pure Raft 11.09.2020 by Open source Team Last week the new Patroni 2.0 release was published which brings many new features. But one makes me absolutely curious. At the moment only as BETA, but I had to test it. Patroni on pure Raft. It's possible to run(…)
Oracle Oracle recovery concepts 29.03.2020 by Oracle Team I’ve published a while ago a twitter thead on some Oracle recovery concepts. For those who are not following twitter, I’m putting the whole thread here: 🔴⏬ Here I start a thread(…)
Database Administration & Monitoring Migrating an Oracle instance to AWS Aurora – 1 – Setting up the base infrastructure 17.03.2020 by Daniel Westermann Migrating database to the cloud is a hot topic since a few years. As more and more of our customers are in the cloud, and some of them in AWS, migrating some of their Oracle databases(…)
Development & Performance Refactoring procedural to SQL – an example with MySQL Sakila 01.03.2020 by Open source Team By Franck Pachot What I want to show in this blog post is that, as in mathematics where you have to apply some algebra rules to transform an equation to an equivalent one, the database developer must translate the business(…)
Database Administration & Monitoring Documentum Administrator in a Container 01.10.2019 by Middleware Team In article A Small Footprint Docker Container with Documentum command-line Tools, we presented a possible way to containerize the usual Documentum clients idql, iapi, dmawk and dmdocbroker.