|
|
Post by admin1 aka Ed on Jan 20, 2003 17:37:37 GMT -5
It looks like I will be entering the age of Databases...FINALLY.
My web site was just upgraded to accept MY Sql and/or Microsoft SQL (only about 15 MB).
So who has experience in this area? Can anyone suggest the best price or option?
-Ed
|
|
|
|
Post by Inwards on Jan 21, 2003 8:50:55 GMT -5
I like MySQL a lot (in fact, this is what we're using at ToyboxDX), but a quick peek at your webserver shows that you're running on IIS/Win2k. Although MySQL will work fairly well on that platform, chances are that the only server-side scripting that you're going to be able to use on your site is ASP. In that case, you're MUCH better off using MS SQL Server, particularly if there's no price difference to you.
Basically, you want to avoid using ODBC for writing web apps if possible. Simple things like returning accurate row counts, etc are buggy as heck so you're much better off using direct api calls to the DB in question. Of course Microsoft supports its own SQL Server product in ASP a lot better than MySQL.
On another note, 15MB is not a lot of space, particularly if you're going to store graphics as BLOBs in the DB itself.
Anyway, good luck! I look forward to seeing another toy database out there...
|
|
|
|
Post by Edward28 on Jan 21, 2003 9:05:55 GMT -5
Great, thank you for the feedback. My site is in the process of being migrated over to a newer set-up, one where My SQL will work. So I'm happy to see that it is a good product. Did you find My SQL to be the most cost effective solution versus the full blown SQL Server? The toy database should be fun  -E |
|
|
|
Post by Inwards on Jan 21, 2003 9:20:17 GMT -5
Did you find My SQL to be the most cost effective solution versus the full blown SQL Server? Well, MySQL is free, so its price is tough to beat from that perspective. MS SQL Server certainly has its advantages over MySQL and is technically superior in most areas (fully ACID compliant, views, stored procedures, etc.) but MySQL is almost unquestionably faster and works well for non-profit sites. If you're new to relational databases in general, though, MySQL is sort of like jumping into the deep end first. There's no nice gui to let you manage your tables or indexs, or even a friendly way to edit your data. MS SQL Server makes this WAY easier. If you already have some RDBMS background, then MySQL is familiar territory. Of course the backend DB is only part of the equation. What scripting language are you planning on using to access the DB? PHP? PERL? ASP? ColdFusion? Java? These all have a bearing on which DB is the best choice. |
|
|
|
Post by Edward28 on Jan 21, 2003 9:26:27 GMT -5
SELECT *
FROM PORU.ROBOT_JAPAN_DATA
WHERE LUCK = EXCELLENT
AND FORTUINE = GOOD
WITH UR;
;D
I have a background on mainframe work (nested SQL), so I hope the MY product will be similar.
-E
|
|
|
|
Post by Edward28 on Jan 21, 2003 9:31:16 GMT -5
P.S. I like the free part  ...and the back end is to be determined. I've signed up with interland.com and purchased a business account.... |
|
|
|
Post by Inwards on Jan 21, 2003 9:38:24 GMT -5
I have a background on mainframe work (nested SQL), so I hope the MY product will be similar. -E Mmm... Now if there were only a web version of COBOL and JCL... >:> Looks like interland's using IIS/Win2k as well. I'd check with them first to see what your scripting language choices are, as they'll have the biggest impact on which DB it'll make sense to choose. |
|
