When it comes to connection pooling in the PostgreSQL world, PgBouncer is probably the most popular option. It's a very simple utility that does exactly one thing “ it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. A client connects to PgBouncer with the exact same syntax it would use when connecting directly to … [Read more...] about PostgreSQL Connection Pooling: Part 2 PgBouncer
developers
PostgreSQL Connection Pooling: Part 1 Pros & Cons
A long time ago, in a galaxy far far away, threads' were a programming novelty rarely used and seldom trusted. In that environment, the first PostgreSQL developers decided forking a process for each connection to the database is the safest choice. It would be a shame if your database crashed, after all. Since then, a lot of water has flown under that bridge, but the PostgreSQL … [Read more...] about PostgreSQL Connection Pooling: Part 1 Pros & Cons
Managing High Availability in PostgreSQL Part III: Patroni
In our previous blog posts, we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by Cluster Labs and Replication Manager (repmgr) by 2ndQuadrant. In the final post of this series, we will review the last solution, Patroni by Zalando, and compare all three at the end so you can determine which high availability framework is best for your … [Read more...] about Managing High Availability in PostgreSQL Part III: Patroni
Which is the Best MongoDB GUI? 2019 Update
A good UI is an important part of the development experience. The MongoDB Shell works great for administrative actions, but when working with larger amounts of data, the UI becomes fairly important. In 2014, we discussed 4 of the top MongoDB GUIs: MongoVue, MongoHub, RockMongo, and Robo 3T (formerly Robomongo), and again in 2016: MongoDB Compass, Robo 3T, Studio 3T, and … [Read more...] about Which is the Best MongoDB GUI? 2019 Update
Machine Learning Drives Skyrocketing Demand for Entry Level Python Coders
Even professional engineers are often dismayed by the pace of change in the technology industry. One of the biggest examples is with the emergence of machine learning. Only a few years ago, very few people had ever heard of the term. Today, it is growing faster than ever. One study shows that the machine learning market will be worth over $19 billion by 2023. Since demand for … [Read more...] about Machine Learning Drives Skyrocketing Demand for Entry Level Python Coders