sqlite

has anybody install some databases manager on mini2440? and how can i
install it?

It should work if you just cross-compile the SQLite sources for arm-gnueabi
and install the compiled software. See http://sqlite.org/download.html

im already looking that link but with but what should i download? i have
that doubt

this one:

sqlite-amalgamation-3.6.23.1.tar.gz
(1.36 MiB)  

or this one:

sqlite-amalgamation-3_6_23_1.zip

and how can i do the cross compilation?

Look here on my page (sorry, it's under development and german):
http://programmers-projects.de/project/mini2440

Direct link to the SQLite-arm-gnueabi release:
http://programmers-projects.de/sqlite-36231-arm-linux-gnueabi

ok friend i already download the package ejej about the german language
dont problem google traductor my best friend jejeje.

but now how can i do the cross compilation?

im gonna to look, while im wait for your answer ejej

thanks!

You maybe look for something like this:
http://www.ailis.de/~k/archives/19-ARM-cross-compiling-howto.html

friend and sqlite can be drive on mini by C language?
can you giveme an example?

Hi!!.. i've been trying to cross-compile the SQLiteDBMS that is a a kin of
databse server and manager or SQLite but no success. When cross-compiling i
get an error that the sqlite3 library could not be foun... i made a copy of
the sqlite3 library to the ../libc/lib but nothing!! anyone has an idea!??

Why you don't like to use this from here:
http://programmers-projects.de/sqlite-36231-arm-linux-gnueabi ? A binary
for database management in the console is also included (in the bin folder
of the archive). I did nothing else than cross compiling with my toolchain.
A higher version isn't available from the SQLite main project yet so this
cross compiled sqlite set is the actual one.

Actualy i am using it but i also need to communicate with the db through a
TCP/IP connection... that is why i need the SQLiteDBMS witch is a SQLite
server that allows me to do the connection and also includes some sql
extended language to improve security issues!!

Ah okay. I can try to cross compile it for you if you arn't able to build
without errors because I have a clean toolchain for arm-linux-gnueabi
installed.

That is gonna be awesome. Could you try please!!
I'll be waiting right here!!

Okay I have tried yesterday but it hasn't compiled to the end. I will try
and manage to fix the few errors that appeared in a few days again. I
looked at the SQLiteDBMS project pages and found it great so it could be
useful for me too because I think SQLite is best for this board (instead of
using the big parent MySQL) ;)

Ok.. I`ll keep trying here too... i'm posting my email so if you find out
something mail me or post here!!! i'm new in this kind of development so
anythig is a great plus for me!

tks!!

ops forgot the emial... digodox@gmail.com

Finally I was able to ran ./configure for the SQLiteDBMS but now i have
another problem on th make... i get the following error massage:

undefined reference to `rpl_malloc'

any suggestions?

just for the record... to solve my sqlite3 library not found issue I first
cross compiled the sqlie3 to an specified folder then i made a copy of the
libraries and the includes to the /usr/local/arm/4.3.2/ and all the lib
subfolders in this directory!! 1 problem solved... 1 more to go!!!

I get the same error as you... If I it wouldn't be there, I would have
finished compilation already. I think it's possible but I will try to get
rid of this beside my kernel project.

I have successfully cross compiled sqlitedbms! Yeah!
It is difficult to explain what I did because I experimented too much. But
I will upload it onto my Git server.

Maybe you will bring it to success by using my command line:

make clean
make distclean
./configure --host=armel --prefix=/tmp/sqlitedbms --with-sqlite3=DIR
--exec-prefix=/tmp/sqlitedbms CFLAGS="-I/usr/arm-linux-gnueabi/include
-msoft-float -D__GCC_FLOAT_NOT_NEEDED"
make
make install

This will install everything in /tmp/sqlitedbms.

It worked here too... as i said i'm new in this things so i realy dont
understant a bit of what you did... but i'm realy glad that it worked!!
thank you!!

jay or digodox could you help to make my sqlite cross compilation? i have
been doing that too but i dont have to much experience with this.

what was the steps you did?

thanks

i have made that by using the command line that jay has posted with some
modifications:

first at the configure file i commented the lines #define malloc rpl_malloc
and #define realloc rpl_realloc

then executed the following

make clean
make distclean
./configure --host=armlinux --prefix=/tmp/sqlitedbms --with-sqlite3=DIR
--exec-prefix=/tmp/sqlitedbms CFLAGS="-I/usr/arm-linux-gnueabi/include
-msoft-float -D__GCC_FLOAT_NOT_NEEDED"
make
make install

i cross-compiled it and it is already running but i'm having some problems
with the tcp ip connection!! if anybody find something...

obs... use --host=arm-linux

could you please giveme more information you tellme that you did it
following this instructions:

make clean
make distclean
./configure --host=armel --prefix=/tmp/sqlitedbms --with-sqlite3=DIR
--exec-prefix=/tmp/sqlitedbms CFLAGS="-I/usr/arm-linux-gnueabi/include
-msoft-float -D__GCC_FLOAT_NOT_NEEDED"
make
make install

but where did you type this? i downloaded the sqlite from the jay's website
inside what folder can i make my crosscompile? if i put make clean on
sqlite folder it shows me that theres not a rule to build the object clean
stop.

and this is normal because there is not a config file. how did you did
that?

i you can my email its andrewt12357@hotmail.com im on a similar proyect
maybe we can help us on other points

Jay

when are you going to updoad this on you page?

Here i am again....

Now i'm able to connect to the server only by browser because the he is not
finding the database!!

i thing it might be some kind of bug.. i dont know... any ideas?

jay have you tested your cross compiled form??
could you upload it or send by email??

hi

im using the file that is found on jay's page:

http://programmers-projects.de/node/33/release

sqlite_36231_arm_linux_gnueabi.tar.gz

im trying to use it doing this:

cd bin (because here is the sqlite3 file)

and on this file i put ./sqlite3

but it throws me this mistake:

error while loading shared libraries_ libsqlite3.so.0: cannot open shared
object file: No such file or directory

also i tried too with these instrutions:

sqlite3 test.db "create table t1 (t1key INTEGER
PRIMARY KEY,data TEXT,num double,timeEnter DATE);"

but it happened the same mistake

what do i have to do to make it works?

thanks

help!!!

I'm sorry, I havn't had time to test it. Thats why the project is called
mini2440-DEV - because there is no guarantee that everything is working
without problems.

Do you guys have installed the libraries in the right folder of your
mini2440 filesystem? Linux must be able to find these. Without it will not
work!

ok friend thanks a lot it was that copy

libsqlite3.so.0 locate on sqlite3/lib

and paste that on:

/lib of mini2440 directory 

again thanks alot:

Now i want to know what was the steps to make your cross compile, and what
is the source who you work with.

was it sqlite-amalgamation-3.6.23.1?

im tring to compile it with this instrution:
./configure --host=arm-linux --prefix=/sqlitedbms
--exec-prefix=/opt/sqlitedbms CFLAGS="-march=armv4t -mtune=arm920t -Os
-lpthread -lrt" LDFLAGS=${LDFLAGS}


it compiles well but when i execute make appearsme this:
IC -o .libs/sqlite3.o
arm-none-linux-gnueabi-gcc: 3.6.23.1": No such file or directory
<command-line>: warning: missing terminating " character
make: *** [sqlite3.lo] Error 1

or did you make your compile with:
http://sqlitedbms.sourceforge.net/

with that source im having the same mistake digodox had:
error: sqlite3 library is required by SQLiteDBMS. use --with-sqlite3=DIR.

i made what digodox said:
compiled it and After this i copied my files that its locate on
sqlitedbms-0.5.1/src/lib and pasted them on /usr/local/arm/4.3.2/ also i
did it with
the files located on sqlitedbms-0.5.1/src/backend.

and after this i tried to did my compilation. but i throws me the same
mistake.

what am i doing wrong

Jay,

I'm able to compile all these files, but running sqlite3 on arm I'm getting
"Illegal Instruction" while creating a new table on my database.

My cmd line for sqlite3 is: 
./configure --host=arm-linux --prefix=/usr/local/sqlite
CFLAGS="-msoft-float -D__GCC_FLOAT_NOT_NEEDED -march=armv4 -mtune=arm920t"
make
make install


Am I missing something?
Could you share your cmd line for compile sqlite3 utility?

regards.

Hmm, are you sure that the database file is writable for the user under
which you try to create the database table on the mini2440 board?

Then maybe you should try this tutorial:
http://www.shokhirev.com/nikolai/abc/sql/sql.html

Has somebody already tried the SQLiteDBMS 0.5.1 on mini2440? I havn't had
time yet to test if it works so here is the link:
http://www.programmers-projects.de/release/sqlitedbms-0-5-1-fuer-mini244...

Thanks for your response Jay! 
I did the cross compile last Wednesday and everything is working. I'll test
your sqlitedbms as soon as possible. 
Thanks for the other link, will be very useful to me.

I have compiled the SQLiteDBMS directly on the Mini2440 now because with
Cross-Compiling I have had problems in executing the program. Now it's
working great (yes, I can see and use the webinterface of the SQLiteDBMS of
the Mini2440 on my Laptop). I also have added a german tutorial (you can
translate via Gtranslate on the right top of the site).

Very nice, did you install gcc into mini2440? 
Is there any tutorial available?

Yeah, I think to compile directly on mini2440 is the best you can do if
your sources arn't to large. Then you have more compatibility and
flexibility without being in need of a cross compiler. I simply have
installed gcc + needed libraries, headers etc. via APT on the mini2440
board. Then I am able to install everything I need because most of the
packages also are built for armel processors.

New Web-Adress for the Mini2440 SQLite-Database-Management-System:
http://programmers-projects.de/node/12

could anyone plz help me with the steps for cross compiling sqlite-3.7.9
for mini2440..i have no idea abt it..im stuck with the configure step...pls
do help me..