Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re^2: Image Hosting Application

by Your Mother (Chancellor)
on Jul 21, 2004 at 08:17 UTC ( #376179=note: print w/ replies, xml ) Need Help??


in reply to •Re: Image Hosting Application
in thread Image Hosting Application

(hint: PostgreSQL or Oracle, but probably not MySQL).

I think MySQL has supported transactions (and foreign keys and such) for quite a long time now. From its manual: MySQL Server (version 3.23-max and all versions 4.0 and above) supports transactions with the InnoDB and BDB transactional storage engines. InnoDB provides full ACID compliance.


Comment on Re^2: Image Hosting Application
Replies are listed 'Best First'.
•Re^3: Image Hosting Application
by merlyn (Sage) on Jul 21, 2004 at 15:31 UTC
    Yes, but from what I understand, when you start using InnoDB, you sacrifice the only advantage MySQL has, which is speed and reliability for non-transactional database accesses. So if you want a fast, reliable transactional database, even MySQL with InnoDB doesn't cut it. Hence, my recommendation for PostgreSQL or Oracle, depending on your budget.

    -- Randal L. Schwartz, Perl hacker
    Be sure to read my standard disclaimer if this is a reply.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (8)
As of 2015-07-31 05:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (274 votes), past polls