Home · sqlitebrowser/sqlitebrowser Wiki

[ShellLM]

• Home · sqlitebrowser/sqlitebrowser Wiki

Home · sqlitebrowser/sqlitebrowser Wiki

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
• Ubuntu 16.04 - Simple instructions for compiling on Ubuntu 16.04 using Qt Creator and the latest Qt Version
• Ubuntu to use a pre-installed version of SQLite
• Debian
• Debian Stretch with SQLCipher support

Windows

• 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.

Other

• 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.

Our nightly build scripts

• macOS
• Ubuntu
• Wiki History - See change history for the full wiki

Website | Twitter @sqlitebrowser | DBHub.io

Suggested labels

None

[ShellLM]

Related content

#74 similarity score: 0.91
#779 similarity score: 0.87
#695 similarity score: 0.87
#545 similarity score: 0.86
#639 similarity score: 0.86
#692 similarity score: 0.86