Re: [sqlite] Compiling SQLite Encryption Extension for ARM processor

> On Feb 13, 2020, at 10:51 AM, Subodh Pathak wrote: > > I am looking for help to configure machine to compile SEE for ARM. I am > using Android mobile Samsung G7. You have to use a cross-compiler, a version of GCC that runs on your platform but generates ARM-Linux code. Specifically, to bui

Re: [sqlite] Compiling SQLite Encryption Extension for ARM processor

On 2/13/20, Subodh Pathak wrote: > > I am trying to compile SEE for ARM processor. There is a website explain how to compile SQLite for Android here: https://www.sqlite.org/android/doc/trunk/www/index.wiki Please review the instructions on that website and write again if they do not work for you

[sqlite] Compiling SQLite Encryption Extension for ARM processor

Team, I am trying to compile SEE for ARM processor. I have followed following steps. But was not successful in generating " *libsqliteX.so*" file which can be used on Android Samsung G7 mobile. 1. Installed GCC compiler from “http://www.mingw.org/” reference at “ https://gcc.gnu.org/”. 2.

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

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

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

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

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

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 al

Re: [sqlite] How to use SQLite Encryption Extension in Oracle MAF app

On 10/29/18, smartsanja wrote: > My hybrid mobile app built using Oracle MAF framework. I have a requirement > to encrypt the sqlite db using SQLite Encryption Extension. I could not find > any documentation on how to integrate SEE in Oracle MAF apps. I want to know > whether is this

[sqlite] How to use SQLite Encryption Extension in Oracle MAF app

My hybrid mobile app built using Oracle MAF framework. I have a requirement to encrypt the sqlite db using SQLite Encryption Extension. I could not find any documentation on how to integrate SEE in Oracle MAF apps. I want to know whether is this can be done or totally not supported yet. Highly

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

Jens Alfke writes: >> On Jun 17, 2017, at 7:02 AM, Yuriy M. Kaminskiy wrote: >> >> *) don't appear to be able to keep key in system-provided secure >> device/enclave; > > In their defense, I think this is out-of-scope for a cross-platform db > encryption library, as there are so many different

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

> On Jun 17, 2017, at 7:02 AM, Yuriy M. Kaminskiy wrote: > > *) don't appear to be able to keep key in system-provided secure > device/enclave; In their defense, I think this is out-of-scope for a cross-platform db encryption library, as there are so many different APIs for this on different

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

Jens Alfke writes: >> And any non-opensource crypto should be taken with triple caution. Or >> even opensource, but not widely-used or otherwise not known to be >> carefully peer-reviewed (FWIW, I looked at e.g. wxsqlite crypto code, it >> looks not exactly promising too). > > What do you think of

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

On 9 June 2017 at 22:30, Yuriy M. Kaminskiy wrote: > > Don't know about windows, but on linux no additional "debug privileges" > needed. You can attach debugger (ptrace syscall) to any process running > with under same user. Additional privileges needed only for debugging > processes running under

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

On 2017-06-09 00:13, Wout Mertens wrote: > Isn't it all just obfuscation? Any root user can read your key, if not from > disk then from memory. Any normal user can't read your key, nor from disk, > nor from memory; and they can't read your db file either. > > So if the adversary is someone with ac

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

> On Jun 9, 2017, at 7:30 AM, Yuriy M. Kaminskiy wrote: > > On other hand, application-level encryption should be used with great > caution; it is a way too often designed and implemented by > non-cryptographers, does not use optimized or hardware-assisted crypto > primitives (and, for AES, ofte

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

> On Jun 8, 2017, at 3:13 PM, Wout Mertens wrote: > > Isn't it all just obfuscation? Any root user can read your key, if not from > disk then from memory. Keys on disk are [or should be!] generally stored by special OS subsystems (like the Keychain on Apple platforms) that use encrypted storag

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

Eric Grange writes: >> Isn't it all just obfuscation? > > Not really, the encryption protects the file, wherever it is, as long as > the attacker does not have access to the application keys or application > memory. > >> If the adversary is another process on the same host, encrypting the db >> j

[sqlite] Questions about SQLite Encryption Extension (SEE)

Aha, that does make sense, thinking of each risk in terms in likelihoods. So encrypting the db as well as the disk seems the safest route here. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailm

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

> Isn't it all just obfuscation? Not really, the encryption protects the file, wherever it is, as long as the attacker does not have access to the application keys or application memory. > If the adversary is another process on the same host, encrypting the db > just adds obfuscation, which is se

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

On 8 Jun 2017, at 11:13pm, Wout Mertens wrote: > So if the adversary is someone with access to your disk image, disk > encryption trumps db encryption (unless the disk encryption is vulnerable > to known-plaintext attacks, but I guess they probably apply to sqlite too). Your hope is that the d

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

Isn't it all just obfuscation? Any root user can read your key, if not from disk then from memory. Any normal user can't read your key, nor from disk, nor from memory; and they can't read your db file either. So if the adversary is someone with access to your disk image, disk encryption trumps db

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

On 6/8/17, Wout Mertens wrote: > Just musing: is an encrypted disk not more reliable? You have to store the > key somewhere… Maybe. I guess it depends on your threat model. Encrypting the whole disk is a system setting,. Anybody who has access to the system can see everything on disk. You als

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

Just musing: is an encrypted disk not more reliable? You have to store the key somewhere… On Thu, Jun 8, 2017, 7:07 PM Richard Hipp wrote: > On 6/8/17, Karl Sanders wrote: > > I would like to know if an encrypted database allows hot backups and > > page sizes different from the default one. > >

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

On 6/8/17, Karl Sanders wrote: > I would like to know if an encrypted database allows hot backups and > page sizes different from the default one. Yes and Yes. > > Is encryption applied to everything that gets written to disk? > Including transient indices and materializations of views and subqu

[sqlite] Questions about SQLite Encryption Extension (SEE)

I would like to know if an encrypted database allows hot backups and page sizes different from the default one. Is encryption applied to everything that gets written to disk? Including transient indices and materializations of views and subqueries? Regards, Karl __

Re: [sqlite] Encryption

ite3/releases), Windows binaries > are provided > Other SQLite3 management tools that support the wxSQLite3 encryption scheme > are > - SQLite Maestro > (https://www.sqlmaestro.com/en/products/sqlite/maestro/about/) > - wxSQLitePlus (https://github.com/guanlisheng/wxsq

Re: [sqlite] Encryption

, Windows > binaries are provided > > Other SQLite3 management tools that support the wxSQLite3 encryption > scheme are > > - SQLite Maestro (https://www.sqlmaestro.com/en/products/sqlite/maestro/ > about/) > - wxSQLitePlus (https://github.com/guanlisheng/wxsqliteplus) > &

Re: [sqlite] Encryption

> > On Nov 14, 2016, at 7:23 AM, Ulrich Telle wrote: > > > > The RSA encryption offered by System.Data.SQLite should not be used, > > if security is a concern for you. You should prefer an AES encryption > > scheme. > > I’m surprised anything encrypts databases with RSA, as that algorithm > is p

Re: [sqlite] Encryption

> On Nov 14, 2016, at 7:23 AM, Ulrich Telle wrote: > > The RSA encryption offered by System.Data.SQLite should not be used, if > security is a concern for you. You should prefer an AES encryption scheme. I’m surprised anything encrypts databases with RSA, as that algorithm is pretty unsuitabl

Re: [sqlite] Encryption

- SQLite Maestro (https://www.sqlmaestro.com/en/products/sqlite/maestro/about/) - wxSQLitePlus (https://github.com/guanlisheng/wxsqliteplus) > > Richard Andersen wrote: > > In DB Browser for SQlite I can edit the table but I'm not sure if the > > SQLCipher encryption used

Re: [sqlite] Encryption

Sunday, November 13, 2016, 2:16:40 PM, you wrote: Thanks. Well what I've done is to create an encrypted database with SQLite2009 and then use that in my C# project. I just add the password to the connection string in my app and then it works right away. As far as I understand (I'm new to all this)

Re: [sqlite] Encryption

Friday, November 11, 2016, 9:00:36 PM, you wrote: Ok, thanks! > Encryption in system.data.sqlite is legacy encryption, only used within > itself, and not with other applications. > On Fri, Nov 11, 2016 at 6:24 PM, Richard Andersen wrote: >> >> >> I'm using the ADO.NET version (System.Data.SQli

[sqlite] Encryption

I am not sure about sqlite2009, but you edit DBs that are encrypted using the encryption in system.data.sqlite. I use SQLITE Expert. It allows you to replace the standard library which does not support encryption to one from the system.data.sqlite that does. It is the interop dll that you replace.

Re: [sqlite] Encryption

Encryption in system.data.sqlite is legacy encryption, only used within itself, and not with other applications. On Fri, Nov 11, 2016 at 6:24 PM, Richard Andersen wrote: > > > I'm using the ADO.NET version (System.Data.SQlite). > > I've created an RSA encrypted database using SQLite2009 and that

[sqlite] Encryption

I'm using the ADO.NET version (System.Data.SQlite). I've created an RSA encrypted database using SQLite2009 and that is working fine, but I can't find any tools for editing the table in SQLite2009 once it's been created. Is it possible at all? In DB Browser for SQlite I can edit the table but I

[sqlite] PhoneGap with SQLite Encryption Extension?

SQLite Encryption Extension? On 12/4/15, Ribeiro, Glauber wrote: > We have an Android application built on PhoneGap, which uses the built-in > SQLite to store data. > > Does anybody here know if it's possible to replace the built-in SQLite in > PhoneGap (Android) with a v

[sqlite] PhoneGap with SQLite Encryption Extension?

We have an Android application built on PhoneGap, which uses the built-in SQLite to store data. Does anybody here know if it's possible to replace the built-in SQLite in PhoneGap (Android) with a version that supports encryption (S.E.E. or other kind), so that the application information would

[sqlite] PhoneGap with SQLite Encryption Extension?

On 12/4/15, Ribeiro, Glauber wrote: > We have an Android application built on PhoneGap, which uses the built-in > SQLite to store data. > > Does anybody here know if it's possible to replace the built-in SQLite in > PhoneGap (Android) with a version that supports encryption (S.E.E. or other > kind

[sqlite] Security vulnerability in the SQLite Encryption Extension

Part of the interface design to the SQLite Encryption Extension makes it possible for an application to accidentally supply weak keys. This only happens if the keying interface is misused. Though to be fair, the documentation could be clearer about how to avoid misusing the interface. If an

Re: [sqlite] Encryption of SQLite database using jquery

On Mon, Sep 22, 2014 at 3:00 PM, Prava Kafle wrote: > Hi, > > I have been looking for a product that can encrypt Sqlite database using > JavaScript and came across Sqlite Encryption extension. > Can I use this with my application that uses jquery mobile and > sqlitedatabase?

[sqlite] Encryption of SQLite database using jquery

Hi, I have been looking for a product that can encrypt Sqlite database using JavaScript and came across Sqlite Encryption extension. Can I use this with my application that uses jquery mobile and sqlitedatabase? Before purchasing the product, if I could get some information on it or a trial

Re: [sqlite] Whats the SQLite Encryption Algo?

On 8 Sep 2014, at 9:16am, Tom Ashley wrote: > I noticed that in C# I can set a password using SetPassword. Does this > encrypt the entire database? If so, What algorithm precisely does it use? See this and get back to us if you have questions. The ba

[sqlite] Whats the SQLite Encryption Algo?

I noticed that in C# I can set a password using SetPassword. Does this encrypt the entire database? If so, What algorithm precisely does it use? Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/

Re: [sqlite] Encryption

Yes, I did test SQLCipher and it slows down a bit. Now, I would like to go with SEE if its available for the latest version. SQLCipher is available for 3.8.0.2 while 3.8.1 is out. On Thu, Dec 5, 2013 at 9:34 PM, Simon Slavin wrote: > > On 5 Dec 2013, at 3:02pm, Raheel Gupta wrote: > > > The on

Re: [sqlite] Encryption

On 5 Dec 2013, at 3:02pm, Raheel Gupta wrote: > The only problem is that I dont have access to SEE by Dr. Richard. So how > should I test it ? Why should you test it ? Have you tested the solutions you do have access to and found that they make your app too slow to use ? Simon. _

Re: [sqlite] Encryption

Hi, The only problem is that I dont have access to SEE by Dr. Richard. So how should I test it ? Does he give test licenses ? Also I am assuming it will always be supported by the latest version of SQLite right ? On Thu, Dec 5, 2013 at 7:09 PM, Simon Slavin wrote: > > On 5 Dec 2013, at 9:15am,

Re: [sqlite] Encryption

On 5 Dec 2013, at 9:15am, Raheel Gupta wrote: > Yes, I agree. But it should not make the inserts and read too slow as well. The key word here is 'too'. If there's only 5% difference in speed between the two systems then it doesn't matter which one you use. So you have to write your applicati

Re: [sqlite] Encryption

Yes, I agree. But it should not make the inserts and read too slow as well. I just want to support 256 Bit AES. On Thu, Dec 5, 2013 at 1:50 PM, Klaas V wrote: > When you'use the word 'perfornance' you might be interested not jonly in > speed, but in strength of protection, privacy of the employ

Re: [sqlite] Encryption

When you'use the word 'perfornance' you might be interested not jonly in speed, but in strength of protection, privacy of the employees, your company as a whole and above all your clients. One of the goals of encryption is to avoid e.g. the government(s and the spies they hired to peek into your

Re: [sqlite] Encryption

>> The answer may depend on what storage system you were using 7200 RPM Sata Drives >> whether you have small or big databases, Big which may even reach TBs of data. >> and whether you have just one user at a time or many users at once. Multi user. I do use WAL mode. On Wed, Dec 4, 2013 at 6

Re: [sqlite] Encryption

On 4 Dec 2013, at 10:45am, Raheel Gupta wrote: > I wanted to know which is the best in performance ? There would probably not be a simple definite answer that applied to all setups. The answer may depend on what storage system you were using, whether you have small or big databases, and whet

[sqlite] Encryption

Hi, I wanted to implement Encryption on my sqlite DB with least load on performance. I have come across Sqlcipher.net and SQLite Encryption Extension (By Dr. Hipp) I wanted to know which is the best in performance ? Has anyone tested both of these and can provide some feedback

Re: [sqlite] A few questions about SQLite Encryption Extension

OK. Thank you. 2013/7/19 Richard Hipp > On Fri, Jul 19, 2013 at 9:20 AM, Sqlite Dog wrote: > > > > > > > There is no way to detect which encryption algorithm is used. Indeed, > > the > > > encryption is so thorough that there is no way to tell whether or not > the > > > file you are trying to

Re: [sqlite] A few questions about SQLite Encryption Extension

2013/7/19 RSmith > Being a Delphi Developer (mostly) and using SQLite quite often, I can tell > you some things about it: > > You can easily wrap an SQLite DLL in Delphi, there are many free > implementations of this, if you dont have one, send me a mail and I will > supply one. SEE will work as

Re: [sqlite] A few questions about SQLite Encryption Extension

Being a Delphi Developer (mostly) and using SQLite quite often, I can tell you some things about it: You can easily wrap an SQLite DLL in Delphi, there are many free implementations of this, if you dont have one, send me a mail and I will supply one. SEE will work as easily and I don't know of

Re: [sqlite] A few questions about SQLite Encryption Extension

On 19.07.2013 15:27, Sqlite Dog wrote: >> * Statically link SQLite to your Delphi application. My DISQLite3 >> enables you to do just that and has numerous extensions: One is a >> custom encryption algorithm. This is not compatible with SEE, >> but if you like I can replace it with your orig

Re: [sqlite] A few questions about SQLite Encryption Extension

On Fri, Jul 19, 2013 at 9:20 AM, Sqlite Dog wrote: > > > > There is no way to detect which encryption algorithm is used. Indeed, > the > > encryption is so thorough that there is no way to tell whether or not the > > file you are trying to open is an encrypted database file or just a file > of >

Re: [sqlite] A few questions about SQLite Encryption Extension

2013/7/19 Ralf Junker > On 19.07.2013 09:21, Sqlite Dog wrote: > > > Our database manager is developed using Delphi (Pascal). Thus it is > > not possible to statically link SQLite library, SQLite.dll is used. > > Is there some other way to support SEE in our project? > > You have two options: > >

Re: [sqlite] A few questions about SQLite Encryption Extension

2013/7/19 Richard Hipp > On Fri, Jul 19, 2013 at 3:21 AM, Sqlite Dog wrote: > > > > > Our database manager is developed using Delphi (Pascal). Thus it is not > > possible to statically link SQLite library, SQLite.dll is used. Is there > > some other way to support SEE in our project? > > > > Yes

Re: [sqlite] A few questions about SQLite Encryption Extension

On Fri, Jul 19, 2013 at 3:49 PM, Sqlite Dog wrote: > That's interesting. What about pas file with function declarations to > SQLite API? Should it be modified somehow? > > If you use static dll loading and linking, Instead of declaring API functions as external 'sqlite3.dll' you declare them as p

Re: [sqlite] A few questions about SQLite Encryption Extension

On Fri, Jul 19, 2013 at 8:49 AM, Sqlite Dog wrote: > That's interesting. What about pas file with function declarations to > SQLite API? Should it be modified somehow? > No need to. The SQLite Encryption Extension is controlled using PRAGMA statements. -- D. Richard Hipp d

Re: [sqlite] A few questions about SQLite Encryption Extension

That's interesting. What about pas file with function declarations to SQLite API? Should it be modified somehow? 2013/7/19 kyan > On Fri, Jul 19, 2013 at 10:21 AM, Sqlite Dog wrote: > > > > > Our database manager is developed using Delphi (Pascal). Thus it is not > > possible to statically lin

Re: [sqlite] A few questions about SQLite Encryption Extension

On 19.07.2013 09:21, Sqlite Dog wrote: > Our database manager is developed using Delphi (Pascal). Thus it is > not possible to statically link SQLite library, SQLite.dll is used. > Is there some other way to support SEE in our project? You have two options: * Create your own sqlite.dll and com

Re: [sqlite] A few questions about SQLite Encryption Extension

On Fri, Jul 19, 2013 at 3:21 AM, Sqlite Dog wrote: > > Our database manager is developed using Delphi (Pascal). Thus it is not > possible to statically link SQLite library, SQLite.dll is used. Is there > some other way to support SEE in our project? > Yes. You can ship it as a DLL and use a spe

Re: [sqlite] A few questions about SQLite Encryption Extension

On Fri, Jul 19, 2013 at 10:21 AM, Sqlite Dog wrote: > > Our database manager is developed using Delphi (Pascal). Thus it is not > possible to statically link SQLite library, SQLite.dll is used. Is there > some other way to support SEE in our project? > It is possible to compile the SQLite amalga

[sqlite] A few questions about SQLite Encryption Extension

Hi, documentation on SEE (http://www.hwaci.com/sw/sqlite/see.html) states that "You can ship as many compiled, binary copies of SQLite with your commercial product as long as each copy is attached to your product in such a way that it cannot be separated from your product. Normally this means tha

Re: [sqlite] SQLite Encryption in Windows 8 Metro App

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 two encryption systems fo

[sqlite] SQLite Encryption in Windows 8 Metro App

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 librar

Re: [sqlite] Encryption using System.Data.SQLite.dll

On 08/20/2012 11:08 AM, Bishwa Shrestha wrote: Hi, I am creating an sqlite3 interface to an existing data model. For that purpose sqlite3 tables are dynamically loaded. I'm using /sqlite3_column_count/ and /sqlite3_column_table_name/ to load data into relevant tables only. Now, I am having

Re: [sqlite] Encryption using System.Data.SQLite.dll

Hi, I am creating an sqlite3 interface to an existing data model. For that purpose sqlite3 tables are dynamically loaded. I'm using /sqlite3_column_count/ and /sqlite3_column_table_name/ to load data into relevant tables only. Now, I am having problems with queries such as: SELECT a.column1

Re: [sqlite] Encryption using System.Data.SQLite.dll

-Original Message- > > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > > boun...@sqlite.org] On Behalf Of Richard Hipp > > Sent: Friday, August 17, 2012 12:09 PM > > To: General Discussion of SQLite Database > > Subject: Re: [sqlite] Encryption u

Re: [sqlite] Encryption using System.Data.SQLite.dll

e- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Richard Hipp > Sent: Friday, August 17, 2012 12:09 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Encryption using System.Data.SQLite.dll > > On Fri

Re: [sqlite] Encryption using System.Data.SQLite.dll

On Fri, Aug 17, 2012 at 11:58 AM, Carlos Milon Silva wrote: > John, > > The internal Adobe Air SQLite is built to not accept extensions, > Yes, but Adobe Air comes with the SQLite Encryption Extension (SEE) built in. There is nothing that needs to be extended with Adobe Air. >

Re: [sqlite] Encryption using System.Data.SQLite.dll

John, The internal Adobe Air SQLite is built to not accept extensions, so, either the System.Data.SQLite.dll or the SQLite Encryption Extension from hwaci could only be used with a an external native extension application. Carlos. Em 17/08/2012 09:48, John Grasmeder escreveu: Carlos, My

Re: [sqlite] Encryption using System.Data.SQLite.dll

On 8/17/12 9:48 AM, John Grasmeder wrote: Joe Mistachkin has also replied with a reference to SQLite Encryption Extension (http://www.hwaci.com/sw/sqlite/see.html) which I will look into today and see if it can be added to my Dotnet code. That $2000.00 license fee would be a killer for me

Re: [sqlite] Encryption using System.Data.SQLite.dll

ome way of overriding the encryption used on the database file. Joe Mistachkin has also replied with a reference to SQLite Encryption Extension (http://www.hwaci.com/sw/sqlite/see.html) which I will look into today and see if it can be added to my Dotnet code. Thanks, John G. > -Original Messa

Re: [sqlite] Encryption using System.Data.SQLite.dll

if you really need to use System.Data.SQLite.dll, from Adobe Air, then you need to follow something like to: http://blogs.adobe.com/globalization/invoking-icu-from-adobe-air-applications-part-2-using-flash-builder-4-6/ and call System.Data.SQLite.dll as an external native extension Carlos. Em

Re: [sqlite] Encryption using System.Data.SQLite.dll

John Grasmeder wrote: > > How do I go about changing the encryption method/methods that are used > in the SQLite.SQLiteConnection class? Do I need to implement my own > version of SQLiteConnection and override some methods or is there some > other code I have not found as of date? > The encrypt

[sqlite] Encryption using System.Data.SQLite.dll

Hello List, I am currently using System.Data.SQLite.dll version 1.0.79.0. I am creating a SQLite database file from data stored in MS-SQL which will be pushed to client applications running an Adobe Air application on Macs and Windows PCs. Everything is progressing nicely but I am now at the

Re: [sqlite] SQLite Encryption Extension Performance?

> > 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?

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?

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?

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?

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 perfor

Re: [sqlite] SQLite Encryption Extension Performance?

this helps. Regards, Etienne - Original message - From: Paul Vercellotti To: General Discussion of SQLite Database Subject: [sqlite] SQLite Encryption Extension Performance? Date: Wed, 27 Jun 2012 11:55:21 -0700 (PDT) Hi there, We are considering using the SQLite Encryption Extensi

[sqlite] SQLite Encryption Extension Performance?

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

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

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 &g

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

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

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

[sqlite] SQLite encryption extension

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

[sqlite] Question about SQLite Encryption Extension (SEE)

Hi, I have a question about SQLite Encryption Extension (SEE) add-on. I am using for develop a Visual Basic .NET v2010 with ADO.NET 2.0 and *System.Data.SQLite 1.0.72.0* for work with DB. If I adquire SEE add-on, it works correctly with *System.Data.SQLite 1.0.72.0*. Thanks for all

Re: [sqlite] Bug: SQLite Encryption Extension And Backup API

] Bug: SQLite Encryption Extension And Backup API On Wed, Apr 6, 2011 at 8:21 AM, Ulric Auger wrote: Hi, I think I found a bug creating an encrypted backup. The source database is encrypted using key: aes256:A94A8FE5CCB19BA61C4C0873D391E987982FBBD3 The source database is readable, I

Re: [sqlite] Bug: SQLite Encryption Extension And Backup API

On Wed, Apr 6, 2011 at 8:21 AM, Ulric Auger wrote: > Hi, > > I think I found a bug creating an encrypted backup. > > > > The source database is encrypted using key: > > aes256:A94A8FE5CCB19BA61C4C0873D391E987982FBBD3 > > > > The source database is readable, I can run select queries and insert dat

Re: [sqlite] Bug: SQLite Encryption Extension And Backup API

us Grimm Sent: April 7, 2011 10:13 To: General Discussion of SQLite Database Subject: Re: [sqlite] Bug: SQLite Encryption Extension And Backup API Hi, sorry.. my fault. It should be: if (zKey != NULL) { sqlite3_key(pBackupDb, NULL, 0); sqlite3_rekey(pBackupDb, zKey, strlen(zKey)); }

Re: [sqlite] Bug: SQLite Encryption Extension And Backup API

Hi, sorry.. my fault. It should be: if (zKey != NULL) { sqlite3_key(pBackupDb, NULL, 0); sqlite3_rekey(pBackupDb, zKey, strlen(zKey)); } Thats works for me.. Marcus On 07.04.2011 15:58, Ulric Auger wrote: > It didn't change anything to call sqlite3_key twice as you suggested. > > I'm

Re: [sqlite] Bug: SQLite Encryption Extension And Backup API

It didn't change anything to call sqlite3_key twice as you suggested. I'm using SQLite 3.7.4 with SEE (SEE v3.7.5 is not available from the SEE download page, that is strange) I hope SQLite team can look into this. Ulric ___ sqlite-users mailing list

Re: [sqlite] Bug: SQLite Encryption Extension And Backup API

On 06.04.2011 14:21, Ulric Auger wrote: > Hi, > > I think I found a bug creating an encrypted backup. .. > > > > When I use the following function to create a backup of the database, the > backup database becomes unreadable. ... > > > >rc = sqlite3_open(zFilename,&pBackupDb); > >if( rc==

[sqlite] Bug: SQLite Encryption Extension And Backup API

Hi, I think I found a bug creating an encrypted backup. The source database is encrypted using key: aes256:A94A8FE5CCB19BA61C4C0873D391E987982FBBD3 The source database is readable, I can run select queries and insert data with no problem. When I use the following function to create a

  1   2   >