Skip to main content

 $ ./blog

SQLite database WHERE clause condition not filtering rows

·5 mins

It is possible to create a table in an SQLite database where the columns have no type.

For example, the columns in this STATS table have no type specified:

sqlite> PRAGMA TABLE_INFO('STATS');
cid  name       type  notnull  dflt_value  pk
---  ---------  ----  -------  ----------  --
0    PLAYER_ID        0                    0 
1    YEAR             0                    0 
2    TEAM             0                    0 
3    AB               0                    0 
4    HITS             0                    0 
5    HR               0                    0 
6    RBI              0                    0 



This doesn’t seem to make much of a difference if you are storing strings / text data, and writing queries to retrieve things based on those strings.

However, if you are storing numbers, then you’ll notice a problem if you try queries like this:

weeknotes: GIS 101

·2 mins

So I’ve decided to give weeknotes a go.

What are weeknotes?

At the most basic level they are posts on someone’s blog that generally appear each week. What about a level up from that? Well, they tend to contain some account of what the author of the post got up to in the last week. That might take the form of a detailed list of activities, such as events attended, work completed, or personal endeavours enjoyed. It might also be more reflective, a form of journaling, how things in the last week made one feel. Indeed a weeknote could be a mixture of those things, and more, or less. They are whatever the author makes of them.

I’m going to give them a go, at least for a little while, as a way to encourage myself to write about what I’m getting up with regards to exploring the world of GIS.

Exploring GIS

·2 mins

I’ve been exploring the world of GIS for a few months now, and it wouldn’t be unreasonable to say I’ve been taking notes in a similar manner to this dog drinking from a hose:

PC Build 004: Powered by Seasonic

·4 mins

A power supply unit, or PSU, was the first thing I started looking into after I bought my case. But I soon realised there is a vast range of power-supplying capabilities – with the most basic question “what wattage is it?” ranging from 300W to 1200W. That’s quite a difference.

So, ignoring other fancy PSU stuff, how do you figure out what wattage to get?