Re: [sqlite] Has anyone used sqlite for Pocket PC development?
core source code supports it. The provider I wrote that Brad mentions is for VS2005 and .NET 2.0, but there does exist a .NET 1.1 provider from Finisar: http://sourceforge.net/projects/adodotnetsqlite I can't vouch for its performance since I've never actually used it. I've used the Finisar one on the desktop in the past, and it works quite well there. I've never used the CF version of it, though. Since moving my own projects to .NET 2.0, I haven't used it at all.
RE: [sqlite] Has anyone used sqlite for Pocket PC development?
Hello Robert, On Wed, March 22, 2006 15:32, Robert Simpson wrote: ... > I can't vouch for its performance since I've never actually used it. we're using SQLite under WinCE since version 2.1.7, with excellent performances. We have been able to handle database with more than 10 records and up to more than 15 Mb without much problems. Most of the times the programming language is the bottleneck, with queries executed in no time and most of the computing time spent filling grids, combo boxes and so on. SQLite rocks also when it comes to reliability, with almost no data loss despite the problematic mobile environment. We haven't tried the recent 3.X version yet, but 2.8 works like a charm, both with the old Embedded Visual Tools environment and the newer .NET Compact Framework. BTW we're not using the .NET data provider but direct calls to a DLL that wraps SQLite so that it is usable from the development languages we use. Bye, -- Denis Sbragion InfoTecna Tel: +39 0362 805396, Fax: +39 0362 805404 URL: http://www.infotecna.it
RE: [sqlite] Has anyone used sqlite for Pocket PC development?
> -Original Message- > From: Monkey Code [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 22, 2006 12:24 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Has anyone used sqlite for Pocket PC development? > > Hi, > > I am planning to use sqlite with VS .Net 2003 Smart device C# > application. > Just wondering if anyone has blazed down this path before and has any > insights to share. Lots of people are using SQLite on Windows CE -- especially now that the core source code supports it. The provider I wrote that Brad mentions is for VS2005 and .NET 2.0, but there does exist a .NET 1.1 provider from Finisar: http://sourceforge.net/projects/adodotnetsqlite I can't vouch for its performance since I've never actually used it. In almost every test I ran on a PocketPC against Sql Server Mobile 3.0 (the replacement for SqlCE), SQLite smoked it in performance. SQLite is less than 1/3rd the install size as well. Robert
Re: [sqlite] Has anyone used sqlite for Pocket PC development?
I am planning to use sqlite with VS .Net 2003 Smart device C# application. Just wondering if anyone has blazed down this path before and has any insights to share. The big thing to remember is that you are not programming for a desktop device, nor even a laptop. If you can limit the use of the keyboard, you should. Don't try to do data entry, unless you have another way to do it, such as a barcode scanner. Check out http://sqlite.phxsoftware.com/ for a SQLite provider for .NET and the CF. For some reading, I picked up this book last year, and it has some really good information in it. There are a number of other books available as well. http://www.amazon.com/gp/product/0735617252/sr=8-2/qid=1143033346/ref=pd_bbs_2/104-2336543-8207937?%5Fencoding=UTF8 This one also looks pretty good. http://www.amazon.com/gp/product/0321174038/sr=8-1/qid=1143033346/ref=pd_bbs_1/104-2336543-8207937?%5Fencoding=UTF8