You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
sqlite is good, and I like it.
SEE(Sqlite Encryption Extension) not free. and sqlcipher
not amalgamation, so I cut some essential to do some updated.
But after sqlite3 version up, some api changed, so I search another solution,
now change to CEVFS.
Building
make.
Using
cerod is encrypt vfs name.
create plain db
bin/sqlite plain.db
SQLite version 3.39.3 2022-09-05 11:02:23
Enter ".help"for usage hints.
sqlite> create table people (name text primary key);
sqlite> insert into people (name) values ('charlie'), ('huey');
sqlite>select* from people;
charlie
huey
sqlite> .quit
bin/secure
sqlite> PRAGMA activate_extensions("cerod-x'2F3A995FCE317EA22F3A995FCE317EA22F3A995FCE317EA22F3A995FCE317EA2'");
sqlite> .open cipher.db
sqlite>select* from people;
Parse error: file is not a database (26)
sqlite> .quit
bin/secure
sqlite> PRAGMA activate_extensions("cerod-x'2F3A995FCE317EA22F3A995FCE317EA22F3A995FCE317EA22F3A995FCE317EA2'");
sqlite> .open test.db
sqlite> create table people (name text primary key);
sqlite> insert into people (name) values ('charlie'), ('huey');
sqlite>select* from people;
charlie
huey
sqlite> .quit
bin/secure
sqlite> PRAGMA activate_extensions("cerod-x''2F3A995FCE317EA22F3A995FCE317EA22F3A995FCE317EA22F3A995FCE317EA2'");
sqlite> .open test.db
sqlite>select* from people;
charlie
huey
sqlite> .quit
