SQLite and NetCF

  • Thread starter Thread starter usunto_bryjamus
  • Start date Start date
U

usunto_bryjamus

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.
 
(e-mail address removed) escribió:
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.
Click to expand...

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!
 
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
 
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
 
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
Click to expand...

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
 
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.
 
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).
 
Back
Top