Re: [sqlite] SQLite Encryption Extension For Use with With PHP 7.x Code

2019-08-20 Thread Simon Slavin
On 20 Aug 2019, at 8:40pm, Mark Tomlin wrote: > I found the regular sqlite3::open method has an $encryption_key parameter. > > https://www.php.net/manual/en/sqlite3.open.php Yep. > As I am using PDO for the interface into SQLite, I wonder if there is a > similar parameter for that interface.

Re: [sqlite] SQLite Encryption Extension For Use with With PHP 7.x Code

2019-08-20 Thread Richard Hipp
On 8/20/19, Mark Tomlin wrote: > I've looked at the PRAGMA statements and there doesn't appear to > be any public documentation on this interface. The PRAGMAs in question are part of the SEE documentation, as they are unique to SEE. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] SQLite Encryption Extension For Use with With PHP 7.x Code

2019-08-20 Thread Mark Tomlin
Thank you Richard for the extremely quick response. I found the regular sqlite3::open method has an $encryption_key parameter. https://www.php.net/manual/en/sqlite3.open.php As I am using PDO for the interface into SQLite, I wonder if there is a similar parameter for that interface. Perhaps usin

Re: [sqlite] SQLite Encryption Extension For Use with With PHP 7.x Code

2019-08-20 Thread Richard Hipp
On 8/20/19, Mark Tomlin wrote: > I would like to use SQLite's Encryption Extension with my PHP 7.2 code > base, as well as 7.3 and 7.4 code bases moving forward. My hope is is that > the see-sqlite.c code file can be simply renaming it to sqlite.c and > dropping it into PHP's build directory.Then

Re: [sqlite] SQLite Encryption Extension Performance?

2012-06-28 Thread Adolfo J . Millan
> > Mensaje original > De: Simon Slavin > Para: a...@zator.com,General Discussion of SQLite Database > > Fecha: Thu, 28 Jun 2012 15:43:26 +0200 > Asunto: Re: [sqlite] SQLite Encryption Extension Performance? > > > > >On 28 Jun 2012, at 12:

Re: [sqlite] SQLite Encryption Extension Performance?

2012-06-28 Thread Simon Slavin
On 28 Jun 2012, at 12:12pm, a...@zator.com wrote: > Assuming using SEE, do is there the ability to decide what I/O operations are > to be performed encrypted or with the plain (as is) content? I hope Richard's answer tells you what you want to know. He runs the team that makes SEE. Just in c

Re: [sqlite] SQLite Encryption Extension Performance?

2012-06-28 Thread Richard Hipp
plain state). > > Thanks in advance. > > > > > Mensaje original > > De: Richard Hipp > > Para: Paul Vercellotti , General Discussion of > SQLite Database > > Fecha: Wed, 27 Jun 2012 21:28:30 +0200 > > Asunto: Re: [sqlite] SQLite Encryption Exte

Re: [sqlite] SQLite Encryption Extension Performance?

2012-06-28 Thread ajm
state). Thanks in advance. > > Mensaje original > De: Richard Hipp > Para: Paul Vercellotti , General Discussion of SQLite > Database > Fecha: Wed, 27 Jun 2012 21:28:30 +0200 > Asunto: Re: [sqlite] SQLite Encryption Extension Performance? > > >SEE is a dr

Re: [sqlite] SQLite Encryption Extension Performance?

2012-06-27 Thread Richard Hipp
On Wed, Jun 27, 2012 at 2:55 PM, Paul Vercellotti wrote: > > > Hi there, > > We are considering using the SQLite Encryption Extension in one of our > products, and are wondering what the performance characteristics of it are? > Does the encryption algorithm affect performance? Any stats on thi

Re: [sqlite] SQLite Encryption Extension Performance?

2012-06-27 Thread Etienne
Hi Paul, Are you speaking of CEROD? FYI, I use to link sqlite3.c with the free wxSQLite3 encryption (AES128/256) module (http://wxcode.sourceforge.net/components/wxsqlite3). I didn't notice any significant slowing down (3-4% max.), but of course there is no compression involved... Hope this h

Re: [sqlite] SQLite Encryption Extension (SEE) and Public Domain Sqlite

2011-07-07 Thread Black, Michael (IS)
July 07, 2011 2:16 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] SQLite Encryption Extension (SEE) and Public Domain Sqlite On 7 Jul 2011, at 7:41pm, Prakash Reddy Bande wrote: > I wanted to get an understanding of SQLite Encryption Extension. I am > currently us

Re: [sqlite] SQLite Encryption Extension (SEE) and Public Domain Sqlite

2011-07-07 Thread Simon Slavin
On 7 Jul 2011, at 7:41pm, Prakash Reddy Bande wrote: > I wanted to get an understanding of SQLite Encryption Extension. I am > currently using sqlite-3.7.2, and if I want to use SEE, would it be equally > compatible. Well, thehttp://www.hwaci.com/sw/sqlite/see.html page does not > give much in

Re: [sqlite] SQLite encryption extension

2011-06-08 Thread Richard Hipp
On Tue, Jun 7, 2011 at 11:41 AM, NewsGroupSpam wrote: > Can anyone comment about whether the SEE is delivered as an amalgamation, > or > whether it comes as pre-amalgamation files? > SEE is a single file of C code that you append to a standard "sqlite3.c" amalgamation file and then compile as a

Re: [sqlite] SQLite Encryption Extension

2010-01-04 Thread D. Richard Hipp
On Jan 4, 2010, at 10:36 AM, Olivier Roger wrote: > Hello, > for some project we need an encryption on our database. SQLite > Encryption Extension seems to fit our need perfectly but some > questions > remain. > > After having paid the license fee we can download the entire source > code > of

Re: [sqlite] SQLite Encryption Extension: Datatype misalignmenterror on WM 5.0

2009-02-13 Thread Ulric Auger
Thanks, It worked. Ulric -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of D. Richard Hipp Sent: February 13, 2009 10:49 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite Encryption Extension: Datatype

Re: [sqlite] SQLite Encryption Extension: Datatype misalignment error on WM 5.0

2009-02-13 Thread D. Richard Hipp
On Feb 13, 2009, at 10:31 AM, Ulric Auger wrote: > Hi > > I'm trying to use SQLite Encryption Extension on Windows Mobile 5.0 > but I'm > getting a "Datatype misalignment" error inside rijndaelKeySetupEnc256 > function. > > The Datatype misalignment occurs on the line: > rk[0] = GETU32(cipherKe

Re: [sqlite] SQLite Encryption Extension (SEE) memory usage andperformance

2009-01-14 Thread Ulric Auger
: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of D. Richard Hipp Sent: January 13, 2009 9:37 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite Encryption Extension (SEE) memory usage andperformance On Jan 13, 2009, at 9:29 PM, Ulric

Re: [sqlite] SQLite Encryption Extension (SEE) memory usage and performance

2009-01-13 Thread D. Richard Hipp
On Jan 13, 2009, at 9:29 PM, Ulric Auger wrote: > I started to use SEE and I was surprise to notice that the file size > of my > encrypted database is the same has the un-encrypted database, how > come? > > It seems too good to be true, I was sure that the encrypted database > would > have