DB Browser for SQLite (formerly SQLite Database Browser)
As its name suggests, DB Browser for SQLite aims to provide both developers and end users with a simple tool for creating and editing SQLite database files, without having to deal with complicated SQL commands.
With help of this intuitive application, you can view the content of your databases in a structured manner. The simplistic, interface efficiently organizes the data, enabling you to view and browse indexes, schemas, tables and fields in tree view.
With just a few clicks, you can add new tables to the database, as well as remove or modify existing ones, without affecting the database integrity. New fields can be created, tables can be renamed and the field type can be easily changed. Moreover, you can create new indexes for a table or a field and insert them into the database.
The content of each table can be visualized separately and the data can be sorted by fields. The application comes with a search tool that can assist you in quickly finding the desired entry in a large database. Furthermore, the ‘Go To’ function makes navigation even more easy.
New records can be created and existing ones can be removed from the currently opened table. The content of each cell can be manually edited or imported from a text file in your computer.
DB Browser for SQLite features importing and exporting capabilities, with support for SQL and CSV formats. Furthermore, it enables you to write SQL queries, execute them and view the returned data, as well as the generated error messages, if any.
DB Browser for SQLite adopts a simplistic approach for managing SQL compatible databases. It includes comprehensive wizards for generating and modifying tables, performing interrogations and filtering data, issuing SQL queries, all without requiring familiarity with SQL commands.
included in these download hubs