I would like to know if it is possible to store a (little, basic) SqlLite DataBase (or of any other type) into the (old) ESP32.
I don't want to use an SD card for that (for which I already know it is possible).
Thanks in advance for any hint on this
-
Sure, you can store it. You can store anything you like, size permitting, it's just a file after all. But I assume you actually want to use it from the ESP32 too?– MajenkoDec 29, 2020 at 11:18
-
@Majenko sure! ;-) i would load data "once" on programming the ESP32, and then "just" read it to take decissions and drive the program on different settings.– Paul EffordDec 29, 2020 at 11:32
-
Then a database file is probably overkill. You could just use a simple text file for that.– MajenkoDec 29, 2020 at 11:33
-
@Majenko thanks!– Paul EffordDec 29, 2020 at 11:38
Add a comment
|
2 Answers
I found these two post to be a useful answer to my question:
-
2It could be really educating and clarifying if the downvoter would shine to explain why he downvoted... downvoting without an explanation may be considered impolite and unsmart... Dec 29, 2020 at 13:39
-
Possibly because it mostly consists of links. You can always add more details on how they helped. Broadly you can make the answer more useful to future readers.– timemageDec 30, 2020 at 19:14
Yes you can - or you can certainly store it. ESP32 can use its flash as a filesystem (SPIFFS, LittleFS, FAT, etc) so you can store whatever data you like on there.
Whether the SQLite library can work with that file is another matter though, and is something you would have to explore yourself.
However for your use case using a database file is a bit silly. If all you want is some pre-defined runtime settings then all you really need is a simple text file. Maybe something like an INI file (key=value pairs) would be plenty for your needs, and pretty simple to parse without any libraries.
