0

Is it possible to use Mysql as SQLlite, Firebird (single databse file) for a local application without installing the server?

I need a database to store the data of my application.thanks

Dail
  • 4,622
  • 16
  • 74
  • 109
  • Unless your application is open sourced under GPL, embedding it inside your app can be a problem if you don't buy commercial license from Oracle. If you would like to pay for that, why not consult Oracle pre-sale directly on your questions :) – Lex Li Jun 10 '12 at 11:38
  • BTW, Firebird does have good records on large databases, http://www.firebirdsql.org/en/case-studies/ so I am not sure why you cannot use it (its license is less restricted than GPL for MySQL). – Lex Li Jun 10 '12 at 11:42

1 Answers1

1

It seems there is an option for you: libmysqld.

The embedded MySQL server library makes it possible to run a full-featured MySQL server inside a client application.

It is written in C/C++, so you should be able to use it in your C# application.

By the way: why not to use SQLite of Firebird? They seems to suit better your requirement.

Luca Fagioli
  • 12,722
  • 5
  • 59
  • 57
  • thanks! As far as I know, SQLite is not good for big databases, and i never used Firebird – Dail Jun 10 '12 at 11:00
  • I have used SQLite in a desktop application with, among the others, a table of 10000 rows. It is not *that* much, but it handles it without any issues, and the application is actually in stressing production since almost 2 years now. – Luca Fagioli Jun 10 '12 at 15:19
  • If the answer satisfies your question, could you flag it as accepted? – Luca Fagioli Jun 16 '12 at 12:13