Skip to content

{ Tag Archives } o rly

SQLite more laid back than the D-O-double-G

SQLite only supports a simple set of data types and the only one that really matters is “INTEGER PRIMARY KEY” so you can have it auto-increment. In fact, by default, I can declare the columns as anything I want and it doesn’t even throw a warning. sqlite> CREATE TABLE t2(c1 wtf, c2 yomama); sqlite> INSERT [...]

Also tagged

When is a TINYINT(1) not a TINYINT(1)?

When you’re using CakePHP! Turns out CakePHP considers a TINYINT(1) to be a Boolean. Judging from all the support tickets that have been filed, I’m not the first person to get taken off guard by this behavior. When I asked about it on IRC, the response was that since MySQL considers a TINYINT(1) to be [...]

Also tagged , ,

Mmmm…. scams… (part 2)

I think it must be my old age shining through but rather than go down to the meeting and cause hate and discontent I decided to repair a hole in my kitchen floor instead. As much as I enjoy awkward conversations (when I’m the instigator), it just seemed like a lot of effort – and [...]

Also tagged ,

Mmmm…. scams… (part 1?)

This afternoon my neighbor (who I’d never met before) showed up at my door with a bundle of bright pink papers. He explained to me that he was inviting me to a meeting tomorrow at our local library that would help me make vast amounts of money. Oh really? I probed for some details but [...]

Also tagged ,