[sqlite] R: [sqlite] Sqlite for Embedded Devices
Hi, I've compiled sqlite2 and sqlite3 for some embedded architecture (mipsel, avr, arm, cris) and it work fine. If you want an help, post your problems. Bye Francesco -Messaggio originale- Da: Jakub Ladman [mailto:[EMAIL PROTECTED] Inviato: giovedì 1 marzo 2007 14.21 A: sqlite-users@sqlite.org Oggetto: Re: [sqlite] Sqlite for Embedded Devices Dne čtvrtek 01 březen 2007 13:11 Pavan napsal(a): > Hi, > > Could anyone share their observations/comments on having used sqlite > as DB for embedded linux environment. I have just started. Now i have sqlite compiled for embedded linux based on kernel 2.4.18 and uclibc library on Renesas SuperH cpu SH7760, it seems to be working good, but i am thorough beginner in SQL technology generally. Maybe later ... Jakub > > Thanks, > Pavan. - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] R: [sqlite] Cross compile error!
OK Richard, I've follow your steps and all is fine. I've created libsqlite3.a, but how i create .so files? Another questionwhen i compile a program using cross compile and the libsqlite3.a lib, the executable file (in my case .cgi file) is too big!! Why? If i strip it the size decrease a bit. My compile command is : mipsel-linux-gcc -o xxx.cgi xxx.c -lsqlite3 Mystrip command is: mipsel-linux-strip xxx.cgi Thank a lot. Regards -Messaggio originale- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Inviato: martedì 2 gennaio 2007 17.25 A: sqlite-users@sqlite.org Oggetto: Re: [sqlite] Cross compile error! "Francesco Andrisani" <[EMAIL PROTECTED]> wrote: > Hi comunity, > i've a problem when i try to cross compile sqlite-3.3.8 for mipsel > architecture. Suggested approach. 1. Configure for the host. 2. Type "make target_source". This puts a bugs of C source files in a subdirectory named "tsrc". 3. Remove tclsqlite.c and possibly also shell.c from tsrc. 4. Compile all the other C files in tsrc using your cross-compiler. for i in *.c; do xcc -c $i.c; done ar r libsqlite3.a *.o The key step is to do "make target_source" on your host machine. There is a lot of generated code in SQLite. That step will do all the automatic code generation and leave you with a batch of ordinary C source code files, which are much easier to deal with using a cross-compiler. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Cross compile error!
Hi comunity, i've a problem when i try to cross compile sqlite-3.3.8 for mipsel architecture. I lauch configure file with follow params: [EMAIL PROTECTED] sqlite-3.3.8]$ ./configure --prefix=/home/frank/Router/OpenWRT/whiterussian/openwrt/staging_dir_mipsel --host=mipsel-linux --disable-tcl I've by-passed first error: Version set to 3.3 Release set to 3.3.8 Version number set to 3003008 checking for mipsel-linux-gcc... (cached) mipsel-linux-gcc checking whether we are using the GNU C compiler... (cached) yes checking whether mipsel-linux-gcc accepts -g... (cached) yes checking for mipsel-linux-gcc option to accept ANSI C... (cached) none needed configure: error: unable to find a compiler for building build tools ...changing configure file, but if i re-lauch it show new error: checking readline header files... not specified: still searching... checking readline.h usability... no checking readline.h presence... no checking for readline.h... no checking for /usr/include/readline.h... configure: error: cannot check for file existence when cross compiling Can someone suggest the solution of my problems? Regards
[sqlite] unable to open database file
Hi comunity, i'm writing CGI pages (writeen in ANSI C) with SQLITE3 support, all work fine using "SELECT" statement, but when i try to exec "UPDATE" or "INSERT" statement i've the follow error: unable to open database file I've set all data base fle permission, but it don't work. Thank a lot. Regards
[sqlite] Problem with sqlite3 on CGI scripts with ANSI C
Hi comunity, i have the follow problem. I've insert into a C-CGI page a small sqlite3 code. When i call the page from a browser, it exec a query and show on browser the entries, but it don't work. If i add a "printf" above the sqlite3_open() it print the message, but if i put the instruction after the sqlite2_open() it don't swow the message. Under i put my piece of code: printf("\nhello [1]"); if (sqlite_open("myDB.db", )); error_handle(db); printf("\n hello [2]"); Regards. F. ________ Francesco Andrisani Software Engineer mailto: [EMAIL PROTECTED] Gruppo Acotel http://www.acotel.com <http://www.acotel.com/> Via della Valle dei Fontanili, 29 00168 Roma Tel: +39661141270 Fax +3966149936 Le informazioni contenute nella comunicazione che precede possono essere riservate e sono, comunque, destinate esclusivamente alla persona o all'ente sopraindicati. La diffusione, distribuzione e/o copiatura non autorizzata del documento trasmesso da parte di qualsiasi soggetto è proibita. La sicurezza e la correttezza dei messaggi di posta elettronica non possono essere garantite. Se avete ricevuto questo messaggio per errore, Vi preghiamo di contattarci immediatamente. Grazie. This communication is intended only for use by the addressee. It may contain confidential or privileged information. Transmission cannot be guaranteed to be secure or error-free. If you receive this communication unintentionally, please inform us immediately. Thank you.