tclsqlcrypt

tclsqlcrypt is an adaptation of tclsqlite that uses SQLcrypt™.

Analogous to tclsqlite's Tcl command, sqlite3, tclsqlcrypt's Tcl command is sqlcrypt3.

  $ ./tclsqlcrypt3
  % sqlcrypt3
  Error: wrong # args: sould be "sqlcrypt3 HANDLE FILENAME ?-[decrypt|encrypt] PASSPHRASE?"
  % sqlcrypt3 -version
  3.2.2
  % sqlcrypt3 -is-sqlcrypt
  1
  % sqlcrypt3 db x.db -encrypt "book boo"
  0x605d60
  % db eval "create table a (ak int, av int)"
  % db eval "insert into a values (1,1)"
  % db close
  % sqlcrypt3 db x.db -decrypt "book boo"
  0x605d60
  % db eval "select * from sqlite_master"
  table a a 2 {CREATE TABLE a (ak int, av int)}
  % db eval "select * from a"
  1 1
  % ^D

  $ sqlite3 x.db "select * from a"
  SQL error: file is encrypted or is not a database

  $ ./sqlcrypt3 x.db
  SQLcrypt version 3.2.2
  Enter ".help" for instructions
  sqlcrypt> .decrypt "book boo"  
  sqlcrypt> select * from a;
  1|1

A tclsqlcrypt download package will be made available shortly.