topic Re: Data base suggestion for lpc1788 in LPC Microcontrollers

Data base suggestion for lpc1788

lpcware — Wed, 15 Jun 2016 17:23:44 GMT

Content originally posted in LPCWare by nil on Thu Jul 02 05:21:12 MST 2015

Hi All,

I am using lpc1788 with freertos and LWIP.I have a requirement for a database on an lpc1788. Currently, I have looked at SQLite (http://www.sqlite.org/) and MySQL
(http://www.mysql.com/).But I don't know how much they are comfortable with micro controller( lpc1788).
Does anyone have any other suggestions?Does any one know any other database which is generally used for lpc micro controller.
Does anyone have any comments on either of these two regarding
performance (specifically SELECT speeds and memory footprint)?
Any pointers appreciated!

Re: Data base suggestion for lpc1788

lpcware — Wed, 15 Jun 2016 17:23:44 GMT

Content originally posted in LPCWare by wmues on Thu Jul 02 06:51:39 MST 2015
I would not use a SQL database on a CPU without MMU. You will get serious memory fragmentation.
Try to keep it simple and fast.

Re: Data base suggestion for lpc1788

lpcware — Wed, 15 Jun 2016 17:23:45 GMT

Content originally posted in LPCWare by rocketdawg on Thu Jul 02 12:27:24 MST 2015
I second that.
The controller does not have enough resources.
What one wants is a high speed transport to move the data from the controller to a PC. The PC can place the data into an data base.

Re: Data base suggestion for lpc1788

lpcware — Wed, 15 Jun 2016 17:23:46 GMT

Content originally posted in LPCWare by nil on Thu Jul 02 22:31:33 MST 2015
Hi,

Thanks for the reply.I already Implement the database on the pc side now i want to implement on controller side and remove the pc database application.I interface the sd card with lpc1788 and
want implement any data base so I am searching for micro controller compatible database.

Re: Data base suggestion for lpc1788

lpcware — Wed, 15 Jun 2016 17:23:46 GMT

Content originally posted in LPCWare by TheFallGuy on Fri Jul 03 01:06:36 MST 2015
The SQLLite web pages says:
- removing optional features reduces size to below 300KiB
- minimal stack size of 4KiB
- very little heap of 100KiB

That gives you a code (Flash) size requirement of 300K and a data (RAM) size of 104K. This is WITHOUT your application, and (I guess) without a C library too.

Given that an LPC1788 has a 96k of RAM in total, this is not going to work.

As other correspondents have noted, an LPC1788 does not have enough resources for you to be able to implement much of a database.

You might want to look at these which claim very small footprint:
eXtremeDB
WhiteDB

It may also be worth reading
http://www.embedded.com/electronics-blogs/embedded-com-tech-focus-newsletter-archive/4027613/Embedded-com-Tech-Focus-Newsletter-1-11-10--Embedding-Databases