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.
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.
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.
A technical guide on configuring Django to force SSL connections to a PostgreSQL database server.
A technical guide on generating and downloading CSV files from an ASP page by querying a SQL database and setting HTTP headers.
MongoDB 1.8.0 Release Candidate 2 is now available for download, featuring several updates and changes.
Announcement for the SQLSoton User Group meeting on March 9th, 2011, featuring a talk on SQL Server replication.
MongoDB 1.8.0 Release Candidate introduces key features like write-ahead journaling for durability, sparse indexes, and enhanced Map/Reduce.
Announcement for the MongoUK 2011 conference in London, covering MongoDB topics like schema design, indexing, and scalability.
SQL Southampton User Group announces a room change to a larger hall within the same venue for its upcoming meetings.
Explains the GROUPING SETS operator in SQL Server for flexible data aggregation, comparing it to UNION ALL and WITH CUBE approaches.
