Hello,
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.
Regards,
Marco
SQLITE database
Started by ●August 18, 2009
Reply by ●August 18, 20092009-08-18
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
interested
in helping if I can :-)
--
Miguel Angel Ajo Pelayo
http://www.nbee.es
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
interested
in helping if I can :-)
--
Miguel Angel Ajo Pelayo
http://www.nbee.es
Reply by ●August 18, 20092009-08-18
Reply by ●August 18, 20092009-08-18
I'm sure that you will be able to run sqlite with 8-16MB of ram :)
--
Miguel Angel Ajo Pelayo
http://www.nbee.es
--
Miguel Angel Ajo Pelayo
http://www.nbee.es
Reply by ●August 18, 20092009-08-18
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.
Gus
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.
Gus
Reply by ●August 19, 20092009-08-19
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 ?
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 ?
Reply by ●August 19, 20092009-08-19
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
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
Reply by ●August 19, 20092009-08-19
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 ?
Marco
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 ?
Marco
Reply by ●August 19, 20092009-08-19
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 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
Reply by ●August 19, 20092009-08-19
CrossWorks is now a supported compiler for the uEZ software project that
FDI/NXP have going:
http://sourceforge.net/projects/uez/
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
directory.
-- Paul.
FDI/NXP have going:
http://sourceforge.net/projects/uez/
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
directory.
-- Paul.