Re: PHP/MySQL vs ASP/MSSQL?
Me, too. One thing that's a plus for my clients is to tell them that is will cost them less if I develop in php/mysql as opposed to ASP/MSSQL. Hosting is cheaper and I can do things in PHP that takes 5 lines as opposed to ASP/MSSQL which takes 20. heh Jenifer - Original Message - I have used both and I prefer php/mysql :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP/MySQL vs ASP/MSSQL?
I have used both and I prefer php/mysql :-) On 11/4/05, Peter Brawley <[EMAIL PROTECTED]> wrote: > Marc, > > >I've been using ASP for years but I have to work on a bigger project > involving many > >users and data so of course, Access is not an option anymore. Since > it's a project requiring > >thousand of files and several applications all linked together, I > can't create it once and change > >it later. Basically, which option is the best between PHP/MySQL and > ASP/MSSQL? It's > >not a giant project but it might include around 20'000 members > interacting daily through > >forums, blogs, messages etc... > > .NET/MySQL will be a _lot_ cheaper than .NET/MSSQL. Visual Studio will > save you a lot of time, but even that is a cost consideration, there is > a free .NET GUI too. If you go Windows and .NET, I'd strongly encourage > you to use Connector/NET rather than Connector/ODBC. Assuming you are > using such a direct connector rather than ODBC, there are small > MySQL-MSSQL differences in how you work with the database in the .NET > GUI, but these differences will not slow you down appreciably. If OS is > a major issue for you, it's even possible now to develop in .NET/MySQL > on Linux, but a main point of .NET is to insulate you from the OS, and > IAC Windows is not hard to get comfortable with, even if you hate it as > many do. > > PB > > - > > Marc Pidoux wrote: > > > I've been using ASP for years but I have to work on a bigger project > > involving many users and data so of course, Access is not an option > > anymore. Since it's a project requiring thousand of files and several > > applications all linked together, I can't create it once and change it > > later. Basically, which option is the best between PHP/MySQL and > > ASP/MSSQL? It's not a giant project but it might include around 20'000 > > members interacting daily through forums, blogs, messages etc... > > > > Thanks, > > > > Marc > > > > > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.362 / Virus Database: 267.12.8/161 - Release Date: 11/3/2005 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP/MySQL vs ASP/MSSQL?
Marc, >I've been using ASP for years but I have to work on a bigger project involving many >users and data so of course, Access is not an option anymore. Since it's a project requiring >thousand of files and several applications all linked together, I can't create it once and change >it later. Basically, which option is the best between PHP/MySQL and ASP/MSSQL? It's >not a giant project but it might include around 20'000 members interacting daily through >forums, blogs, messages etc... .NET/MySQL will be a _lot_ cheaper than .NET/MSSQL. Visual Studio will save you a lot of time, but even that is a cost consideration, there is a free .NET GUI too. If you go Windows and .NET, I'd strongly encourage you to use Connector/NET rather than Connector/ODBC. Assuming you are using such a direct connector rather than ODBC, there are small MySQL-MSSQL differences in how you work with the database in the .NET GUI, but these differences will not slow you down appreciably. If OS is a major issue for you, it's even possible now to develop in .NET/MySQL on Linux, but a main point of .NET is to insulate you from the OS, and IAC Windows is not hard to get comfortable with, even if you hate it as many do. PB - Marc Pidoux wrote: I've been using ASP for years but I have to work on a bigger project involving many users and data so of course, Access is not an option anymore. Since it's a project requiring thousand of files and several applications all linked together, I can't create it once and change it later. Basically, which option is the best between PHP/MySQL and ASP/MSSQL? It's not a giant project but it might include around 20'000 members interacting daily through forums, blogs, messages etc... Thanks, Marc -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/161 - Release Date: 11/3/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP/MySQL vs ASP/MSSQL?
Jigal van Hemert <[EMAIL PROTECTED]> wrote on 11/04/2005 03:09:58 AM: > Marc Pidoux wrote: > > I've been using ASP for years but I have to work on a bigger project > > involving many users and data so of course, Access is not an option > > anymore. Since it's a project requiring thousand of files and several > > applications all linked together, I can't create it once and change it > > later. Basically, which option is the best between PHP/MySQL and > > ASP/MSSQL? It's not a giant project but it might include around 20'000 > > members interacting daily through forums, blogs, messages etc... > > It's not an easy question to answer, Marc. > > Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to > Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup > will probably be higher. Both will be able to do the job. > > What you have to include in your decision is what the company you work > for is used to have. It's not easy and probably expensive too if they > have to support another OS/webserver/scripting languag/database than > they're used to. > Another point of consideration is what you are used to. You mention > years of experience in using ASP. If that means you have to learn > PHP/MySQL from scratch then that will be very expensive also (counting > the extra hours you have to spend to learn all the ins and outs of both > PHP and MySQL). > > Kind regards, Jigal. > I agree, unless you have the time and resources to learn and support a different OS and development environment stick within your comfort zone. If you have been using ASP for any length of time then you are probably used to using ODBC (or OLEDB) for data access. MySQL has an excellent ODBC driver. If you are moving to ASP.NET there is also a .NET connector for MySQL that also works very well. I am not suggesting that one platform is in general better than the other, I am suggesting that with your background, your best bet on a good project outcome will be to stay with what you know and what your client can support (even if you are the client). I would heed Jigal's advice. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: PHP/MySQL vs ASP/MSSQL?
Jigal van Hemert wrote: Hi Joerg (and other list readers), Joerg Bruehe wrote: Jigal van Hemert wrote: Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to Linux/Apache/MySQL/PHP (aka LAMP). You could always run MySQL on Windows Server along with your IIS and ASP. You don't need to throw the baby out with the bathwater. If you decide to keep your ASP code, then I would keep your IIS setup, as opposed to running something like Chilisoft and Apache. -- Erich Beyrent -- http://www.beyrent.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: PHP/MySQL vs ASP/MSSQL?
My turn to chime in on this one... I have been using ASP/MySQL on a Windows AND Linux box without any issues. Yes, that's right, ASP, with the right 3rd party software, can even run on Linux. (Don't ask Why??, just note that it can be done!) As long as you create a system DSN (IMOH, the easiest way to go) to connect to your MySQL databases (you have to use the MyODBC 3.51 driver), you won't have any problems coding ASP with MySQL as your backend. You can use the MS Jet to connect, however it puts another layer of complexity into the mix. Just another option... J.R. -Original Message- From: Pooly [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 7:37 AM To: MySQL General Subject: Re: PHP/MySQL vs ASP/MSSQL? 2005/11/4, Marc Pidoux <[EMAIL PROTECTED]>: > I've been using ASP for years but I have to work on a bigger project > involving many users and data so of course, Access is not an option > anymore. Since it's a project requiring thousand of files and several > applications all linked together, I can't create it once and change it > later. Basically, which option is the best between PHP/MySQL and > ASP/MSSQL? It's not a giant project but it might include around 20'000 > members interacting daily through forums, blogs, messages etc... A setup of ASP/MySQL could be a right option for you if you already know ASP. I'm not sure if it's possible though (using ODBC ?). -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] smime.p7s Description: S/MIME cryptographic signature
Re: PHP/MySQL vs ASP/MSSQL?
2005/11/4, Marc Pidoux <[EMAIL PROTECTED]>: > I've been using ASP for years but I have to work on a bigger project > involving many users and data so of course, Access is not an option > anymore. Since it's a project requiring thousand of files and several > applications all linked together, I can't create it once and change it > later. Basically, which option is the best between PHP/MySQL and > ASP/MSSQL? It's not a giant project but it might include around 20'000 > members interacting daily through forums, blogs, messages etc... A setup of ASP/MySQL could be a right option for you if you already know ASP. I'm not sure if it's possible though (using ODBC ?). -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP/MySQL vs ASP/MSSQL?
Hi Joerg (and other list readers), Joerg Bruehe wrote: Jigal van Hemert wrote: Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup will probably be higher. Both will be able to do the job. ^^ No flame war intended, but: Is this a typo, or on which assumptions / figures do you base that? Oooops, I meant to wright "lower". Thanks for correcting this. AFAIK, the whole LAMP setup is free-of-charge GPL software, unless the environment requires a commercial MySQL license. (Support agreements would be a different issue.) I agree, and even with a license and a support agreement it will probably be a lot cheaper than a comparable MS based setup (unless I have to believe http://www.microsoft.com/windowsserversystem/facts/topics/tco.mspx which likes me to believe that an MS-based setup is actually cheaper in the end). Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP/MySQL vs ASP/MSSQL?
I would venture to guess that support was the issue. That would make a fair comparison. - Sent from my NYPL BlackBerry Handheld. - Original Message - From: Joerg Bruehe [EMAIL PROTECTED] Sent: 11/04/2005 06:28 AM To: Jigal van Hemert <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Subject: Re: PHP/MySQL vs ASP/MSSQL? Hi Jigal, all! Jigal van Hemert wrote: [[...]] Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup will probably be higher. Both will be able to do the job. ^^ No flame war intended, but: Is this a typo, or on which assumptions / figures do you base that? AFAIK, the whole LAMP setup is free-of-charge GPL software, unless the environment requires a commercial MySQL license. (Support agreements would be a different issue.) Jörg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com Office: (+49 30) 417 01 487 VoIP: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP/MySQL vs ASP/MSSQL?
Hi Jigal, all! Jigal van Hemert wrote: [[...]] Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup will probably be higher. Both will be able to do the job. ^^ No flame war intended, but: Is this a typo, or on which assumptions / figures do you base that? AFAIK, the whole LAMP setup is free-of-charge GPL software, unless the environment requires a commercial MySQL license. (Support agreements would be a different issue.) Jörg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com Office: (+49 30) 417 01 487 VoIP: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP/MySQL vs ASP/MSSQL?
Marc Pidoux wrote: I've been using ASP for years but I have to work on a bigger project involving many users and data so of course, Access is not an option anymore. Since it's a project requiring thousand of files and several applications all linked together, I can't create it once and change it later. Basically, which option is the best between PHP/MySQL and ASP/MSSQL? It's not a giant project but it might include around 20'000 members interacting daily through forums, blogs, messages etc... It's not an easy question to answer, Marc. Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup will probably be higher. Both will be able to do the job. What you have to include in your decision is what the company you work for is used to have. It's not easy and probably expensive too if they have to support another OS/webserver/scripting languag/database than they're used to. Another point of consideration is what you are used to. You mention years of experience in using ASP. If that means you have to learn PHP/MySQL from scratch then that will be very expensive also (counting the extra hours you have to spend to learn all the ins and outs of both PHP and MySQL). Kind regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]