[sqlite] SQLite port to Stellaris ARM processor

2012-02-05 Thread David Henry
Re: http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2012-January/036 538.html download (modified sqlite3.c, posix wrapper, test app, IAR project ) from http://dl.dropbox.com/u/49916007/SQlite.zip ___ sqlite-users mailing list

[sqlite] SQLite port to Stellaris ARM processor

2012-01-31 Thread David Henry
This mail describes how I implemented SQLite3 on a resource limited processor. The attached zip file contains sources and the IAR project files. Any missing sources e.g. fatfs are part of the IAR IDE and are freely available. Enjoy. Development Environment === 1)

[sqlite] How do I contribute a port?

2012-01-30 Thread David Henry
I've just managed to port SQLite to an 50MHz ARM with 256KB ROM and 96KB RAM. It was an interesting exercise, not too painful and quite successful. I have tables of 1 rows, foreign keys, indices etc. Performance is reasonable and it seems to be stable. At this stage I'd like to contribute

Re: [sqlite] replying to thread

2012-01-24 Thread David Henry
Testing with Microsoft Outlook ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] replying to thread

2012-01-23 Thread David Henry
How do I reply to a thread? I put Re: Re: [thread title] into the subject but it comes out as a new thread e.g. I put "Re: Re: [sqlite] ftruncate implementation" in the subject field but a new thread "[sqlite] ftruncate implementation" was started.

Re: [sqlite] ftruncate implementation

2012-01-23 Thread David Henry
I am working without an operating system so there are no other agents trying to steal data. Bearing that in mind, is it still necessary to actually write zero data to the sectors allocated? Is SQLite expecting it? ___ sqlite-users mailing list

Re: [sqlite] Minimum RAM requirements (Richard Hipp)

2012-01-22 Thread David Henry
Thanks for the tip which seems to do the trick. When using MEMSYS3 I was able to create a table with a primary key but inserting rows ran out of memory after 170 rows. Now, with MEMSYS5, I inserted 5000 rows, no problem. ___ sqlite-users mailing list

[sqlite] ftruncate implementation

2012-01-22 Thread David Henry
According to the posix definition of "ftruncate" , a file is made larger by writing zeroes up to the size desired. My implementation of Fat File System can quickly extend a file by allocating more sectors, but will take a long time to write all those new sectors with zeroes. So, is zero filling

[sqlite] Minimum RAM requirements

2012-01-17 Thread David Henry
I asked this question on the sql_dev list which Richard Hipp told me that this list was the proper place. I asked whether it is possible to execute SQLite in 80K of RAM. Well, I can now tell you that you can, just about. My environment has no malloc so I used the MEMSYS5 method of internal