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: 1 <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. Continue reading

SQLite – simple use in scripts

2010-08-21 1 min read Database Linux
Today we will look a the most simple use&#8217;s in the scripts and how to use them. echo &#8221;insert into bills values (&#8221;$name&#8221;,$date_now, $date_now,$1)&#8221;|sqlite bills or the other way to do this is <a class="zem_slink" title="SQLite" rel="homepage" href="http://sqlite.org/">sqlite3 bills &#8221;insert into bills values (&#8221;$name&#8221;,$date_now, $date_now,$1)&#8221; 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. Continue reading

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. Continue reading

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. Continue reading

IRC on Linux de-mystified for new users only

2010-06-15 2 min read Linux
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 <a class="zem_slink freebase/en/server" title="Server (computing)" rel="wikipedia" href="http://en.wikipedia.org/wiki/Server_%28computing%29">server and join #firefox. Though IRC is quite native to <a class="zem_slink freebase/en/linux" title="Linux" rel="wikipedia" href="http://en.wikipedia.org/wiki/Linux">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. Continue reading