DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. DB4S is for users and developers who want to create, search, and edit databases. DB4S uses a familiar spreadsheet-like interface, and complicated SQL commands do not have to be learned. This program is not a visual shell for the sqlite command line tool, and does not require familiarity with SQL commands. It is a tool to be used by both developers and end users, and must remain as simple to use as possible in order to achieve these goals. Import and export records as text, import and export tables from/to CSV files, import and export databases from/to SQL dump files, issue SQL queries and inspect the results, examine a log of all SQL commands issued by the application, plot simple graphs based on table or query data.
Features
- Create and compact database files
- Create, define, modify and delete tables
- Create, define, and delete indexes
- Browse, edit, add, and delete records
- Import and export tables from/to CSV files
- Import and export databases from/to SQL dump files
Project Samples
License
GNU Free Documentation LicenseFollow DB Browser for SQLite
User Reviews
-
Glancing this since several months, this meets now exactly my needs! Please don't stop working on this great project!
-
Works well, at least for small tables, when you don't need a lot of filtering. It would be helpful to have a list of recently visited databases. It is tedious to always pick the database using the file dialogue.
-
.
-
Greate ! all though it needs some enhancmenet for ease of use but no doubt great work ! Can u please populate source code so we can modify it ? Thanks again friend!
-
I would just like to know how to use it!! No help file so I guess it's just assumed that whoever is using it knows what they're doing. All I want to do is add records to an existing .sqlite file and there is nothing whatsoever to give me any clue how. No matter what I do, when I click 'New record' I get an error: "Error adding record, make sure a table is selected". Programs that don't come with help files are very frustrating!!