MySQL or Access

[sail3005]

2. Questions, can i use a mysql database from an ASP page, and which is more powerful/better. Access database, or MySQL? I have heard MySQL, but i am not sure.

[Clunietp]

From what I understand, mySQL is a client/server database, as opposed to MS Access, which is a desktop database. MS Access requires no administration and no setup by a sys admin.

Which one is "better"? It depends on your requirements

[sail3005]

But can you use MySQL database from ASP as easily as you can with Access?

-thanks

[Crazy D]

I think so, although personally I'd go for MSDE (free SQL Server) if you need something more powerfull then Access.
MySQL doesn't even have stored procedures, and doesn't support sub-query's (SELECT Blah, (SELECT MAX(blah1) FROM table2) AS Blahblah FROM table) doesn't work in MySQL.
Especially stored procedures can speed up your application a lot.

[sail3005]

Cool, sounds like MSDE would be a good idea. Basically what i need is a free database that works well with ASP. So, anything that meets those two requirements would be good.

[parksie]

MySQL doesn't have stored procedures, but you can do sub-selects in some of the betas, I think.

[Berthil]

I have a local mySQL installation and I use mySQL on my providers server.

Although there are more and more graphical interfaces for creating and maintaining mySQL databases is far more difficult then MSAccess since a command interpreter is used with mySQL instead of the graphical interface of MSAccess.

Queries for mySQL should not use JOIN expressions, it slows it a lot down with larger results, but it's fast if you build queries without JOIN expressions

If you upload the phpAdmin pages to your website and protect them, you can maintenance the database on the server with your browser. I use text file upload to fill databases with data, works easiest for me.

A mySQL database on a local PC can me maintenanced in MSAccess with specific ODBC drivers, but only the data, not the structure. But you can build queries and forms etc. in MSAccess on the mySQL database.

So it took me a while to make test environment at home and to let mySQL work on the server, but I got it now. For work at home MSAccess is best, but for server applications it's best to use mySQL.

http://www.mysql.com has lots of downloads and info.

[sail3005]

OK, thanks, i'll check it out! :D

[Clunietp]

No subqueries or stored procedures? GEEZ!

MSDE is basically a stripped down version of SQL Server. (in fact, when I upgraded from MSDE to SQL Server a while ago, all the update did was change some registry entries!)

[seoptimizer2001]

I have used both MS Access and SQL server. I used to use Access when I was in school. Then when I started my job we used SQL server, which I had to learn, but find it much more user friendly and less frustrating than Access. I would go with the free version of SQL server.

[sail3005]

Where do i get the free version? What version are you talking about? :confused:

[Clunietp]

here you go

http://msdn.microsoft.com/vstudio/msde/default.asp

[adeelahmed]

You can easily use mySQL with ASP it is power full like ORACLE.
it is an RDBMS. it provide more securities and management.


But many web hosting services not provide services to support mySQL with ASP.
they support mySQL with JSP with like Unix or Linux plateform

So if you planning to use database with ASP you should use SQL server.

but if want to install any thing abt mysql for freee
then visit www.mysql.com
and can get information from

www.webmonkey.com

[sail3005]

Cool. Thanks. I host the website off my computer and it is mainly for learning purposes so as long as it will work on my computer that is ok.

[Clunietp]

Originally posted by adeelahmed
You can easily use mySQL with ASP it is power full like ORACLE.
it is an RDBMS. it provide more securities and management.


How is it as "powerful as oracle" if it does not support subqueries, stored procedures or db logging (to name a few features)?

[adeelahmed]

RE: quote:

NASA switches from Oracle to MySQL

more Information visit: http://www.mysql.com/news/article-51.html

general information n Documentation about mySQL for more information as i said
"mySQL is power full like ORACLE."
http://www.mysql.com/documentation/mysql/bychapter/


mySQL is also multithreaded, and you can use it as client server database system.


I take my words back as i said
"mySQL is RDBMS(Relational Database Management System)"

but yes mySQL is "Database Management System"

[parksie]

MySQL is definitely not a contender to Oracle, which kicks it completely. But since it's free I'm not complaining :)

[sail3005]

Wow, i feel really high tech. Using the same database as NASA? Oh man. :D :confused:

[Clunietp]

From that article:

The switch to Open Source software was primarily driven by costs, and MySQL was found to be the most robust product available


Well, since MySQL is free and Oracle costs a bundle, and you are limited by cost, which one would you choose? :)

I suppose when they compared free databases, they found that MySQL was definitely more powerful than manually editing a text file with notepad :D.

All modern RDBMSs' are multithreaded, client/server systems, and whoever wrote that MySQL help file that says MySQL is as powerful as Oracle is on crack! Also note the source of that document (mysql.com)

For a free database, I'm definitely not going to complain, but there is alot of hype about mysql. I am not claiming to be a MySQL expert, but from what I understand about its limitations I can't see how this can be considered a contender to the big boys (Oracle, M$, IBM, Sybase) when you need anything more than table storage and some simple queries.

[adeelahmed]

Is the Cost every thing that NASA has taken step to switch all of its information From ORACLE to mySQL?


but I will second whatever the Clunietp explained abt ORACLE.

[parksie]

I'm just going to tidy up here ;)

MySQL -- free
ORACLE -- costs more than you can fit in a Long

So this is why I use it :)
And also, the point of this thread was choosing MySQL over Access...