[oclug] LAMP vs MS Solutions for Small Business

[Adrian Irving-Beer]

On Wed, Feb 16, 2005 at 04:30:26PM -0500, Howard Krakower wrote:

> My gut feel is that you likely need something using PHP & SQL
> (preferably mySQL).

FYI, I personally prefer PostgreSQL (www.postgresql.org).

Though I haven't seen any recent comparisons, in the past, MySQL has
been better for simple-SELECT-query sites, while its simplicity made
it slower at more complex queries, and its overbearing data locking
system (among other things) made it *much* slower at inserting or
updating data.  It's also traditionally had fewer features than other
RDBMSes (typically shunning those as unnecessary cruft).

On the other hand, SELECT queries (usually fairly simple) are the very
core of many write-once read-many sites.  And MySQL has since added
critical features it once shunned, like transactions and foreign key
relations.  Conversely, databases like PostgreSQL are more scalable,
if a bit slower -- but even there, they're catching up.

Other than that, I don't really know where they stand in relation to
each other today.  Certainly PostgreSQL is much closer to the SQL
standard, which I find handy.

Just something to consider.  In a POS situation where reliability and
updatability are high concerns, it might be best to shop around.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://tux.oclug.on.ca/pipermail/oclug/attachments/20050216/624ec7f5/attachment.bin