Which databases are recommended to be used as embedded databases?

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.

A list can be found on Wikipedia. I think the overwhelming leader in embedded sql databases is sqlite. Found everywhere!

StackExchange Database Administrators Q#201, answer score: 10