- 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
https://autohotkey.com/boards/viewtopic ... 12&t=13432
- Also, SQL apps mentioned in the Stack Overflow 2018 survey:
Stack Overflow Developer 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.