A guide on programmatically dropping all collections in a MongoDB database using Mongoose, useful for resetting a database during testing.
A guide on using PostgreSQL's FOR loop to generate test data for development and UI testing.
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.
