SQLite and NetCF

d...@zmyly.pl

unread,

Dec 3, 2007, 9:23:02 AM12/3/07

to

Hi,

I use NetCF 2.0 and Finisar.SQLite wrapper (SQLLite version 3).

What is your opinion on this database? Is it stable? I do some tests and
it looks ok. Faster than SQL CE, smaller output file, no installation
needed. Do you have expirience on this database?

I need something with small footprint (32MB RAM device) and of course
as fast as possible. If you know something worth to reccomend please
give me information. I will be thankful.

--
Best regards,
Klaudiusz

Antonio Prados

unread,

Dec 3, 2007, 11:49:34 AM12/3/07

to

usunto_...@interia.pl escribió:

Hi,

I have been working with SQLite for Compact Framework 2.0 for a long
time (more than a year) and it runs very well. I think SQLite is a good
option for non-shared databases.
Do you know SQLite Database Browser? A very useful tool for programmers
who use SQLite...
Bye!

Peter Morris

unread,

Dec 3, 2007, 3:18:23 PM12/3/07

to

I've had an app in use for just over a year now with over 200 users and I
have never had a single problem with SQLite. I also find it to be faster
than SQL CE.

Pete

Peter Schottland

unread,

Dec 4, 2007, 7:31:53 AM12/4/07

to

Our application (.NET CF 1.0) is running on more than 11.000 devices for
about 2 years now. So far, we've noticed no problems on the database side
(SQLite v3.2.1 to be exactly). Though, we used the databases read-only and
accessed it through SQLite's native API.

-peter

Jin Chang

unread,

Dec 5, 2007, 1:05:34 AM12/5/07

to

On Dec 4, 7:31 am, "Peter Schottland" <anonym...@microsoft-

SQLite seems very interesting based on this thread. Is it generally
faster than SQL CE when using normal SQL queries or is it even faster
than SQL CE using the TableDirect cursor operations (does it have an
equivalent feature)? I find the cursor operations in SQL CE to be
very fast.

Thanks for any response.

- Jin

Christian Schwarz

unread,

Dec 5, 2007, 2:12:35 PM12/5/07

to

Sorry, I'm not familar with the TableDirect operations. I'm also not aware
of any benchmarks comparing SQLite and SQL CE with TableDirect operations.
Here are benchmarks comparing standard queries:

http://sqlite.phxsoftware.com/forums/t/175.aspx (.NET data provider, SQLite
and Sql Server Mobile Edition 3.0)
http://sqlite.phxsoftware.com/forums/t/174.aspx (.NET data provider, desktop
databases)
http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison (Native interface,
desktop databases)

-peter

Manoj Jayswal

unread,

May 4, 2009, 10:37:56 AM5/4/09

to

I m developing application using compact framework sqlite.. but facing "Can't find PInvoke DLL 'SQLite.Interop.060.DLL'." problem at time of connectivity with sqlite..

can u help me pls...

Thanks in advance...

From http://www.developmentnow.com/g/18_2007_12_0_0_1038905/SQLite-and-NetCF.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/

Paul G. Tobey [eMVP]

unread,

May 4, 2009, 12:06:38 PM5/4/09

to

That seems like a question better targeted at the SQLLite guys. It doesn't
indicate a problem with the compact framework. It sounds like the DLL is
missing!

Paul T.

"Manoj Jayswal" <meet.j...@gmail.com> wrote in message
news:3f00a6cd-07a4-4950...@developmentnow.com...

Lobezno

unread,

Jun 30, 2009, 10:24:06 PM6/30/09

to

The reference in the project is System.Data.SQLite.dll and must be the
version for compact framework (not .Net framework) , after in the emulator or
pda copy SQLite.Interop.060.DLL in the same path of applicaction.

SQLite.Interop.060.DLL use pinvoke of Windows CE(core.dll ,native code).

Christian Resma Helle

unread,

Jul 1, 2009, 3:53:00 AM7/1/09

to

Add the SQLite.Interop.060.dll to your project in the root folder and set it
to deploy as "content" and to "copy if newer". This way you can ensure that
its deployed.

And when you package your app in a CAB file remember to add the content
files

--
Regards,
Christian Resma Helle
http://christian-helle.blogspot.com

"Lobezno" <Lob...@discussions.microsoft.com> wrote in message
news:74E9CC52-E53E-4E98...@microsoft.com...