how to develop embedded database system by using stm32

[Senthil Karalasingam]

Posted on May 10, 2018 at 11:51

How to design Embedded database system by using stm32 ?

[T J]

Posted on May 10, 2018 at 13:21

A database is only a table.

the question is only about saving the file at every adjustment.

Where will you save the file ?

[henry.dick]

Posted on May 10, 2018 at 14:15

The answer ranges from easy to I.possible, depending on your definition of 'database'.

[Senthil Karalasingam]

Posted on May 11, 2018 at 17:33

Well. I want to save data in SD card with embedded database such as sqllite.

Thank you.

[Senthil Karalasingam]

Posted on May 11, 2018 at 17:34

Is it possible to save with sqllite or mysql embedded database

[T J]

Posted on May 12, 2018 at 00:01

SqlLite is not so light that it will fit in a uController. maybe you could find an OpenSql.

you would have to disassemble the file structure an mimic the SqlLite functionality.

Extremely difficult.

A Database is a record based Table.

Every entry is the same length.

ie

char Name[24];

char Address[128]

char Phone[12];

then append your new record to the end of the file.

[Senthil Karalasingam]

Posted on May 12, 2018 at 03:17

Well said. Could you give some example to develop embedded database with stm32 microcontroller by opensql.

[T J]

Posted on May 12, 2018 at 06:29

I cant do your work, did you look for an open SQL ?

how many elements in your database ?

How many entries ?

How much RAM do you have ?

How can you sort the table, if you don't have enough RAM ?

You have issues with such a small RAM footprint.

in my server code, I created a 6MByte scratch area to sort tables.

[henry.dick]

Posted on May 12, 2018 at 17:22

Yes and no, depending on your ability to port.

a few simple ways:

1) port your database of choice to stm32;

2) port your operating system of choice (Windows, unix or linux, etc.) to stm32 and run your database from inside.

whether ***you*** can get any of that done is entirely up to your skills and dedication.