MAMohammed Alfarraintabelaro.hashnode.dev·8h ago · 2 min readWhy my database client makes you review every edit before it runsMost database clients let you edit a cell and the change is saved immediately. That's fine until it isn't: a wrong row, a wrong table, a connection pointed at production. I built Tabelaro, a free data00
Aara-ta3inara-ta3.hashnode.dev·12h ago · 5 min readHow to Get the Latest Row per Group in MySQL 8 Using ROW_NUMBER()Introduction I sometimes need to get the latest row for each group in MySQL: the most recent login per user, the latest status per order, or the last edit per article. For MySQL 8.0 and later, ROW_NUM00
MFMahir Faysalinmfaysaldev.hashnode.dev·15h ago · 12 min readMySQL GROUP_CONCAT with ORDER BY, SEPARATOR and DISTINCT (Tested on 8.4)To join several rows into one string per group in MySQL, use GROUP_CONCAT() with GROUP BY. The order and the separator go inside the brackets: GROUP_CONCAT(subject ORDER BY subject SEPARATOR ', '). Ad00
PGPhil Grinhaminphilgrinham.hashnode.dev·1d ago · 7 min readBubble Sorting Delimited Strings #JoelKallmanDayIn honor Joel and all he did for the Oracle community, this is a quick blog post on a solution to the problem of sorting a delimited string. The basic premise is a common headache where we are require00
UAUptime Architectinuptimearchitect.hashnode.dev·1d ago · 12 min readYou Deleted 99% of the Rows. The Full Scan Didn't Get Any Faster.The audit table had grown to 200 million rows, so the team finally ran the purge: everything older than 90 days, gone. Ninety-nine percent of the rows deleted, committed, celebrated. The next morning 00
V-VisuaLeaf - MongoDB Data Workspaceinvisualeaf.hashnode.dev·1d ago · 11 min readHow to Open a SQLite Database: Query and Explore Your DataYou have a SQLite file and want to see the information inside it. To open a SQLite database, select the file in software that can read SQLite, such as VisuaLeaf. You can then browse the tables and use00
SGSoham Gaichorinsoham111.hashnode.dev·1d ago · 5 min readThe Cashier and the CEO: A Tale of Two Database Worlds (OLTP vs. OLAP)Imagine you walk into a bustling coffee shop. At the front counter, a barista is rapidly tapping the screen, printing paper receipts, and handing out lattes. In the back office, the store owner is sit00
SGSoham Gaichorinsoham111.hashnode.dev·1d ago · 6 min readThe Shepherd, the Dog, and the 700 Sheep: A Visual Guide to SQL Server Composite IndexesHave you ever wondered what actually happens inside a database when you run a query filtering on multiple columns? Or why adding an index sometimes makes your queries lightning-fast, but other times b00
SGSoham Gaichorinsoham111.hashnode.dev·1d ago · 6 min readThe Secret Life of Database Pages: Why "Fill Factor" is the Ultimate Balancing ActImagine you are packing your school backpack for the year. Do you shove your books in so tightly that you can't even zip it closed? Or do you leave a bunch of empty space in every pocket so you can ea00
VHVictor Horlenkoinainsights.hashnode.dev·2d ago · 7 min readContext Is the Feature: Bringing Free AI SQL Help Into the dbForge IDEGenerating a SQL query has become the cheap part of database work. Almost any AI model can turn a sentence into syntactically valid SQL in a couple of seconds. What has not become cheap is confidence:00
