Databases
-
Software Development
Writing Tests for Data Access Code – Don’t Forget the Database
When we write tests for our data access code, we must follow these three rules: …
Read More » -
Software Development
PostgreSQL’s Table-Valued Functions
Table-valued functions are an awesome thing. Many databases support them in one way or another and so does PostgreSQL. In…
Read More » -
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 »
