Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re^2: Returning to Perl, seeking advice on modern DB and format tools

by erix (Prior)
on Dec 22, 2013 at 13:20 UTC ( [id://1068096]=note: print w/replies, xml ) Need Help??


in reply to Re: Returning to Perl, seeking advice on modern DB and format tools
in thread Returning to Perl, seeking advice on modern DB and format tools

Although your reply is not really a recommendation (fortunately), I cannot resist to place this comparison here. FWIW.

Look at the "Specifications" (=features) for each of the systems.

That lack of features is probably accurate. MariaDB is a young (2007 ?), under-duresse derivative of an already problematically weak system (MySQL), and consequently derives its following mainly from the ranks of the mysql-encumbered (such as, apparently, SlackWare).

Greenfield projects can/should do better.

update: fixed link.

Replies are listed 'Best First'.
Re^3: Returning to Perl, seeking advice on modern DB and format tools
by Shuraski (Scribe) on Dec 22, 2013 at 19:14 UTC

    The Greenfield projects link doesn't go anywhere useful except a wikipedia search page.

Re^3: Returning to Perl, seeking advice on modern DB and format tools
by mbethke (Hermit) on Dec 23, 2013 at 17:05 UTC
    Although your reply is not really a recommendation (fortunately), I cannot resist to place this comparison here. FWIW.
    Sorry, but that's a crock of shit. MariaDB can only not run unprivileged? PostgreSQL is not open source? MariaDB supports ACID but no referential integrity? If one system supports one datatype that is equivalent to a dozen types of the other's, that counts as negative? I suppose this is auto-generated by a necessarily shoddy parser from marketing blurb and nobody with an ounce of a clue has even glanced at it.

      I'm not sufficiently interested in such lists to look up all details, but I did look up that "running as root", and it does seem possible (maybe even usual/normal, who knows) to run MariaDB as root. Postgres will simply refuse, period. That's a Pg-plus, I would say.

      I don't see that that list claims that postgresql is not opensource. Which is good, because if anything, it's more open (the "PostgreSQL Licence" is practically the same as FreeBSD/MIT licenses). That's a Pg-plus, I would say.

      Referential Integrity is a painful subject in mysql-land. Maybe it has improved. I'm sceptical.

      But it is all really beside the point. The point is that a relatively new system (derived from a somewhat inferior system) is not going to catch up with postgres with its long-term focus on stability, reliability, and standard compliance (to name a few) any time soon, IMHO.

        Part of the Unix philosophy is "trust the user". So for the tiny minority that uses a DBMS without some kind of distribution-supplied init script that usually handles the privilege dropping, I don't see why running as root should be forbidden. In any case though that's a very minor point and can hardly count the same as ACID support with which, for many people, database systems stand and fall.

        You have to click "see more" under "Features" to see that PostgreSQL is supposedly not OSS. There you can also learn similar wisdom such as that Mariadb can neither import nor export data, Postgres has no "Internet Protocol Support" and MariaDB has multithreading but no parallel processing while for Postgres it's the opposite.

        I completely agree with the general conclusion that Postgres is a superior system for many applications, it's just that this list is a collection of bullshit that just happens to come to the same result. It could easily reach the opposite conclusion given how many errors and apples-vs.-oranges it contains.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1068096]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others about the Monastery: (5)
As of 2024-03-29 01:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found