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 &#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.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">

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.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).

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

<a href="http://blog.amit-agarwal.co.in/wp-content/uploads/2010/08/DSCN1316.jpg"><img class="size-medium wp-image-2374" title="Independence Day Celebration in School" src="http://blog.amit-agarwal.co.in/wp-content/uploads/2010/08/DSCN1316-300x205.jpg" alt="Independence Day Celebration in School" width="300" height="205" /><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=a412647a-18c4-4f00-a62f-93de0d55329f" alt="Enhanced by Zemanta" /><span class="zem-script more-related pretty-attribution">

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

Continue reading

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&#8217;s see how this works.. run the command gphotoframe from a terminal:

Here is what you will see :

<a href="http://blog.amit-agarwal.com/wp-content/uploads/2010/08/Screenshot-gphotoframe.png"><img class="size-medium wp-image-1880" title="Screenshot-gphotoframe" src="http://blog.amit-agarwal.com/wp-content/uploads/2010/08/Screenshot-gphotoframe-300x227.png" alt="Screenshot-gphotoframe" width="300" height="227" />

Don&#8217;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:

Continue reading

\[Solution\] Solaris issue with wget not resolving Domain name (DNS name lookup failure)

2010-08-09 2 min read Solaris

Today I was working with <a class="zem_slink" title="Solaris (operating system)" rel="homepage" href="http://oracle.com/solaris">Solaris and after I had set up the <a class="zem_slink" title="NIS+" rel="wikipedia" href="http://en.wikipedia.org/wiki/NIS%2B">NIS+, <a class="zem_slink" title="Name server" rel="wikipedia" href="http://en.wikipedia.org/wiki/Name_server">DNS server, IP Address and completing the basic setting. I was using the pkg-get util from the freesunware.com

The utility was using wget and it was failing constantly. From the looks of it, it was very clear that the wget utility was unable to find the <a class="zem_slink" title="IP address" rel="wikipedia" href="http://en.wikipedia.org/wiki/IP_address">IP address from the name. <a class="zem_slink" title="Name resolution" rel="wikipedia" href="http://en.wikipedia.org/wiki/Name_resolution">Name resolution was not happening, while dig and <a class="zem_slink" title="Nslookup" rel="wikipedia" href="http://en.wikipedia.org/wiki/Nslookup">nslookup was able to do the DNS lookup.

Continue reading
Older posts Newer posts