A guide to customizing and enhancing the PostgreSQL command-line interface (psql) for improved productivity and workflow.
Announcing django-db-tools, a lightweight Django utility for enabling read-only or GET-only modes during large database migrations.
Argues that SQL databases are inherently non-scalable, questioning the effectiveness of traditional scaling techniques like caching and sharding.
A guide to database sharding, explaining what it is, why it's needed, and how to implement logical and physical shards for scaling.
Explains Drupal's node access system, covering the node_access table, grant records, and module hooks for implementing role-based access control.
A developer shares his approach to writing clean, readable SQL with practical examples and best practices for structuring queries.
A tutorial on using PostgreSQL array fields within Django models to simplify data structures like tags, improving performance and code clarity.
Explains why MySQL's 'utf8' charset is incomplete and how to use 'utf8mb4' for full Unicode support, including emojis.
Explains how to implement schemaless data storage in Django using PostgreSQL's hstore extension as an alternative to MongoDB.
Guide to running Oracle BI Repository Creation Utility (RCU) from the command line for silent, unattended installations.
A detailed exploration of advanced PostgreSQL features like concurrent indexing, transactional DDL, and foreign data wrappers.
A detailed list of technical advantages and features that make PostgreSQL a powerful and versatile database choice for developers.
Explains how to instrument OBIEE database connections for improved performance diagnostics and user session tracking.
Fixing Oracle tnsping error 'Message 3513 not found' on Windows by adjusting the PATH variable order after installing a new Oracle version.
Oracle releases OBIEE 11g for HP-UX Itanium, surprising the author who doubted it would happen.
Explains the importance of defining CLIENT_ID in OBIEE for user query tracking and troubleshooting database calls.
A technical guide on integrating MongoDB, a NoSQL document database, with the Spring Data framework for Java applications.
Explains the concept of 'working set' in databases, its importance for performance, and how to manage it, with examples focused on MongoDB.
