PgBouncer, Pgpool-II and others: A proxy for PostgreSQL 🐘

2025-10-30

A PostgreSQL proxy or connection pooler is an intermediary application that sits between your client applications and one or more PostgreSQL servers. It speaks the PostgreSQL network protocol, which allows any standard client (for example, your web server or an application in Java/Python/Go) to connect to the proxy believing it is talking directly to a PostgreSQL server.

Unlike MySQL, where proxies are often used for read/write splitting (R/W split) or caching, in the PostgreSQL world the main task of a proxy is efficient connection management.

117 | phpMyAdmin or Adminer? What if you have PostgreSQL? 🐘 A simple guide to choosing a database tool

2025-10-08

Congratulations! You just set up your web server (LAMP, LEMP, or something else) and are ready to build awesome websites. You have an operating system, a web server, a programming language, but one important puzzle piece remains — the database. Managing it without a convenient tool is like fixing a car without a wrench. 😅

If you use MySQL or MariaDB, you’ve probably heard of phpMyAdmin and Adminer. If you chose PostgreSQL, you also have great options! Let’s figure out which tool to choose so working with your database is easy and pleasant.

How to Restore Access to WordPress Administrator: Resetting Password via Database

2025-07-14

Losing access to the WordPress administrator account can be a real headache. Sometimes, standard password recovery methods (via email) don’t work, especially if:

• You forgot both your login and password.
• The site’s mail sending function (wp_mail) is broken.
• The WordPress admin panel is broken or unavailable.
• The only access left is to the database (via MySQL client, phpMyAdmin, WP-CLI, etc.).

In this article, we’ll walk through a reliable and secure way to find the WordPress administrator directly in the database and reset their password using SQL. We’ll follow DevSecOps best practices to avoid breaking serialized data and minimize risks.