Re: [sqlite] a couple notes on cross-compiling sqlite3 for the PPC
sqlite should build shared libs for powerpc (cross) just fine. My suggestion is there are two places to look. First make sure your cross compilers function properly. (Normally this just works.) Second look in the configure script helpers for a powerpc (might be labeled mklinux) check. Older versions of configure has a check for PowerPC linux to conver a situation that occurred WAY back in 1996 or so... a lot of folks are still running into this issue.) Fix the configure script, or aclocal files.. and that should correct the issue. --Mark Robert P. J. Day wrote: first, it doesn't support building shared libs, which i'd prefer. also, it's not clear how to disable tcl support just from that makefile, which i'm assuming should be allowable since it was an option with the configure program.
Re: [sqlite] a couple notes on cross-compiling sqlite3 for the PPC
On 6/23/05, Robert P. J. Day [EMAIL PROTECTED] wrote: p.s. as a side note, the whole point of this exercise is to build a *really* small footprint DB for an embedded system for which space is at a premium, and sqlite came highly recommended. if anyone has a suggestion as to some other, freely-available, OSS DB package that would be worth examining, i'm all ears. i'd like to be able to say i at least considered some alternatives. It worked well for me too. If you don't need very sophisticated query capability, like you get with sqlite, homebrewed is simple, and dbm is old but workable (it's from early unix).
Re: [sqlite] a couple notes on cross-compiling sqlite3 for the PPC
On Thu, 2005-06-23 at 13:47 -0400, Robert P. J. Day wrote: in any event, the simplest solution appears to be to just hack up a modified makefile to do what i want. thanks for the info thus far, i'm sure this isn't the end of it. I hack the Makefile template for all my builds. I never use autoconf. If you want to use autoconf, you can do this: make target_source That creates subdirectory tsrc that contains all of the generated source code files. Cd into that directory and delete the ones you do not want. (ex: tclsqlite.c and shell.c) then do crosscompiler -o libsqlite.a *.c -- D. Richard Hipp [EMAIL PROTECTED]
Re: [sqlite] a couple notes on cross-compiling sqlite3 for the PPC
p.s. as a side note, the whole point of this exercise is to build a *really* small footprint DB for an embedded system for which space is at a premium, and sqlite came highly recommended. If you look on SourceForge, there is a project called adodotnetsqlite, http://sourceforge.net/projects/adodotnetsqlite/, and the programmers there have mentioned a version of SQLite compiled for handheld platforms. I know that they use a version of that for the .NET provider they are writing.
Re: [sqlite] a couple notes on cross-compiling sqlite3 for the PPC
On Thu, 23 Jun 2005, Brass Tilde wrote: p.s. as a side note, the whole point of this exercise is to build a *really* small footprint DB for an embedded system for which space is at a premium, and sqlite came highly recommended. If you look on SourceForge, there is a project called adodotnetsqlite, http://sourceforge.net/projects/adodotnetsqlite/, and the programmers there have mentioned a version of SQLite compiled for handheld platforms. I know that they use a version of that for the .NET provider they are writing. ok, i just took a quick look there and, personally, there's just a wee bit too much .vcl and .vcp and .net and so forth for my comfort level. :-P i'll take a shot at the full sqlite and see where that takes me, but i'll keep the alternative in mind. thanks. rday
Re: [sqlite] a couple notes on cross-compiling sqlite3 for the PPC
[23-06-2005 21:32, Robert P. J. Day escreveu] On Thu, 23 Jun 2005, Brass Tilde wrote: If you look on SourceForge, there is a project called adodotnetsqlite, http://sourceforge.net/projects/adodotnetsqlite/, and the programmers there have mentioned a version of SQLite compiled for handheld platforms. I know that they use a version of that for the .NET provider they are writing. ok, i just took a quick look there and, personally, there's just a wee bit too much .vcl and .vcp and .net and so forth for my comfort level. :-P i'll take a shot at the full sqlite and see where that takes me, but i'll keep the alternative in mind. thanks. The code they use is from http://sqlite-wince.sf.net But I don't know if that helps you as it's a windows API thing. It could give you some ideas on what you need to do the port, and the patch is done so that the same source can be used on other systems (like linux Windows). I think the only advantage is that it's all pre-processed code, so you don't need to run the lemon parser to generate some files, etc. (but you can get the same thing by downloading the pre-processed source from the sqlite site). Regards, ~Nuno Lucas
RE: [sqlite] a couple notes on cross-compiling sqlite3 for the PPC
ok, i just took a quick look there and, personally, there's just a wee bit too much .vcl and .vcp and .net and so forth for my comfort level. :-P i'll take a shot at the full sqlite and see where that takes me, but i'll keep the alternative in mind. thanks. Understood, I was refering to the fact that he was compiling for the platform. I was thinking you might get some pointers from how he does it.