Monthly Archives: October 2009

Calling all SQLite people

Posted on by
Reply

I am looking to migrate my project data from MySQL to SQLite because I want it more portable and so on and so forth.

I however want some inside information on SQLite and how it runs. I have been looking at some of the SQLite documentation and I must be honest I have been lazy about it.

At the moment I would like to know about how much data I can actually store in an SQLite database, and also how it handles different datatypes and finally does it have any built-in injection safeguards?

Also, I would like to know which version to use as a PHP/Python developer. I understand you need to access SQLite3 through something called PDO. In short is there an easy to follow tutorial or document on PHP and SQLite like this one

Skinny Facebook

Posted on by
Reply

I suppose it’s not a great surprise to have the new facebook lite site released to everyone. Personally I think it’s great because the old facebook in my opinion was getting a bit too “bloated” with all that chat and apps bar and all that. Having said that it is still in heavy development so you cannot do anything with your settings at the moment. For that you will have to go to the full fat facebook not to say that there’s much I want to change on my settings though.

Also I think it’s great because it runs better and doesn’t crash my browser after a few minutes on my old compaq N410C. Give credit where it is due…?

Ubuntu Karmic Beta

Posted on by
1

First Attempt

First thing I had to do on my laptop (an old compaq evo N410c), is to disable visual effects because the first install window would just not draw. Once I filled in my details set up how I wanted my hard disk partitioned and clicked on install the window closed and nothing happened. (Thank God I got into work early so I could start it again).

Second Attempt

The second attempt saved me time because some of the information I put in the first time had persisted so that was not a problem. I selected the guided partition option when it got to the file system business and clicked on install again. For the second time the installer just closed down and that was the end of that.

Third attempt

At this point I think either this image I downloaded is corrupt. Or beta is not ready for my laptop. I’m going to download another image and this time run an MD5Checksum on it to make sure that it’s the right image. After which I will install. On trying out the new image of my downloaded and checked image, using unetbootin to extract/decompress onto my USB stick, I still get the same trouble.

Fourth Attempt

I am going to install a clean copy of jaunty (hopefully that works) seeing as I currently use crunchbang with openbox window manager. For all I know it might be a GNOME problem but I suppose I will find out this evening. I did also notice a crash report for metacity, I am not sure how concerned I should be because of this but I am acutely aware of my laptop’s graphic inadequacies, but it should be able to run jaunty and ultimately karmic without disastrous effects on productivity.

Progress!!!

So after installing Jaunty and then bumping it up to karmic it went off without a hitch and it’s actually working much better than any ubuntu worked on this laptop, bearing in mind the restrictions I have on this machine