Software Development
-
Use MySQL’s Strict Mode on all new Projects!
MySQL is a database that has been bending the SQL standard in ways that make it hard to move off…
Read More » -
Between 0 and 1 – PWM with Raspberry Pi
Switch on and off an LED and let run a motor at one speed and direction is easy, but what…
Read More » -
Don’t Miss out on Awesome SQL Power with FIRST_VALUE(), LAST_VALUE(), LEAD(), and LAG()
If you’re using a commercial database or PostgreSQL / Firebird / CUBRID, you will be able to take advantage of…
Read More » -
What is your “x”? The technical details about the Devoxx Keynote Demo
If everything went fine, I just got off the stage and ended the demo part of Mike’s (@mpiech) demo.We talked…
Read More » -
Don’t Migrate to MariaDB just yet. MySQL is Back!
Now that I have your attention, I’d like to invite you to a critical review of where we’re at in…
Read More » -
Development Overhead
What does a developer spend his time on? Writing code, debugging, thinking and communicating with colleagues (that includes meetings). Anything…
Read More » -
Painless Access from Java to PL/SQL Procedures with jOOQ
PL/SQL is one of those things. Most people try to stay clear of it. Few people really love it. I…
Read More » -
Pair Programming for Team Building
Extreme programming (XP) introduced most people to pair programming. The theory was that the sooner that code was reviewed, the…
Read More » -
Have You Ever Wondered About the Difference Between NOT NULL and DEFAULT?
When writing DDL in SQL, you can specify a couple of constraints on columns, like NOT NULL or DEFAULT constraints.…
Read More »