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 (
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 pro
Bernd 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 peek ins
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 da
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
Евгений Земляков 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 default(42));
--
Igo
Özgür KELEŞ 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 Tandetnik
__
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
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
sqlite-use
2011/10/30 Black, Michael (IS)
>
> #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 next 10,000?
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.
> > >
> > >
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 that
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 wrote:
> Hi all,
>
> Searching the archives implies, that "sqlite expert" hasn't be
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 =
On Mon, Oct 31, 2011 at 5:01 PM, Korey Calmettes wrote:
> 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
> 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 M>0 and M wrote:
> On Mon, Oct 31, 2011 at 5:01 PM, Korey Calmettes
> wrote:
>
>> Hello,
>>
>> We are
On Mon, Oct 31, 2011 at 5:40 PM, Pavel Ivanov 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 M>0 and M
> Could it be that N bytes c
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 corr
18 matches
Mail list logo