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

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

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

2019-08-20 Thread Mark Tomlin
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 compiling it as I normally would. I'm

Re: [sqlite] SQLite Encryption Extension Performance?

2012-06-28 Thread Adolfo J . Millan
> > Mensaje original > De: Simon Slavin <slav...@bigfraud.org> > Para: a...@zator.com,General Discussion of SQLite Database > <sqlite-users@sqlite.org> > Fecha: Thu, 28 Jun 2012 15:43:26 +0200 > Asunto: Re: [sqlite] SQLite Encryption Extension Perf

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

Re: [sqlite] SQLite Encryption Extension Performance?

2012-06-28 Thread Richard Hipp
e encrypted/plain state). > > Thanks in advance. > > > > > Mensaje original > > De: Richard Hipp <d...@sqlite.org> > > Para: Paul Vercellotti <pverce...@yahoo.com>, General Discussion of > SQLite Database <sqlite-users@sqlite.org&g

Re: [sqlite] SQLite Encryption Extension Performance?

2012-06-28 Thread ajm
). Thanks in advance. > > Mensaje original > De: Richard Hipp <d...@sqlite.org> > Para: Paul Vercellotti <pverce...@yahoo.com>, General Discussion of SQLite > Database <sqlite-users@sqlite.org> > Fecha: Wed, 27 Jun 2012 21:28:30 +0200 > Asunto: R

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

Re: [sqlite] SQLite Encryption Extension Performance?

2012-06-27 Thread Etienne
this helps. Regards, Etienne - Original message - From: Paul Vercellotti <pverce...@yahoo.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: [sqlite] SQLite Encryption Extension Performance? Date: Wed, 27 Jun 2012 11:55:21 -0700 (PDT) H

[sqlite] SQLite Encryption Extension Performance?

2012-06-27 Thread Paul Vercellotti
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 this you might have would be useful. Thanks! -Paul

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

2011-07-07 Thread Black, Michael (IS)
11 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 using sqlite-3.7.

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

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

2011-07-07 Thread Prakash Reddy Bande
Hi, 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, the http://www.hwaci.com/sw/sqlite/see.html page does not give much information, i.e. do still build sqlite from public and

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"

[sqlite] SQLite encryption extension

2011-06-08 Thread NewsGroupSpam
Can anyone comment about whether the SEE is delivered as an amalgamation, or whether it comes as pre-amalgamation files? Thanks Doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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 >

[sqlite] SQLite Encryption Extension

2010-01-04 Thread Olivier Roger
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 the extension, right ? not only a dll (or equivalent) The encrypted

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] =

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

2009-02-13 Thread Ulric Auger
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(cipherKey ); I'm using sqlite 3.6.10 with see.h Here is the complete

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

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

2009-01-13 Thread Ulric Auger
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 been bigger. Also, I timed some query (insert and select) and