Looking for a cross platform small footprint database [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 8 years ago.

Improve this question

I have the following scenario. I need a db to store XML messages that开发者_C百科 have been created by a reader. I then want to use a transport (wcf) to read the db external to the populating app and send the messages to a central db Generally the db needs to run on mono, and windows.

I did look at sqlite3, and it seemed to fit all my requirements, but i'm reading its not so good on multi process access and t's moving away from my sweet spot, these last couple of days.

Thanks.

---

Have you considered just using XML to store the data? It doesn't get any more portable than that and will work fine as long your client-side storage needs are simple. E.g. not a large amount of many domain objects that need to be stored.

Additionally using an XML data store solves a lot of setup and installation headaches. You simply reference a file (or files) relative to your executable. You don't need to worry about installing db engines for a variety of platforms and then worry about upgrading.

---

WOuld it be feasible to give each process their own sqlite3 database? They all ultimately use the central database anyway, right?

---

Have a look at Firebird.

You can use it as an embedded engine just like SQLite, but it can scale to a full blown server as well.

The only drawback is, that the documentation is a mess