SQLite Studio is an open source web-based SQLite database browser that supports local and remote database files, and can query SQLite databases on the browser. @iFAdmin
What is SQLite?
SQLite is an embedded, lightweight relational database management system that supports most SQL standards and is commonly used in mobile applications and small projects.
For example, the database you use in WeChat is the WCDB database developed by Tencent based on SQLite.
SQLite Studio
SQLite Studio is a tool specifically designed to browse SQLite databases. After downloading, you only need to:
| 1 | $ sqlite-studio sqlite.db |
The browser will automatically open for query
In addition, you can also use the built-in preview database to familiarize yourself with the operation when running for the first time:
| 1 | sqlite-studio preview |
You can also query:
Dear developers, do you find this useful?
