SQLite Browser per OS/2

Version: 
3.9.1
Release date: 
Monday, 3 October, 2016

License:

Interface:

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 as compressed package. You have to download and manually install it; if prerequisites are required, you will have to manually install them too.

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 ghostscript
Following links are to additional programs, not mandatory but useful:

Online documentation:

Following ones are the download links for manual installation:

SQLite Browser per OS/2 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
SQLite Browser per OS/2 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
SQLite Browser per OS/2 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
SQLite Browser per OS/2 v. 3.7.8 (5/6/2012, Ruediger Ihle)
 hobbes.nmsu.edu/download/pub/os2/apps/database/sqlitebrowser13j.zip
Record updated last time on: 09/10/2020 - 17:46

Translate to...

Add new comment