SQLite ID Idiosyncrasies

April 23rd, 2007

Unique primary keys are an important feature of relational databases, however coming from a MySQL environment, I found some small issues when looking at how SQLite automatically creates IDs for your rows. Basically this is just illustrating the autoincrement SQLite documentation.
Here’s the schema of a simple SQLite database with no ID column specified:

sqlite> CREATE TABLE […]

All of a Sudden I Miss Everyone

April 14th, 2007

My uncle leant me The Earth is Not a Cold and Dead Place by Explosions in the Sky around this time last year. The whole album was recorded as a single MiniDisc track, so if I started listening to it, I listened all the way through. In a way this was quite liberating, as I […]

Fire Destroys Johnny Cash House

April 12th, 2007

Heard about it yesterday, read the article on the BBC website.

Another neighbour, Richard Sterban of country and gospel band, the Oak Ridge Boys, is quoted by the AP news agency as saying the fire may be “the good Lord’s way to make sure that it was only Johnny’s house”.