NGINX PostgreSQL Module: Direct Database Queries
by Danila Vershinin, March 18, 2026
Learn how to use the NGINX PostgreSQL module (ngx_postgres) to query PostgreSQL databases directly from NGINX — without any application server. Build lightweight REST APIs, implement database-driven authentication, and eliminate middleware overhead with built-in connection pooling and SQL injection prevention.
Read More...NGINX SQLite Logging: Queryable Access Logs
by Danila Vershinin, March 12, 2026
Learn how to store NGINX access logs in SQLite databases for powerful SQL-based analysis. The ngx_http_sqlitelog module replaces flat text log files with structured, queryable databases — making traffic analysis, bot detection, and error tracking dramatically easier.
Read More...Improving WordPress database performance with cleanup and maintenance
by Danila Vershinin, September 4, 2022
Improve MySQL database performance for WordPress by adding high-performance keys and other maintenance tasks.
Read More...How to deal with a huge Magento 2 database
by Danila Vershinin, April 29, 2020
Cleanup huge Magento 2 database with simple SQL queries and/or do it regularly via cron.
Read More...Protecting Magento 2 from SPAM registrations
by Danila Vershinin, March 4, 2020
Fight SPAM registration in Magento 2 by fixing… Magento 2.
Read More...Fix Magento 1.9.x timezone after migration
by Danila Vershinin, March 6, 2018
Here’s how to fix that wrong time in Magento 1.x post migration to another server.
Read More...Recommended Web Hosting
