Hi, I ported sqlite to Vxworks. It was a straight forward port. File locking is not possible in VxWorks. So I do not use it. So I define the macro __DJGPP__ which takes care of fcntl call used for file locking. Did not include the files shell.c and tclsqlite.c in my project. I used the following macros -DOS_UNIX -DSQLITE_OMIT_AUTHORIZATION -DSQLITE_OMIT_VACUUM -D__DJGPP__ -DSQLITE_TRACE_DEBUG
Will have to modify TIMER_START and TIMER_END macros in os.c for VxWorks. Replaced malloc and free with memory pools. realloc requires special attention when repcaling with memory pools. Will need to spend some time in tuning memory pool sizes. Modified util.c for memory pools. Most of the time use sqlite_exec and sqlite_query_table API calls. Use temporary tables too. Very happy so far. vt Brett Granger <[EMAIL PROTECTED]> wrote: Hi, I'm new to this list, and have been given a task to investigate various alternatives for databases on embedded systems. I like what I have seen of sqlite so far! On the sqlite.org wiki under "when to use sqlite", there is the following: "# Embedded devices and applications Because an SQLite database requires little or no administration, SQLite is a good choice for devices or services that must work unattended and without human support. SQLite is a good fit for use in cellphones, PDAs, set-top boxes, and/or appliances. It also works well as an embedded database in downloadable consumer applications." Based on size, speed, and performance the above claim appears to be true. However, a lot of set-top boxes out there are not running Linux or WinCE, but are instead running vxworks or even vrtx. Has anyone ported/compiled sqlite to run on either of these OSes? Does anyone have a sense as to how hard it might or might not be if it doesn't already exist? Maybe it's not too hard if they're both POSIX compliant? I know that Berkeley DB from sleepy cat has a vxworks port, but I would really prefer to pursue sqlite. Any thoughts/hints welcomed! --Brett Granger --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------- Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time.
