SQLite – simple use in scripts

Today we will look a the most simple use\’s in the scripts and how to use them.

echo \”insert into bills values (\”$name\”,$date_now, $date_now,$1)\”|sqlite bills

or the other way to do this is

sqlite3 bills \”insert into bills values (\”$name\”,$date_now, $date_now,$1)\”

OK, now in the next post we will see a simple application that I am currently developing or planning.

\"Enhanced

SQLite : Manager for this simple database

We will look at sqliteman – SQLite Database manager.

If you are looking for a tool for tuning SQL statements, manage tables, views, or triggers, administrate the database space and index statistics then Sqliteman is the perfect choice.
If you are looking for a graphical queries creation wizards, user interface designers for your database, or an universal report tool try the applications designed for tasks such this (Kexi, knoda).

You can visist the home page of the project to get a little more details.

Now on to the features that I liked and how to use this.

First install the application:

sudo yum install sqliteman

Once done, run the application:

sqliteman

Now time for some screenshots:

\"SQLite \"SQLite \"SQLite \"SQLite \"SQLite
\"Enhanced

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