MSDE is basically SQL server version 7 ====================================== Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf ====================================== If you are not satisfied with my service, my job isn't done!
----- Original Message ----- From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 21, 2003 7:05 PM Subject: Re: MS SQL Server vs. MySQL | First off....thanks everyone for your opinions...glad to hear them | | So far I'm not sold on MySQL simply because of what it lacks and MyPHPAdmin | is junk IMHO (only security I could get workng was wide open to the planet | or locked down so tight nobody could access...no even admin). | | I'd like to hear more about MSDE...what exactly is it? what is missng from | full blown MS SQL Server? what kind of interface (i.e. like Enterprise | Manager)? | | I'd also like to hear more about Postgre(s)? It sounds as though it has the | features MySQL is missing? Does it have a better/easier interface (more | like Enterprise Manager)? What OS does it work on? | | Thanks again folks...great info | | Cheers | | Bryan Stevenson B.Comm. | VP & Director of E-Commerce Development | Electric Edge Systems Group Inc. | t. 250.920.8830 | e. [EMAIL PROTECTED] | | --------------------------------------------------------- | Macromedia Associate Partner | www.macromedia.com | --------------------------------------------------------- | Vancouver Island ColdFusion Users Group | Founder & Director | www.cfug-vancouverisland.com | ----- Original Message ----- | From: "John Paul Ashenfelter" <[EMAIL PROTECTED]> | To: "CF-Talk" <[EMAIL PROTECTED]> | Sent: Thursday, August 21, 2003 4:23 PM | Subject: Re: MS SQL Server vs. MySQL | | | > Actually, if you've outgrown Access and can't afford MS-SQL, MSDE is | > probably a better answer since it saves you converting SQL twice -- once | to | > MySQL and once to MS-SQL down the road. | > | > Better plan is to code for the db you plan to use -- MSDE from the | beginning | > if you're heading for MS-SQL, MySQL if you want MySQL, etc. Database | > conversion is a pain. | > | > Regards, | > | > John Paul Ashenfelter | > CTO/Transitionpoint | > [EMAIL PROTECTED] | > ----- Original Message ----- | > From: "Massimo Foti" <[EMAIL PROTECTED]> | > To: "CF-Talk" <[EMAIL PROTECTED]> | > Sent: Thursday, August 21, 2003 5:51 PM | > Subject: Re: MS SQL Server vs. MySQL | > | > | > > "Matt Robertson" <[EMAIL PROTECTED]> wrote in message | > > news:[EMAIL PROTECTED] | > > > > Now if it's missing all that then what is it....Access on | > > > > steroids?? ;-) | > > > | > > > Yes, precisely. All the basics and none of the fancy stuff, plus | speed. | > > | > > Speed when you read data, on insert it can slow down quite a lot. I | don't | > > know about version 4.x, but older versions used to lock on write at the | > > table level; totally insane in my opinion. | > > | > > It can also slow down developing since it doesn't enforce referential | > > integrity and you have to do it on the application (same for cascading | > > delete) | > > | > > | > > > If you've outgrown Access and your budget is not ready for the MSSQL | hit | > > > then mySQL is a viable alternative. | > > | > > I really think that in this scenario Postgres is a much better | > alternative, | > > but maybe it's just me... | > > | > > ---------------------------- | > > Massimo Foti | > > Certified Dreamweaver MX Developer | > > Certified Advanced ColdFusion MX Developer | > > http://www.massimocorner.com/ | > > ---------------------------- | > > | > > | > > | > > | > | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
