Skip the hand-rolled MongoDB two phase commit unless you’re on a standalone server or a version older than 4.0. A real multi-document transaction did the same transfers 3 to 6 times faster in my runs. Quick answer: the pattern logs each transfer in a transactions collection, walks it through initial, pending, applied and done, and … Read more >>
My first try printed result._id and mongosh answered undefined. The id was there all along, just under another name. The fix for “get id after insert MongoDB“: read insertedId from the insertOne() result, or insertedIds from insertMany(). No second query: Tested on MongoDB 9.0.4 with mongosh 2.14 and PyMongo 4.19 on Windows. Get the _id … Read more >>
Every new app should get its own MariaDB database and its own login, so a bug in one app can’t read or drop another app’s tables. Quick answer: run CREATE DATABASE app_db;, then CREATE USER ‘app’@’localhost’ IDENTIFIED BY ‘password’; and GRANT ALL PRIVILEGES ON app_db.* TO ‘app’@’localhost’;. You don’t need FLUSH PRIVILEGES. In this tutorial, … Read more >>
How the choice of a MariaDB migration tool can make or break your project timeline. In this guide, I will walk you through the landscape of MariaDB migration, the tools that define the industry standard, and a comprehensive tutorial on how to execute a professional-grade migration. MariaDB Migration Tool We are seeing a massive shift … Read more >>
Choosing the right relational database management system (RDBMS) is a critical decision for any tech-driven enterprise. MariaDB has emerged as the high-performance, community-driven alternative that many of us in the industry now prefer. In this article, I’m going to guide you through the essentials of using MariaDB, from installation to advanced administration. How to use … Read more >>
If you need a MariaDB GUI on Windows, use HeidiSQL: the MariaDB installer already put it on your disk. On a Mac or Linux box, or when you also manage PostgreSQL or SQL Server, pick DBeaver Community instead. That’s my verdict after connecting HeidiSQL 12.20.0.7320 to MariaDB 13.0.2 on Windows 11 and logging every statement … Read more >>
Back up with mongodump, restore with mongorestore. That’s the whole MongoDB backup and restore loop for one database: Tested on MongoDB 9.0.4 (standalone, Windows 11), mongosh 2.14 and Database Tools 100.20.1. Here’s the end state after I dropped a database and restored it: Before You Start: Sample Database and Tools Since MongoDB 4.4 the dump … Read more >>
What is MariaDB? It’s a free, open-source relational database that started in 2009 as a fork of MySQL, built by MySQL’s original developers and licensed under the GPLv2. The project calls it a drop-in replacement for MySQL. I wanted to see what the current release actually ships with, so I ran it on Windows. Quick … Read more >>
Many guides still add CASCADE to a MariaDB drop table statement. MariaDB accepts it and ignores it. Use IF EXISTS, and clear foreign keys first: My run: MariaDB 13.0.2, InnoDB tables, Windows 11. The Sample Store Tables Five plain MariaDB tables. Only orders has a foreign key, pointing at customers: MariaDB DROP TABLE Syntax WAIT … Read more >>
You copied the constraint name from memory, ran the ALTER, and MariaDB said no: The reply from the server: Quick answer: the drop constraint MariaDB statement is ALTER TABLE t DROP CONSTRAINT name;, using the exact name from information_schema. Tested on MariaDB 13.0.2, Windows 11. I was one letter off. That’s ERROR 1091, and it … Read more >>