Amit Agarwal Linux Blog

Using SQLite to maintain your monthly bills.

2010-08-24 6 min read Linux

I was looking for a small application to maintain my every month bills. The application had to be small and script-able. I basically wanted to keep track of the bills that have been generated and pending payment and the bills that have been paid.

First we will create the <a class="zem_slink" title="Database" rel="wikipedia" href="http://en.wikipedia.org/wiki/Database">database schema with the following command:

  <td>
    <div class="text codecolorer">
      CREATE TABLE bills(name varchar(20), due_dt text, p_dt text, amount integer);
    </div>
  </td>
</tr>

So, I built on the knowledge gathered on <a class="zem_slink" title="SQLite" rel="homepage" href="http://sqlite.org/">SQLite. And here is a small script that I wrote:

SQLite – simple use in scripts

2010-08-21 1 min read Database Linux

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

<a class="zem_slink" title="SQLite" rel="homepage" href="http://sqlite.org/">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.<h6 class="zemanta-related-title" style="font-size: 1em;">Related articles by Zemanta <ul class="zemanta-article-ul"> <li class="zemanta-article-ul-li"><a href="http://tobu.lightbird.net/">Tobu Tutorial (tobu.lightbird.net) <li class="zemanta-article-ul-li"><a href="http://go.theregister.com/feed/www.theregister.co.uk/2010/07/02/openoffice_adopts_gstreamer/">OpenOffice gets Ubuntu-media friendly (go.theregister.com) <li class="zemanta-article-ul-li"><a href="http://elegantcode.com/2010/07/02/using-transactionscope-with-sqlite/">Using TransactionScope with SQLite (elegantcode.com) <li class="zemanta-article-ul-li"><a href="http://www.slideshare.net/aikisteve/flash-and-the-city-2010">Flash And The City 2010 (slideshare.net) <div class="zemanta-pixie" style="margin-top: 10px; height: 15px;"><a class="zemanta-pixie-a" title="Enhanced by Zemanta" href="http://www.zemanta.com/"><img class="zemanta-pixie-img" style="border: medium none; float: right;" src="http://img.zemanta.com/zemified_e.png?x-id=7b7c893c-d92b-44bc-8923-d7c6fddc8b42" alt="Enhanced by Zemanta" /><span class="zem-script more-related pretty-attribution">

SQLite : Manager for this simple database

2010-08-19 2 min read Database Linux

We will look at sqliteman – <a class="zem_slink" title="SQLite" rel="homepage" href="http://sqlite.org/">SQLite Database manager.

If you are looking for a tool for tuning <a class="zem_slink" title="SQL" rel="wikipedia" href="http://en.wikipedia.org/wiki/SQL">SQL statements, manage tables, views, or triggers, administrate the <a class="zem_slink" title="Database" rel="wikipedia" href="http://en.wikipedia.org/wiki/Database">database space and index <a class="zem_slink" title="Statistics" rel="wikipedia" href="http://en.wikipedia.org/wiki/Statistics">statistics then Sqliteman is the perfect choice.
If you are looking for a <a class="zem_slink" title="Graphical user interface" rel="wikipedia" href="http://en.wikipedia.org/wiki/Graphical_user_interface">graphical queries creation wizards, <a class="zem_slink" title="User interface" rel="wikipedia" href="http://en.wikipedia.org/wiki/User_interface">user interface designers for your database, or an universal report tool try the applications designed for tasks such this (<a class="zem_slink" title="Kexi" rel="homepage" href="http://kexi-project.org/">Kexi, knoda).

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

2010-08-17 2 min read Database Linux

For last couple of days I am looking at <a class="zem_slink" title="SQLite" rel="homepage" href="http://sqlite.org/">SQLite, a very footprint, file based Database.

SQLite is a C <a class="zem_slink" title="Library (computing)" rel="wikipedia" href="http://en.wikipedia.org/wiki/Library_%28computing%29">library that implements an <a class="zem_slink" title="SQL" rel="wikipedia" href="http://en.wikipedia.org/wiki/SQL">SQL database <a class="zem_slink" title="Database engine" rel="wikipedia" href="http://en.wikipedia.org/wiki/Database_engine">engine. A large subset of <a class="zem_slink" title="SQL-92" rel="wikipedia" href="http://en.wikipedia.org/wiki/SQL-92">SQL92 is supported. A complete <a class="zem_slink" title="Database" rel="wikipedia" href="http://en.wikipedia.org/wiki/Database">database is stored in a single disk file. The <a class="zem_slink" title="Application programming interface" rel="wikipedia" href="http://en.wikipedia.org/wiki/Application_programming_interface">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 <a class="zem_slink" title="Database server" rel="wikipedia" href="http://en.wikipedia.org/wiki/Database_server">database server. Version 2 and version 3 binaries are named to permit each to be installed on a single <a class="zem_slink" title="Server (computing)" rel="wikipedia" href="http://en.wikipedia.org/wiki/Server_%28computing%29">host.
Continue reading

Happy Independence Day

2010-08-15 1 min read Uncategorized

Happy Independence Day to all.

tee to a file descriptor

2010-08-13 1 min read Bash Linux

tee to a file descriptor

1

$ tee >(cat &#8211; >&2)

the tee command does fine with file names, but not so much with file descriptors, such as &2. This uses process redirection to tee to the specified descriptor.

In the sample output, it’s being used to tee to stderr, which is connected with the terminal, and to wc -l, which is also outputting to the terminal. The result is the output of bash –version followed by the linecount

gphotoframe Free digital photo frame for your desk.

2010-08-11 2 min read Fedora GNOME Photo

First install the gphotoframe application with the command :

sudo yum install gphotoframe

and if you want gnome-screensaver compatibility then install the package gphotoframe-gss also.

Gnome Photo Frame is a photo frame gadget for the <a class="zem_slink" title="GNOME" rel="homepage" href="http://www.gnome.org/">GNOME Desktop. Let’s see how this works.. run the command gphotoframe from a terminal:

Here is what you will see :

Don’t panic on seeing the blank/black page. You need to add the source first. So <a class="zem_slink" title="Mouse (computing)" rel="wikipedia" href="http://en.wikipedia.org/wiki/Mouse_%28computing%29">right click on the window and go to preferences:

Older posts Newer posts

Bilberry Hugo Theme