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 (www.sqlite.org), 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.
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
Miguel Angel Ajo Pelayo
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.
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 ?
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.
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 ?
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.
FDI/NXP have going:
I'll shout this:
I AM AMAZED THAT SO FEW PEOPLE KNOW ABOUT THIS RESOURCE!
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