V-VisuaLeaf - MongoDB Data Workspaceinvisualeaf.hashnode.dev·Sep 22 · 8 min readMySQL Database Management System: Manage Your Data VisuallyMySQL uses tables to store application data. For instance, an online store can have individual tables for its customers, orders, items, and transactions. SQL is the language used to read and change th00
V-VisuaLeaf - MongoDB Data Workspaceinvisualeaf.hashnode.dev·Sep 18 · 7 min readMongoDB Sharding: Manage a Sharded Cluster VisuallyMongoDB sharding helps a database handle growth by dividing a large collection into smaller blocks called chunks and distributing them across multiple shards.A shard key, such as customerId or region,00
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