DB Browser for SQLite
DB Browser for SQLite
3.12.0

5.0

HomeDeveloper ToolsSourceDB Browser for SQLite
DB Browser for SQLite free download for Mac

DB Browser for SQLite3.12.0

09 July 2020

Create database files compatible with SQLite (was SQLite Database Browser).

Overview

DB Browser for SQLite (was SQLite Database Browser) is a high quality, visual, open-source tool to create, design, and edit database files compatible with SQLite. It is for users and developers wanting to create databases, and search and edit data. It uses a familiar spreadsheet-like interface, and you don't need to learn complicated SQL commands. Controls and wizards are available for users to:

  • Create and compact database files
  • Create, define, modify and delete tables
  • Create, define and delete indexes
  • Browse, edit, add, and delete records
  • Search records
  • Import and export records as text
  • Import and export tables from/to CSV files
  • Import and export databases from/to SQL dump files
  • Issue SQL queries and inspect the results
  • Examine a log of all SQL commands issued by the application

What's new in DB Browser for SQLite

Version 3.12.0:
Enhancements:
  • Make use of the enhanced ALTER TABLE features in SQLite 3.25.0
  • Allow specifying an ON CONFLICT strategy in the Import CSV dialog
  • Add option to remember last location per action type when saving and loading
  • Add conditional formats to the Browse Data tab
  • Show current database action and add a cancel button in status bar (11ace1e)
  • Save read-only state in the project file
  • Add support for filtering by regular expressions using the /regexp/ syntax
  • More efficient table editing. When editing the schema, do all changes in one go at the end
  • Add comment/uncomment feature to the SQL editor
  • Add option to find and replace in the selection in the SQL editor
  • Execute SQL statements in a different thread, allowing long-running queries to be cancelled
  • When editing a cell with a foreign-key, show a list of possible values in a dropdown list
  • Many small performance improvements
  • Lots of UI reworking, allowing more flexibility, adding new shortcuts, fixing glitches, and making it more responsive. Some of the new settings are stored in the project file while the handling of project files itself is improved too
  • New Save Project As menu item
  • Ask the user whether to save modified SQL tabs when closing, add a new button to save changes in all open tabs, prompt to save changes in the project when closing the database or the application
  • Allow custom display formats
  • Add new log to the SQL log dock which prints the SQLite error log
  • New setting allowing to set a dark style using a style-sheet
  • Add support for sorting by multiple columns in the Browse Data tab and add a button to clear sort orders
  • Add support for inserting rows into views with appropriate triggers
  • Enable build against external QCustomPlot
  • Improved text editor in the Edit Cell dock
  • New command-line argument for saving settings
  • Show some information about the selected data when selecting cells in the Browse Data tab
  • Detect changes in SQL files made by other programs
  • Add a full find dialog to all text editors
  • Add constraint editing to the Edit Table dialog
  • Include a built-in certificate which allows out-of-the-box read-only access to dbhub.io
  • Support all Unicode quote and escape characters in the Import CSV dialog
  • Add proxy support to dbhub.io functionality
  • Add "Browse Table" action to the context menu of the DB Structure dock
  • Remember read-only flag for recent files list
  • Extended regular expression support in the find dialogs
  • Add duplicate tab feature to Execute SQL area
  • Prompt user for options after dropping files
  • Allow changing the collation of columns in the Edit Table dialog
  • Add global filter field to Browse Data tab
  • Support inline preview of image data in cells
  • Add move field to top/bottom buttons to Edit Table dialog
  • Add a find and replace toolbars to the Browse Data tab
  • Add a toolbar for direct formatting of columns, rows, and single cells in the Browse Data tab
  • Support custom SQLCipher cipher_plaintext_header_size
  • Add support for parsing, browsing, and editing tables with GENERATED ALWAYS AS columns
  • Use the column type affinity for the default text alignment in the Browse Data tab
  • Resize columns according to contents
  • Allow opening of URLs or filenames from database cells and add a button to insert a link to the file into the cell
  • Allow editing of the contents of database cells in external applications
  • Add support for a secondary Y-axis to the plot area
  • Drop close buttons on every Execute SQL tab(x)
  • Show a useful icon in SQL tabs
  • Open SQL tabs for modifying views and triggers
  • Fix logo issues
  • Install the AppStream file to the canonical location
  • Open a set of SQL-Files
  • Consistent naming of DB Browser for SQLite
  • Minor: Change "Filter in all columns" => "Filter in any column"
  • Avoid unchanged translation of keyboard shortcuts to work around problems
  • Rearrange preferences database
  • Use port 443 for DBHub.io traffic, to be more enterprise firewall friendly
  • Application icon cleanup
  • Update to Windows Icon Generation script
Bug fixes:
  • Avoid setting the database dirty with some trailing whitespace and comments
  • Use native and localised names for shortcuts in the tool-tips
  • Add macOS .dylib extension to the extension selector dialog
  • Do not show more than 512 characters in DB Structure tooltips
  • Load all pending data when select all is requested
  • Make the Edit Cell Dock to update with the selected cell in SQL results
  • Fix selecting columns in Browse Data tab instead of sorting them
  • Fix detection of XML data, some types of text data, and large numbers in the Edit Cell dock
  • Fix default collations and callbacks when creating a new database
  • Lots of bug fixes in the SQL parser
  • Always set sort direction to ascending when sorting a different column
  • Fix problems with the JSON export
  • Fix problems after closing a database
  • Fix syntax highlighting to exactly match the SQLite keywords
  • Fix deleting from WITHOUT ROWID table
  • Fix editing data in WITHOUT ROWID tables with multiple primary key columns
  • Silence some unnecessary warning messages
  • Fix licence list in dbhub.io push dialog
  • Fix loading last used settings in the Import CSV dialog
  • Fix setting last modified date when cloning a dbhub.io database
  • Fix possible crash when loading a corrupt project file
  • Include transaction statements in the SQL log
  • Fixes for editing cells with RTL texts
  • When updating a field try to respect the affinity data type if possible
  • Fix value in size column of dbhub.io panel for very large databases
  • Fix plotting data with NULL values by leaving gaps in the graph
  • Fix importing CSV files with quote characters and no final line break and with only one column and no final line break
  • Escape filepath when attaching database
  • Fix foreign-key editor not working correctly in Edit Table dialog
  • Fix issues with resizing and with hiding a column
  • Fix editing in tables with custom display formats
  • Fix problems with greediness in the DB4S implementation of the SQLite REGEXP operator
  • Check if some column has a NOT NULL constraint in "Set to NULL"
  • Fix error indication and savepoint handling after failed statements
  • Make SQL editor in Edit Table dialog read-only
  • Fix some problems with view editing in Browse Data tab
  • Fix handling of databases with a view and a trigger with the same name
  • Never mark the DB dirty if it is read-only
  • Fix the recordset numbers in the Browse Data tab
  • Fix some typos and translation problems
  • Fix dotenv not working for databases encrypted using SQLCipher 3
  • Fix dotenv not working when not specifying the plaintext header size
  • Crash when -t option specifies missing table
Translations:
  • Add Japanese translation
  • Update Russian translation
  • Update Chinese translation
  • Update Polish translation
  • Update Portuguese translation
  • Update French translation
  • Update Spanish translation
  • Update Turkish translation
  • Update Italian translation
  • Update German translation
  • Update Arabic translation
  • Update Simplified Chinese translation
  • Update German translation for v3.12.x
  • Updates the Brazilian Portuguese files for 3.12.0
  • Portuguese updates for 3.12
  • Update Japanese Translation for v3.12.x
  • Update zh translation
Packaging and Building:
  • Antlr is removed as a dependency
  • Niels Lohmann's JSON library is added as a dependency. A copy of the library is included in the source code.
  • Update bundled QScintilla library to version 2.11.1
  • Update bundled QHexEdit2 library to version 0.8.6
  • Update bunbled QCustomPlot library to version 2.0.1
  • Update bundled QDarkStyleSheet to version 2.8
  • More flexibility to override library paths
  • Add support for building with cmake 3.11 and later
  • cmake installation on macOS also copies the icon and desktop files
  • Add workaround for Qt bugs QTBUG-68891 and QTBUG-71020
  • Include a new SQLite extension for encoding and decoding base64 and decoding plist data
  • Include the fileio, soundex, r-tree, and geopoly extensions
  • Raise the maximum number of attached databases to 125 when using the bundled SQLite version
  • Add MIME information file

Join over 500,000 subscribers.

Subscribe for our newsletter with best Mac offers from MacUpdate.

How would you rate DB Browser for SQLite app?

1 Reviews of DB Browser for SQLite

WordWeaver
19 March 2014
Version: 2.0b1

Most helpful

Please note that the download link for this app is dead. However, this same app can be downloaded on the Sourceforge website at the following URL: http://sourceforge.net/projects/sqlitebrowser/
(1)
WordWeaver
19 March 2014
Version: 2.0b1
Please note that the download link for this app is dead. However, this same app can be downloaded on the Sourceforge website at the following URL: http://sourceforge.net/projects/sqlitebrowser/
(1)
Show comments (2)
Free

5.0

App requirements: 
  • Intel 64
  • OS X 10.8.0 or later
License: 
FreeAbsolutely Free

Downloaded & Installed 68,575 times

Similar apps
SQLPro for SQLite
SQLPro for SQLite
Advanced SQL editor.
Is this app is similar to SQLPro for SQLite? Vote to improve the quality of this list.
Vote results
0
Upvotes
3
Total score
0
Downvotes
Symphytum
Symphytum
Personal database software.
Is this app is similar to Symphytum? Vote to improve the quality of this list.
Vote results
0
Upvotes
2
Total score
0
Downvotes
SQLiteFlow
SQLiteFlow
SQL editor.
Is this app is similar to SQLiteFlow? Vote to improve the quality of this list.
Vote results
2
Upvotes
2
Total score
0
Downvotes
SQLiteManager
SQLiteManager
Database manager for SQLite databases.
Is this app is similar to SQLiteManager? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes
SQLite
SQLite
SQL database connection development library.
Is this app is similar to SQLite? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes