How to design embedded database?

[7rots51]

sqlite-source-2_8_16.zip

Hi

How can I develop an embedded database?

please talk on hardware ,software implementation,algorithms.
(simple embedded database for 8051 family and ARM7)

bye

 

[techie]

sqlite mcu

depends on exactly what are you expecting out of the database.

1. Data storage can be obtained by using any standard means. Flash chips, flash media cards, IDE hard disk have all been interfaced with 8051 with many examples avialable on the internet

2. FAT file storage expamples are also there.

3. Record storage can be implemented using C structures and arrays of structures.

4. Searching / addition / deletion etc of records can be implemented in C in a fairly simple manner

 

[year]

flash database

File system need lots of memory and CPU perfomance. Then I would not recoommend 8 bit CPU.
At least 16bit will be....

 

[7rots51]

HI

1.What ICs or cards can store a large amount of data(nonvolatile)?
I need it for industerial application and must be reliable at performance.
large amount ~ 1GB

2.What is your idea about atmel AT45 series(dataflash)?

3 .Do you have a good c code on search,add,delete a record?

4: there are some commercial file system libs like as uco*s FS ,K*dak.
Is tehy suitable for 8 bit MCU ?

bye

 

[fireplus]

Re: embedded database?

Dear 7rots51,
how are you ?
long time since i here from you
i hope this be useful for you :

[SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine]

[This ZIP archive contains pure C source code for the SQLite library. Unlike the tarballs below, all of the preprocessing and automatic code generation has already been done on these C source code, so they can be processed directly with any ordinary C compiler. This file is provided as a service to MS-Windows users who lack the build support infrastructure of Unix]
https://sqlite.org/
**broken link removed**

bye

Fire in the Wire :idea: