Which databases are recommended to be used as embedded databases to store data within an application? The embedded database may or may not synchronize back to a larger system database.
locked by Paul White♦ Dec 2 '16 at 17:22
This question exists because it has historical significance, but it is not considered a good, on-topic question for this site so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. See the help center for guidance on writing a good question.
Read more about locked posts here.
A list can be found on Wikipedia. I think the overwhelming leader in embedded sql databases is sqlite. Found everywhere!
SQLite is probably the most commonly used one. It is light weight and has an open license. SQLite is being used by many embedded systems including Apple's iPod/iPhone/iTouch line of mobile devices, Google's Android phones, and Airbus aircraft.
Given this I would probably recommend its use, but I will say that I myself have not used it for an embedded system.
At my previous employer, we sold applications with SQL Server Compact as the embedded database. It has some quirks, but it works reasonably well.