DB Browser for SQLite (ex SQLite Browser)

Release date: 
Tuesday, 5 June, 2012



Authors/Port authors:

This is a port of SQLite Browser to OS/2. SQLite Database Browser is a freeware, open source visual tool used to create, design and edit database files compatible with SQLite. Program ported using the QT Toolkit. Port by different authors.

It is for users and developers wanting to create databases, 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

This program is not a visual shell for the sqlite command line tool. It does not require familiarity with SQL commands. It is a tool to be used both by developers and by end users, and it must remain as simple to use as possible in order to achieve its goals.

This software is distributed in two modes:
  • as compressed package that you have to download and manually install; if prerequisites are required, you will have to manually install them too;
  • as RPM package; you can install it using your favorite rpm package manager, that will take care to download and install both the software and its prerequisites.
Choose the installation mode that you prefer. Please note that not all the versions are available in both the installation modes.

Installation with rpm

This program is installable using the rpm package manager. See below for the install string. Required prerequisites are automatically processed by the package manager and, if needed, downloaded and installed.

sqlitebrowser-3.12.2-1.oc00 (16/05/2021)
Repository: Netlabs stable
# DB Browser for SQLite [![Wiki][wiki-img]][wiki] [![Build Status][travis-img]][travis] [![Join the chat at https://gitter.im/sqlitebrowser/sqlitebrowser][gitter-img]][gitter] [![Join the chat at https://join.slack.com/t/db4s/shared_invite/enQtMzc3MzY5OTU4NDgzLWRlYjk0ZmE5ZDEzYWVmNDQxYTYxNmJjNWVkMjI3ZmVjZTY2NDBjODY3YzNhNTNmZDVlNWI2ZGFjNTk5MjJkYmU][slack-img]][slack] [![Download][download-img]][download] [![Qt][qt-img]][qt] [![Coverity][coverity-img]][coverity] [![Patreon][patreon-img]][patreon] ![DB Browser for SQLite Screenshot](https://github.com/sqlitebrowser/sqlitebrowser/raw/master/images/sqlitebrowser.png "DB Browser for SQLite Screenshot") ## What it is _DB Browser for SQLite_ (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. DB4S is for users and developers who want to create, search, and edit databases. DB4S uses a familiar spreadsheet-like interface, and complicated SQL commands do not have to be learned. 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 * Plot simple graphs based on table or query data ## What it is not This program is not a visual shell for the sqlite command line tool, and does not require familiarity with SQL commands. It is a tool to be used by both developers and end users, and must remain as simple to use as possible in order to achieve these goals. ## Wiki For user and developer documentation, check out our Wiki at: https://github.com/sqlitebrowser/sqlitebrowser/wiki. ## Nightly builds Download nightly builds for Windows and OSX here: * https://nightlies.sqlitebrowser.org/latest ## Windows Download Windows releases here: * https://sqlitebrowser.org/dl/#windows **Note** - If for some reason the standard Windows release does not work (e.g. gives an error), try a nightly build. Nightly builds often fix bugs reported after the last release. :D ## MacOS X / macOS DB Browser for SQLite works well on MacOS X / macOS. * OSX 10.8 (Mountain Lion) - 10.13 (High Sierra) are tested and known to work Download OSX releases here: * https://sqlitebrowser.org/dl/#macos The latest OSX binary can be installed via [Homebrew Cask](https://caskroom.github.io/ "Homebrew Cask"): ``` brew cask install db-browser-for-sqlite ``` ## Linux DB Browser for SQLite works well on Linux. ### Arch Linux Arch Linux provides a package through pacman. ### Fedora Install for Fedora (i386 and x86_64) by issuing the following command: $ sudo dnf install sqlitebrowser ### openSUSE $ sudo zypper install sqlitebrowser ### Debian Note that Debian focuses more on stability rather than newest features. Therefore packages will typically contain some older (but well tested) version, compared to the latest release. Update the cache using: sudo apt-get update Install the package using: sudo apt-get install sqlitebrowser ### Ubuntu and Derivatives #### Stable release For Ubuntu and derivaties, [@deepsidhu1313](https://github.com/deepsidhu1313) provides a PPA with the latest release here: * https://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowser To add this ppa just type in these commands in terminal: sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser Then update the cache using: sudo apt-get update Install the package using: sudo apt-get install sqlitebrowser Ubuntu 14.04.X, 15.04.X, 15.10.X and 16.04.X are supported for now (until Launchpad decides to discontinue building for any series). Ubuntu Precise (12.04) and Utopic (14.10) are not supported: * Precise does not have a new enough Qt package in its repository by default, which is a dependency * Launchpad does not support Utopic any more, which has reached its End of Life #### Nightly builds Nightly builds are available here: * https://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowser-testing To add this ppa, type these commands into the terminal: sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser-testing Then update the cache using: sudo apt-get update Install the package using: sudo apt-get install sqlitebrowser ### Other Linux On others, compile DB4S using the instructions in [BUILDING.md](BUILDING.md). ## FreeBSD DB Browser for SQLite works well on FreeBSD, and there is a port for it (thanks to [lbartoletti](https://github.com/lbartoletti) :smile:). DB4S can be installed using either this command: # make -C /usr/ports/databases/sqlitebrowser install or this command: # pkg install sqlitebrowser ## Snap packages [![Get it from the Snap Store](https://snapcraft.io/static/images/badges/en/snap-store-black.svg)](https://snapcraft.io/sqlitebrowser) #### Snap Nightlies snap install sqlitebrowser --devmode #### Snap Stable snap install sqlitebrowser ## Compiling Instructions for compiling on Windows, OSX, Linux, and FreeBSD are in [BUILDING](BUILDING.md). ## Twitter Follow us on Twitter: https://twitter.com/sqlitebrowser ## Website * https://sqlitebrowser.org ## Old project page * https://sourceforge.net/projects/sqlitebrowser ## Releases * [Version 3.11.2 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.11.2) - 2019-04-03 * [Version 3.11.1 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.11.1) - 2019-02-18 * [Version 3.11.0 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.11.0) - 2019-02-07 * [Version 3.10.1 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.10.1) - 2017-09-20 * [Version 3.10.0 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.10.0) - 2017-08-20 * [Version 3.9.1 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.9.1) - 2016-10-03 * [Version 3.9.0 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.9.0) - 2016-08-24 * [Version 3.8.0 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.8.0) - 2015-12-25 * [Version 3.7.0 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.7.0) - 2015-06-14 * [Version 3.6.0 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.6.0) - 2015-04-27 * [Version 3.5.1 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.5.1) - 2015-02-08 * [Version 3.5.0 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.5.0) - 2015-01-31 * [Version 3.4.0 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.4.0) - 2014-10-29 * [Version 3.3.1 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.3.1) - 2014-08-31 - Project renamed from "SQLite Database Browser" * [Version 3.3.0 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.3.0) - 2014-08-24 * [Version 3.2.0 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/sqlb-3.2.0) - 2014-07-06 * [Version 3.1.0 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/sqlb-3.1.0) - 2014-05-17 * [Version 3.0.3 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/sqlb-3.0.3) - 2014-04-28 * [Version 3.0.2 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/sqlb-3.0.2) - 2014-02-12 * [Version 3.0.1 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/sqlb-3.0.1) - 2013-12-02 * [Version 3.0 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/sqlb-3.0) - 2013-09-15 * [Version 3.0rc1 released](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/rc1) - 2013-09-09 - Project now on GitHub * Version 2.0b1 released - 2009-12-10 - Based on Qt4.6 * Version 1.2 released - 2005-04-05 * Version 1.1 released - 2004-07-20 * Version 1.01 released - 2003-10-02 * Version 1.0 released to public domain - 2003-08-19 ## History This program was developed originally by Mauricio Piacentini ([@piacentini](https://github.com/piacentini)) from Tabuleiro Producoes, as the Arca Database Browser. The original version was used as a free companion tool to the Arca Database Xtra, a commercial product that embeds SQLite databases with some additional extensions to handle compressed and binary data. The original code was trimmed and adjusted to be compatible with standard SQLite 2.x databases. The resulting program was renamed SQLite Database Browser, and released into the Public Domain by Mauricio. Icons were contributed by [Raquel Ravanini](http://www.raquelravanini.com), also from Tabuleiro. Jens Miltner ([@jmiltner](https://github.com/jmiltner)) contributed the code to support SQLite 3.x databases for the 1.2 release. Pete Morgan ([@daffodil](https://github.com/daffodil)) created an initial project on GitHub with the code in 2012, where several contributors fixed and improved pieces over the years. René Peinthor ([@rp-](https://github.com/rp-)) and Martin Kleusberg ([@MKleusberg](https://github.com/MKleusberg)) then became involved, and have been the main driving force from that point. Justin Clift ([@justinclift](https://github.com/justinclift)) helps out with testing on OSX, and started the new github.com/sqlitebrowser organisation on GitHub. [John T. Haller](http://johnhaller.com), of [PortableApps.com](http://portableapps.com) fame, created the new logo. He based it on the Tango icon set (public domain). In August 2014, the project was renamed to "Database Browser for SQLite" at the request of [Richard Hipp](http://www.hwaci.com/drh) (creator of [SQLite](http://sqlite.org)), as the previous name was creating unintended support issues. In September 2014, the project was renamed to "DB Browser for SQLite", to avoid confusion with an existing application called "Database Browser". ## Contributors View the list by going to the [__Contributors__ tab](https://github.com/sqlitebrowser/sqlitebrowser/graphs/contributors). ## License DB Browser for SQLite is bi-licensed under the Mozilla Public License Version 2, as well as the GNU General Public License Version 3 or later. Modification or redistribution is permitted under the conditions of these licenses. [travis-img]: https://travis-ci.org/sqlitebrowser/sqlitebrowser.svg?branch=master [travis]: https://travis-ci.org/sqlitebrowser/sqlitebrowser [gitter-img]: https://badges.gitter.im/sqlitebrowser/sqlitebrowser.svg [gitter]: https://gitter.im/sqlitebrowser/sqlitebrowser [slack-img]: https://img.shields.io/badge/chat-on%20slack-orange.svg [slack]: https://join.slack.com/t/db4s/shared_invite/enQtMzc3MzY5OTU4NDgzLWRlYjk0ZmE5ZDEzYWVmNDQxYTYxNmJjNWVkMjI3ZmVjZTY2NDBjODY3YzNhNTNmZDVlNWI2ZGFjNTk5MjJkYmU [download-img]: https://img.shields.io/github/downloads/sqlitebrowser/sqlitebrowser/total.svg [download]: https://github.com/sqlitebrowser/sqlitebrowser/releases [qt-img]: https://img.shields.io/badge/Qt-qmake-green.svg [qt]: https://www.qt.io [coverity-img]: https://img.shields.io/coverity/scan/11712.svg [coverity]: https://scan.coverity.com/projects/sqlitebrowser-sqlitebrowser [patreon-img]: https://img.shields.io/badge/donate-Patreon-coral.svg [patreon]: https://www.patreon.com/bePatron?u=11578749 [wiki-img]: https://img.shields.io/badge/docs-Wiki-blue.svg [wiki]: https://github.com/sqlitebrowser/sqlitebrowser/wiki changelog * Sat May 15 2021 - First RPM for OS2

Manual installation

Program is distributed as ZIP/7 ZIP package: download to temporary directory and unpack to destination folder. See below for download link(s).

  • ExtendedSysTray widget for xCenter/eCenter. Not strictly required but recommended.
  • Cups is needed for printing, if it's not then it's not needed to install.

You can install the prerequisites with rpm running the following string in a command line:

yum install libc libcx libgcc1 libssp libstdc++6 libstdc++ libsupc++6 libsupc++ libgcc-fwd libqt4 libqt4-gui libqt4-webkit libqt4-sql-mysql libqt4-sql-psql cups cups-filters qt5-qtbase* ghostscript
Following links are to additional programs, not mandatory but useful:

Online documentation:

Following ones are the download links for manual installation:

DB Browser for SQLite (ex SQLite Browser) v. 3.12.99 (Release 2, 6/10/2023, Elbert Pol (TeLLie)) Readme/What's new
# CHANGELOG for DB4S All notable changes to the **Database Browser for SQLite** - DB4S - project will be documented in this file. The format is based on [Keep a Changelog](https://keepachangelog.com/en/1.1.0/), and this project adheres to [Semantic Versioning](https://semver.org/spec/v2.0.0.html).
DB Browser for SQLite (ex SQLite Browser) v. 3.9.1 (3/10/2016, Elbert Pol (TeLLie)) Readme/What's new
This is a small release that prepares the terrain for a new upcoming feature called DBHub plus a few old bugs fixed and some others that were introduced by 3.9.0: Major features DBHub.io was recently announced. Future releases of DB Browser for SQLite will optionally be able to save and retrieve your SQLite databases "in the cloud". 2016-10-01 file menu options 1b You can enable/disable this new submenu in Preferences. Enhancements Decreased lagging with long strings (further work still needed) - #761 (thanks to @innermous and @MKleusberg) Indicate when display strings are being truncated - #767 (thanks to @justinclift) Focus the newly created field after clicking 'Add field' - 64ee665 (thanks to @revolter) Improved Execute current SQL line action - #780, 45affc9, 531eddb (thanks to @revolter) Bug fixes Fixed default font selected being incorrectly detected - b15c7f2, 49786e1 (thanks to @innermous and @justinclift) Increased custom Page Size upper limit - e12e043 (thanks to @MKleusberg) Fixed program not being able to uninstall from "Programs and Features" in Windows 7 - 90c094e (thanks to @justinclift) Fixed executing current line action incorrectly logging the entire SQL - 55d8905 (thanks to @revolter) Added HTML entities escaping in output when executing SQL - b9dd11d (thanks to @innermous) Fixed Indexes with spaces around their name not being able to be deleted - 8be2c54 (thanks to @MKleusberg) Removed quotes around content when a single cell is copied - 8c510ff (thanks to @revolter) Help button should not be present in Windows title bar - #796 (thanks to @schdub) Translations Updated Russian translation - #795 (thanks to @schdub) Updated Spanish translation - #794, #801 (thanks to @lulol) Updated German translation - #798 (thanks to @FriedrichFroebel) Updated Korean translation - #797 (thanks to @progh2) Updated Brazilian Portuguese translation - #802 (thanks to @mafagafogigante)
DB Browser for SQLite (ex SQLite Browser) v. 3.9.0 (2/10/2016, Elbert Pol (TeLLie)) Readme/What's new
It's been yet another half a year (more precisely, 8 months) since the previous version 3.8.0 was released, and a lot of good things happened. Major features Strong encryption is now supported on Windows, using SQLCipher! - 5d98a19 (thanks to @huy-cong and @justinclift for figuring this out) Keyboard navigation in the "Browse Data" tab now works well Our releases are now digitally signed on both Windows and MacOS Enhancements Add Fedora install instructions - #467, #470 (thanks to @subdriven) Add Windows DATE display format - #471 (thanks to @MyRoGeertGit) Remove ampersands from windows title - d9d2f96 (thanks to @MKleusberg) Feature request: Option to turn off "intellisense"-like suggestions - #537 (thanks to @MKleusberg) Add select and deselect all options for Export SQL dialog - #549 (thanks to @wierzba3) Add Homebrew Cask install instructions - #564, #566 (thanks to @timbroder) Add decimal support to display format - #569 (thanks to @jungle-boogie) Add Edit Database Cell update when selecting a cell from the Execute SQL tab - #570 (thanks to @larsimmisch) Cannot view binary data on BLOB columns containing image - #580 (thanks to @justinclift) Update Fedora install instructions - #586, #587 (thanks to @FreedomBen) Add preference setting for exports line ending - #592, #597 (thanks to @justinclift) Adjust executable/app name according to the project's name - #593 (thanks to @justinclift) Add duplicate record option - #594 (thanks to @innermous) Change default button to No in removal message dialogs - #618 (thanks to @innermous) Add default field type preference setting - #652 (thanks to @revolter) Add option to export only the data in an SQL export - c8f0203 (thanks to @MKleusberg) Remove buggy Edit Dialog and improved Edit Dock - #668, #679 (thanks to @justinclift) Add Ubuntu install instructions on the website - #671 (thanks to @justinclift) Add Rackspace logo on the website - 6fda155 (thanks to @justinclift) Add binary data size to the Edit Dock - #699 (thanks to @revolter) Update installer .dmg on Mac OS - #693 (thanks to @justinclift and @revolter) Add Create Index button in the toolbar and fixed Create Index dialog sizing - #704 (thanks to @revolter) Add backspace alongside delete key for cell empty, for laptops missing the delete key - #705 (thanks to @justinclift) Optimize choosing displayed text for cell - 6b42af7 (thanks to @innermous) Improve copy/pasting in ExtendedTableWidget - #709 (thanks to @innermous) Feature request: We should sign our official releases - #711 (thanks to @justinclift) Reimplement data handling in the Edit Cell widget - #713 #410 (thanks to @justinclift) Bug fixes Fix building on CentOS - #572 (thanks to @Maxim-Mazurok) Fix crash when browsing data in some cases - 730a272 (thanks to @MKleusberg) Fix font blur on retina displays in the SQL Log - #575 (thanks to @nickberry17) Fix crash when trying to delete records from empty table - #590 (thanks to @innermous) Fix database toolbar actions not updating after deleting a table - #600 (thanks to @revolter) Fix cancel button not working in the Export SQL dialog - #608 (thanks to @justinclift) Fix Field separator and Quote character preferences not restoring correctly - #609 (thanks to @justinclift) Fix various small bugs with the quote and separator choices - #611 (thanks to @justinclift) Fix primary keys not being quoted when creating/modifying tables - 7e0adab (thanks to @MKleusberg) Fix crash in Browse Data tab when pasting empty string over non-empty cell - 1ce62d7 (thanks to @innermous) Fix cell Edit Dialog not showing up centered - #644 (thanks to @DelphiGit) Fix Show rowid column option not correctly refreshing the table view - #645 (thanks to @revolter) Fix crash when hovering over any row from the rowid column - #646 (thanks to @revolter) Fix for unquoted path vulnerability in the Windows app - #649 (thanks to @DelphiGit and @justinclift) Fix incorrect app version in Finder's Info view - #658 (thanks to @revolter) Fix crash when trying to Export table(s) as CSV in some cases - 2c1ab5b (thanks to @innermous) Fix navigation keyboard shortcuts not working in Browse Data tab in some cases - 2bcc603 (thanks to @justinclift) Fix DB Toolbar visibility preference setting not restored in some cases - #666 :smiling_imp: (thanks to @innermous) Fix Alt-Delete not setting the selected cell to NULL - #663 (thanks to @justinclift) Fix transactions not being ignored when executing SQL - #656 (thanks to @revolter) Fix elements focus order on Tab press - #676 (thanks to @chrisjlocke) Fix Edit Dialog opening when pressing Enter - a7b5c3f (thanks to @MKleusberg) Fix Filter Input row in RTL Locales - #685 (thanks to @SafaAlfulaij) Fix Edit Dock default position - 30d2ce3 (thanks to @revolter) Fix crash when closing unsaved database (or some other rare cases) - #690 (thanks to @revolter) Fix font preference settings not being reflected in the Edit Dock - 7eb733b (thanks to @justinclift) Fix Arabic translations not showing up correctly - #702 (thanks to @justinclift) Fix cell binary data getting corrupted when trying to edit in place - #708 (thanks to @SafaAlfulaij) Fix foreign key preview not showing up for foreign keys in the first column - #718 (thanks to @schdub) Translations Add Korean translation - #475, #736 (thanks to @progh2) Add Turkish translation - #546, #548 f33a988 (thanks to @firateski) Add Spanish translation - #560, #723, #740 b1c853a (thanks to @lulol) Update German translation - #567, #733 (thanks to @FriedrichFroebel) Add Arabic translation - #642 (thanks to @0xbsec) Update Arabic translation - #706, #716 efba2eb (thanks to @SafaAlfulaij) Update Russian translation - #719 (thanks to @schdub) Add Brazilian Portuguese translation - #730 (thanks to @mafagafogigante) Update French translation - #727 (thanks to @mvt91)
DB Browser for SQLite (ex SQLite Browser) v. 3.8.0 (17/6/2016, Elbert Pol (TeLLie)) Readme/What's new
It is over 6 months since the previous version 3.7.0 was released and a lot has happened since, all the details on which are below and as you can see there is a lot! On MacOS X, this is our first release using Qt5, and it's worth noting we updated the underlying SQLite to version 3.9.2 (on both platforms) this is so we can support the changes made for 3.9.x which impact database schema, see https://www.sqlite.org/releaselog/3_9_2.html for these changes. You will also notice a lot of "user experience" enhancements and fixes, so hopefully you will find this new release a pleasure to use. Happy Christmas! Enhancements Add proper file extension filters to all file dialogs - 6b8f57d (thanks to @MKleusberg) Improved error handling, e.g. more error messages with more detailed error descriptions - #362, #363, 1696ad1 (thanks to @schdub and @MKleusberg) Allow changing table columns even when there is a foreign key constraint on the table - #362 (thanks to @MKleusberg) When holding Ctrl and Shift while clicking on a cell with a foreign key set, the browser now jumps to the referenced record - #192 (thanks to @MKleusberg) Add option for disabling the SQL error indicators in the Execute SQL area - #302 (thanks to @MKleusberg) Add an option for setting the colours of fields with regular and binary data - #377 (thanks to @schdub) Use the name of the imported file as default suggestion for a table name during CSV import - #376 (thanks to @MKleusberg) Save filter values, sort order and column widths for all tables when switching the current table or tab; also save the settings in the project file - 748f06d (thanks to @MKleusberg) Show a small clear button inside each filter box - 944e22a (thanks to @MKleusberg) Add basic support for different 'display formats', i.e. a conversion of the contents of a column into a different format for display purposes (e.g. converting a Unix epoch into an actual date) - 7c1d237, 22e858d (thanks to @MKleusberg) Remove deleted files from list of recently opened files - #379 (thanks to @MKleusberg) Add a new option for horizontal tiling of the code and result view in the Execute SQL area - #380 (thanks to @MKleusberg) Move execution time of the SQL statement to the top of the result view in the Execute SQL area - #381 (thanks to @MKleusberg) Add 'x rows affected' information to the result view of the Execute SQL area - 82292c2 (thanks to @MKleusberg) Add built-in UTF16 and UTF16CI collation - #391 (thanks to @sebastian-philipp) Add Ctrl+R shortcut (besides F5) for the refresh table button - #388 (thanks to @MKleusberg) Add option for setting the font and font size of the text in the table browser view - #383 (thanks to @MKleusberg) Support opening of read only database files - #402 (thanks to @MKleusberg) Add option for showing the rowid column in the data browser view - #408 (thanks to @MKleusberg) Add option for showing the text in the data browser view using a different encoding - #414 (thanks to @MKleusberg) Add option for setting an escape character for the filters in the data browser - #421 (thanks to @MKleusberg) Add a small delay before applying a new filter value instead of performing an instantaneous search to improve performance on large tables - #415 (thanks to @MKleusberg) Automatically add '%...%' wildcards to a filter query - #415 (thanks to @MKleusberg) Add Delete and Alt+Delete keyboard shortcuts for setting the current cell to empty string or NULL in the data browser view - #443 (thanks to @MKleusberg) Add new option for moving the Edit cell data dialog into a dock which is locked to the main window and stays opened - #416, #440, #441 (thanks to @MKleusberg) Allow drag-&-dropping text and files on a cell in the data browser - #441 (thanks to @MKleusberg) Add keyboard shortcuts for recently opened files - #432 (thanks to @MKleusberg) Add new option for setting a SQL script which gets executed whenever any database file is opened - #451 (thanks to @MKleusberg) Allow pasting data (e.g. from a spreadsheet) directly into the data browser view - #453 (thanks to @MilosSubotic) Bug fixes Fix missing SQL log when query contains a line break, also trim the log - #337, #356 (thanks to @schdub and @MKleusberg) Also set foreign key settings when creating a new database instead of just setting them when opening a file - 212116a (thanks to @MKleusberg) Fix drawing of Unicode characters in the SQL editor where the font settings wouldn't apply as they should have - #365 (thanks to @SevenLines) Allow values greater than 10000 in the user_version pragma of a database - #366 (thanks to @schdub) Fix adding new a record into a table where all fields are set to a default value - #369 (thanks to @schdub) Fix resizing of the code and result view in the Execute SQL area - 6806a9b (thanks to @MKleusberg) Fix error message when changing table - #390 (thanks to @MKleusberg and @GeorgijK) Fix parsing of double backticks and double quotes used to escape a single one in create table statements - 160bc87, dce47b3 (thanks to @MKleusberg) Fix handling of tables when their name contains a backtick - #387 (thanks to @MKleusberg) Try to set a better window position when opening the Edit cell data dialog - #342, #394 (thanks to @MKleusberg) Fix possible infinite loop in the Edit cell data dialog - #444 (thanks to @manisandro) Fix bug when pressing the cancel button in the dialog you see when you're closing a database with unsaved changes - #432 (thanks to @MKleusberg) Don't allow conflicting field names in the Edit Table dialog - #460 (thanks to @MKleusberg) Translations Add translation into Traditional Chinese - #425 (thanks to @PeterDaveHello) Cross platform fixes Fix building on OS X 10.10 - #384 (thanks to @jehoffmann)
DB Browser for SQLite (ex SQLite Browser) v. 3.7.8 (5/6/2012, Ruediger Ihle)
Record updated last time on: 17/10/2023 - 03:23

Translate to...

Add new comment