Databases - WAS Re: acronym LAMP
redhowlingwolves at nc.rr.com
Mon Jun 22 08:53:21 UTC 2009
-----BEGIN PGP SIGNED MESSAGE-----
Derek Broughton wrote:
> Karl F. Larsen wrote:
>> The MySQL database is used a lot on Web Pages you buy things from. It
>> is the Data Base (DB) of choice for that purpose. You can get MySQL from
>> the Ubuntu repositories.
>> Oracle is a big SQL DB which is very expensive and used by Banks and
>> big business.
> Fairly accurate - except that I question Oracle as being used by "Banks"
> which have a horrible tendency to be monolithic IBM shops (thus, DB2 if they
> want a relational database, otherwise IMS).
> But you missed commenting on Postgres, which is, indeed, a viable
> replacement for Oracle for many users. It probably can't handle the load
> that a big Oracle database can, but it can do pretty well everything Oracle
> can - making it easier to switch databases between the two than between
> either and MySQL. All accounts suggest that as a web back-end, nothing
> beats MySQL.
When it comes to SQL, it depends on what you're good at. Oracle,
PostGre, DB2, MSSQL, MySQL all have their pluses and minuses.
Oracle is supposed to be more secure, DB2 more scalable for large
datacenters and MYSQL is faster.
Apparently, they are _all_ the above, according to their literature.
CLI seems to be the way to go. Definitely shows more knowledge in
working with a database to me.
Fo someone without knowledge of cquill, MYSQL would be the way to go.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
-----END PGP SIGNATURE-----
More information about the ubuntu-users