PHP and SQLite

So I whipped up a quick chat script today, nothing fancy but a little more stable than facebook chat so that’s something.  It was a bit of a wrestle getting SQLite to work, but only because Ubuntu decided to ship PHP with SQLite 2 but the gui admin tool is SQLite 3 only (not backwards compatible with SQLite 2).  Ok, so there’s an SQLite 3 library – but I’m not going to recompile PHP for a gui tool which I’m rarely ever going to use.  No, I instead opted to learn SQLite2 (which differs remarkably from MySQL, I can tell you!) and use the command line tool “sqlite”.  Problem solved.  The chat script is slightly prettier (in my humble opinion) than my old chat script, not much more functional (yet) but a lot more expandable and scalable.

Anyway, techie garbage that most readers of this blog care even less than me about (and I don’t care that much for it) out of the way, let’s move on shall we?

So I applied for a job at the DWP about 3 weeks ago, and it was left that they’d get me CRB checked (which takes 3-4 weeks) and I’d be good to start work 3-4 weeks after then.  I’ll post back when I hear anything about that job.

What else have I done… oh yeah, I got a new mail client called Claws, which has more dials and switches than the USS Enterprise.  Just how I like my software, then!  I’m very pleased with it so far, and will later be recommending it to certain members of my family who are still using OS X’s “Mail” program, which to be quite frank is apallingly ill suited to the simple task of sending and receiving email.  Surprising, because Apple are usually pretty good at bundled software.  Still, at least they don’t have the user locked in to using their application (like they who shall not be named do) so it won’t be hard to replace Mail with Claws.

Anyway, I also set up a family email address which I plan to persuade the whole family to regularly check (hopefully you won’t see any mail coming -from- that address though).  Use it to send funny stories or notices which the whole family need to read (like the twitter page you just set up for your cat – and no, I don’t know Jason Scott, I just googled “twitter cat”).

Oh, one last thing – feel free to stop by my brother’s blog; he has fulfilled his pledge and produced his first weekly song!  I personally think it sounds very professional, and shows off his recording skills well.