Join GitHub today
GitHub is home to over 31 million developers working together to host and review code, manage projects, and build software together.Sign up
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:
- 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
- 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)
- 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.