Hi All,

I have a requirement for a database on an embedded platform.

Currently, I have looked at SQLite (http://www.sqlite.org/) and MySQL
(http://www.mysql.com/).

Does anyone have any other suggestions?

Does anyone have any comments on either of these two regarding
performance (specifically SELECT speeds and memory footprint)?

Any pointers appreciated!

Ciao,

Peter K.

-- 
"And he sees the vision splendid 
of the sunlit plains extended
And at night the wondrous glory of the everlasting stars."

 

> I have a requirement for a database on an embedded platform.

...but you do not mention what these requirements are so how can be offer 
advice?

-- 
Regards,
Richard.

+ http://www.FreeRTOS.org & http://www.FreeRTOS.org/shop
17 official architecture ports, more than 6000 downloads per month.

+ http://www.SafeRTOS.com
Certified by TÜV as meeting the requirements for safety related systems.

"Peter K." <p...@remove.ieee.org> schreef in bericht 
news:u...@remove.ieee.org...
> Hi All,
>
> I have a requirement for a database on an embedded platform.
>
> Currently, I have looked at SQLite (http://www.sqlite.org/) and MySQL
> (http://www.mysql.com/).
>
> Does anyone have any other suggestions?
>
> Does anyone have any comments on either of these two regarding
> performance (specifically SELECT speeds and memory footprint)?

MySQL is not an embedded database IMHO, way too big. The licensing is also 
very commercial since you're only really entitled to use it if for free you 
are an open-source programmer.

I'm using SQLite in many projects and the performance is excellent and the 
memory footprint very, very small (several KBytes). There's also an 
in-memory version of the database in development (or maybe already 
available). 


** Posted from http://www.teranews.com **

"Peter K." wrote:
> 
> I have a requirement for a database on an embedded platform.
> 
> Currently, I have looked at SQLite (http://www.sqlite.org/) and
> MySQL (http://www.mysql.com/).
> 
> Does anyone have any other suggestions?
> 
> Does anyone have any comments on either of these two regarding
> performance (specifically SELECT speeds and memory footprint)?
> 
> Any pointers appreciated!

If an 'in memory' database is satisfactory, take a look at my GPLd
hashlib.  It is written in pure standard C, so extremely portable. 
I own it, so arrangements can be made if the GPL requirement to
release your code is a problem.  See:

  <http://cbfalconer.home.att.net/download/hashlib.zip>;

-- 
 [mail]: Chuck F (cbfalconer at maineline dot net) 
 [page]: <http://cbfalconer.home.att.net>;
            Try the download section.

"FreeRTOS.org" <n...@given.com> writes:

> > I have a requirement for a database on an embedded platform.
> 
> ...but you do not mention what these requirements are so how can be offer 
> advice?

Repeated from my original post:

>>Does anyone have any comments on either of these two regarding
>>performance (specifically SELECT speeds and memory footprint)?
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^


Ciao,

Peter K.

-- 
"And he sees the vision splendid 
of the sunlit plains extended
And at night the wondrous glory of the everlasting stars."

 

Dale, thanks for the comments!
-- 
"And he sees the vision splendid 
of the sunlit plains extended
And at night the wondrous glory of the everlasting stars."

 

"Peter K." <p...@remove.ieee.org> wrote in message 
news:u...@remove.ieee.org...
> "FreeRTOS.org" <n...@given.com> writes:
>
>> > I have a requirement for a database on an embedded platform.
>>
>> ...but you do not mention what these requirements are so how can be offer
>> advice?
>
> Repeated from my original post:
>
>>>Does anyone have any comments on either of these two regarding
>>>performance (specifically SELECT speeds and memory footprint)?
>               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^


Well the SELECT speed and memory footprint of mySQL are both superb.

[caveat - you need a 2GHz Pentium and 1GByte of RAM]

-- 
Regards,
Richard.

+ http://www.FreeRTOS.org & http://www.FreeRTOS.org/shop
17 official architecture ports, more than 6000 downloads per month.

+ http://www.SafeRTOS.com
Certified by TÜV as meeting the requirements for safety related systems. 

CBFalconer <c...@yahoo.com> writes:

> If an 'in memory' database is satisfactory, take a look at my GPLd
> hashlib.  It is written in pure standard C, so extremely portable. 
> I own it, so arrangements can be made if the GPL requirement to
> release your code is a problem.  See:
> 
>   <http://cbfalconer.home.att.net/download/hashlib.zip>;
> 

Thanks, Chuck, I'll take a look.

Ciao,

Peter K.

-- 
"And he sees the vision splendid 
of the sunlit plains extended
And at night the wondrous glory of the everlasting stars."

 

In article <Q82ek.25508$E...@text.news.virginmedia.com>, 
n...@given.com says...
> "Peter K." <p...@remove.ieee.org> wrote in message 
> news:u...@remove.ieee.org...
> > "FreeRTOS.org" <n...@given.com> writes:
> >
> >> > I have a requirement for a database on an embedded platform.
> >>
> >> ...but you do not mention what these requirements are so how can be offer
> >> advice?
> >
> > Repeated from my original post:
> >
> >>>Does anyone have any comments on either of these two regarding
> >>>performance (specifically SELECT speeds and memory footprint)?
> >               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> >               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> 
> 
> Well the SELECT speed and memory footprint of mySQL are both superb.
> 
> [caveat - you need a 2GHz Pentium and 1GByte of RAM]

Hmm my working gateway email server uses mySQL, originally on a sub GHz
processor and 256MB of RAM, Got upgraded to a newer nano-ATX board 
1GHz and 1GB RAM. System runs Apache and email server and several other
apps, some of them using the half dozen databases.

However the system is so lightly loaded, the real question on SELECT 
speeds and memory footprint depends on

	Size and complexity of database
	Number of concurrent users (access to database)
	Number of SELECT requests per min/per hour...
	What forms of caching are being used
	etc....

-- 
Paul Carpenter          | p...@pcserviceselectronics.co.uk
<http://www.pcserviceselectronics.co.uk/>;    PC Services
<http://www.pcserviceselectronics.co.uk/fonts/>; Timing Diagram Font
<http://www.gnuh8.org.uk/>;  GNU H8 - compiler & Renesas H8/H8S/H8 Tiny
<http://www.badweb.org.uk/>; For those web sites you hate

Paul Carpenter <p...@pcserviceselectronics.co.uk> writes:

> Hmm my working gateway email server uses mySQL, originally on a sub GHz
> processor and 256MB of RAM, Got upgraded to a newer nano-ATX board 
> 1GHz and 1GB RAM. System runs Apache and email server and several other
> apps, some of them using the half dozen databases.

Thanks, all good information.

> However the system is so lightly loaded, the real question on SELECT 
> speeds and memory footprint depends on
> 
> 	Size and complexity of database
> 	Number of concurrent users (access to database)
> 	Number of SELECT requests per min/per hour...
> 	What forms of caching are being used
> 	etc....

The database will be large (e.g. tables of 1,000,000 or more entries),
but not particularly complex.

There weill only be one application accessing the database at a time
(or at all).

Assuming only one (concurrent) connection, I wonder why the number of
select requests per time period is a factor (it clearly will be for
multiple connections).

I suppose what I'm looking for is how long it takes to do:

SELECT * FROM SomeTable WHERE SomeField = 'SomeValue'

and SomeField is the primary key. By "how long" I mean mean, standard
deviation, and [if possible] worst case times.

Ciao,

Peter K.

-- 
"And he sees the vision splendid 
of the sunlit plains extended
And at night the wondrous glory of the everlasting stars."