Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Databases
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Databases
 Post Reply Post Reply Page  123>
Author
  Topic Search Topic Search  Topic Options Topic Options
Lamur View Drop Down
Newbie
Newbie
Avatar

Joined: 13 September 2003
Status: Offline
Points: 23 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Lamur Quote  Post ReplyReply Direct Link To This Post Topic: Databases
    Posted: 16 September 2003 at 11:44am
I see alot about MySQL and Access databases, and I really don't know a whole lot about them. Can someone explain, what they are excatly and whats better to use for various situations, etc. Thanks
Back to Top
3BEPb View Drop Down
Groupie
Groupie


Joined: 07 August 2003
Location: United States
Status: Offline
Points: 81 		Post Options Post Options   Thanks (0) Thanks(0)   Quote 3BEPb Quote  Post ReplyReply Direct Link To This Post Posted: 17 September 2003 at 12:12am
IMHO The major MS Access "contra" is limited connections oppt. But in general I will prefer Access. I don't know why... just personal opinion :)
Back to Top
Tegwin View Drop Down
Senior Member
Senior Member


Joined: 03 September 2003
Location: United Kingdom
Status: Offline
Points: 430 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Tegwin Quote  Post ReplyReply Direct Link To This Post Posted: 17 September 2003 at 10:43am

You can get a lot of information regarding MYSQL from their website at http://www.mysql.com this is an open source database product so you can install/use it for free.
If you dont want my peaches, dont shake my tree
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 18 September 2003 at 12:43am

There's been some discussion going around that MS will be dropping Access within a couple of years in favor of a light version of MS SQL. They currently offer MSDE for free which is a throttled version of MS SQL. Outperforms Access but only has command line db management services although you can get free windows and web based management gui's for it.

As of last month MS dropped the MS SQL developer edition to $50 US (Also seen it for under $40 US). Contains the throttled MS SQL, but also the full management console suite (Enterprise Manager) and SQL Server Books Online. Getting just Enterprise Manager is a great buy at $50.

Apparently, over the next year, MS will be releasing stuff to make MSDE more user friendly. Apparently, their goal is to reproduce all the funtionality in MS Office Access for the MS SQL light version. Don't know what they're going to do about licensing for web hosting companies. Right now, an Access license is cheap and a MS SQL license is megabucks. Might drive some companies who only offer MS Access to go to MySql.

 

Lead me not into temptation... I know the short cut, follow me.
Back to Top
Bluefrog View Drop Down
Senior Member
Senior Member


Joined: 23 October 2002
Location: Korea, South
Status: Offline
Points: 1701 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Bluefrog Quote  Post ReplyReply Direct Link To This Post Posted: 19 September 2003 at 8:46am

Originally posted by dpyers dpyers wrote:

As of last month MS dropped the MS SQL developer edition to $50 US (Also seen it for under $40 US). Contains the throttled MS SQL, but also the full management console suite (Enterprise Manager) and SQL Server Books Online. Getting just Enterprise Manager is a great buy at $50.

HOLY Mother of God!

I haven't really been paying attention to pricing lately, but "a great buy" is such a massive understatement that it borders on irresponsible...

Access is a waste of time for anything except very small databases. Great for personal contacts and CD collections, and blah blah. It does have one large advantage over MySQL in that it is an RDBMS. MySQL is not an RDBMS. But it is well supported and free. But for $50... There's still no contest - MS SQL Server wins hands down over MySQL at that price.

MySQL is not well suited for some tasks. You'll always hear people saying that it is "great for web stuff". Which is true. Step it up a few notches and you're in trouble. I'm guessing that there are few people here that need that kind of power though.

However, when it comes to power, most people don't need all the power MS SQL Server offers either - but the real advantage there is that it is a true RDBMS, which can guarantee the integrity of your data. Something that MySQL can't do.

If you need something that is well proven, is a true RDBMS, can get on the cheap, and still packs a punch, then look into PostGreSQL. It is better suited to nix systems, but... it's also free.

If you need reliability and data integrity for a relatively small application (thousands of records) that has a limited number of simultaneous users (10~30 max), then Access is fine. If you have more users, then PostGreSQL. If you don't care about data integrity, then MySQL. If you want a tac-nuke, then MS SQL Server.

If you want it easy, then 1) Access, 2) MS SQL Server, 3) MySQL, 4) PostGreSQL.

 
Back to Top
Tegwin View Drop Down
Senior Member
Senior Member


Joined: 03 September 2003
Location: United Kingdom
Status: Offline
Points: 430 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Tegwin Quote  Post ReplyReply Direct Link To This Post Posted: 19 September 2003 at 3:27pm
Originally posted by dpyers dpyers wrote:

As of last month MS dropped the MS SQL developer edition to $50 US (Also seen it for under $40 US). Contains the throttled MS SQL, but also the full management console suite (Enterprise Manager) and SQL Server Books Online. Getting just Enterprise Manager is a great buy at $50.

US$50 sounds very cheap. Do you not have to own like MSDN or something first before you can get MSSQL at $50. If not then please tell me where you saw it for this price.

 
If you dont want my peaches, dont shake my tree
Back to Top
Tegwin View Drop Down
Senior Member
Senior Member


Joined: 03 September 2003
Location: United Kingdom
Status: Offline
Points: 430 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Tegwin Quote  Post ReplyReply Direct Link To This Post Posted: 19 September 2003 at 4:01pm
Originally posted by Bluefrog Bluefrog wrote:

.... MySQL is not an RDBMS.

Just wanted to say here for the record that MYSQL IS an RDBMS.. The exceprt below is directly from the online manual at http://www.mysql.com/documentation/mysql/bychapter/manual_In troduction.html#Introduction

 
MySQL is a relational database management system.
A relational database stores data in separate tables rather than putting all the data in one big storeroom. This adds speed and flexibility. The SQL part of ``MySQL'' stands for ``Structured Query Language''. SQL is the most common standardised language used to access databases and is defined by the ANSI/ISO SQL Standard.(The SQL standard has been evolving since 1986 and several versions exist. In this manual, ''SQL-92'' refers to the standard released in 1992, ''SQL-99'' refers to the standard released in 1999, and ''SQL:2003'' refers to the version of the standard that is expected to be released in mid-2003.We use the term ''the SQL standard'' to mean the current version of the SQL Standard at any time.)

 
If you dont want my peaches, dont shake my tree
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 19 September 2003 at 9:28pm

Quote =Tegwin

US$50 sounds very cheap. Do you not have to own like MSDN or something first before you can get MSSQL at $50. If not then please tell me where you saw it for this price.

You don't need MSDN. The developer edition db is throttled - 2 gb limit, 5 concurrent workload/batch streams (NOT the same as 5 concurrent connections). You also get the license to distribute MSDE if you're developing desktop/lan apps.

Great tool for developing web apps, and Enterprise manager is worth it's weight in gold for managing and deploying the db.

Couple of links...

http://www.microsoft.com/sql/howtobuy/development.asp - General info on the 3 MSSQL developer versions offered. The one for $50 is just the DB and Enterprise Manager. The others contain various other servers and programs.

http://shop.microsoft.com/Referral/productInfo.asp?siteID=10 145 - $50 from MS

http://www.pcconnection.com/scripts/productdetail.asp?produc t_id=213218 - $43 from PC Connection

Saw some other page on the MS site that had more detail info specific to the $50 developer edition, but couldn't find it again.

Bought mine from the MS link. Ordered on Sunday evening, got it on Tuesday afternoon. Included a CD for SP3a which fixes that little virus problem that knocked out most of the MSSQL servers earlier this year.



Edited by dpyers

Lead me not into temptation... I know the short cut, follow me.
Back to Top
 Post Reply Post Reply Page  123>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.