Posted inPython
A Guide to DiskCache in Python: Safe Multi-Process Disk Caching Without Redis
Boost Python performance on low-RAM servers with DiskCache: safe, high-speed multi-process disk caching without installing or managing Redis.
Posted inMySQL
MySQL Spatial Data: The Ultimate Guide to Handling GPS Coordinates and Finding Nearby Locations
Is calculating GPS distance with DECIMAL slowing down MySQL? Discover how to use Spatial Data, POINT, and Spatial Index to optimize nearby location searches for maximum speed.
Posted inDatabase
Memcached: When to Choose This ‘Veteran’ Over Redis?
Memcached remains a top choice for systems requiring massive throughput. Explore installation guides, real-world comparisons with Redis, and security tips to keep your system safe.
Posted inDatabase
PostgreSQL Full-Text Search: High-Performance Vietnamese Search Without Elasticsearch
Don't rush to install Elasticsearch! A detailed guide on building high-speed, accurate Vietnamese search directly in PostgreSQL using only tsvector and GIN Index.
Posted inMySQL
MySQL 8 CTE: A Professional Solution for Hierarchical Data and Recursive Queries
A detailed guide on using CTE and Recursive CTE in MySQL 8 to efficiently handle hierarchical data, replace complex Self-joins, and optimize query performance.