Re: Getting started with Postgres or MySQL

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 02/01/07 07:31, Max Hyre wrote:
Roberto C. Sanchez wrote:
On Wed, Jan 31, 2007 at 02:54:01PM -0900, Joshua J. Kugler wrote:
In that same document, they give the reason for doing so:
"The reason for using the preceding rules in non-strict
mode is that we can't check these conditions until the
statement has begun executing. We can't just roll back if
we encounter a problem after updating a few rows, because
the storage engine may not support rollback. The option
of terminating the statement is not that good; in this
case, the update would be ???half done,??? which is
probably the worst possible scenario. In this case, it's
better to ???do the best you can??? and then continue as
if nothing happened."


I'm sorry, but "our database can't always handle
transactions" is not a valid excuse for allowing bogus
data.

Does this mean that Mysql isn't really a DB, but is in fact just a
front-end, translating SQL statements into commands to the real DB?

MySQL with the MyISAM data store is *exactly* what you describe.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFwkKmS9HxQb37XmcRAgVHAKDBgwiyVWcCSl7jtMmQOSwJm/atnQCffXyS
4dkRg5saUcZFFEddkHGhfNw=
=EwZz
-----END PGP SIGNATURE-----


--
To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx
with a subject of "unsubscribe". Trouble? Contact listmaster@xxxxxxxxxxxxxxxx

Relevant Pages

  • Re: lost mysql root password
    ... On Friday 03 March 2006 02:20 pm, Matt Price wrote: ... Now I'm back to configuring some programs that use mysql, ... | hash 1 ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: [PHP] php cli and mysql
    ... James Tu wrote: ... Why is the CLI looking for it at /var/myslq/mysql.sock? ... Do I change the mysql settings so that mysql.sock is at ... To unsubscribe, visit: http://www.php.net/unsub.php ...
    (php.general)
  • RE: File not found error
    ... after downloading, issuing a mv or rm command does not ... error: File not found by glob: MySql* ... Check out the new Yahoo! ... unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe ...
    (RedHat)
  • Re: SQL Questions (MySQL or PostgreSQL?)
    ... just rounds up what anyone would tell about it. ... >> i would like to suggest PostgreSQL if your objective is learning SQL. ... > What is the difference between PostgreSQL and MySQL? ... To unsubscribe, ...
    (freebsd-questions)