LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-08-2002, 05:08 AM   #1
Bert
Senior Member
 
Registered: Jul 2001
Location: 406292E 290755N
Distribution: GNU/Linux Slackware 8.1, Redhat 8.0, LFS 4.0
Posts: 1,004

Rep: Reputation: 46
Unhappy Your chance to save MySQL / PHP from ASP.NET !


I have this dilemma.

The system is behind schedule. Consultants have been brought in. They have shiny neckties. They are from the dark side. They are certified Micro$oft-bankroll developers.

They want to replace the previous developers' MySQL / PHP solution with an ASP.NET kludge.

What can I do ? How can I save MySQL / PHP, how can I save my conscience?

I need answers. Quick.

Q. Why is MySQL better than ASP.NET ?

OK, I know it's faster, easier to learn etc. but I need some technical answers to stop this beast dead in its tracks.

Any ideas, anyone?

Thanks
Bert
 
Old 07-10-2002, 02:11 PM   #2
Bert
Senior Member
 
Registered: Jul 2001
Location: 406292E 290755N
Distribution: GNU/Linux Slackware 8.1, Redhat 8.0, LFS 4.0
Posts: 1,004

Original Poster
Rep: Reputation: 46
eeeeeeeeeeeeeeeeegh. phutt.

That was the sound of an open source solution dying.

The MySQL / PHP db on the Linux box is dead.

Long live .NET / MSSQL / TransactSQL (?!)



Ah well. I'll put it back when they leave .

Bert
 
Old 07-10-2002, 03:13 PM   #3
Phonics3k
Member
 
Registered: Jun 2002
Location: Wales, UK
Distribution: Gentoo 2005.1
Posts: 213

Rep: Reputation: 30
well the stable answer is all u need
 
Old 07-10-2002, 03:53 PM   #4
neo77777
LQ Addict
 
Registered: Dec 2001
Location: Brooklyn, NY
Distribution: *NIX
Posts: 3,704

Rep: Reputation: 56
Just let them see PHPNuke, and I bet they have never seen anything comparing to that in windows world http://phpnuke.org/
 
Old 07-10-2002, 04:34 PM   #5
jeremy
root
 
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 11,968

Rep: Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115
I would focus on the fact that it is far more secure and the costs are much lower. It can also be modified to do exactly what you want it to do.

--jeremy
 
Old 07-11-2002, 01:56 PM   #6
mace
Member
 
Registered: Apr 2002
Distribution: redhat7, 7.1, 7.2, 8.0, mandrake, debian2.2, 3, suse
Posts: 176

Rep: Reputation: 30
$ involved long term with ms solution is what i'd also bring to light.
 
Old 07-13-2002, 07:01 AM   #7
Bert
Senior Member
 
Registered: Jul 2001
Location: 406292E 290755N
Distribution: GNU/Linux Slackware 8.1, Redhat 8.0, LFS 4.0
Posts: 1,004

Original Poster
Rep: Reputation: 46
Actually, a more technical reason was given for going for an MS solution. MySQL does not enforce referential integrity.
OK, referential integrity is basically enforcing foreign keys so that the tables are strung together and duplication or redundant data won't exist (that's the theory aneeway).

Do later versions of MySQL enforce referential integrity?

Thanks for the responses.

BTW the money thing is a factor. Systems and the consultants are bickering on this point, as when the consultants leave, we could be left with crippling license costs.

There's a meeting on Monday to resolve this.

Hmmm.

Bert

Last edited by Bert; 07-13-2002 at 07:03 AM.
 
Old 07-13-2002, 08:20 AM   #8
RefriedBean
Member
 
Registered: Jun 2002
Location: N 37 33.327 E 126 55.650
Distribution: Gentoo, Slackware, OpenZaurus
Posts: 186

Rep: Reputation: 30
Quote:
Originally posted by Bert

Do later versions of MySQL enforce referential integrity?
Hi there!

Well, I don't know MySQL, but I did a quick google, and it seems to me that MySQL does not support referential integrity. But it looks like PostgreSQL support it. I don't use PostgreSQL either, so I won't know if its good.

Hope this helps..
RefriedBean

PS. I don't use SQL at all, so if anything I said is wrong, please ignore this post
 
Old 07-13-2002, 09:26 AM   #9
NetScripter
Member
 
Registered: Feb 2002
Location: Russia
Distribution: Gentoo 2005.1, Ubuntu 5.10, Debian 3.1
Posts: 66

Rep: Reputation: 15
MySQL supports foreign keys, since near 3.23.43 - more than half of the year
 
Old 07-13-2002, 02:56 PM   #10
Bert
Senior Member
 
Registered: Jul 2001
Location: 406292E 290755N
Distribution: GNU/Linux Slackware 8.1, Redhat 8.0, LFS 4.0
Posts: 1,004

Original Poster
Rep: Reputation: 46
Quote:
Originally posted by NetScripter
MySQL supports foreign keys, since near 3.23.43 - more than half of the year
The trouble is, this app was coded using the current version of MySQL 6 months ago. Frankly, not supporting referential integrity isn't great - it's central to database modelling and everything else (SQL92 even) supports it .

The developer should have used PostgreSQL. The moral of the story is pick your app well. MySQL is a speed tool (I think google runs it for this reason) but complex modelling it won't do.

I'm setting up a Redhat 7.3 NFS server using a processor array (we can't use Ghost anymore as it's an er... aquired copy) so the peguin won't be poleaxed yet.

Grrrr
 
Old 07-13-2002, 06:34 PM   #11
jeremy
root
 
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 11,968

Rep: Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115
MySQL isn't ACID compliant and I don't think they plan on it in the near future. If that is one of your needs you should look into PostgreSQL.

http://www.us.postgresql.org/features.html

--jeremy
 
Old 07-13-2002, 06:55 PM   #12
jeremy
root
 
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 11,968

Rep: Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115Reputation: 3115
I should add the following two points.

It is possible to get referential integrity now if you use certain transactional table types. These table types are new however and do have some issuses:
InnoDB - http://www.mysql.com/doc/I/n/InnoDB_overview.html
Gemini - http://www.nusphere.com

You can get an atomic operation with the current MyISAM table type:
http://www.mysql.com/doc/A/N/ANSI_di...nsactions.html

--jeremy
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
What's the best tool for ERP development??...PHP or ASP.NET fhameed Linux - Software 6 11-10-2010 02:17 AM
asp.net and mysql on linux montylee Programming 0 02-05-2004 04:24 AM
ASP.NET nd MySQL montylee Linux - Newbie 0 02-05-2004 04:21 AM
ASP.NET and MySQL montylee Programming 0 02-04-2004 12:34 AM
php vs asp.net lackluster General 4 07-18-2003 01:12 AM


All times are GMT -5. The time now is 03:40 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration