Search results for postgres install source code

K8s on Windows/VirtualBox

By Franck Pachot . This is a little demo, easy to copy-paste, if you want to play with Kubernetes on your laptop. And, not a simple “Hello World” but a real database running here, able to scale up and(…)

temBoard on SLES15 – 1 – The WebUI

During our last SwissPUG online meeting there was a presentation about monitoring PostgreSQL with temBoard. A question that came up afterwards was: How to install that on SLES 15 as there(…)

Should CPU-intensive logic be done in the DB or in application server?

By Franck Pachot . Should CPU-intensive logic be done in the DB or in application server? Here was a answer found in Reddit: Comment byu/CacheMeUp from discussion inPostgreSQL Reducing the(…)

Foreign Keys in MySQL, SQL, NoSQL, NewSQL

By Franck Pachot . In the NoSQL times, it was common to hear thinks like “SQL is bad”, “joins are bad”, “foreign keys are bad”. Just because people didn’t know how to use them, or they were running on(…)

Google Cloud SQL Insights: ASH, plans and statement tagging

By Franck Pachot . Looking at database performance has always been necessary to optimize the response time or throughput, but when it comes to public cloud where you are charged by resource usage, performance tuning is critical for cost(…)

Google Spanner – SQL compatibility

By Franck Pachot . I have posted, a long time ago, about Google Spanner (inserting data and no decimal numeric data types) but many things have changed in this area. There(…)

DctmAPI.py revisited

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(…)

Easy failover and switchover with pg_auto_failover

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(…)

Deploy GitLab on Kubernetes using Helm

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(…)

What is EDB?

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(…)