[sqlite] Best practices for dealing with password protected database

This may not be really SQLite specific, but as it's at least SQLite related I thought I asked here. Our program ships with an encrypted SQLite database that has to be opened by the application to process some other data. As it's a .NET application, it's very easy to peek inside the source code

Re: [sqlite] Best practices for dealing with password protected database

Hello Bernd! I have a very limited knowledge about such matters, but it seems to me there is a caveat in the whole area of using encrypted data on a end-user pc; For your .NET application to use the, DB it must first decrypt it; That means, storing the plain version in ram; A memory dump will

Re: [sqlite] Best practices for dealing with password protected database

Bernd be...@web.de wrote: This may not be really SQLite specific, but as it's at least SQLite related I thought I asked here. Our program ships with an encrypted SQLite database that has to be opened by the application to process some other data. As it's a .NET application, it's very easy to

[sqlite] Corrupted Database

Hi, We use sqlite in our industrial devices. But sometimes the database corrupted. We could not find the problem , how it can be possible to corrupt the database. It is possible to see powerless on devices and OS crashes cause of electromagnetic noises, rarely. I attached some of corrupted

[sqlite] Default column values conflict with not null option

Default column values conflict with not null option. Truly yours, Eugene. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Default column values conflict with not null option

Евгений Земляков new_fel...@rambler.ru wrote: Default column values conflict with not null option. Conflict in what sense? What statement are you executing, and how does the outcome of running that statement differ from your expectations? This works for me: create table t(x integer not null

Re: [sqlite] Corrupted Database

Özgür KELEŞ ozgur.ke...@enmos.com wrote: We use sqlite in our industrial devices. But sometimes the database corrupted. We could not find the problem , how it can be possible to corrupt the database. http://www.sqlite.org/lockingv3.html Section 6.0 How To Corrupt Your Database Files -- Igor

Re: [sqlite] Best practices for dealing with password protected database

On 31 Oct 2011, at 8:07am, Eugene N wrote: For your .NET application to use the, DB it must first decrypt it; That means, storing the plain version in ram; A memory dump will pronto show the contents of this sqlite database; Physical possession of the hardware concerned is always an end to

Re: [sqlite] ChangePassword method problem

Reading your code quickly, it seems the problem may be related to the use of single-quotes (') around the passwords in the connection string. Please remove all the single-quotes and try again. -- Joe Mistachkin ___ sqlite-users mailing list

Re: [sqlite] Slow inserts with UNIQUE

2011/10/30 Black, Michael (IS) michael.bla...@ngc.com #1 What version? 3.7.8, using System.Data.Sqlite wrapper #2 How long to insert the 1M? 10 seconds #3 What's the average string size? 55 characters #5 How long to create the index? 10 seconds #6 How long to insert the

Re: [sqlite] SQLite Expert

Thanks for your answer, Jean-Christophe, I'll give it a try. Abair On Sun, 30 Oct 2011 22:41:58 +0100 Jean-Christophe Deschamps said: On 30 Oct 2011, at 7:50pm, Abair Heart wrote: Searching the archives implies, that sqlite expert hasn't been asked about. Has anyone tried it

[sqlite] Disk I/O Error

Hello, We are having a random problem with our system that has be puzzled at this point. First a little background. We have an embedded system running an ARM processor and JFFS file system. We are running 3.7.7.1. I e-mailed about a month ago about enabling WAL on our system. Found out

Re: [sqlite] SQLite Expert

I use the free version of sqlite expert. I use sqlite for my IO handling. Having the power of sql available to test values, generate counts, etc... is indispensable. On Sun, Oct 30, 2011 at 2:50 PM, Abair Heart abairhe...@gmail.com wrote: Hi all, Searching the archives implies, that sqlite

[sqlite] UPDATE

I need help with a complex UPDATE. I want to update each row in a table, calculating an average, and then apply that value back into a column of the same row. Is this possible with Sqlite? Below is code that should work with SqlServer; its UPDATE supports a FROM statement. UPDATE m SET rtwgt =

Re: [sqlite] Disk I/O Error

On Mon, Oct 31, 2011 at 5:01 PM, Korey Calmettes kcalmet...@icontime.comwrote: Hello, We are having a random problem with our system that has be puzzled at this point. First a little background. We have an embedded system running an ARM processor and JFFS file system. We are running

Re: [sqlite] Disk I/O Error

Error code 522 is SQLITE_IOERR_SHORT_READ.  It is generated here:     http://www.sqlite.org/src/artifact/07acbb3e074e?ln=3012 SQLite was trying to read N bytes and got back M byes where M0 and MN. Could it be that N bytes cannot be read atomically and operation was interrupted in the middle

Re: [sqlite] Disk I/O Error

On Mon, Oct 31, 2011 at 5:40 PM, Pavel Ivanov paiva...@gmail.com wrote: Error code 522 is SQLITE_IOERR_SHORT_READ. It is generated here: http://www.sqlite.org/src/artifact/07acbb3e074e?ln=3012 SQLite was trying to read N bytes and got back M byes where M0 and MN. Could it be that

Re: [sqlite] sqlite-users Digest, Vol 46, Issue 29

Thanks. I guess I'd like to confirm just where column aliases can be referenced. I think they cannot be referenced within the list of column names in which they are defined, and they can be referenced in any other clauses of the SELECT statement, eg WHERE, ORDER BY, GROUP BY, HAVING. Is that