Brew Sqlite

Posted on by



Note, if building against homebrew-installed sqlite on OS X you can do: npm install -build-from-source -sqlite= /usr/ local/opt/sqlite/ By default the node-gyp install will use python as part of the installation. A different python executable can be specified on the command line. Npm install -build-from-source -python= /usr/ bin/python2. 2017-09-20 - DB Browser for SQLite 3.10.1 has been released!:D 2017-09-08 - Removed the continuous AppImage builds for Linux due to problems with the upload script. DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. The brewday printout is formatted in organized specifically for following when you brew. Saving Your Work. When you close brewtarget, you will be given an option to either save or discard your work. General Concepts. Brewtarget v2.0 uses an SQLite database of recipes, ingredients, etc. Adds spatial SQL capabilities to SQLite: proj: 7.2.1: Cartographic Projections Library: sqlite: 3.35.4: Command-line interface for SQLite: wxmac: 3.0.5.1: Cross. Homebrew is a package manager for larger “general purpose” packages, such as Python, SQLite, MySQL, PostgreSQL, or Git. Do not install packages whose languages have package managers of their own. For example, packages written in Python be installed not with Homebrew but with pip, a package manager for Python, and will be explained later.

What it is

DB Browser for SQLite is a high quality, visual, open source tool tocreate, design, and edit database files compatible with SQLite.

It is for users and developers wanting to create databases, search, and editdata. It uses a familiar spreadsheet-like interface, and you don't need tolearn 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 it is not

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

Windows

Windows binaries can be downloaded from here:

Nightly builds are available at:

Note - If for some reason the standard Windows release doesn't work foryou (eg it gives an error), try a nightly build. They often fix bugsreported after the last release. :D

MacOS X

DB Browser for SQLite works well on MacOS X.

  • OSX 10.8 (Mountain Lion) - 10.11 (El Capitan) are tested and known to work
Brew Sqlite

OSX binaries can be downloaded from here:

Latest OSX binary can be installed via Homebrew Cask:

Nightly builds for OSX are available at:

Brew Sqlite Browser

Linux

DB Browser for SQLite works well on Linux.

Arch Linux

Arch Linux provides a package through pacman. Game save editor for mac.

Fedora

For Fedora (i386 and x86_64) you can install by issuing:

Ubuntu and Derivatives

Stable release

For Ubuntu and derivaties, @deepsidhu1313provides a PPA with our latest release here:

To add this ppa just type in these commands in terminal:

Then update the cache using: Free cropping tool for mac.

Install the package using:

Ubuntu 14.04.X, 15.04.X, 15.10.X and 16.04.X are supported for now (untilLaunchpad decides to discontinue build for any series).

Ubuntu Precise (12.04) and Utopic (14.10) are not supported:

Brew Sqliteman

  • Precise doesn't have a Qt 5.2 package in its repository by default, which isa dependency
  • Launchpad doesn't support Utopic any more, as that has reached its End ofLife

Nightly builds

Nightly builds are available here:

To add this ppa just type in these commands in terminal:

Then update the cache using:

Install the package using:

Other Linux

On others you'll need to compile it yourself using the (simple) instructionsin BUILDING.md.

FreeBSD

DB Browser for SQLite works well on FreeBSD, and there is a port for it (thanksto lbartoletti😄). It can be installedusing either this:

or this:

Compiling

Instructions for compiling on (at least) Windows, OSX, Linux, and FreeBSD arein BUILDING.

Twitter

Follow us on Twitter: https://twitter.com/sqlitebrowser

Website

Old project page

Releases

  • Version 3.9.1 released - 2016-10-03
  • Version 3.9.0 released - 2016-08-24
  • Version 3.8.0 released - 2015-12-25
  • Version 3.7.0 released - 2015-06-14
  • Version 3.6.0 released - 2015-04-27
  • Version 3.5.1 released - 2015-02-08
  • Version 3.5.0 released - 2015-01-31
  • Version 3.4.0 released - 2014-10-29
  • Version 3.3.1 released - 2014-08-31 - Project renamed from 'SQLite Database Browser'
  • Version 3.3.0 released - 2014-08-24
  • Version 3.2.0 released - 2014-07-06
  • Version 3.1.0 released - 2014-05-17
  • Version 3.0.3 released - 2014-04-28
  • Version 3.0.2 released - 2014-02-12
  • Version 3.0.1 released - 2013-12-02
  • Version 3.0 released - 2013-09-15
  • Version 3.0rc1 released - 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) from Tabuleiro Producoes, asthe Arca Database Browser. The original version was used as a free companiontool to the Arca Database Xtra, a commercial product that embeds SQLitedatabases with some additional extensions to handle compressed and binary data.

The original code was trimmed and adjusted to be compatible with standardSQLite 2.x databases. The resulting program was renamed SQLite DatabaseBrowser, and released into the Public Domain by Mauricio. Icons werecontributed by Raquel Ravanini, also fromTabuleiro. Jens Miltner (@jmiltner) contributedthe code to support SQLite 3.x databases for the 1.2 release.

Pete Morgan (@daffodil) created an initialproject on GitHub with the code in 2012, where several contributors fixed andimproved pieces over the years. René Peinthor (@rp-)and Martin Kleusberg (@MKleusberg) thenbecame involved, and have been the main driving force from that point. JustinClift (@justinclift) helps out with testingon OSX, and started the new github.com/sqlitebrowser organisation on GitHub.

John T. Haller, ofPortableApps.com fame, created the new logo. Hebased it on the Tango icon set (public domain).

In August 2014, the project was renamed to 'Database Browser for SQLite' atthe request of Richard Hipp (creator ofSQLite), as the previous name was creating unintendedsupport issues.

In September 2014, the project was renamed to 'DB Browser for SQLite', toavoid confusion with an existing application called 'Database Browser'.

Contributors

You can see the list by going to the Contributors tab.

License

DB Browser for SQLite is bi-licensed under the Mozilla Public LicenseVersion 2, as well as the GNU General Public License Version 3 or later.

You can modify or redistribute it under the conditions of these licenses.

The Official home of the DB Browser for SQLite

Screenshot

What it is

DB Browser for SQLite (DB4S) is a high quality, visual, open source tool tocreate, design, and edit database files compatible with SQLite.

DB4S is for users and developers who want to create, search, and editdatabases. 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 doesnot require familiarity with SQL commands. It is a tool to be used by bothdevelopers and end users, and must remain as simple to use as possiblein order to achieve these goals.