Two years of blogging

Keep on writing

It’s been two years since I started this blog and so it’s time to draw a line and see how it went since last year.

Page Views

meta_24m_wp_months

In these two years, I got 500.000 page views and the last month was the first one to break the 50.000 views threshold.

Continue reading “Two years of blogging”

Advertisements

How does the MySQL JDBC driver handle prepared statements

Prepared statement types

While researching for the Statement Caching chapter in my High-Performance Java Persistence book, I got the chance to compare how Oracle, SQL Server, PostgreSQL and MySQL handle prepare statements.

Thanks to Jess Balint (MySQL JDBC driver contributor), who gave a wonderful answer on StackOverflow, I managed to get a better understanding of how MySQL handles prepared statements from a database performance point of view.

Continue reading “How does the MySQL JDBC driver handle prepared statements”

A paranoid’s guide to backing up a working folder

Oops time

Leanpub supports multiple storage engines and a private GitHub repository is probably the safest way to the backing up your working folder. I chose Dropbox as I didn’t envision anything wrong with the automatic synchronization mechanism.

While working on my book, I accidentally managed to wipe-out half of my diagrams and all changes were instantly synchronized by Dropbox. The free-of-charge Dropbox account doesn’t offer folder-level versioning, so deleted files are simply gone. Fortunately, IntelliJ IDEA Local History saved the day and the diagrams were properly restored.

Continue reading “A paranoid’s guide to backing up a working folder”