Forums

Simple DB and lpc2000

Started by Micron Engineering February 12, 2008
Hi all,
may be a little OT but I need to know if someone knows a DB engine like
SQLite (single file db like "MS Access") that supports foreign keys
(SQLite don't support FK). The DB engine would be embeddable, I will use
a LPC2478 with ucLinux.

An Engineer's Guide to the LPC2100 Series

Micron Engineering wrote:
>
> Hi all,
> may be a little OT but I need to know if someone knows a DB engine like
> SQLite (single file db like "MS Access") that supports foreign keys
> (SQLite don't support FK). The DB engine would be embeddable, I will use
> a LPC2478 with ucLinux.
>

Not for nothing, but, why did Philips bother to cram all that I/O into a
chip that has no MMU? IMO, it is pretty much worthless as anything but
for building toys.

Memory fragmentation is a huge issue with uClinux and remains the
monster lurking in the closet for those who need long uptimes for their
product design. IMO, uClinux is more of a curiosity than something that
would be designed into a mission critical system.

I am designing a new product which will support an SQL server which will
be accessible via an IP network. That system will run on a Samsung
S3C2410 processor (which has an MMU). By choosing a processor with an
MMU, you do lose that ridiculously high degree of peripheral integration
of the LPC2478, but, I have MySQL and PostgreSQL running on the system
now. Along with 64Meg of SDRAM.

I still have an LCD controller, several SPI ports, several UARTs,
battery powered clock, and A/D inputs. It doesn't have the ethernet
MAC, but a LAN9196 is not that difficult to add (or several in my
case). The big (huge?) advantage is that it will run a mainstream Linux
kernel and not some crippled version.

Maybe you need to rethink your choice of a processor platform? Just my
2 cents worth...

Regards,

TomW
Tom Walsh ha scritto:
>
> Micron Engineering wrote:
> >
> > Hi all, may be a little OT but I need to know if someone knows a DB
> > engine like SQLite (single file db like "MS Access") that supports
> > foreign keys (SQLite don't support FK). The DB engine would be
> > embeddable, I will use a LPC2478 with ucLinux.
> > Not for nothing, but, why did Philips bother to cram all that I/O
> into a chip that has no MMU? IMO, it is pretty much worthless as
> anything but for building toys.

Yes, it is correct... but I can't choose the hw, the customer has the hw
ready and ask only to have the firmware so I have to live with that.
>