Category Archives: Database

Database Snark

Whenever I hear about relational databases not scaling – I think “you are doing it wrong”. There are a ton of applications where the NoSQL solutions make a ton of sense. However, saying “Relational databases do not scale” is not a valid one. They don’t scale easily, but they do scale. Side note – I [...]

Quick thought on Greenplum

If you haven’t heard, Greenplum was just bought by EMC. This, to me, was not unexpected. Smaller players need a lot of funds to create compelling products in this space. Even with a compelling product (and Greenplum’s product is compelling), getting to that next stage may very well require a deep pocketed sugar mommy (or [...]

Do as you auttah, never pour ACID into Watah

Many years ago, I had a high school science teacher who used that simple line to teach us the proper direction for mixing acid and water. If we forgot, typically there would be sizzling and maybe a mess afterward (only once an explosion). Recently, I’ve been doing a lot of reading on ACID, BASE and [...]

ODBC Driver Development – more thoughts

I should start this out with a general statement – I don’t think there is a very good resource for developing ODBC driver code. There are some decent resources, but I’ve found myself time and again going to either unix ODBC or to microsoft’s ODBC resource. Neither one has been very sufficient in detailing all [...]

ODBC – Starting out

I’m currently working on an ODBC driver. This, in turn, means that I need to know how ODBC is used/called so that I can test said driver. One of the first things I’ve come across in the documentation talks about two calls to SQLAllocHandle before you can connect – the first to allocate the SQL_HANDLE_ENV [...]