Building DataDiluvium: A Data Generation Tool – Part 1: Prerequisites and Project Overview

DataDiluvium is a web tool for generating realistic test data from SQL schema definitions, aiding developers and data engineers. Key features include SQL parsing, customizable data rules, foreign key support, and various output formats. Built with Next.js, TypeScript, and Tailwind CSS, it offers a responsive design and real-time data previews. Continue reading →

Effortless Data Generation for Developers

DataDiluvium is a web-based tool for generating realistic test data from SQL schema definitions, aimed at developers and database administrators. It facilitates rapid development environment setups, automated testing, and data migrations. Key features include customizable data generation, various export formats, and real-time previews, ensuring users can create high-quality test datasets effortlessly. 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 →