SQLite – Easy to use, dependable and good to use database for small applications.

Table of contents for SQLite

  1. SQLite – Easy to use, dependable and good to use database for small applications.
  2. SQLite : Manager for this simple database
  3. SQLite – simple use in scripts
  4. Using SQLite to maintain your monthly bills.

For last couple of days I am looking at SQLite, a very footprint, file based Database.

SQLite is a C library that implements an SQL database engine. A large subset of SQL92 is supported. A complete database is stored in a single disk file. The API is designed for convenience and ease of use. Applications that link against SQLite can enjoy the power and flexibility of an SQL database without the administrative hassles of supporting a separate database server. Version 2 and version 3 binaries are named to permit each to be installed on a single host.

There are already some cool tutorials on various blogs about sqlite, so I will just point to them for now.. More to come soon.
1. http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html
2. http://freshmeat.net/articles/sqlite-tutorial
3. http://zetcode.com/databases/sqlitetutorial/

\"Enhanced

IRC on Linux de-mystified for new users only

IRC on Linux de-mystified for new users only

The other day, I was trying to fix something in my firefox and found that the way to go was to login to IRC and go to the mozilla server and join #firefox.

Though IRC is quite native to Linux, I did not know where to start. So, I noted down the list of steps that need to be done to get you started. (Note this may not be new to most of you).

First install a IRC client like xchat-gnome. To do that

sudo yum install xchat-gnome

Once that is done, just fire up your xchat-gnome. you might have to enter some details for the first time 🙂

If you want to join a server not listed in the list, then you can add the server:

Go to Edit -> Preference -> Network -> Add

and add the server.

Note: If you are running squid and getting an error

for being behind open proxy then you should deny all hosts and allow just your intranet or just your host 🙂

\"Enhanced