Sqlite

Install DB Browser for SQLite 3.9.0 on Ubuntu 16.04

DB Browser for SQLite 3.9.0 which was released end of last year is now available for installation via the PPA. SQLite Browser is a visual tool used to create, design and edit database files compatible with SQLite. This release contains some important enhancements, and fixes. SQLite Browser 3.9.0 Changelog Major Features Strong encryption is now supported on Windows, using SQLCipher! – 5d98a19 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 Add Windows DATE display format Remove ampersands from windows title Feature request: Option to turn off “intellisense”-like suggestions Add select and deselect all options for Export SQL dialog Add Homebrew Cask install instructions Add decimal support to display format Add Edit Database Cell update when selecting a cell from the Execute SQL tab Cannot view binary data on BLOB columns containing image Update Fedora install instructions Add preference setting for exports line ending Adjust executable/app name according to the project’s name Add duplicate record option Change default button to No in removal message dialogs Add default field type preference setting See changelog for more Install SQLite Browser 3.

Install SQLite Browser 3.8 on Ubuntu 16.04 and Derivatives

In this tutorial, we’re going to show you how to Install SQLite Browser 3.8 on Ubuntu 16.04 and Derivatives. SQLite Browser 3.8.0 which was released end of last year is now available for installation via the PPA. SQLite Browser is a visual tool used to create, design and edit database files compatible with SQLite. This release contains some important enhancements, and fixes. Install SQLite Browser 3.8 on Ubuntu 16.04 and Derivatives SQLite Browser 3.

DB Browser for SQLite 3.7.0 released

DB Browser for SQLite 3.7.0 recently released, is a visual tool used to create, design and edit database files compatible with SQLite. This release contains some important enhancements, and fixes issues that are getting filed a lot. Specifically UTF-8 characters in the SQL Editor window and Windows dependency installation issues DB Browser for SQLite 3.7.0 update Enhancements Remove superfluous whitespace from Schema column in DB Structure view Add option to remember last location for file dialogs Add option for setting the font used in the SQL code editor Preserve filters in Browse Data tab when changing tabs Allow setting the line type and the point shape in the plot area Add a ‘Copy Create statement’ popup action to Database Browser tab Bug Fixes Fix UTF-8 characters in SQL code editor Make sure to always show text data (instead of ‘BLOB’) in Browse Data tab no matter the column’s data type in the table definition EditTableDialog: Add ‘=’ in front of default value when it is a function Fix a couple of typos Fix incorrect extra ‘);’ after create table statement in exported SQL Regexp cannot handle NULL text See changelog for more Download SQLite

DB Browser for SQLite 3.5.0 released with support for encrypted databases

SQLite 3.5.0 Database Browser recently released, is a visual tool used to create, design and edit database files compatible with SQLite. One of the major improvements in this release, is support for encrypted databases (for MacOS X and Linux only, not Windows yet). This is done using the SQLCipher encryption library. SQLite Database Browser 3.5.0 update Enhancements I18N – Simplified Chinese language support Add tooltip for all table items Remember CSV export options Distinguish Save and Save As when saving SQL files in the Execute SQL tab Add support for compiling on OS/2 Add two buttons to navigate to the head and the tail Compatibility with shadow build Support Indices without sorting – FreeBSD Port Enhancements with progress, though more still needs to be done Open Encrypted Database Add full support for tables without rowid NULL field values are not highlighted Ability to change language Bug fixes Foreign Key in Edit Create Table CSV export bug – Fields aren’t automatically quoted when separator character is present in the data [feature request]”Execute SQL”: clear output if query returns nothing Export to SQL INT Datatype Expression Crash when opening db without rowid and composite primary key Database Structure view: wrong parsing of CHECK constraints tests: fix QCoreApplication parameters Other notes The Windows release uses SQLite v3.

Adminer 4.2.0 – Database Management released

Adminer (formerly known as phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL,Oracle, SimpleDB, Elasticsearch and MongoDB. Adminer 4.2.0 changelog Fix XSS in login form (bug #436) Allow limiting number of displayed rows in SQL command Fix reading routine column collations Unlock session in alter database Make master key unreadable to others (bug #410) Fix edit by long non-utf8 string Specify encoding for PHP 5.