Navicat Premium [Large and complete, commercial software]
Navicat Premium is a database development tool that allows you to connect to MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL and SQLite databases simultaneously from a single application.
www.navicat.com.cn/products/na…
SQLite Expert Professional
www.sqliteexpert.com/
SQLiteStudio (open source, lightweight, recommended)
Based on Qt, open source, the main interface supports a small part of Chinese
sqlitestudio.pl/
Github.com/pawelsalawa…
4, DB Browser for SQLite
SQLiteBrowser based on Qt, open source, the main interface support Chinese
Github.com/sqlitebrows…
5, dbeaver
Free universal database tool and SQL client
dbeaver.io/
Github.com/dbeaver/dbe…
6, DbGate
Database manager for MySQL, PostgreSQL, SQL Server and MongoDB. Runs under Windows, Linux, Mac or as web application
dbgate.org/
Github.com/dbgate/dbga…
X. Matters needing attention:
If you want to compile SQLiteStudio or SQLiteBrowser source code, you must prepare the following files:
sqlite3.dll
sqlite3.lib
sqlite3.h
How to prepare? See my other blog post for details:
Libaineu2004.blog.csdn.net/article/det…
(2) SQLiteStudio source code compilation
Copy sqlite3. H to
D:\tmp-source\qt-hmi\SQL\sqlitestudio-master\SQLiteStudio3\coreSQLiteStudio\db
Copy sqlite3.lib and sqlite3. DLL to
D:\tmp-source\qt-hmi\SQL\sqlitestudio-master\output\SQLiteStudio
In addition, third-party dependencies need to be downloaded, see:
Github.com/pawelsalawa…
—
reference
www.sqlite.org/index.html
www.runoob.com/sqlite/sqli…