0

I am writing an application in C#.NET. I need to use a SQL compliant single file db like sqlite. I can't use sqlite because it is extremely odd way of storing dates in UTC instead of localtime. Also its support for date operations relies on Julianized date format which is not easy for end-user to grasp at all.

I wish I could use MS-Access, but I guess the end user will have to have MS-Access on their machine to run the application, which is not something I can ask them for.

It is important for me to have near zero install experience.

I took a look at H2 but I am not sure how easy it is to run with .NET and I did not see any browser for it.

The database is expected to be used by 5 users at most for read and 1 user for write at any given time. The largest volume may not exceed 100000 rows in 5 tables.

I would like the solution to be royalty free, even if the product itself is not free.

Thank you.

  • 1
    "I can't use sqlite because it is extremely odd way of storing dates in UTC instead of localtime" == "I ***won't*** use sqlite because it is extremely odd way of storing dates in UTC instead of localtime". You can use it, just don't want to. "Julianized date format which is not easy for end-user to grasp at all" which is why your GUI translates it for them. – Mawg Oct 9 at 11:43
  • 1
    @Mawg, Thanks for your comment. I can't use it because I find it very hard to use. Which GUI tool automatically does the translation? In my application, I want users to use simple SELECT statements. I need to spend time and effort to take care of the translation. – NoChance Oct 9 at 12:10
  • @a_horse_with_no_name, thank you for your suggestion, I will give it a try. If you like you could post this as an answer. – NoChance Oct 9 at 12:11
1

You can give Firebird a try.

It is a very capable relational database, that can be used in embedded mode ("single file"). It's the embedded DBMS used by the newer versions of LibreOffice.

It can also be used as a central database server installation in case youneed that later.

It offers much better data type handling than SQLite (which essentially doesn't have anything else than string) - including a proper timestamp (although without time zone support)

  • Great, thank you much :) – NoChance Oct 9 at 18:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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