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. To compile the code, it needs access to the sqlite development libraries. This Rails on Mac OS X tutorial explains how to do it. Here is the most immediately relevant part: sudo chown -R `whoami` /usr/local #make sure we have correct permissions to install sqlite brew install sqlite gem install.
(Please consider sponsoring us on Patreon 😄)
Windows
Our latest release (3.12.0) for Windows:
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 an up to date version
Install with the following command:
Fedora
Install for Fedora (i386 and x86_64) by issuing the following command:
openSUSE
Debian
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 Derivatives
Stable release
For Ubuntu and derivaties, @deepsidhu1313provides a PPA with the latest release here:
Hold down the Shift key and left-click the Reload button. Press 'Ctrl + F5' or press 'Ctrl + Shift + R' (Windows,Linux). If you use extensions (Firefox menu button/Tools Add-ons Extensions) that can block content (e.g. Java for mac firefox. Adblock Plus, NoScript, Flash Block, Ghostery) then make sure that such extensions aren't blocking content.You can try these steps in case of issues with web pages:You can reload web page(s) and bypass the cache to refresh possibly outdated or corrupted files.
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:
- Precise does not have a new enough Qt package in its repository by default,which is a dependency
- Launchpad does not support Utopic any more, which has reached its End ofLife
Install Sqlite Studio Mac
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:
Our latest release (3.12.0) for Windows:
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 an up to date version
Install with the following command:
Fedora
Install for Fedora (i386 and x86_64) by issuing the following command:
openSUSE
Debian
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 Derivatives
Stable release
For Ubuntu and derivaties, @deepsidhu1313provides a PPA with the latest release here:
Hold down the Shift key and left-click the Reload button. Press 'Ctrl + F5' or press 'Ctrl + Shift + R' (Windows,Linux). If you use extensions (Firefox menu button/Tools Add-ons Extensions) that can block content (e.g. Java for mac firefox. Adblock Plus, NoScript, Flash Block, Ghostery) then make sure that such extensions aren't blocking content.You can try these steps in case of issues with web pages:You can reload web page(s) and bypass the cache to refresh possibly outdated or corrupted files.
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:
- Precise does not have a new enough Qt package in its repository by default,which is a dependency
- Launchpad does not support Utopic any more, which has reached its End ofLife
Install Sqlite Studio Mac
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 packages
Snap Nightlies
Snap Stable
About the App
- App name: sqlite-analyzer
- App description: Analyze how space is allocated inside an SQLite file
- App website: https://www.sqlite.org/
Install the App
- Press
Command+Space
and type Terminal and press enter/return key. - Run in Terminal app:
ruby -e '$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)' < /dev/null 2> /dev/null
and press enter/return key.
If the screen prompts you to enter a password, please enter your Mac's user password to continue. When you type the password, it won't be displayed on screen, but the system would accept it. So just type your password and press ENTER/RETURN key. Then wait for the command to finish. - Run:
brew install sqlite-analyzer
Done! You can now use sqlite-analyzer
.