DevelopmentSQLiteDatabase Management

What is the best SQLite manager for OS X?

6
Options 
Considered
0
User 
Recs.
Last 
Updated

Navicat for SQLite vs DB Browser for SQLite vs Base 2

 vs SQLPro vs TablePlus vs JookDB vs Valentina Studio

Specs

Platforms

-

Technology

-

Database management

-

Platforms

Windows, Linux, Mac, BSD

Technology

C++

Database management

-

Platforms

-

Technology

-

Database management

-

Platforms

-

Technology

-

Database management

-

Platforms

Windows, Linux, Mac

Technology

-

Database management

-

Platforms

Windows, Mac, Linux

Technology

C++

Database management

MySQL, MariaDB, Oracle, PostgreSQL, SQLite, MongoDB, DM, OceanBase, TiDB and SQLServer

Platforms

Windows, Linux, Mac

Technology

C++, QT

Database management

-

Pros + Cons

Pro
 Easy to use

Navicat manages an intuitive, easy to use UI without sacrificing functionality.
Comment

Pro
 Excellent choice of import/export options

You can easily import data from ODBC, Excel, Access, DBF, TXT, CSV, XML, JSON etc and export to Excel, Access, DBF, TXT, CSV, XML, JSON etc.
Comment

Con
 Expensive

Navicat for SQLite is very expensive, at least compared to other alternatives. It's cheapest version costs $129.00.
Comment

Pro
 Data and structure synchronization

Navicat can compare and synchronize your data and structure between local and remote databases.
Comment

Pro
 Unicode support

Navicat has full unicode support.
Comment

Pro
 SQL code completion

Navicat supports auto-complete for SQL queries.
Comment

Pro
 Visual report builder

Build reports in a visual way. Once set up, the process can be scheduled.
Comment

Pro
 Visual query builder

Create and edit queries without writing SQL.
Comment

Pro
 Cross-platform

Originally released on Windows, it has been ported to OS X and Linux.
Comment

Pro
 User management

Navicat allows for simple user and access management.
Comment

Pro
 Batch job scheduling

You can schedule things like backups, restores, data transfers or report building.
Comment

Pro
 HTTP Tunneling

Navicat offers HTTP Tunneling which allows users to bypass ISP restrictions on direct db server connections.
Comment

Pro
 Cross platform

DB Browser for SQLite is cross-platform and it's available for Mac, Linux and Windows.
Comment

Pro
 Open source

DB Browser is completely free and Open Source, it's source code is hosted on GitHub and is accessible by anyone.
Comment

Pro
 Simple to use

This tool was made to be used by both developers and end users. It was not made to be a shell for sqlite nor does it require to have knowledge of SQL. It's simply a visual tool to help users work with SQLite databases.
Comment

Con
 May freeze with big files

Even though large SQLite databases are very rare, DB Browser for SQLite freezes in those cases it comes across them.
Comment

Pro
 Easy data import

Base can easily import existing SQL or CSV data and save them to a SQLite database.
Comment

Con
 Proprietary

Base is a proprietary software, it costs £19.99 to buy. Although it has a free trial version which has multiple limitations, such as limiting developers to 15-minute long sessions and queries do not return more than 5 rows.
Comment

Pro
 Easy to use interface

Comment

Con
 Proprietary

SQLPro is a paid proprietary software with licenses starting at $19.99.
Comment

Pro
 Easily save queries

SQLPro supports saving queries that you may want to use more than once.
Comment

Pro
 Versions support

SQLPro supports version control with SQLite Tables. This means that if you truncate or modify a table by mistake, you can always revert to a previous version.
Comment

Con
 Pricy

This is a subscription based service. It's paid per month and add up from $161 to $180 per year.
Comment

Pro
 Powerful SQL editor

Equipped with the following features: •Highlight syntax •Indent SQL Command •Split Results into Tabs •Save favorite SQL to snippet •Customize font size
Comment

Pro
 Native, beautiful and friendly

TablePlus is a native app which helps you easily edit database data and structure.
Comment

Pro
 Most of the databases supported as database development tools

Includes Mysql, Oracle, Sqlserver, PostgreSql, Sqlite, etc. The interface is smooth and responsive, and the functions are strong.
Comment

Pro
 Good UI

Valentina Studio has a responsive and clean user interface.
Comment

Pro
 Multi DB

Supports several databases, MySQL/ MSSQL / PostGresSQL / and more
Comment

Pro
 Free version

You can download a free version from the app store.
Comment

Pro
 Cross-platform

Valentina Studio works on Windows, Linux and OS X.
Comment
undefinedurl nextprice drop