A guide to using the $project stage in MongoDB's aggregation pipeline, covering field inclusion, exclusion, and array operations.
A talk on leveraging PostgreSQL's advanced features within Django projects, presented at Pyjamas Conf 2021.
Microsoft PM announces a series of public presentations on Azure SQL Managed Instance, covering new features, HA/DR, performance, and monitoring.
An appreciation of PostgreSQL's power, reliability, comprehensive documentation, and disciplined engineering team after 25+ years of development.
A talk on leveraging PostgreSQL's advanced features within Django projects, presented at EuroPython 2021.
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.
