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.
Explores SQL Server 2019's new 'Feature Restrictions' security feature, designed to help prevent SQL injection attacks.
Author shares excitement about presenting two technical sessions on SQL Server Columnstore Indexes and Batch Execution Mode at the PASS Summit 2019 data platform conference.
Explains SQL Server 2019's Froid feature for inlining Scalar T-SQL UDFs to improve performance, with caveats and function type context.
A technical guide comparing Python methods for efficiently loading and transforming large, messy datasets into a PostgreSQL database.
Explains SQL injection risks in Laravel's query builder, focusing on unsafe functions like addSelect and JSON shorthand, with a fixed vulnerability example.
