hey friends...i request you all to pls help me out...im damn confused...
im planning to make a website by March,2011 in which i will be using HTML/JSP and Mysql as d/b. however, i have a few doubts abt. Mysql....
1) on the mysql site, there are many packages available to download. which one should i d/l. im using windows 7 and netbeans IDE?
2) im confused whether i should use only the essentials package or the complete package ? wats d difference between both as far as query processing time is considered. my web application needs lowest query response time.
3) any tutorial site covering all the queries of Mysql....???
4) is there any other d/b that i should use instead of Mysql ? im not willing to invest any money since im a student and i have previusly worked on oracle and sql.
thanx a lot in advance.
Hi, maybe you can try MS SQL Express instead - http://www.microsoft.com/express/Database/ ? Less hassle to select correct package to download and plenty of documentation available.
Microsoft SQL Express is not the same as MySQL. Totally different animals.
For MySQL, you can grab the latest stable release for your operating system: http://dev.mysql.com/downloads/mysql/
That's the standard MySQL package. Other packages are for large-scale operations, such as load balancing.
Since you are using Java, you will probably need a MySQL connector for whichever Java server you're using, be it JBOSS, Tomcat, or something else. The MySQL Connector allows you to connect to the MySQL server from whatever language you're using. You'll probably need the ODBC or J connector: http://dev.mysql.com/downloads/connector/
@ allan22 : i had considered the option of MS SQL express, but didnt find it comfortable.
@ force flow : on the link :http://dev.mysql.com/downloads/mysql/ there are 2 types...MSI installer and ZIP archives...which one should i d/l ?
do i need to d/l the cluster packages ?
i am using netbeans IDE, so do i need to download the JDBC connector (since i am using JSP) ?
thanx a lot...!!!
You'll want the MSI installer and then you'll need either the 32bit or the 64bit - that'll depend on what windows you are running on your PC.
You may need the JDBC connector for your code, yes.
This MySQL tutorial will be a good starting point for you.