mORMot Open Source

Are you implementing the new encryption on to TSQLDBSQLite3ConnectionProperties.Create?

Any plans to link with Wxsqlite?

I can't find where the authentication is defined. All I can find is
Server := TSQLite3HttpServer.Create('8080',[DB], 'localhost');

You should use ChangeSQLEncryptTablePassWord before you connect with the database

ChangeSQLEncryptTablePassWord(DBFilename, '', edtPassword.Text);

I was wrong.
even though sqlite browser does not list data, sqlite console shows the table and data - except that PC's bell is ringing throughout the listing.

It works for me.
This time even though testpass.db3 opens in sqlite3 browser, even the database structure is not visible.
Array, have you removed the old synopse directories from delphi library options?

It is not a wrapper over hwaci SEE but over standard SQlite with added encryption. My understanding is it is a standalone implementation of encryption. However it is compatible with Hwaci implement.
I have used the dll with ZeosDB successfully.

http://zeos.firmos.at/kb.php?mode=article&k=14

If you are in a hurry, ZeosDBO is a good solution.
It provides sqlite3 encryption when used sqlite3.dll from WxSqlite or System.Data.SQLite. My experience is that WxSqlite is superior to the later.
See http://zeos.firmos.at/viewtopic.php?t=1 … ecb3efde22
Development is more or less stalled at the moment, however, the library is very stable (IMHO).
The only drawback I experienced is that static linking of sqlite is not available.

Hi ab,
Thanks for the help.
However, I am facing a new problem now. I am not able to attach a :memory: database.
The code:

DBsUser.ExecuteNoResult('ATTACH DATABASE ":memory:" AS Memfile;', [VarRec]);

I am getting the error:
"SQL logic error or missing database"

Thanks ab for the help. I was able to create a simple example using SynDBSQLite3.

However, the problem array81 reported is confirmed. My code below:

procedure TForm1.Button1Click(Sender: TObject);
var
   VarRec: array of TVarRec;
begin
   SQLite3DB := TSQLDBSQLite3ConnectionProperties.Create('Test.db3', '', '', '123');
   SQLite3DB.ExecuteNoResult('create table if not exists mytable (a integer, b integer);', VarRec);
   SQLite3DB.ExecuteNoResult('INSERT INTO mytable VALUES (1, 2);', VarRec);
end;

The database is successfully created, but I can open the file in a sqlite browser without any password.
ab, can you please look into it?