Re: Re: [sqlite] V2.8 or V3.0 for embedded devices?

2005-01-13 Thread [EMAIL PROTECTED]
I use eMbedded Visual C++ 4.0 with de 3.0.8 Wrapper created by Rob Groves that you will find in http://www.codeproject.com/database/CppSQLite.asp and with de WinCE port http://sqlite-wince.sourceforge.net/ created by Nuno Lucas. You will find a manual steb-by-step of install this WinCE port in my

Re: [sqlite] V2.8 or V3.0 for embedded devices?

2005-01-13 Thread Markus Oliver Junginger
Miquel Matas wrote: Please, what kind of application developent do you use me to develop in pocketpc and sqlite 3.0?? Are you asking about the IDE or the application itself? IDE: Embedded Visual Studio 4 and Visual Studio 2003 (it runs on pdas and on desktops). application: it's actually a platf

Re: [sqlite] V2.8 or V3.0 for embedded devices?

2005-01-13 Thread Miquel Matas
Markus Oliver Junginger wrote: D. Richard Hipp wrote: Not true. V2.8 stores the first 240 or so bytes of data for each row on a single disk page and the rest on overflow pages. ... Thanks for the clarification. So, it seems V3.x is the right choice for embedded software, too, and we will migrat

Re: [sqlite] V2.8 or V3.0 for embedded devices?

2005-01-13 Thread Markus Oliver Junginger
D. Richard Hipp wrote: Not true. V2.8 stores the first 240 or so bytes of data for each row on a single disk page and the rest on overflow pages. ... Thanks for the clarification. So, it seems V3.x is the right choice for embedded software, too, and we will migrate to V3.x in the long term. Reg

Re: [sqlite] V2.8 or V3.0 for embedded devices?

2005-01-11 Thread D. Richard Hipp
Markus Oliver Junginger wrote: Thanks for the answers so far; there have been some interesting suggestions ( for example, I didn't know about the SQLITE_OMIT). Still, I would like to know more about my main concern - memory consumption. Somewhere I read V2.8 holds the first 240 bytes or so of e

Re: [sqlite] V2.8 or V3.0 for embedded devices?

2005-01-10 Thread Markus Oliver Junginger
Thanks for the answers so far; there have been some interesting suggestions ( for example, I didn't know about the SQLITE_OMIT). Still, I would like to know more about my main concern - memory consumption. Somewhere I read V2.8 holds the first 240 bytes or so of each row in memory, while V3.0 h

Re: [sqlite] V2.8 or V3.0 for embedded devices?

2005-01-10 Thread Randy J. Ray
Christian Smith wrote: For non-text data, SQLite 3.x has more efficient storage, as binary data is stored in binary format and not text format. I've heard figures such as 25% savings on disk space bandied about, but YMMV. The storage is not binary compatible with SQLite 2.8.x files, and SQLite 3 ca

Re: [sqlite] V2.8 or V3.0 for embedded devices?

2005-01-10 Thread chorlya
There are some changes in CVS that introduced a few SQLITE_OMIT_* macros that are supposed to exclude some features at compile time. Since you're on embedded system, I guess you'll find quite a few features that you can omit, hence reduce memory footprint. I don't think there's any documentation f

Re: [sqlite] V2.8 or V3.0 for embedded devices?

2005-01-10 Thread Christian Smith
On Mon, 10 Jan 2005, Markus Oliver Junginger wrote: >We are developing applications that also run on PocketPC devices; Sqlite >2.8.x is used here as the database. > >For the next release of our software the question is if we should switch >to SQLite 3. What's the experts' recommendation? The main