I was wondering which of these would be best suited for the needs of my application.The application would be distributed on multiple pc and share a common database. This database could contains up to about 20 000 entries. Basically it is simply a meeting manager and each entry in the DB would represent a meeting.For instance, I might want to show every meeting involving a certain person or every meeting with a certain object. That's not really important at this point since this is only the Data representation I might want to make.The fact is I have certain limitations :
I'm doing the application in C#
I can't install anything on the users' pc (I must only copy the .exe + dll if needed)
The Database will be locate on a network storage and might beaccessed by up to ~10 pc at the same time
I have never used SQL CE nor SQLite (nor any other DB in fact)
My first idea was to use a pure XML Database since it's pretty straightforward with .NET class serializer. In order to modify the Database, a user should have to acquire write access on the file. Meanwhile, every other users would be in read-only. At any moment they could know who owns the write access through a file created upon getting this access. Each application in read mode would also have a running process monitoring the XML file in order to notify its user if any change were made to the DataBase, letting the user the ability to reload it.Having heard a little of SQLite and SQL CE, I'm not quite sure I have the right approach in term of scalability and performance. I don't mind learning how to use them. My main concern is mainly the fact that I really can't install anything on the users pc and I want to make the deployment of the application as simple as possible for the users (ideally, copy/paste the application folder).So here are the questions:[*]What advantage would there be in using SQLite or SQL CE in my situation ? [*]SQLite or SQL CE (In term of ease of use, learning, performance, C# compatibility, data safety, etc)Note: I haven't started the development yet, so I'm completely free to choose any solutionSimilar Question:Xml or Sqlite, When to drop Xml for a Database?
