Re: [sqlite] SQLite on Nintndo DS?

2008-10-30 Thread Jay A. Kreibich
On Fri, Oct 31, 2008 at 12:21:50AM -0400, [EMAIL PROTECTED] scratched on the wall: > I use it built in on iPhone -- oops. Can't talk about iPhone. Yes, you can. On Oct. 1st Apple modified the SDK Agreement, essentially removing the developer NDA. Some aspects (i.e. pre-release software)

Re: [sqlite] SQLite on Nintndo DS?

2008-10-30 Thread Regnirps
In a message dated 10/30/08 9:05:28 PM, [EMAIL PROTECTED] writes: > If you have an official devkit, or care to grab a copy of the > I-don't-know-if-it's-legal DevKit Pro, you can try it out yourself and let > us know how it works. > I have the DevKit and all the goodies and am able to make the

Re: [sqlite] SQLite on Nintndo DS?

2008-10-30 Thread Sherief N. Farouk
> Has anyone used SQLite on the NintendoDS? Can it fit? Arm7 and ARM9 and > a > cartridge like an SD card. The database can be static in FLASH. But the > rest? > > -- Charlie Springer > [Sherief N. Farouk] If you have an official devkit, or care to grab a copy of the I-don't-know-if-it's-legal

Re: [sqlite] insert speeds slowing down as database size increases (newb)

2008-10-30 Thread Julian Bui
Unless I did something wrong, I did observe constant time inserts in Berkeley DB. Is it possible that I had constant time inserts into a btree as my db grew because of the nature of my data? I was inserting records in order of how they would be sorted by index. In other words, every inserted rec

Re: [sqlite] insert speeds slowing down as database size increases (newb)

2008-10-30 Thread Alex Scotti
On Oct 29, 2008, at 4:59 AM, Julian Bui wrote: > Hi everyone, > > First off, I'm a database and sqlite newbie. I'm inserting many many > records and indexing over one of the double attributes. I am seeing > my insert times slowly degrade as the database grows in size until > it's unacceptable -

[sqlite] SQLite on Nintndo DS?

2008-10-30 Thread Regnirps
Has anyone used SQLite on the NintendoDS? Can it fit? Arm7 and ARM9 and a cartridge like an SD card. The database can be static in FLASH. But the rest? -- Charlie Springer ** Plan your next getaway with AOL Travel. Check out Today's Hot 5 Travel Deals! (http://pr.atwola.com/promo

Re: [sqlite] sqlite3_open() problem for ARM

2008-10-30 Thread MikeW
Leandro Ribeiro <[EMAIL PROTECTED]> writes: > > Hello Guys. > > I have a problem with running SQLite. > I am running linux 2.6.17 on *ARM* and basically problem is that my > application > is crushing on *sqlite3_open*() function while the sqlite3 command > shell is > running without problems.

Re: [sqlite] Problem : SQLite Database error

2008-10-30 Thread MikeW
Mihai Limbasan <[EMAIL PROTECTED]> writes: > > Hello, Aaron. > > Have you tried Mr. Griggs' solution yet? Please be aware that posting > the same question for the *third* time in a row will not make it any > more visible, but will dramatically increase the chance that people will > become ann

Re: [sqlite] Making the binary small

2008-10-30 Thread Shane Harrelson
On Thu, Oct 30, 2008 at 1:02 PM, Shane Harrelson <[EMAIL PROTECTED]> wrote: > The sizes that I mentioned (315KB vs 205KB) are for the final .dll and That should read (235KB and 205KB). ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.

Re: [sqlite] Making the binary small

2008-10-30 Thread Shane Harrelson
The sizes that I mentioned (315KB vs 205KB) are for the final .dll and .so size. You might try linking your object files into a lib to see how that affects size. You could also try running the "strip" command on the object files to ensure all the debugging symbols are removed. Any OMIT options

[sqlite] Disk I/O error on INSERT timeout expired

2008-10-30 Thread Darko Filipovic
Hello, I'm having two independent processes that accessing SQLite db simultaneously. Process A writes db in transaction and Process B reads the same db simultaneously. If Process B reads db and timeout for Process A expires, SQLite returns code 10 (disk I/O error) instead of 5 (sqlite busy). I

Re: [sqlite] Making the binary small

2008-10-30 Thread Pados Károly
Just one more clarification: I am measuring the size of the produced .o object file, that is, before linking. That is why I remove -ffunction-sections, but of course, with -ffs would probably produce a smaller binary after linking. The reason is that it is not clear which microcontroller I'll b

Re: [sqlite] Making the binary small

2008-10-30 Thread Pados Károly
First a note: I removed -ffunction-sections from the compiler options, and it is now better, but not good enough (365KB). It was an options the AVR IDE defaulted to, that is why I not noticed it. OMIT_DISKIO is also NOT defined. I am using SQLite version 3.6.4. OTHER_OS=1 and THREADSAFE=0. At

Re: [sqlite] Separating error conditions that are all lumpe d as SQLITE_ERROR

2008-10-30 Thread MikeW
Roger Binns <[EMAIL PROTECTED]> writes: > > > MikeW wrote: > > Having looked at the source code, looks like the best way to do this > > /would/ be to add another (!) numerical parameter to sqlite3ErrorMsg() indicating > > the extended error code that corresponds with the message. > > http://www.

Re: [sqlite] sqlite3_total_changes() doesn't include schema changes?

2008-10-30 Thread David Barrett
Ah, thanks. I think I'll wait for the next stable release and go to that; in the meantime I'll use the WHERE 1 trick. Thanks! -david Dan wrote: > On Oct 30, 2008, at 3:10 PM, David Barrett wrote: > >> Ok, getting close: now I test for changes in sqlite3_total_changes() >> and >> PRAGMA sche

Re: [sqlite] sqlite3_total_changes() doesn't include schema changes?

2008-10-30 Thread Dan
On Oct 30, 2008, at 3:10 PM, David Barrett wrote: > Ok, getting close: now I test for changes in sqlite3_total_changes() > and > PRAGMA schema_version and that works, except for one case: > > DELETE FROM table; > > I see in the docs for sqlite_total_changes() that I can solve this > by

Re: [sqlite] sqlite3_total_changes() doesn't include schema changes?

2008-10-30 Thread David Barrett
Ok, getting close: now I test for changes in sqlite3_total_changes() and PRAGMA schema_version and that works, except for one case: DELETE FROM table; I see in the docs for sqlite_total_changes() that I can solve this by doing: DELETE FROM table WHERE 1; Is there any other way