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 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 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 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 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 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 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
– Article ends here –
Software engineer by profession, founder of troubleshottyourself channel and enthusiastic blogger. Love to write articles on new technology, programming,