Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm here because I need somme advices about the best DBMS to use in my case. Indeed, I've only studied the theory about the databases. So I don't know a lot about the pratice.

I'm searching after a free DBMS if possible, which provides the following tools :

Trigger/Check Procedure View

The database must be adapted to be installed on a hard disk locally. This database will be used by C# applications at first time and so with .NET

Which is the easiest to use according to my case ?

Thank you for any help.

share|improve this question

closed as off-topic by Mark Storey-Smith, Paul White, billinkc, RolandoMySQLDBA, Max Vernon Aug 28 '13 at 19:49

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Mark Storey-Smith, Paul White, billinkc, RolandoMySQLDBA, Max Vernon
If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers 2

up vote 1 down vote accepted

The well known players in the database market have cost free editions (usually called Express Edition) of their products available, e.g. Oracle Database Express Edition, SQL Server Express Edition, DB2 Express-C and probably more. They are usually limited on CPU usage, RAM usage and data volume, but provide the features you need just like their costly companions.

However, when it is coming to the handling (installation, maintenance, backup&restore) they are "real DMBS" as well and not necessary end user friendly all the time.

For a broad deployment (e.g. all desktops of a company) there is the concept of "embedded databases" like SQL Server Compact Edition, which gets linked to the application, is not even a seperate process and aims to be free of maintenance.

Unfortunately the feature set of the Compact Edition is too limited for your requirements I think. A quick overview on the features and differences can be found here

share|improve this answer

I think you have two that I would recommend:

The first is PostgreSQL, which runs on your local computer as a database server. It has an impressive feature set and allows stored procedures to be written in a number of languages (including PL/PGSQL, PL/Perl, and PL/Python). It is free and it is enterprise-grade. PostgreSQL ideas have made their way into Informix and elsewhere.

The second is Firebird which is the open sourced version of Interbase. It contains triggers, stored procedures, and more, and is free. The feature set is not as large as it is with PostgreSQL in terms of programmability, but it has the additional feature of being able to be run as an embedded library in the process of your application. PostgreSQL also has a larger community.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.
{"cc_re__cc_re__cc_by_sa_3_0": ["        <li><a href=\"http://area51.stackexchange.com\" title=\"proposing new sites in the Stack Exchange network\">Area 51</a></li>\r\n                        <li><a href=\"http://careers.stackoverflow.com\">Stack Overflow Careers</a></li>\r\n                    \r\n                </ol>\r\n            </td>\r\n    </tr>\r\n</table>\r\n                </div>\r\n            </div>\r\n\r\n            <div id=\"copyright\">\r\n                site design / logo &#169; 2014 stack exchange inc; user contributions licensed under <a href=\"http://creativecommons.org/licenses/by-sa/3.0/\" rel=\"license\">cc by-sa 3.0</a> \r\n                with <a href=\"http://blog.stackoverflow.com/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"svnrev\">\r\n                rev 2014.9.2.1810\r\n            </div>\r\n            \r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">Database Administrators Stack Exchange works best with JavaScript enabled<img src=\"http://pixel.quantserve.com/pixel/p-c1rF4kxgLUzNc.gif\" alt=\"\" class="], "copyright__copyright__copyright": ["e.\n\nThe second is Firebird which is the open sourced version of Interbase. It contains triggers, stored procedures, and more, and is free. The feature set is not as large as it is with PostgreSQL in terms of programmability, but it has the additional feature of being able to be run as an embedded library in the process of your application. PostgreSQL also has a larger community.\n\nshare|improve this answer\n\nNot the answer you're looking for? Browse other questions tagged or ask your own question."]}