A developer's personal appreciation letter to PostgreSQL, reflecting on its evolution, robust features, and adaptability over the years.
A preview of the 2017 Postgres Open Silicon Valley conference lineup, highlighting key talks on PostgreSQL indexing, scaling, and concurrency.
Debunks the myth that complex software like Google Search is easy to build, explaining why it requires vast engineering resources.
A summary of recent blog posts and presentations by Guido van Rossum, the creator of Python, covering topics like 0-based indexing and Python 3.
Analyzing MongoDB query performance using $exists operator and the impact of indexes on large datasets.
Explains how to use PostgreSQL expression and functional indexes to optimize queries using built-in functions or custom JavaScript functions.
A guide for developers on monitoring and improving PostgreSQL database performance, covering cache hit rates and index usage.
A detailed exploration of advanced PostgreSQL features like concurrent indexing, transactional DDL, and foreign data wrappers.
MongoDB 1.8.0 Release Candidate introduces key features like write-ahead journaling for durability, sparse indexes, and enhanced Map/Reduce.
A technical guide on optimizing SQL queries with wildcard-prefixed LIKE conditions using indexed computed columns for better performance.
How rewriting a MySQL query to use indexes properly improved performance from 10 seconds to 0.03 seconds.
Explains how to optimize SQL query performance by avoiding functions in WHERE clauses, using date filtering as a key example.
Zend Framework 1.7 now includes native OpenXML indexing support for Lucene, simplifying document search integration.
Guide to configuring search and indexing in MOSS 2007, including content sources, search scopes, and Search Center customization.
