Databases
-
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 » -
Software Development
Seven Databases in Seven Days – Riak
In this post I am summarizing the three days of Riak, which is the second database in the Seven Databases…
Read More » -
Software Development
db.person.find( { “role” : “DBA” } )
Wow! it has been a while since I posted something on my blog post. I have been very busy, moving…
Read More » -
Enterprise Java
Java 8 Friday: Java 8 Will Revolutionize Database Access
At Data Geekery, we love Java. And as we’re really into jOOQ’s fluent API and query DSL, we’re absolutely thrilled…
Read More » -
Software Development
A Better Query Language than SQL
Leland Richardson, Founder of Tech.Pro has recently published a very interesting article about BQL, his visions of a better query…
Read More »
