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

You can visist the <a href="http://www.sqliteman.com">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:

<a href="http://blog.amit-agarwal.co.in/wp-content/uploads/2010/08/Screenshot.jpg"><img class="size-medium wp-image-2404" title="SQLite Manager" src="http://blog.amit-agarwal.co.in/wp-content/uploads/2010/08/Screenshot-300x187.jpg" alt="SQLite Manager" width="300" height="187" />

<a href="http://blog.amit-agarwal.co.in/wp-content/uploads/2010/08/Screenshot-Open-Database.jpg"><img class="size-medium wp-image-2405" title="SQLite Manager-Open Database" src="http://blog.amit-agarwal.co.in/wp-content/uploads/2010/08/Screenshot-Open-Database-300x258.jpg" alt="SQLite Manager-Open Database" width="300" height="258" />

<a href="http://blog.amit-agarwal.co.in/wp-content/uploads/2010/08/Screenshot-Data-Import.jpg"><img class="size-full wp-image-2406" title="SQLite Manager-Data Import" src="http://blog.amit-agarwal.co.in/wp-content/uploads/2010/08/Screenshot-Data-Import.jpg" alt="SQLite Manager-Data Import" width="256" height="241" />

<a href="http://blog.amit-agarwal.co.in/wp-content/uploads/2010/08/Screenshot-bills-Sqliteman-1.jpg"><img class="size-medium wp-image-2407" title="SQLite Manager - Sqliteman" src="http://blog.amit-agarwal.co.in/wp-content/uploads/2010/08/Screenshot-bills-Sqliteman-1-300x209.jpg" alt="SQLite Manager - Sqliteman" width="300" height="209" />

<a href="http://blog.amit-agarwal.co.in/wp-content/uploads/2010/08/Screenshot-bills-Sqliteman.jpg"><img class="size-medium wp-image-2408" title="SQLite Manager - Sqliteman 1" src="http://blog.amit-agarwal.co.in/wp-content/uploads/2010/08/Screenshot-bills-Sqliteman-300x209.jpg" alt="SQLite Manager - Sqliteman 1" width="300" height="209" /><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://themactrack.com/2010/07/20/sqlabs-announces-sqlitemanager-3-5-powerful-sqlite-database-manager/">SQLabs announces SQLiteManager 3.5 – Powerful SQlite Database Manager (themactrack.com) <li class="zemanta-article-ul-li"><a href="http://posterous.mclov.in/how-to-dump-out-sql-from-an-sqlite-database">How to dump out SQL from an SQLite database (posterous.mclov.in) <li class="zemanta-article-ul-li"><a href="http://sheddingbikes.com/posts/1277495906.html">Mongrel2 Sqlite3 Config System Working (sheddingbikes.com) <li class="zemanta-article-ul-li"><a href="http://hackaday.com/2010/07/21/android-development-101-part-3introduction-to-databases/">Android Development 101 – Part 3:Introduction to Databases (hackaday.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.sqlite.org/draft/wal.html">SQLite 3.7: WAL (Write Ahead Logging) for better Concurrency and Performance (sqlite.org) <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=fe5483d3-fbea-46b4-a06d-87cdc88d8741" alt="Enhanced by Zemanta" /><span class="zem-script more-related pretty-attribution">