DB Browser for SQLite (SQLite Browser)

Version: 
3.13.1
Release date: 
Tuesday, 5 June, 2012
Home: 
https://sqlitebrowser.org/

Categories:

License:

  • LGPL

Interface:

  • PMShell
  • Workplace Shell

Authors/Port authors:

Netlabs

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.13.1-1.oc00 (16/10/2024)
Repository: Netlabs stable
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, and this project adheres to Semantic Versioning. [Unreleased - nightly] - 2023-11-11 Add bullet points to the subheadings below as you commit changes. When a new version is released, incorporate the changes into that version's description, and create a new "[Unreleased - nightly] - yyyy-mm-dd" entry at the head of this file. [3.13.0] - 2023-11-11 See "Highlights on user-visible changes" on https://github.com/sqlitebrowser/sqlitebrowser/releases Added dbhub: Add text to upload button (7c6ef2ae) Add zooming to image viewer in the Edit Dialog (d3c69ad2) New setting for having close button on tabs (default) or not (896b0daa) New setting for configuring brace matching background (662dbcf9) New settings for changing the selection appearance in editors (0562f16d) Improvements for working in the SQL Execution area using keyboard (946d408a) Fall back to asking SQLite when parsing a table schema has failed (139de669) Update schema after attaching/detaching a database in an Execute SQL tab (b16017e1) Scale large images in ImageViewer to fit the viewport by default (23b1021d) Rename 'Open tab' to 'New tab' in the Execute SQL area (f5590265) Add iif SQL function to the list of known functions in Execute SQL tab (ff37c901) dbhub: Add refresh button to both tool bars (9a8bcafa) dbhub: Log in by only selecting an identity, no need to press a button (5cdda286) dbhub: Add context menu actions to all tree views (4c4e55f8) dbhub: Add toolbar action for fetching the latest commit (2e958036) dbhub: Add context menu action for saving a revision to another file (ab5b6337) Add GUID display format (e51aa2ee) Bar charts did not display labels in x axis when NULL values present (3485a52e) Add more options for setting font sizes (0eb01fe0) dbhub: Add view of all checked out databases (c776af98) dbhub: Add context menu action to delete local databases (dd323faf) dbhub: Add button for cloning databases from a link (e2783b68) dbhub: Add some line breaks to the input dialog text for cloning (595d845a) dbhub: Add link to webUI page of currently opened database (12ba01ff) Add status message when opening a file from the recent file list (d5b9d809) Move recent files items to new submenu and add clear recent file function (#2347) (ec6ff6a4) Add new action to close project file and return to initial state (aaa628bf) dbhub: Add "Upload Database" action to context menu of local file list (8db6e16f) Add file, line number and function to Error Log (ed226f1d) Add 'Don't ask again' button to collation message box (8323f2a1) Allow multiple TableBrowser tabs in the Browse Data tab (1e1e87e6) Add .NET DateTime.Ticks to date display format (b24c1f06) dbhub: Allow pushing to other user accounts to which you have access (dfc76450) Add the ability to support custom config files (#2390) (0644bc09) Add new option to freeze columns in the Browse Data tab (a15f81bc) Allow users to export or import user-settings file in a GUI environment (#2394) (27c2f64d) Add new menu item to import from CSV data in the system clipboard (9d87b963) Enable HiDPI on Windows (#2469) (1dc7ffee) Add "Save Database As..." action (c8cd8586) Enable HiDPI on all platforms by default (59778379) Add new menu item to show the row counts of all tables (efb9f9c9) Add Ctrl+Enter as shortcut for executing query (af84e89b) ImageViewer: Add mouse wheel zoom (f749f38f) Import: Add import-csv option to command line to import CSV files (09aaacca) parser: Add support for IS (NOT) DISTINCT FROM expressions (5c57622f) Add an extra tab for editing foreign keys to the Edit Table dialog (53b5493f) Add an extra tab for editing check constraints to the Edit Table dialog (54d82eab) Add auto completion for math functions (#2631) (fb80d3bc) Execute SQL: add Ctrl+Shift+T for "Open SQL file(s)" (128babb6) Add a refresh button to the Database Structure tab (d5c66088) macOS ARM version (e4435e67aad8d15569684074681c7200d55f5ac6) Fixed Fix crash when trying to open non-existing table via command line (112e0089) Fix possible crashes when loading outdated project file (31ded8a8) Fix possible crash when loading project files (fa04d72f) Fix empty filters in project files (60f12143) Fix a harmless warning when searching for an empty font name (ea6d0089) Fix executing selected SQL text when there are multi-byte characters (d089a60b) Fix SQL import of files with BOM (7c3cce56) Fix warning in SQL error log when creating an in-memory database (f4f014e7) dbhub: Fix port number mismatch when using port 443 (910ca3d2) Fix colour assigned to plot being always black (651c1999) dbhub: Fix sporadic crashes when selecting an identity (5341112b) Fix bug which made tables from other schemas inaccessible in Browse Data (b6e3db34) Fix crash when a format is applied and one or more columns are selected (4f9e7c5d) dbhub: Fix updating branch list when database name is changed (9274e24e) dbhub: Fix reply handler for push actions (cefb4b70) dbhub: Fix saving latest commit to file (d76d6c25) dbhub: Fix creating new branches (8c12ee01) Fix problems when showing help message in rich text format (0963cacc) Fixed incorrect display of SQL calltips containing non-US-ASCII characters (852faf6b) Fix to 'Window Layout' options work properly (bdabc446) parser: Fix unquoting when using square brackets (9a3e5b1a) Fix possible crash when trying to modify a table (b0762119) Fix formatting and syntax of the help message in Spanish (1a2de374) Fix saving the list of extensions in the Preferences dialog (9b387d20) Fix remaining issue with optimised SELECT statements (6f499054) Fix filter row losing focus when changing filter values (c951c1cb) Fix issues with executing SQL statements (367665e7) Fix editing of tables without rowid (1c0cf443) Fix running ALTER TABLE statements in Execute SQL tab (5d80f987) Fix 'Set Encryption': don't reuse current file after closing (967780d0) Fix possible crash when removing constraints from table definition (7c1454e7) Fix #2583: quote identifiers, not expressions (6b03a33e) Fix filters for tables with display formats (910a2e10) Fix changes to constraints in Edit Table dialog not always being applied (ef87dc63) Fix browsing tables without rowid and multiple primary key columns (0b1ff641) Fix possible memory leak when trying to open an encrypted database (13e17579) Fix title, which must be non-empty (c13fb733) Fix possible crash when browsing a table with multiple PK columns (b3fab20c) parser: Fix string literals used as column ids in indexed columns (594aa020) Fix repositioning of filter widgets after the second click on the header (13b372ca) Fix possible crash when opening a project without SQL tabs (f5e07452) Fixes for hiding the title bar of the single Table Browser (a1f6d2c7) [Fix Can't parse db name in .env file (302a5fe0) Fix type on TableBrowser.ui (33639dd2) Fix crash when removing the only index constraint from a table (a5a3d7fd) Fix error messages in Execute SQL tab (c0adfe43) Fix altering tables with generated as columns (39e9eb0e) <<<<<<< HEAD Changed Show a useful icon in SQL tabs (#2153) (81b9b5a1) Use Ctrl+PgUp to set focus to editor inside the SQL Execution Area. (971b5ce5) Open SQL tabs for modifying views and triggers (ebeef140) Font change in Browse Data table not applied to RTL Text editor (a803069d) No longer force Light theme on macOS when "Follow the desktop style" is chosen (0bb3b230) Also update schema when clicking the Refresh button in Browse Data tab (a09df5bc) dbhub: Improve support for different branches (6c2e38c2) dbhub: Show some information on the currently opened database file (8428c934) dbhub: Automatically switch to the correct identity when opening file (635dba93) Restore original default for having condition format in filter line (5f53d630) dbhub: Show list of commits in Remote dock (5d89bb89) dbhub: Use current locale for formatting all timestamps (f6f28855) dbhub: Refresh commit list after pushing a new commit (0942fad6) dbhub: Show a warning when trying to push unsaved changes (e285de6d) dbhub: Highlight current commit in commit list (c05b92e9) dbhub: Do not allow pushing in-memory databases (2ea87e7e) dbhub: Do no show error message when download was cancelled (10214b31) Better error messages when CSV import fails due to an unexpected EOF (f75a3587) dbhub: Better explanations for the Clone button (f81e4c2f) dbhub: Clear branches combo box when closing database (7842f2a1) Clear currently opened database file name when closing database (9fcba5a8) dbhub: Improve default settings table views in Remote dock a bit (fbfcdbe4) dbhub: Some UI improvements (fa193013) Use native path separators in Preferences dialog (f67d72df) dbhub: Allow checking out different commits and different branches (065adabe) dbhub: In Push dialog preselect the current branch (fc4deeb9) dbhub: Only show warning about losing unsaved changes when downloading (1af81359) Select column in table results when column header is pressed (aaf671f4) dbhub: Show more information in tree views (8b5f34c4) Hide filters when table is empty (fc78fc2f) GUI improvements in Edit Table Dialog (de28943e) Edit Table: Change the key icons from header to tooltips (424dd57d) Edit Table: alternating row colors in tables for better readability (4bf7adfa) Cut to clipboard operation in data browsers (09320c20) Remove filter widgets when the table is empty (0e1eb7db) Update remote database information when an upload is completed (40c132e9) Comment out additional gotReply() signal connection (aa3d2814) dbhub: When deleting last local database of a user, remove user too (70eb15a8) Resize rows to contents only for visible rows (c77cb972) dbhub: Redownload database when checking out current commit (69eec2b6) Avoid attaching the plot when the signal is notifying the row count since the data wouldn't be available yet. (20e94984) Return the configured font for data browser in the model (47aa591d) Avoid possible database busy message when using the Browse Table action (73b2a1c2) Use table name as tab text in Browse Data tabs (c96c393d) Always load settings for Browse Data tabs (e9ec07e1) Save custom tab title flag in project files (c33b8be8) Allow the user can change MaxRecentFiles (#2373) (54ee47b5) Change tabbed table browisng to use docks instead (28ae7417) Always raise new Data Browser tabs to the foreground (539657e5) Allow multiple -t/--table parameters on the command line (ab682a32) detach additional database connection (29635e9e) Refresh table views when using --table command line option (598dd545) Tweak the output wording for command line options (153e0290) Show preformatted text for output from command line arguments in Windows (175ff737) Remove the Default property of the fetching dialog (c791a9ff) Unify message in About dialog and version argument (fd54bf1a) Change to 'Preference' expression for consistent (d9fd0e17) dbhub: Make HTML text of commit message field non-translateable (a6acb6cc) Destroy the Temporary Fiel object so it is not kept open (d8ca11f5) Open in external application: apply saved data directly to the cell (7c147456) Adjust the bottom buttons layout (b5a0d531) User can disable 'Save Project' dialog (#2420) (04d53c6e) Correct to tab instead of space (bd8e6bfd) Evaluation mode in the Edit Database Cell editor (9a70af79) Store a relative filename if the path to project and to DB is the same (2390b9e6) Allow selecting fixed format for big integer numbers (7d041020) Avoid type conversion warnings in Plot Dock (8b98df14) Warn user to apply or discard unsaved changes in cell editor (1e4a88dd) Allow opening recent files in read-only mode using a different shortcut (11058633) Export SQL: fix quoting of BLOB values and non-printable strings (e5734d4f) CSV Import: give option to use system locale conventions (f9314b6d) CSV Import: fix importing into existing table (dafa873d) CSV Import: fixes of the local convention option (e0b40ad9) Data Browser: avoid showing BLOBs containing unprintable characters as text (5e0c56a4) SQL Execution Editor: appropriate helping message in reload dialog (df853b30) Plot: fix selecting points to select corresponding line in table (223a7cd6) CSV Export: binary BLOB to base64 (a86c196a) Complete menu accelerators in File and Tools entries (be041e5e) Give alternate shorcuts to the ones using F keys (576bbe7e) Binary detection: end-of-line characters where not treated as text (fb7248b7) Avoid running SELECT statements twice in Execute SQL tab (99ee8fa1) Enable buttons for editing/deleting tables and similar on first click (b3d30cad) For sorted column remember column name instead of column index (94023a55) Change WHERE clauses of queries to use column names instead of indexes (18c7e9c4) Import: support importing the single file argument as a CSV file (cfa4dee3) Import: announce support for CSV files in Desktop file (efa1cdf2) Import: do not remove characters from CSV header fields (248a630d) Update appdata to pass validation (b553c088) src: rename sqlb::Query::setColumNames (38cdd94e) Import: allow CSV separator and quote to be passed from command line (36c5b1ba) Export query results as JSON (e225dc1e) Save as view: allow any state in the table (2826e7b9) Data Browser: export query results as JSON (a5cc259b) Store table constraints in a vector instead of a set (4e1d1ff4) Import: "Yes to All" to skip all further prompts (035a541c) Table Browser: "Clear Filters" button to clear the global filter (580e86e2) Table Browser: give hint of table sorted or filtered state in the toolbar (78edc8f9) Import: don't assume an empty file is a text file (93a5c2d0) update plotwindow's selection in tablebrowser (a51d6c10) Table Browser: Support extended selections (c5199f55) Show tables in foreign key editor in alphabetical order (d7074bb8) Avoid multiple error messages when deleting cell values (50b48bc7) Do not always refresh the table browser dock when opening a database (3be5969b) Use LIMIT + OFFSET when generating SELECT statements instead (bbfaca2e) When modifying a view use DROP VIEW IF EXISTS instead of just DROP VIEW (6cde3f51) Add basic support for new RETURNING keyword (6f6113c2) fix indentation (4 spaces) (bb44fc15) Improve support for BLOB columns as primary key (6510bb10) CSV Import: use file before it is removed by destructor (5097760f) Export SQL: option to keep original CREATE statements (df700d19) Avoid error messages when checking for updates (3af4c3db) CipherSettings: fix crash with empty RawKey (1e77bc78) CipherDialog: Improve password fields validation (b7f5ef3f) Permit dollar signs ($) after the first char in unquoted IDs (c5853727) AboutDialog: Change layout to fit large font better (2df29fad) CLI: Reuse --table as table name for a CSV Import (6bdacf65) Settings: fix file check in "-S" option for Windows (dc855711) Execute SQL editor: Use tabs for indentation (9ba1a2ed) Do not add SQL keywords multiple times to auto completion (a92ab5e6) Swap sort order indicators (03ce1405) Only show numbered sort indicators when more than one column is sorted (d2746c0f) Icon in data browser for primary key fields (636662b3) Open SQL files are now linked when saving project file (3a4d7d8d) Data Browser: use font style to indicate keys (b6c5024d) Add copy column name to table viewer (32c99f0f) Use a separate enum for table constraint types in the Edit Table dialog (42c5de72) Respect the sqlite_sequence table when generating PK value for new rows (e6556585) Plot Dock: use more precision for small numbers and less for big numbers (974954f1) Edit Database Cell: fixed potential for data loss and better feedback (8f5c17e2) DB Schema: drag & drop SELECT queries (8bb16d1d) Change mouse cursor to the pointing hand when Ctrl+Shift are pressed (f18611ae) Do not show the titlebar for the Table Browser dock when there is only one (c40fb07b) Associate copy table column menu entry to action. (2e39408f) Refactor the constraints tab in the Edit Table dialog (dd625778) parser: Refactor parsing and handling of constraints (13b15ddc) Project files: fix crash when tables does not match DB file (f3247297) sqlite3 API: Prevent that busy DB are left open (0280d98a) Project files: prevent SQL tabs loss while closing the application (fb43e067) Save some screen space and reduce number of unnecessary borders (a78dd029) Export: fix no error check for export errors (e56051ce) Export: more error checks (b466cfa9) Optimise executing large SQL files in the Execute SQL tab (a4a19693) Speed up execution of many SQL statements by delaying the log output (21c7f76e) Plot: show x and y values on a tooltip when hovering over the plot (ce176be2) Export: use QSaveFile to get better error check on full partition (496d39db) appimage: Update to SQLite 3.41.1 (9426509ac8a8422d8b164c2acfb6a849ea37e306) ||||||| parent of 9832a52d (Replace http with https in the AboutDialog and MainWindow) none none etc. Replace http with https in the AboutDialog and MainWindow. 9832a52d (Replace http with https in the AboutDialog and MainWindow) Removed Translation Fix translation to match UI (f10bdbdb) Add Dutch translation (308e6ec7, 30413802) Add Indonesian translation (b9391212) Add Swedish translation (f69f66cc) Update Arabic translation (f0e7fe22) Update Brazilian Portuguese translation (ab2df420e4cb714d29437f2e94b938191f0ef886) Update Chinese translations (24c1fa73, 4a475757) Update French translation (fa3a0f57, 759efc68, e31d9fe7, 06200bfb, c902183c, 4eef0080, 2903ce1d, 6a641297) Update German translation (bbb8d1a6, 2a6acbfa, 48c8de6e, efcb24ae) Update Italian translation (5fd2cea5, be07d48c) Update Japanese translation (c894c4cb) Update Korean translation (bee8cfc6, 39026bc2, 81af52af, 5df98099, 4c404000) Update Polish translation (957de605) Update Spanish translation (a3360cc2, 579ab4e0, 4a2179ba) [3.12.2] - 2021-05-17 Release version of DB4S - DB Browser for SQLite. The basic features of the program are described in the README. Download release versions from https://sqlitebrowser.org/dl/

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.
Following is a list of prerequisites that you have to manually install in order to have the program working:

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 (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).
 hobbes.nmsu.edu/download/pub/pub/os2/util/database/SQLiteBrowser_3-12-99r2.zip
DB Browser for SQLite (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)
 ftp.netlabs.org/pub/qtapps/sqlitebrowser-3.9.1-os2.7z
DB Browser for SQLite (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)
 ftp.netlabs.org/pub/qtapps/sqlitebrowser-3.9.0-os2.7z
DB Browser for SQLite (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)
 ftp.netlabs.org/pub/qtapps/sqlitebrowser-3.8.0-os2.7z
DB Browser for SQLite (SQLite Browser) v. 3.7.8 (5/6/2012, Ruediger Ihle)
 hobbes.nmsu.edu/download/pub/os2/apps/database/sqlitebrowser13j.zip
Record updated last time on: 17/10/2024 - 05:36

Translate to...

EnglishEnglish
EnglishEnglishDutchDutchFrenchFrenchGermanGermanKoreanKoreanRussianRussianSwedishSwedish

Add new comment