Installing SQLite on your Mac is pretty straightforward. Just follow these steps: Head over to SQlite.org and download the C source code file, named sqlite-autoconf-3130000.tar.gz or similar, from. Jan 31, 2019. SQLite is the server. The SQLite library reads and writes directly to and from the database files on disk. SQLite is used by Mac OS X software such as NetNewsWire and SpamSieve. When you download SQLite and build it on a stock Mac OS X system, the sqlite tool has a very primitive command-line.
(Please consider sponsoring us on Patreon ?)
![]() Windows
Our latest release (3.12.0) for Windows:
Sqlite Manager For Mac
Note - If for any reason the standard Windows release does not work(e.g. gives an error), try a nightly build (below).
Nightly builds often fix bugs reported after the last release. ?
macOS
Our latest release (3.12.0) for macOS:
Homebrew
If you prefer using Homebrew for macOS, our latest release can be installed via Homebrew Cask:
Nightly builds
Download nightly builds for Windows and macOS here:
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:
openSUSEDebian
Note that Debian focuses more on stability rather than newest features. Therefore packages will typically contain some older version, compared to the latest release.
Update the cache using:
Install the package using:
Ubuntu and DerivativesStable release
For Ubuntu and derivaties, @deepsidhu1313provides a PPA with the latest release here:
To add this ppa just type in these commands in terminal:
Then update the cache using:
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 building for any series).
Ubuntu Precise (12.04) and Utopic (14.10) are not supported:
Nightly builds
Nightly builds are available here:
To add this ppa, type these commands into the terminal:
Then update the cache using:
Install the package using:
Other Linux
On others, compile DB4S using the instructionsin BUILDING.md.
FreeBSD
DB Browser for SQLite works well on FreeBSD, and there is a port for it (thanksto lbartoletti ?). DB4S can be installedusing either this command:
or this command:
Snap packagesDb Browser For Sqlite MacSnap NightliesSnap Stable
OS X 10.9 Mavericks comes with pre-installed SQLite 3.7.13, and OS X 10.10 Yosemite comes with version 3.8.5. At the time of this writing, SQLite version 3.8.6 is already available. This post would like to show you how to upgrade SQLite in OS X to the latest version.
This tutorial should be also applicable for previous Mac OS X versions such as OS X 10.7 Lion and OS X 10.8 Mountain Lion.
1. Run ‘sqlite3’ in the Terminal app to show the installed SQLite version.
2. Go to http://www.sqlite.org/download.html page and download the Precompiled Binaries for Mac OS X (sqlite-shell-osx-x86-3080600.zip)
3. Unzip the ‘sqlite-shell-osx-x86-3080600.zip’ file so you will get the new ‘sqlite3’ file.
4. Backup the current version of SQLite and make it non-executable file.
Sqlite Browser For Mac
5. Now move the new downloaded sqlite3 file to /usr/bin/ directory and make it executable.
Download Sqlite Mac Os Xp
6. Verify that SQLite has been upgraded by issuing ‘sqlite3’ command in Terminal
Mac Sqlite Viewer
You can see on the above that the SQLite has been successfully upgraded to version 3.8.6
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |