Databases
-
Software Development
The 10 Most Popular DB Engines (SQL and NoSQL)
How to objectively measure the popularity of a DB engine? Good question! And there’s an Austrian company (Solid IT) who…
Read More » -
Software Development
Why PostgreSQL is so Awesome
Just recently, I’ve blogged about PostgreSQL 9.3 having been released, which is awesome enough as PostgreSQL finally supports materialised views…
Read More » -
Enterprise Java
Batch Writing, and Dynamic vs Parametrized SQL, how well does your database perform?
One of the most effective database optimizations is batch writing. Batch writing is supported by most modern databases and part…
Read More » -
Software Development
10 More Common Mistakes Java Developers Make when Writing SQL
I was positively surprised to see how popular my recent listing about 10 Common Mistakes Java Developers Make when Writing SQL was, both…
Read More » -
Software Development
An argument against defaulting to auto-increment primary keys
The de-facto “easy” primary key for ages has been the auto-incrementing integer. Upon insertion of a new record, the database…
Read More » -
Software Development
10 Common Mistakes Java Developers Make when Writing SQL
Java developers mix object-oriented thinking with imperative thinking, depending on their levels of: Skill (anyone can code imperatively) Dogma (some…
Read More » -
Software Development
Source control your database with Liquibase
I recently started to use Liquibase on a project to keep track of the database changes in our Java Enterprise…
Read More » -
Software Development
Easy Mocking of Your Database
Test-driven development is something wonderful! Once you’ve established it in your organisation, you will start to: Greatly improve your quality…
Read More » -
Software Development
Caveats With MySQL Pagination
We’ve all done pagination – it’s sensible for both lists in the UI and for processing data in batches. “SELECT…
Read More »