Hi Walt, et al.
"It's quite possible to use MySQL as a backend database for web hosting and
get good performance and decent reliability. I haven't heard of Access being
used for that sort of thing."
Actually Access is used quite widely as a backend database for web servers.
The usual set-up for an NT web server is to have IIS (web server agent),
that accesses either a SQLServer or Access database via asp pages. We use an
Access database at the backend of our cool-tools.co.uk site.
"Just wondering why do you think MySQL is closer to Access than to Oracle. I
have played with MySQL a
little and it is a relational database like Oracle (not sure if access is
one), uses a SQL, can have
logging and archiving just like Oracle. Again I'm not sure whether access
have all this."
Actually, whoever it was that said this (I forget) is right, MySQL is more
like Access (or maybe the older versions of SQLServer (read 7)), than it is
to Oracle. Access is a relational database just like the rest, it's just
that it's more of a "desktop" or workgroup level database than an enterprise
level database. It handles table relationships etc. just the same however,
and is also SQL based via the back end.
I just wrote an entire application for an "introductions agency" (dating
agency ;P) that runs entirely on an access database as a "side job" for a
friend of my fathers.. It's SQLServer/Oracle's "little brother" by all
accounts, only it includes things such as forms designing etc. as part of
the package..
Damn I'm starting to sound like a Micro$lop sales man now!! But I have to
say, for what I needed to do - it was great!
HTH
Mark
===================================================
Mark Leith | T: +44 (0)1905 330 281
Sales & Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
===================================================
http://www.cool-tools.co.uk
Maximising throughput & performance
-----Original Message-----
Walt
Sent: 17 April 2002 18:45
To: Multiple recipients of list ORACLE-L
Well, MySQL and Oracle are very different, but there's a world of difference
between MySQL and Access too. It's quite possible to use MySQL as a backend
database for web hosting and get good performance and decent reliability. I
haven't heard of Access being used for that sort of thing.
--Walt Weaver
Bozeman, Montana
-----Original Message-----
Sent: Wednesday, April 17, 2002 11:03 AM
To: Multiple recipients of list ORACLE-L
Check google. Anyway they are completely different. MySQL is more like
Access than Oracle.
On Wed, 17 Apr 2002, Nguyen, David M wrote:
> What is different between MySQL and Oracle database? Someone says they
are
> the same as they are just database. From DBA or developer point of view,
> what do you say?
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alex
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Weaver, Walt
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
