A talk from DjangoCon Europe 2021 on leveraging PostgreSQL's advanced features within Django projects for enhanced database capabilities.
Diagnosing and fixing Azure App Service backup failures due to a 10GB size limit, with a solution to exclude the database.
A deep dive into DynamoDB partitions, explaining their role in data modeling and performance for the NoSQL database.
Announcing the free release of 'Practical MongoDB Aggregations', a book with tips and examples for developers and data professionals.
A guide to using SQL for efficient data analysis, comparing performance with pandas and demonstrating advanced SQL techniques.
Explores case-sensitivity handling in Aurora PostgreSQL, comparing native collations with the CITEXT extension for case-insensitive operations.
A detailed overview of new features in Django 3.2, focusing on ORM improvements like covering indexes, JSON object building, and new admin decorators.
Explores how to use MongoDB aggregation pipelines to mask sensitive data for testing and API access, with practical examples.
A guide to understanding and using DynamoDB Condition Expressions for enforcing data integrity and business rules in AWS.
A beginner-friendly guide explaining what Core Data is, why it's needed for iOS/macOS apps, and how it simplifies data persistence.
A tutorial on connecting to a MongoDB database using the Mongoose ODM library in JavaScript, including setup, schemas, and queries.
A technical deep dive into automating internal infrastructure and data workflows using Rust, cron jobs, and a central database.
A technical guide on managing and cleaning up custom search engines in Google Chrome by directly manipulating its SQLite database.
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.
