- 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
SQLite and AHK - AutoHotkey Community
SQLite - AutoHotkey Community
- Also, SQL apps mentioned in the Stack Overflow 2018 survey:
Stack Overflow Developer Survey 2018
41.2% SQL Server
7.9% Microsoft Azure (Tables, CosmosDB, SQL, etc)
5.5% Google Cloud Storage
5.2% Amazon DynamoDB
5.1% Amazon RDS/Aurora
2.5% IBM Db2
2.2% Amazon Redshift
2.2% Apache Hive
2.1% Google BigQuery
1.7% Apache HBase
- Any further help or information would be much appreciated. Thanks.
- 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.