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?
    – Majenko
    Dec 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. Dec 29, 2020 at 11:32
  • Then a database file is probably overkill. You could just use a simple text file for that.
    – Majenko
    Dec 29, 2020 at 11:33
  • @Majenko thanks! Dec 29, 2020 at 11:38

2 Answers 2


I found these two post to be a useful answer to my question:

  • 2
    It 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.
    – timemage
    Dec 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.