A patch fixes a bug in daloRADIUS's user refill feature, correcting a database column name in the billing history table.
A retrospective on the first year of the Postgres Weekly newsletter, highlighting key articles, extensions, and community insights about PostgreSQL.
Overview of new PostgreSQL 9.4 features, focusing on the performance benefits of JSONB for document storage and the introduction of logical decoding.
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 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.
