Databases
-
Software Development
Yet Another 10 Common Mistakes Java Developers Make When Writing SQL (You Won’t BELIEVE the Last One)
(Sorry for that click-bait heading. Couldn’t resist!) We’re on a mission. To teach you SQL. But mostly, we want to…
Read More » -
Software Development
MySQL Transaction Isolation Levels and Locks
Recently, an application that my team was working on encountered problems with a MySQL deadlock situation and it took us…
Read More » -
Software Development
Seven Databases in Seven Weeks – Hbase Day 2
This post is a recap of the second day of Hbase from the Seven Databases in Seven Weeks book. Most…
Read More » -
Software Development
SQL Server Trick: Circumvent Missing ORDER BY Clause
SQL Server is known to have a very strict interpretation of the SQL standard. For instance, the following expressions or…
Read More » -
Software Development
The Index You’ve Added is Useless. Why?
Recently, at the office: Bob: I’ve looked into that slow query you’ve told me about yesterday, Alice. I’ve added the…
Read More » -
Software Development
How to import CSV data into PostgreSQL
Introduction Many database servers support CSV data transfers and this post will show one way you can import CSV files…
Read More » -
Software Development
How to Implement Sort Indirection in SQL
I’ve recently stumbled upon this interesting Stack Overflow question, where the user essentially wanted to ensure that resulting records are…
Read More » -
Software Development
NoSQL? No, SQL! – How to Calculate Running Totals
If anything at all, our jOOQ talks at various JUGs and conferences have revealed mostly one thing: Java developers don’t…
Read More » -
Software Development
The anatomy of Connection Pooling
Introduction All projects I’ve been working on have used database connection pooling and that’s for very good reasons. Sometimes we…
Read More »
