A technical tutorial on implementing ASP.NET Identity with Entity Framework for database-backed user authentication in an MVC application.
A historical account of Oracle's poor performance in a 1983 database benchmark and their alleged attempt to have the professor behind it fired.
A developer's perspective on missing features in PostgreSQL 9.4, focusing on upsert, JSON performance, and extension management.
A first look at PostgreSQL 9.4's new features, including pg_prewarm, concurrent materialized view refresh, and ordered set aggregates.
Explains how to use JOIN operations in JPA finder queries within the Play Framework to filter tasks by a related user's name.
A guide to using PostgreSQL Foreign Data Wrappers (FDWs) to access remote data as if it were local tables, including setup and performance tips.
A guide to using SQLite and Python's sqlite3 module to efficiently manage and query large datasets from text files.
A technical guide on using SQLite and Python's sqlite3 module to efficiently manage and query large datasets, replacing slow text file processing.
A guide to using JSON operators and functions in PostgreSQL 9.3, covering data extraction and manipulation from stored JSON.
An analysis of PostgreSQL's documentation strengths and gaps, proposing improvements for onboarding, tutorials, and developer guides.
A tutorial on using Python's sqlite3 library to create, connect to, and manage SQLite databases, including tables and data.
Compares hstore and JSON data types in PostgreSQL, discussing their features, limitations, and use cases for schema-less data storage.
A developer shares common SQL bad habits like using column numbers in ORDER BY, implicit joins, and lacking comments, with examples and better practices.
A guide to using PostgreSQL's array_agg function to efficiently aggregate and format data, avoiding manual application-level processing.
A database expert reflects on the 2013 Frankfurt Database Days conference, comparing SQL Server and Oracle features like isolation levels and security.
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.
