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.
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
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
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
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
On 23 Apr 2013, at 2:11pm, "Jay, Jayavasanthan John"
wrote:
> Or, is there any other package which doesn't have these dependencies for
> encrypting and decrypting SQLite databases.
I cannot answer your questions about SQLCipher, but the main authors of SQLite
produce
Hi Guys,
I tried out SQLCipher and have successfully integrated in testing with
SQLite for encrypting and decrypting my database for a Windows 8 Metro App.
But as per Windows 8 Metro App compatibility guidelines, openssl (which is
the crypto package used by SQLCipher) fails on the usage of
>
> 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
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
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
).
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
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
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
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
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.
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
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
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"
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
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
>
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Simpson wrote:
> I'm pretty sure the license
Rather than speculating, the SEE usage and license is documented at
http://www.hwaci.com/sw/sqlite/see.html
Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using
.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Andi Suhandi
Sent: Saturday, October 03, 2009 11:52 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] SQLite Encryption Extensions(SEE) for SQLite
Dear All
Hi, I was using sqlite as a database
Dear All
Hi, I was using sqlite as a database for my program. My program is
based on C++ . Well, for my next project I want encryt the database,
and I read about SQLite Encryption Extensions(SEE).
My questions :
1. Are there problems if I add SEE ?
2. Do I have change a lot in my program ?
3. How
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
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] =
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
: 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
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
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
For those using the encrypted SQLite extension:
The instructions say the max key length can be 256 *bytes*, and looking at
the code does seem to confirm this. But there is also a comment at the top
of the encryption code which says "change the maximum key size to 56 *bits*
in order to comply
David Maass wrote:
unfortunately the "encrypt database" feature is a bit expensive for a
freeware fun project, are there other ways to prevent ppl from reading
the database?
What about using a cryptoAPI (for example the microsoft one), and do
some symetric encryption in the program before storing
Hi,
unfortunately the "encrypt database" feature is a bit expensive for a
freeware fun project, are there other ways to prevent ppl from reading
the database?
What about using a cryptoAPI (for example the microsoft one), and do
some symetric encryption in the program before storing the data in the
33 matches
Mail list logo