Databases
-
Software Development
Flyway and jOOQ for Unbeatable SQL Development Productivity
When performing database migrations, we at Data Geekery recommend using jOOQ with Flyway – Database Migrations Made Easy. In this…
Read More » -
Software Development
Database primary key flavors
Types of primary keys All database tables must have one primary key column. The primary key uniquely identifies a row…
Read More » -
DevOps
MySQL error: Can’t connect to MySQL server
You may have stumbled on this MySQL error. If you have already seen this before, then it’s really easy to…
Read More » -
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 »
