MongoDB Atlas SDK: A Modern Toolkit

The MongoDB Atlas SDK simplifies database management by wrapping the Atlas API in an intuitive, developer-friendly design. It enhances productivity with robust functionality, seamless integration, and modern practices. While it has minor quirks like vague error messages, it remains a valuable tool for both new and experienced MongoDB users looking for efficiency. Continue reading →

Rethinking My Vinyl App for MongoDB & Atlas

This post discusses migrating the Collector’s Tune Tracker (CTT) from PostgreSQL to MongoDB, utilizing features from MongoDB Atlas. It emphasizes the need for careful design decisions regarding data embedding and referencing, multi-tenancy, and security. The author highlights Atlas features like GraphQL, Triggers, and Search that enhance development efficiency and offer a modern data management approach.... Continue reading →

Reviewing MongoDB Data Workload Migrations

Over the last few years I’ve worked on and led a number of workload projects related to various databases. MongoDB is one of those databases. With some of the ongoing questions I’m asked I found myself wanting to review what the current options are for workload migrations to Mongo DB. Are there new options, is... Continue reading →

Setting Up SQLite on Windows 11: A Guide for Developers

SQLite is a lightweight, serverless, and self-contained database solution ideal for small-scale projects or testing. On Windows 11, it lacks native support but can be easily installed. Steps include downloading SQLite tools, setting up tooling, integrating with Go, and using it with .NET. This versatile database is a great choice for various projects on Windows... Continue reading →

Effective Data Modeling with BSON/JSON: Best Practices and MongoDB Design Patterns

When working with BSON/JSON data modeling, adhere to best practices for schema design, document structure, indexing, data integrity, versioning, performance, security, and documentation. MongoDB-specific patterns include approximation, attribute, bucket, computed, document versioning, extended reference, outlier, preallocated, polymorphic, schema versioning, subset, tree and graph models for efficient, scalable, and maintainable data schemas. BSON, or Binary JSON,... Continue reading →