PostgreSQL JSONB: Query, Update, and Index JSON Data
A practical PostgreSQL JSONB workflow for querying nested values, updating individual fields, and indexing containment searches with GIN.
MongoDB Shell JavaScript: Bulk Updates, Loops & Analysis
Learn how to use mongosh scripts to analyze data, build cleanup plans, run bulk updates, verify results, and inspect query performance.
MongoDB Schema Design: Build or Reverse Engineer Visually
Design a MongoDB schema from scratch or reverse-engineer an existing database visually. Define fields, relationships, validators, and materialize it.
MongoDB GUI Comparison: VisuaLeaf vs Compass vs Studio 3T
See how VisuaLeaf, MongoDB Compass, and Studio 3T handle large collections, compare data, automate tasks, and analyze queries, and which one fits best.
Conway's Game of Life Just Using Mongo Shell
A Quick Fun Article on How You Can Create Conway's Game of Life Using Just the MongoDB Shell and Nothing Else!
How to Copy and Sync a MongoDB Collection to PostgreSQL
Learn how to copy a MongoDB collection to PostgreSQL, map nested fields to JSONB, and keep inserts, updates, and deletes in sync.
How to Import JSON into MongoDB and Export to CSV with Data Masking
Learn how to import JSON orders into MongoDB, copy them into a main collection, export a weekly CSV report, and mask customer data during export using VisuaLeaf Task Manager.
How to Copy and Sync a Local MongoDB Collection to Atlas
Learn how to copy a local MongoDB collection to MongoDB Atlas and keep inserts, updates, and deletes synchronized with Mongo Sync.
The 10 Levels of Building a Data Grid
This is an article focusing on my design pattern when creating a data grid visualizing data for SQL and NoSQL databases
7 MongoDB Query Mistakes That Return the Wrong Results
Learn 7 common MongoDB query mistakes with simple find() examples, including $or, $in, nested fields, dates, and text search.