[REBOL] Re: mySQL - what table type to use?
From: rgaither:triad:rr at: 6-Aug-2003 17:56
Hi Gabriele,
> RG> are using a db without transaction support you need to design it
> RG> differently to get reasonable reliability.
>
> Yes, of course, but it depends on what your DB is modeling.
> Roll-back is important if aborting between queries would leave the
> DB in an inconsistent state. Transactions are important if your
> queries require proper serialization. You usually need these
> features (by "need" I mean "can't live without") only for rather
> complex databases. In simpler cases (as DBs used for web sites
> usually are) you can easily (as you say) just write your software
> differently.
I agree. I just wanted to be sure the point about different design
and programming was mentioned, depending on the choice. If
you don't do this for either type of database you can find yourself
in trouble.
Thanks, Rod.
Rod Gaither
[rgaither--triad--rr--com]
Oak Ridge, NC USA
