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 →

In the realm of relational databases, schemas define and organize data structures and relationships. While SQL Server and PostgreSQL use schemas as logical containers within databases, Oracle intertwines schemas with user accounts, and MariaDB/MySQL equates schemas to databases themselves. Read on to learn more. Continue reading →

In this post I’ve put together some of the naming conventions, rules, and ideas that I tend to follow when creating database schemas to work with. This also applies to schema-less databases, distributed systems databases, graph, time series, or whatever else I am working with. It’s always good to have some good conventions to work... Continue reading →