Mono C# and MySQL? Firebird? Postgres?

kiketom · 03-20-2007, 09:59 AM

Hi!
I want to make a CRM with Mono, but i don't know which database is better for this purpose.

Can you help me?
Thx.

Crito · 03-21-2007, 05:25 AM

Another Coke or Pepsi question. Well, opinions vary, but here are my thoughts.

MySQL is ubiqutous at this point, but it also uses non-standard SQL syntax and is difficlult to migrate away from.

Firebird is a surprisingly adept DBMS, but the developer themselves don't recommend it for large systems, as CRM apps usually become.

PostgreSQL is probably the BEST object oriented database available at any price. Unfortunately it's a lousy relational database.

So I, personally, would look at commercial DBMSes for a CRM app. Being vehemently anti-Oracle, that pretty much leaves me with one choice: Sybase ASE
http://www.sybase.com/linuxpromo

And FWIW, there's already a good open-source CRM package out there:
http://www.sugarcrm.com/crm/download/sugar-suite.html

graemef · 03-21-2007, 08:59 AM

I'm not certain if mono has a database abstraction layer, but if it does you could use that to defer the decision to the users.

graemef · 03-21-2007, 09:03 AM

Quote:

Originally Posted by Crito

PostgreSQL is probably the BEST object oriented database available at any price. Unfortunately it's a lousy relational database.

I wouldn't call PostgreSQL an OODB, it's a Relational DB with some object support.
Neither would I call it a lousy RDB, I have found it yo be a good Relational DB.

Crito · 03-21-2007, 09:18 AM

Quote:

Originally Posted by graemef

I wouldn't call PostgreSQL an OODB, it's a Relational DB with some object support.
Neither would I call it a lousy RDB, I have found it yo be a good Relational DB.

The PostgreSQL developers themselves call it an ORDBMS (object-relational database management system.) My comment about its relational abilities was specifically about performance. It's a lot closer to the ANSI SQL standard than MySQL. It's also a lot slower at relational database operations than MySQL. What sets it appart from the others is its OO features, IMVHO.

graemef · 03-21-2007, 09:54 AM

First yes it is an object relational database, but an Object Oriented database is a quite different beast.

The performance issue is a very cloudy one. In a very simplistic scenario MySQL is faster than PostGreSQL with few concurrent users but PostGreSQL scales better than MySQL, so as the number of concurrent users increases PostGreSQL gets better than MySQL. It is also suggested that PostGreSQL runs better on multiple core processors.

Finally it doesn't matter how good the DB is, a lousy design will give you lousy performance

kiketom · 03-22-2007, 03:10 AM

I'm looking for the MySQL provider here:
Mono MySQL.
And i read this:
Please download and use the 1.0.7 release of MySQL Connector/Net which works on Mono on Windows and Linux.
But, i can't find this provider version :?