by

Sqlite For Mac

  1. Summary: in this tutorial, you will learn step by step on how to download and use the SQLite tools to your computer. Download SQLite tools. To download SQLite, you open the download page of the SQlite official website.
  2. SQLiteStudio - Free (GPL licence), advanced SQLite database manager with intuitive user interface, with no installation needed (single executable file to run).

SQLPro for SQLite is the Premier application for editing and browsing SQLite databases on mac os x. SQLite is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for. The SQLite file format is stable, cross-platform, and backwards compatible and the developers pledge to keep it that way through at least the year 2050. SQLite database files are commonly used as containers to transfer rich content between systems and as a long-term archival format for data.

Screenshots

Description

SQLPro for SQLite is an advanced sqlite editor. It has an easy to navigate interface, with the ability to perform the most basic to advanced tasks.
Features include:
+ Syntax highlighting and query intellisense/auto-complete.
+ Advanced multi-query execution.
+ Pick from multiple included themes, or design your own.
+ Automatic external change detection reloads a database when modified outside of SQLPro.
+ Version integration. Mucked your database? Rollback to a previous version.
+ Runtime loadable extension support.
+ Semiautomatic dependency resolution.
+ Export your data to csv, mysql, xml or json.
+ Backwards compatibility with SQLite 2.
+ Fullscreen support.
+ Column reordering.
+ Inline filters allowing you to customize the way your data is displayed.
If you have any issues with this application, please see our support forum: https://sqlitepro.com/forum or send us a message on Twitter: @SQLProApp.
This product is an independent management tool for SQLite.
SQLPro for SQLite is not affiliated or endorsed by the SQLite development team.

What’s New

+ Resolved an issue which could cause an occasional crash.
+ Improved database support.

56 Ratings

Reloading Database is infuriating!!!!

OMG, it just did it while I'm typing this. Whenever there's a change in the database, it brings the window forward.
I had a two DBs open in separate windows. One much more active than the other. When I was using the less active DB window, the other one kept bringing itself forward, making it nearly impossible for me to do what I needed.
On top of that, the entire window becomes completely locked whenever it's in that loading mode. So, good luck if you're trying to write a query or something with an active DB open.
In Preferences, you can disable 'Reload database on external changes' but toggling that doesn't seem to have any effect. It still keeps reloading itself every few seconds.
This is the only app I've found so far that checks off pretty much every requirement I have for a sqlite GUI, so I'd really like to keep using it, but this 'reloading database' nonsense is getting tiresome.

Lost data

Pc download manager. I rarely write unfavorable reviews, but I just lost a couple of hours worth of work because the app wasn’t saving my changes, and I didn’t discover this until closing and re-opening the file. Hard to trust a database editor that silently ignores saves.

Does what’s on the tin, but leaves me wanting

To inspect and manage SQL databases this app works great. The “reloading database” feature holds this app back the most:
- When the DB changes, the app pops itself up and says “reloading database”. Pops itself up from the bottom of my window stack to just behind my foremost window—still very visually distracting.
- While it’s “reloading database” the app is completely hung: can’t keep working on my SQL query; can’t resize the window; completely hung.
- You can turn this feature off; but it will run all your SQL queries against a cached version of the database instead of the live one.

Information

Size
12.6 MB
Compatibility

OS X 10.11 or later, 64-bit processor

Age Rating
Rated 4+
Price
$39.99

Sqlite Studio For Mac

Supports

  • Family Sharing

    With Family Sharing set up, up to six family members can use this app.

From Postgresql Community:
SQLite is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is currently found in more applications than we can count, including several high-profile projects. SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format. Think of SQLite not as a replacement for Oracle but as a replacement for fopen() If you need a GUI for database management, you can install NAVICAT. SQLite is a compact library. With all features enabled, the library size can be less than 300KiB, depending on compiler optimization settings. (Some compiler optimizations such as aggressive function inlining and loop unrolling can cause the object code to be much larger.) If optional features are omitted, the size of the SQLite library can be reduced below 180KiB. SQLite can also be made to run in minimal stack space (4KiB) and very little heap (100KiB), making SQLite a popular database engine choice on memory constrained gadgets such as cellphones, PDAs, and MP3 players. There is a tradeoff between memory usage and speed. SQLite generally runs faster the more memory you give it. Nevertheless, performance is usually quite good even in low-memory environments.

What do you need to know about free software?

From Postgresql Community:

Sqlite

SQLite is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is currently found in more applications than we can count, including several high-profile projects. SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format. Think of SQLite not as a replacement for Oracle but as a replacement for fopen() If you need a GUI for database management, you can install NAVICAT. SQLite is a compact library. With all features enabled, the library size can be less than 300KiB, depending on compiler optimization settings. (Some compiler optimizations such as aggressive function inlining and loop unrolling can cause the object code to be much larger.) If optional features are omitted, the size of the SQLite library can be reduced below 180KiB. SQLite can also be made to run in minimal stack space (4KiB) and very little heap (100KiB), making SQLite a popular database engine choice on memory constrained gadgets such as cellphones, PDAs, and MP3 players. There is a tradeoff between memory usage and speed. SQLite generally runs faster the more memory you give it. Nevertheless, performance is usually quite good even in low-memory environments.