Learn how Django uses models to store user data from forms into a relational database, covering setup and core concepts.
A tutorial on performing table joins and querying database models using the Fluent 4 ORM framework in Vapor for Swift.
Explains how to programmatically query Alfred's clipboard history, stored as a SQLite database, using SQL commands.
Extending a SQL database in Go to support indexes, focusing on PRIMARY KEY constraints and SELECT optimizations using tree structures.
Extending a SQL database implementation in Go to support binary expressions and WHERE clause filtering.
A guide on deploying Django model changes to production using migrations, covering a simple method and best practices.
A guide to creating and using abstract base classes in Django to reduce code repetition for common timestamp fields like 'added' and 'edited'.
Azure Cosmos DB now offers a Free Tier with 400 RUs and 5GB storage, enabling free development and testing for small applications.
A tutorial on building a basic SQL database from scratch in Go, covering parsing, an in-memory backend, and a REPL for CREATE, INSERT, and SELECT.
A tutorial on creating a custom Django management command to populate a database from an external API, using a beer data example.
A guide on setting up and running PostgreSQL and pgAdmin using Docker Compose for local development.
A step-by-step guide to installing and configuring MongoDB on macOS, including specific instructions for Catalina and newer versions.
A guide to Amazon DynamoDB Transactions, covering use cases, differences from batch operations, and idempotency handling.
A concise guide to using Laravel's HasManyThrough relationship with a practical database schema and code example.
Summary of key new features in SQL Server 2019 Standard Edition, including Transparent Data Encryption (TDE) and performance enhancements.
A developer's wish list for new DynamoDB features, including filtered streams and Redis-like operations.
A post-mortem analysis of a production outage caused by a broken Django migration, and the introduction of django-test-migrations for safer database changes.
Announcement and review of 'The Art of PostgreSQL', a book teaching how to replace complex application code with efficient SQL queries.
Announcement for SQLSaturday Lisbon 2019 and Porto 2019, including dates, call for speakers, and workshop topics.
