LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 05-04-2011, 05:21 AM   #1
golden_boy615
Member
 
Registered: Dec 2008
Distribution: Ubuntu Fedora
Posts: 443

Rep: Reputation: 17
which database is good for embedded arm systems and support PHP and C API


hello
I am working on arm systems that has embedded Linux this system has this specifications:
Quote:
1-64MB memory
2-400 MHz arm cpu
3-embedded linux kernel (2.6.29.4)
I am looking for a good known database that:
Quote:
1-has low memory usage
2-support PHP and C API
3-has Client/Server for accessing over network to its databases
4-fast data transaction
5-free
6-opensource
7-easy to compile for embedded arm linux.
8-has SQL standard syntax to use in queries.
9-can make table in memory
for my project.

does any body has any suggestion ?
 
Old 05-04-2011, 05:46 AM   #2
go_tux_yourself
LQ Newbie
 
Registered: Oct 2009
Posts: 9

Rep: Reputation: 1
I'm pretty sure sqlite is what you are looking for. Lightweight, portable, open source and with C and PHP interface libraries.

Here is an excerpt taken from http://www.sqlite.org/cvstrac/wiki?p=HowToCompile on how to cross compile sqlite for linux arm.

Crosscompile linux x86 -> linux arm

With version 3.3.7 (don't know about other versions) I have figured out how to get configure to work without following the previous procedure defined below which required editing files.

The problem with the configure script is primarily that it doesn't give you a way to specify that you don't have readline for the target. This could easily be fixed if someone wants to tackle it by supporting a --without-readline option that skipped the readline checking and set TARGET_HAVE_READLINE to 0. The other problem is that you have to explicitly tell configure the compiler for both build and target.

Here is the command line I used to configure sqlite3.3.7 for cross compiling to arm-linux:

../configure --host=arm-linux config_BUILD_CC=gcc config_TARGET_CC=arm-linux-gcc --disable-tcl config_TARGET_READLINE_INC=" "

Setting config_TARGET_READLINE_INC to something makes it skip looking for readline.h, which is what causes problems when cross compiling.

################################################################

Apparently temporary in-memory database can be created using
sqlite3_open(":memory:")

ref: http://www.sqlite.org/capi3ref.html#sqlite3_open

Last edited by go_tux_yourself; 05-04-2011 at 06:24 AM.
 
Old 05-08-2011, 02:40 AM   #3
golden_boy615
Member
 
Registered: Dec 2008
Distribution: Ubuntu Fedora
Posts: 443

Original Poster
Rep: Reputation: 17
does sqlite lock whole database when it wants to write in a record if it is doesn't it slow down data transactions? and can I use Mysql commands in sqlite for example:

Quote:
select * from ......
update .....
insert .....
create database ....
create table ......
or not?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Read only file systems, custom live CDs, and embedded systems coffeecoffee Linux - Newbie 2 02-25-2009 12:09 AM
embedded linux on ARM audiogreenie Linux - Embedded & Single-board computer 1 02-02-2009 12:52 PM
Good embedded system NAS with NFS, PHP/MySQL telecomkid Linux - Embedded & Single-board computer 0 09-16-2007 06:15 AM
The PHP configuration on your server doesn't support the database type that you chose waynejkruse10 Linux - Software 1 10-05-2005 03:01 AM


All times are GMT -5. The time now is 03:30 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration