Welcome to the DB Browser for SQLite wiki!

See http://sqlitebrowser.org for the full history, background and an overview.

There is information on SQLite itself at http://www.sqlite.org, which includes the official language overview.

Please feel welcome to create or update anything (related to the project) here.

Pages so far:

For Users

Basic usage

• Keyboard shortcuts - The keyboard shortcuts present in DB4S
• Resizing Columns - How to resize all of the columns in a table at the same time
• Using Filters - How to use the Filters in the Browse Data tab
• Using Regular Expressions - How to use Regular Expressions for powerful queries
• Display Formats - How to configure how data is displayed
• Plot Dock - How to plot graphs using table or query data
• Views - How to create them, and what they're for

Advanced topics

• Licensing - How our licenses work
• Windows File Associations - Making Windows file associations
• Encrypted Databases - How to use Encrypted Databases
• Extracting Installer Contents - How to extract the contents of .msi installers. Useful for installing without Admin rights.
• Silent mode installation on Windows - How to install DB4S silently on Windows. Useful for easy deployment
• Providing debug information - How to gather useful debugging information for reporting DB4S crashes
• SpatiaLite on Windows - The steps needed for installing the SpatiaLite extension to SQLite, on Windows
• Project Files - Save your frequently used SQL scripts with the database ... and other options
• Command Line Interface - You can start DB4S passing some useful parameters

Videos for Users

• How to add JPEG images as BLOB - YouTube video showing how to insert JPEG/JPEG images into a data
  • Note that this requires using a nightly build from 1st November 2017 (or later)

For Developers

• Compiling on OpenSuSE - Simple instructions for compiling on OpenSuSE Leap 42.2 and Tumbleweed
• Compiling on Ubuntu 16.04 - Simple instructions for compiling on Ubuntu 16.04 using Qt Creator and the latest Qt Version
• Compiling on Ubuntu to use a pre-installed version of SQLite
• Compiling on Debian Stretch
• Compiling on Debian Stretch with SQLCipher support
• Compiling SQLCipher on Windows - How to compile SQLCipher on Windows
• Dev environment setup on Windows using MSVC 2013 or 2017 - How to set up a development environment for DB4S on 64-bit Windows, based on using MSVC. Lots of screenshots.
• Merging Commits - How to merge the commits on your fork into one commit for a pull request
• Translation merge conflicts - How to proceed with translation conflicts
• Notes for compiling on OSX - Presently being developed too. Assistance is very welcome.
• Notes for compiling on Windows - Presently being developed. Assistance is very welcome.
• Our Release Process - Checklist / steps to follow when creating new DB Browser for SQLite releases
• Source code highlights - Work in progress. Overview of parts of the codebase.

Other

• Our nightly build scripts

  • MacOS X / OSX
  • Ubuntu
  • Windows

• Wiki History - See change history for the full wiki