V-VisuaLeaf - MongoDB Data Workspaceinvisualeaf.hashnode.dev·Sep 3 · 10 min readHow to Use DuckDB for Local Data AnalysisYou have data on your computer and want to explore it with SQL. It might be a CSV export, an existing database, or files produced by another analytical tool. Setting up a database server just to answe00
V-VisuaLeaf - MongoDB Data Workspaceinvisualeaf.hashnode.dev·Aug 31 · 10 min readmongodump Tasks Automate and Schedule MongoDB BackupsRunning a MongoDB backup once is not difficult. With MongoDB Database Tools installed, the complete PowerShell command can be as short as this: & "C:\Program Files\MongoDB\Tools\100\bin\mongodump.exe"00
V-VisuaLeaf - MongoDB Data Workspaceinvisualeaf.hashnode.dev·Aug 26 · 8 min readWhat Is a SQL Database Schema and How Do You Design One?Open a database for the first time, and you see tables, unfamiliar icons, and folders for columns, indexes, foreign keys, and constraints. Open a table, and rows appear. Switch to the diagram, and lin00
V-VisuaLeaf - MongoDB Data Workspaceinvisualeaf.hashnode.dev·Aug 18 · 7 min readPostgreSQL JSONB: Query, Update, and Index JSON DataJSONB allows you to store JSON data within a PostgreSQL table row. It is suitable when certain columns remain unchanged, while the remaining columns may have different content across rows. Let us take00
V-VisuaLeaf - MongoDB Data Workspaceinvisualeaf.hashnode.dev·Aug 11 · 13 min readMongoDB Shell JavaScript: Bulk Updates, Loops & AnalysisMost mongosh tutorials focus on individual commands: find a document, update a field, or run an aggregation. That is useful when you already know exactly what needs to change. Real cleanup work is oft00