Home

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. 😄 See issue #226 for a list of ideas.

For Users

Basic usage

• Keyboard shortcuts - The keyboard shortcuts present in DB4S
• Browse Data - How to use the "Browse Data" tab
• 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
• Encodings - How to display text in different encodings
• Conditional Formats - How to apply text formatting to cell data
• Plot Dock - How to plot graphs using table or query data
• Views - How to create them, and what they're for
• Transactions - How to commit or revert database changes
• Tutorials - Some third-party text tutorials that might be helpful
• Video tutorials - Some third-party video tutorials that also might be helpful

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
• Running an Integrity Check - Confirming the database is healthy
• Frequently Asked Questions

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
• 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
• Translations - How to add a new translation or update an existing one.
• 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
  • Notarizing our macOS releases - Steps to follow for notarizing our macOS releases
• Source code highlights - Work in progress. Overview of parts of the codebase.

Other

• Our nightly build scripts

  • macOS
  • Ubuntu

• Wiki History - See change history for the full wiki