I am looking for a free/opensource relational database to use on a commercial asp.net 3.5 project. Any recommendations?
This comparison is quite old (2005) and asp.net 3.5 was not ready at this moment. Derby and One$DB are probably very good database for java world but I don't find support for latest dotnet framework.MySQL is not free for commercial use.
Hugues Van Landeghem
2009-09-16 17:27:19
+4
A:
Depending on the size of the project you might be able to get buy using SQL Express Edition.
JoshBerke
2009-09-15 11:56:33
It being a server based application (ASP.NET) I'd second this option considering the good native support for this.
veggerby
2009-09-15 11:59:09
SQL Express has (commercial) limits on size of Db (4GB) and number of users (iirc, 4). I'm not sure about the license web use.
Henk Holterman
2009-09-15 12:01:45
I believe that SQL express is free to distribute .. see http://www.microsoft.com/sqlserver/2005/en/us/express-redistribute.aspx As long as you can live with the size limitations it could be a good choice
Peter M
2009-09-15 12:10:18
I believe your limited to five concurrent connections. It is also a good option because if the project grows you can easily scale up to a more robust version.
JoshBerke
2009-09-15 12:32:45
@Josh - and the complexity of the licensing of the "more robust" version scares me. There are people dedicated to figuring out what sort of licensing you need to pay for SQL server.
Peter M
2009-09-15 13:35:26
@Peter, Licensing for Sql Server is amazingly simple. You either can go with a CAL license based on the number of users that access the db, or you can pay for a per processor license that you're covered for unlimited users. Microsoft licensing for the most part is entirely straight forward.
Chris Marisic
2009-09-15 13:48:53
Check this out http://www.dotnetspider.com/tutorials/SqlServer-Tutorial-158.aspx It shows the limits of SQL Server Express.
Aaron M
2009-09-15 13:51:17
+2
A:
SQLite is a public domain embeddable database engine that has many options for .NET language binding.
Greg Hewgill
2009-09-15 11:59:48
+4
A:
Firebird - nice, scalable open source database with one of the best freeware .NET integration.
smok1
2009-09-15 12:01:59
Firebird support the latest .net framework http://www.firebirdnews.org/?p=3431
Hugues Van Landeghem
2009-09-15 17:02:55
A blog post about Firebird enbedded and dotnet http://blog.coding.ro/2009/09/embedded-database-for-net/
Hugues Van Landeghem
2009-09-18 17:15:35
A:
If you are using .NET I would go for a MS engine. SQL Express is garanteed to work good with .NET Now dependes on the size of your poject and the load the engine will be handling.-
Hope this helps.-
MRFerocius
2009-09-15 12:02:42
+2
A:
C#-SQLite is a complete rewrite of SQLite (mentioned by Greg Hewgill) in C#. The Highlight: It's 100% managed .NET code.
The Chairman
2009-09-15 12:13:25
+1
A:
PostgreSQL is licensed under a BSD license, which makes it an obvious choice if your product is commercial. That, and it's a very good database management system.
SQLite also has a friendly licesnse, but it is very different from a traditional SQL DBMS.
Jeff Davis
2009-09-17 06:55:03