On Mar 29, 2013, at 08:40 05, James Harrison wrote:

> That said it'd be lovely to see PostgreSQL support in Rivendell, but I
> recall Fred pointing out there was a lot of MySQL specific code in and
> it'd take some doing.

Not much at all actually; and most of it in the routines in RDAdmin that 
configure access permissions when creating a new database.  One could make a 
good argument that that functionality should never have been there in the first 
place, but rather should have been explicitly delegated to the DBA (which is 
how most LAMP applications --e.g. WordPress -- handle it).  It's conceivable 
that it will disappear in a future version of RD.

My rationale for MySQL has always been primarily pragmatic -- it works well, 
has a large community of users that understand it well and offers key high-end 
features --e.g. replication -- that are critical for use in HA environments.  
Above all, it has proven itself to be utterly reliable over 10+ years of use 
with RD -- I can't recall a single instance of data corruption over that time 
that was traceable to bug in it.  I honestly don't know all that much about 
PostgreSQL and the other alternatives because I've never needed to -- MySQL 
'just works'.

Cheers!


|-------------------------------------------------------------------------|
| Frederick F. Gleason, Jr. |               Chief Developer               |
|                           |               Paravel Systems               |
|-------------------------------------------------------------------------|
| But in our enthusiasm, we could not resist a radical overhaul of the    |
| system, in which all of its major weaknesses have been exposed,         |
| analyzed, and replaced with new weaknesses.                             |
|                         -- Bruce Leverett                               |
|                        "Register Allocation in Optimizing Compilers"    |
|-------------------------------------------------------------------------|

_______________________________________________
Rivendell-dev mailing list
[email protected]
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev

Reply via email to