Micra: A simple Java Web framework

Java powers a lot of webapps, but I’ve always found it to be fairly unwieldy to get a project started, especially in comparison to the simplicity of Ruby, PHP, or server-side JavaScript (Node.js). Even a simple Hello World in Spring MVC takes a lot of work. This contrasts with the three steps it takes to create and run a Sinatra web site in Ruby. Read more ›

Posted in Uncategorized

Always use decimal for money

Data types make all the difference in the world when you’re designing your database. The choices you make now will affect the quality of your data, as well as application performance. I’m going to focus on one issue in this article: why you should always use decimals to represent money. Let’s jump in and see why that’s true. Read more ›

Tagged with:
Posted in Databases, IT

Interviewing for a Database Developer

I work for a firm that’s heavily invested in SQL – a team that needs to have developers who know their way around relational databases and MySQL in particular. I want to show you how I run interviews for our development positions. Read more ›

Tagged with:
Posted in Databases, IT

Tiny happy features in MySQL

I love it when software gives you elegant ways of solving your problem. Programming language designers make me feel like they care when they take the time to include succinct, powerful expressions. I’ve recently discovered some in new things in MySQL, as well as a few rediscoveries. This is the first five, and I’ll cover the next five in another article. Read more ›

Posted in Uncategorized

Inner vs. Outer Joins

join

I want to teach you the difference between an inner and an outer join. We first need to think about what a join is. Simply, it’s when you combine two tables to make a new one. You’re not physically creating a new table when you join them together, but for the purposes of the query, you are creating a new virtual table. Every row now has the columns from both tables. So if TableA has columns Col1 and Col2 and TableB has columns Col3 and Col4, when you join these two tables, you’ll get Col1, Col2, Col3, and Col4. Just as with any query, you have the option of including all columns or excluding some, as well as filtering out rows. Read more ›

Tagged with: ,
Posted in Databases, IT, Open-Source