Home FAQ Download Timeline Branches Tickets Login. Or the 'sqlite3.dll' native library). This package will depend on the 'System.Data.SQLite.Core'. DB Browser for SQLite is a high quality. Download 32-bit Windows.exe Download 64-bit Windows.exe Download PortableApp Download Mac.dmg Download source.

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.

New in DB Browser for SQLite 3.10.1: • This is a minor bug fix release for most people, but does address one fairly important problem with the Windows installer for the previous (3.10.0) release. • That previous release included updated MSVC redistributables which rebooted some people's computers at the end of the install, without warning or even prompting to save files.?? • Thanks to a fix by @Mischanix, the installer now instructs the included MSVC redistributes not to reboot when it finishes. Problem solved.??

Summary: in this tutorial, we first introduce you to an SQLite sample database. Then, we will give you the links to download the sample database and its diagram. At the end of the tutorial, we will show you how to connect to the sample database using the sqlite3 tool.

Introduction to chinook SQLite sample database We provide you with the SQLite sample database named chinook. The chinook sample database is a good database for practicing with SQL, especially SQLite. The following database diagram illustrates the chinook database tables and their relationships. Chinook sample database tables There are 11 tables in the chinook sample database. • employees table stores employees data such as employee id, last name, first name, etc. It also has a field named ReportsTo to specify who reports to whom. • customers table stores customers data. • invoices & invoice_items tables: these two tables store invoice data.

Peters Aircraft A330. The invoices table stores invoice header data and the invoice_items table stores the invoice line items data. • artists table stores artists data. It is a simple table that contains only artist id and name. • albums table stores data about a list of tracks. Each album belongs to one artist.