Jason Bodnar wrote:
>
> On 13-Apr-99 Samy Elashmawy wrote:
> >
> >
> > Hi folks ,
> >
> > I would like to set up an sql server on linux for the widows apps to acess .
> >
> > 1/ can this be done ?
>
> Yes
>
> > 2/ I am looking at 2 to 3 users with a max of 5 users. two or three apps.
>
> No problem.
>
> > 3/ I want to keep it simple and basic nothing fancy.
>
> The way it should be done.
>
> > 4/ I will nees jdbc support as I am looking to move to java
>
> No problem.
>
> > 5/ how hard / easw is it to set up the server ?
>
> Very easy.
>
> > 6/ how hard / easy ios it to get the windows apps to see the server ?
>
> Easy.
>
> > Do you just need to set up the driver . or give the ipaddress ???
>
> Set up the ODBC driver.
>
> > any pitfalls in what I want to do ??
>
> Not really.
>
> > Thanks
>
> Your welcome.
>
> Oh, I guess you probably want a database recommendation.
>
> http://www.mysql.com
>
I would suggest PostgreSQL because of what mysql lacks. MySQL is only
about 10% faster than PostgreSQL but the latter is more compliant to
ANSI SQL92 standards. PostgreSQL offers classes, inheritance, types,
functions, contraints, triggers, rules and transaction integrity. The
last feature is one that MySQL will never have. PostgreSQL comes with
pgaccess, a tcl application also available for windows that looks and
runs similar to MSAccess, but not as extensive is MSAccess. PostgreSQL
is free (you can purchase support), MySQL costs if you are selling it or
selling a product which includes it (or you run it on Win95 or NT),
although the client code is GPL. MySQL won't do sub-selects, selects
into tables, transactions, triggers, foreign keys (but you get a
philosophical reason why you should not use foreign keys) and views.
"GROUP BY" on text fields only work if they are fixed length. ALTER
TABLE is used for creating and dropping indicies. GRANT is sldo
non-functional, MySQL has it's own non-standard security features. I
used MySQL and liked it. I found PostgreSQL more similar to the
commerical SQL engines I have used and found MySQL more limiting. I
switched from MySQL to PostgreSQL and am glad I did. I am looking
forward to version 6.5: http://postgresql.nextpath.com/ which will
feature multi-version concurency control, a locking scheme which allows
reading of locked rows without access errors.
--
JLK
Linux, because it's STABLE, the source code is included, the price is
right.
--
To get out of this list, please send email to [EMAIL PROTECTED] with
this text in its body: unsubscribe suse-linux-e
Check out the SuSE-FAQ at http://www.suse.com/Support/Doku/FAQ/ and the
archive at http://www.suse.com/Mailinglists/suse-linux-e/index.html
