SQLite Database Tools and Utilities

Tools and Utilities

SQLite described as an “in-process library that implements a self-contained, serverless, zero-configuration, transnational SQL database engine.” SQLite is free and most widely deployed database in the world. SQLite is compact library, embeded database engine and read/write directly into ordinary disk files. That means a complete SQL database with multiple tables, indices, triggers, and views are contained in single disk files. In this article you can find available SQLite Database Tools and Utilities to work with SQLite database.

DB Browser for SQLite

Post2_17032018_1_c
DB Browser for SQLite is onle of the popular high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. Using DB Browser you can create, define, modify, delete tables/indices/records. You can import and export records as text, tables from/to CSV files, databases from/to SQL dump files etc.

SQLite Studio

Post3_17032018_1_c
SQLite Studio is the portable database manager for SQLIte database. Its fast, lightweight and free. SQLite Studio is cross-plarform that runs on Windows 9x/2k/XP/2003/Vista/7, Linux, MacOS X. The Database can be exported into various formats such as SQL statements, CSV, HTML, XML, PDF, JSON. Also, you can import database from various formats CSV, custom text files.

SQLiteSpy

Post3_17032018_2_c
SQLiteSpy is the one of the fastest and compact GUI database manager for SQLite that reads SQLite3 files and execute SQL. SQLiteSpy is free and built-in SQLite engine. Support various mathematical SQL functions, regular expressions, data compressions, full unicode, compact result storage, multiple SQL edits, grid cell editing, encription support and more.

SQLiteTool

Post3_17032018_3_c
SQLiteTool is the stand alone client GUI tool for SQLite database that support both SQLite2 and SQLIte3 versions. The SQLiteTool is available on both Windows and Linux. The SQLiteTool includes SQLite engine and no need to download and install the database.

phpLiteAdmin

Post3_17032018_4_c
phpLiteAdmin is a web-based SQLite database admin tool written in PHP with support for SQLite2 and SQLite3. The features, operations and user experiance are similar to phpMyAdmin for MySQL. If you are experienced in how to use phpMyAdmin, then it wil be easy for you to use phpLiteAdmin. phpLiteAdmin is Lightweight – consists of a single source file for portability and quick installation.

SQLite Administrator

Post3_17032018_5_c
SQLite Administrator is a powerful tool that allow you to create, design or administrate SQLite database files easily and effectively. The SQL code editor helps you to quickly write sql queries with features such as code completion and highlighting. Both major versions of SQLite database files are supported by SQLite Administrator.The SQLite Administrator having powerful feature that allow you to create/delete/modify tables, indices, views, triggers, through wizard. It also includes data importing from CSV files and Data exporting to XLS, CSV HTML and XML. You can store queries into database and it has powerful search module that allow you to search queries. You can also store images such as JPEG and BMP into BLOB. The migration feature allow you to migrate SQLite2 database into SQLite3 database. Supporting powerful GUI elements that makes user friendly interface E.g. locating SQL error, SQL code hilighting, intelisense etc.

SQLite Books from Amazon

Rs. 478
Rs. 599
8 new from Rs. 478
Amazon.in
Free shipping
Rs. 2,199
6 new from Rs. 2,199
Amazon.in
Free shipping
Rs. 1,723
Rs. 1,723
11 new from Rs. 1,723
Amazon.in
Free shipping
Rs. 479
Rs. 599
7 new from Rs. 479
Amazon.in
Free shipping
Rs. 4,899
8 new from Rs. 4,427
2 used from Rs. 2,044
Amazon.in
Free shipping
Rs. 1,099
Rs. 1,356
7 new from Rs. 1,099
Amazon.in
Free shipping
Rs. 4,005
Rs. 5,099
9 new from Rs. 2,582
1 used from Rs. 3,135
Amazon.in
Rs. 6,640
2 new from Rs. 6,640
1 used from Rs. 1,645
Amazon.in
Rs. 5,519
1 new from Rs. 5,519
Amazon.in
Rs. 5,226
Rs. 5,451
4 new from Rs. 5,026
Amazon.in
Last updated on May 20, 2018 2:49 PM

– Article ends here –

Related Tags:

Software engineer by profession, founder of troubleshottyourself channel and enthusiastic blogger. Love to write articles on new technology, programming,

Share this: