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.
Pages so far:
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
- 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
- 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 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
- 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
- Source code highlights - Work in progress. Overview of parts of the codebase.
Other
-
Our nightly build scripts
-
Wiki History - See change history for the full wiki
Getting Started
For Users
- Encrypted Databases
- Keyboard shortcuts
- Browse Data
- Filters
- Regular Expressions
- Display Formats
- Conditional Formats
- Plot Dock
- Views
- Project Files
- Command Line Interface
- Transactions
- Tutorials
- Video tutorials
- Windows Users
- macOS Users
For Developers
- Release process
- Source code highlights
- Merging Commits
- Translations
- Building on
- Nightly Builds
- Nightly build script for