I’m just running through some basic commands from Kurt’s SQLite cheatsheet. I guess I already had some version of SQLite installed that came with the Karmic distribution, but it turns out that SQLite3 wasn’t installed. It was easy, I just did a
sudo apt-get install sqlite3.
Wow, talk about getting sidetracked… I decided today that I want to learn about databases. I want to create a GUI (see previous two posts) and use it to write to and read from a database. I want to be able to search for keywords and numbers from various fields, etc. Somehow, it didn’t seem like it should be that hard. It’s sort of like a spreadsheet, right? I wanted to be able to make a work and survey log, with specific fields that I could fill in each day. Right now, I have something that sort of works, but it’s just an excel spreadsheet where I can filter the contents of the columns. But it’s getting really big and awkward, and not that pretty. I thought I could do better if I could just make a GUI specifically for that task. I did some Google searching, and, quite frankly, it scared me. Everything I found seemed to be aimed at people who already have a bit of a clue (um, definitely not me). So I contacted Kurt, who does all kinds of amazing stuff with databases. He suggested that I start with SQLite, and the Python SQLite module. These two links are various degrees of overwhelming, so I’m looking forward to some more guidance from Kurt! 🙂