System.Data.SQLite

Hello Robert,
let's say one thing first (like Wayne and Garth would say):
I am not worthy! I am not worthy!....

I really do love System.Data.SQLite, the day I found this Project I was smilling when I was driving home from work.
This is 2 years ago and I still know it ....
There is a lot of rumble in the jungle in the last couple of days.
There are rumours around stating that Windows Phone 7 will restrict both native development and Pinvoke native code.
http://www.theregister.co.uk/2010/02/18/windows_phone_compatability/
I love working with System.Data.SQLite on Windows Mobile because it is by far the best DB on this platform.
Way better then SQL Server Compact or however this crap is named today.
Do you know a little bit more?

Best regards,
Tom

Hello Tom. I'm not Robert, but I have an answer - Robert is working on supporting C# SQLite in ADO wrapper (I don't know about ADO in Silverlight, but hey, we haven't seen WP7 SDK yet) and that will give you trully managed SQLite in Winphone or even Iphone... And if you concerned about stability - it passes ALL 32000 unit-tests of SQLite. If you will ask about performance - here is an answer - http://groups.google.com/group/csharp-sqlite/browse_thread/thread/5d7363be7171c370 - it's 2x slower on inserts right now (we're investigating that) and it's 2x faster on search and iterations over native version. So check this out. Max

Hello Max,
good news. So exchanging the native System.Data.SQLite with ADO wrapper is an alternative - perfect.
The numbers you posted are quite good. But they are measured on a desktop, right? I think that not the CPU-clock/-power is the real bottleneck but the additional stress on the memory subsystem. So measuring on a mobile device could change the picture a bit.
But it is good to hear that i can plan with System.Data.SQLite for the future. And the compatibility with mono and iPhone is good news.
But if there is a native version i think i would prefer it, especially for smartphones where you have a limited memory subsystem.

Regards,
Tom

System.Data.SQLite is ADO wrapper and it will support C# SQLite use which is managed and not native as original SQLite. That will give you an ability to run it inside managed only environment like WP7. But as I've said it's unknown right now will we have ADO.NET in WP7. About benchmarks: I don't know any test compared native and managed SQLite on mobile device. So I don't know, but I don't think that will change ratios significantly. It's also not true that C# SQLite uses more memory than native version. Difference in memory usage significantly less than size of adequate page cache (which should be equal on both implementations). So I don't think that memory usage important in that question. But you're welcome to make some tests on memory usage or mobile device benchmarks (despite the fact that there is NO Silverlight on mobile right now and .NET CF is known to have different and much older CLR).

Sorry for my confusion.
So System.Data.SQLite is using SQLite (unmanged) .
And Robert is currently working on a version of System.Data.SQLite which is working with C#-SQLite (managed).

>It's also not true that C# SQLite uses more memory than native version. Difference in memory usage significantly less than
>size of adequate page cache (which should be equal on both implementations). So I don't think that memory usage important
>in that question.

I'm really surprised about that, good to hear. Perhaps I find the time in the next couple of weeks and test this implementation on a Smartphone.

Regards,
Tom

 

You are perfectly right now. Another problem of using unmanaged version btw is that you can't use the same assembly with both 64 and 32 bit version - you have to ship both versions of native implementation and switch them based on architecture used in runtime in case your app targets Any CPU.

Hi,

 are there any news about this topic?

Manfred

Yes, are there any new news about this topic, especially on Windows Phone 7? I'm raring for an update. 

Are there any updates expected in the near future with Support for Windows Phone 7

My development machine uses Windows 7 64bit. Therefore therefore add the reference to the System.Data.SQLite.DLL in C:\Program Files (x86)\SQLite.NET\bin\x64, or change the platform target to x86.

 

Drilling down into the innerException revealed this:

"The IDbCommand and IDbConnection implementation in the assembly System.Data.SQLite could not be found. Ensure that the assembly System.Data.SQLite is located in the application directory or in the Global Assembly Cache. If the assembly is in the GAC, use <qualifyAssembly/> element in the application configuration file to specify the full name of the assembly."

 

Hi,

any news about future Windows Phone 7 support?

 /Claes

Any updates on System.Data.SQLite and Windows Phone 7?