SQLite : Manager for this simple database

2010-08-19 319 words 2 mins read

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

Related Articles:


author

Authored By Amit Agarwal

Amit Agarwal, Linux and Photography are my hobbies.Creative Commons Attribution 4.0 International License.

We notice you're using an adblocker. If you like our webite please keep us running by whitelisting this site in your ad blocker. We’re serving quality, related ads only. Thank you!

I've whitelisted your website.

Not now
This website uses cookies to ensure you get the best experience on our website. Learn more Got it