- These are the results I've found so far:
to view SQL files as plaintext:
Notepad2 [or any text editor, the files may be too big for Notepad to handle]
to browse SQL files:
perhaps? DB Browser for SQLite
[I could see all of the information in Notepad2, however, I got this error:]
Please enter the key used to encrypt the database.
If any of the other settings were altered for this database file you need to provide this information as well.
to view DB files as plaintext:
(not applicable, the file appeared to be a binary format)
to browse DB files:
DB Browser for SQLite
to read/write DB files in AHK:
this class which requires sqlite3.dll:
[Class] SQLiteDB - Update on 2016-03-28 - AutoHotkey Community
https://autohotkey.com/boards/viewtopic.php?f=6&t=1064
[further links:]
SQLite and AHK - AutoHotkey Community
https://autohotkey.com/boards/viewtopic.php?f=5&t=39965
SQLite - AutoHotkey Community
https://autohotkey.com/boards/viewtopic ... 12&t=13432
- Also, SQL apps mentioned in the Stack Overflow 2018 survey:
Stack Overflow Developer Survey 2018
https://insights.stackoverflow.com/survey/2018/
Code: Select all
58.7% MySQL
41.2% SQL Server
32.9% PostgreSQL
25.9% MongoDB
19.7% SQLite
18.0% Redis
14.1% Elasticsearch
13.4% MariaDB
11.1% Oracle
7.9% Microsoft Azure (Tables, CosmosDB, SQL, etc)
5.5% Google Cloud Storage
5.5% Memcached
5.2% Amazon DynamoDB
5.1% Amazon RDS/Aurora
3.7% Cassandra
2.5% IBM Db2
2.4% Neo4j
2.2% Amazon Redshift
2.2% Apache Hive
2.1% Google BigQuery
1.7% Apache HBase
66,264 responses
- Btw please be very clear about any installation instructions.
- DB Browser for SQLite was a stand-alone app, I installed the portable version.
- For just me's SQLite library, I wrote some code in a script, used #Include to include Class_SQLiteDB.ahk, and I dowloanded sqlite3.dll separately and placed it in the same folder as Class_SQLiteDB.ahk.