TCLUG Archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [TCLUG:13347] DB Wars
even tho you say it's narrowed down, have you considered postgres?
it's fairly quick and also supports transactions.
Thank You,
Ben Kochie (ben@nerp.net)
*-----------------------* [ - * - * - * - * - * - * - * - ]
| Unix/Linux Consulting | [ Haiku Error Message: ]
| PC/Mac Repair | [ Chaos reigns within. ]
| Networking | [ Reflect, repent, and reboot. ]
| http://nerp.net | [ Order shall return. ]
*-----------------------* [ - * - * - * - * - * - * - * - ]
"Unix is user friendly, Its just picky about its friends."
On Thu, 3 Feb 2000, Shawn T . Amundson wrote:
> On Thu, Feb 03, 2000 at 06:40:34PM -0600, Scott wrote:
> > I'm presented with a choice of db's to do the backend
> > of OpenBoxen's site in, and I'm interested in some opinions.
> > It's been narrowed down to either MySQL or Sybase, and MySQL
> > is the one I'm more familiar with. Does anyone have
> > anything to say about Sybase however which would suggest it
> > to be the better option?
> > My current design has two db's, one for customer
> > account information and the other containing parts for the
> > machine. The customer db will probably have three tables,
> > the parts db will have 20+. Most of what I figure will be
> > done is select and insert, with a few updates and alters
> > possibly thrown in. What I'm most interested in is
> > performance of Sybase vs. MySQL and features Sybase might
> > have that could prove useful.
> >
> > Scott
>
> MySQL is pretty damn cool. It all comes down to transaction
> support. I wouldn't worry too much about the subselects -
> it can be annoying, but it's not too critical. Another thing
> MySQL lacks is stored procedures.
>
> If you are using Java or Perl, it's easy to switch to something
> else in the future. Transitioning you code to using the new
> features will be a pain, but you don't have to rewrite everything
> if you don't want or need to.
>
> I'm currently using MySQL pretty heavily with JDBC (in Apache
> JServ on Solaris) and it performs exceptionally well, especially
> after I figured out how to do connection pooling properly.
>
> -Shawn
>
> --
> Shawn T. Amundson amundson@eventloop.com
> Research and Development http://www.eventloop.com/
> EventLoop, Inc. http://www.snorfle.net/
>
> "The assumption that the universe looks the same in every
> direction is clearly not true in reality." - Stephen Hawking
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tclug-list-unsubscribe@mn-linux.org
> For additional commands, e-mail: tclug-list-help@mn-linux.org
>