0red / sqlite_encryped_for_js_php

sqlite_encryped_for_js_php

Please copy jrsqlite.exe, jrsqlite.dll,jr_sqlite_secure.php,jr_sql.js i.e. into the dir where the server have the html/php files.

for ExeOutput exe/dll files have to be copied to %LocalAppData%\ExeOutput\{App GUID} --> could not be included "inside" ExeOutput (so mark as external files in ExeOutput and have to be phisically copied after installation).

The sqlite db file itself also will be in that directory - however it will be (is password set) AES-256 encrypted

For php usage (and password setting) please look into jr_sqlite_secure.php

I'm using it as the JS frontend to encrypted sqlite in EXEOUTPUT https://www.exeoutput.com/ For JS usage - the php (jr_sqlite_secure.php) as a wraper is requested (as well as proper access right)

when installed try in chrome console

{
  let q=[
                "DROP TABLE IF EXISTS Cars;",
                "CREATE TABLE Cars(Id INT, Name TEXT, Price INT);" ,
                "INSERT INTO Cars VALUES(67, 'A`udi', 52642);" ,
                "INSERT INTO Cars VALUES(2, 'M\"ercedes', 57127);" ,
                "INSERT INTO Cars VALUES(3, 'Skoda', 9000);" ,
                "INSERT INTO Cars VALUES(4, 'Volvo', 29000);" ,
                "INSERT INTO Cars VALUES(500, 'Bentley', 350000);" ,
                "INSERT INTO Cars VALUES(6000, 'Citroen', 21000);" ,
                "INSERT INTO Cars VALUES(7, 'Hummer', 41400);" ,
                "INSERT INTO Cars VALUES(1600000000000, 'Volkswagen', null);",
                "UPDATE Cars SET Name='VW' where Name='Volkswagen';"
         ];
  await sql(q);
         
  let result=await sql('select * from Cars');
  console.log(result.result)
}

based on https://github.com/utelle/wxsqlite3

via https://github.com/shenghe/FreeSQLiteEncryption or https://github.com/rindeal/SQLite3-Encryption

Please note - only tested on Windows (using EXEOutput) !!!