Andrej Koelewijn

I just uploaded the slides of our JSpring presentation to slideshare: “REST, het internet als database“.

Like most of my presentations, there’s not much text on the slides, so i’ll summarize here:

We start with one slide of JAX-RS code, just to mention that we’re not going to talk about code.
Next, we mention Stefan Tilkovs summary of [...]

Interesting discussion on friendfeeds new database usage: How FriendFeed uses MySQL to store schema-less data. It’s basically a key-value database implemented on top of mysql, to get around schema-change and index performance problems in mysql.
There is a lot of activity around non-RDBMS databases recently. Although it’s always interesting to see new development and innovation, [...]

I’ve been using sql for a number of years now, and thought i knew most of the sql syntax. So i was quite surprised to find out about the existence of UPDATE … FROM. Turns out, this doesn’t exist in Oracle, but is supported by PostgreSQL.
Here’s a small example:

update response
set    house_id = ?
from   house [...]

Sometimes it seems like programmers will do everything to avoid SQL. At the same time DSLs (Domain Specific Languages) are very popular. If DSLs are so great, why are you trying to avoid SQL? Or procedural extensions to SQL? SQL is a DSL for dealing with relational data.
SQL was invented to deal with relational data, [...]