We have not come across any issues in our tests, since it did not hang, crash or pop up error dialogs. The tool does not put a strain on PC performance, since it runs on low CPU and RAM. The database browser keeps all information in tree view form. It also lets you export the query results or copy them to the Clipboard. SQL statements can be easily executed by inputting data in a dialog box (auto-completion is automatically enabled), and SQLite Viewer shows any errors. So, you can select a table to view information, apply quick filters to look up something in particular, as well as export the table to CSV or XML format, or just copy the entire contents to the Clipboard. Database files can be opened via the file browser only, since the drag-and-drop function is not supported. The GUI is based on a regular window split into three main areas for browsing data, executing SQL queries and exploring the database. It is also possible to save SQLite Viewer to a USB flash disk or similar storage unit, to be able to run it on any machine effortlessly and without previously installing anything.Īn important aspect to take into account is that the Windows registry does not get updated with new entries, and no extra files are created on the disk, leaving no traces behind after its removal. You can just drop the program files in any part of the hard drive and just click the executable to run. At the bottom of the data source settings area, click the Download missing driver files link.
#Sqlite database viewer drivers
On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon and select SQLite. This is a portable app, so no installation is necessary. In the Database tool window (View Tool Windows Database), click the Data Source Properties icon. It features just some basic options that can be easily figured out by users.
SQLite Viewer is a free and open-source software utility that enables users to open and examine SQLite database files.