SQLITE database

Started by last_marco August 18, 2009
I am new to ARM and LPC and before I'd like know if it's theoretically possible link the source of this free Database (, or someone have already done.
LPC has SD interface and I see many File System libs available,
but in my application I need store many records/tables, to sort and query, thus it's necessary a true database.
Any thought is welcome.


An Engineer's Guide to the LPC2100 Series

Hehe, what micro are you talking about?

I've been thinking for some time about doing an small port to LPC2148,
but probably it's quite extreme (if not impossible), since we only have 32KB

of available ram...

If you try, please tell me what's the RAM footprint for sqlite, I will be
in helping if I can :-)

Miguel Angel Ajo Pelayo
Sorry, I forgot to say that I was thinking to LPC2478 with 8-16Mb external Ram (!)
I'm sure that you will be able to run sqlite with 8-16MB of ram :)

Miguel Angel Ajo Pelayo
It can be done and I have done it already but can't give you any code. Do not expect it to work with internal RAM only! You need a good size memory to run it. The more the better.

When you get started, use the file name ":MEMORY:" and you will be able to create a database in RAM. You do not need a file system to get started. Once all is working ten you can start adding the code for file system.

Thank you Gus,
I was thinking to a 2478 dev board with 8-16MB ram, to be shared with LCD and application data.
I am new to ARM, thus before approach SQLITE, I'll have to learn ALL basic things (!)
But I had know if my target (database) were reachable before start study a new platform.

I come from Atmel AVR8. Can you advise a board and compiler from your experience ?
Last year I came from Atmel AVR 8bit to LPC2478 ... It's quite a
learning curve!

We used Embedded Artists LPC2478-OEM board, which has onboard QVGA
screen, and Rowley Crossworks compiler with Crossconnect JTAG adapter.
The Embedded Artists board comes with uC-Linux but we decided not to use
Linux and just erased it and wrote our own native code.

Crossworks is very good value for money in my opinion because you're up
and running very quickly. There are free compilers out there but you can
waste a lot of time getting it all working - depends if this is a
commercial or hobby project.

Tim Mitchell
Hi Tim,
mine is a commercial project which use color LCD, SD, USB device, Ethernet and 4 Serial Com port.
I am in doubt between Keil and Crossworks.
However I think very important the Libraries available for system resource management. I need easy multitasking and easy data manipulation (strings?).

I was thinking the same: uClinux or native code, but no knowledge to take right decision...
May be a good set of libraries/RTOS work well as linux, and less effort, but which libraries ?

We chose Crossworks over Keil because a lot of things provided with
Crossworks were an add-on at extra cost with Keil, and the basic cost
was also a lot higher with Keil. However, a lot of the demo code
provided by NXP and others is written using Keil and has to be altered
to compile with Crossworks. Rowley support is very good if you get
stuck, I don't know what Keil is like.

Crossworks comes with a "tasking library" which allows you to create
multitasking code easily - it's not an RTOS though.
As for USB and Ethernet, you will need to purchase a library or spend
time amending sample code to do what you need.

Tim Mitchell
CrossWorks is now a supported compiler for the uEZ software project that
FDI/NXP have going:

I'll shout this:


I mean, it's not like NXP actually actively promote the fact that it
exists. It has CrossWorks, IAR, and Visual Studio files in the top-level

-- Paul.