Stored Procedures in MySQL
-
Hi all Was just reading that MySQL is introducing Stored Procedures (currently in version 5.0 ALPHA). Read more: ^. I was thinking that it would be interesting to try and port one of our .NET web applications to the Mono framework, using MySQL. Of course we couldn't let clients near it until MySQL make it an official release, but it gives us more hosting options. - and well - it just appeals from a geek point of view :) Has anyone else tried this yet? Any thoughts? Cheers Steven
let the stormy clouds chase everyone from the place
-
Hi all Was just reading that MySQL is introducing Stored Procedures (currently in version 5.0 ALPHA). Read more: ^. I was thinking that it would be interesting to try and port one of our .NET web applications to the Mono framework, using MySQL. Of course we couldn't let clients near it until MySQL make it an official release, but it gives us more hosting options. - and well - it just appeals from a geek point of view :) Has anyone else tried this yet? Any thoughts? Cheers Steven
let the stormy clouds chase everyone from the place
We've been thinking of exploring exactly the same thing. I'd be interested in hearing other's opinions/experiences cheers, Chris Maunder
-
Hi all Was just reading that MySQL is introducing Stored Procedures (currently in version 5.0 ALPHA). Read more: ^. I was thinking that it would be interesting to try and port one of our .NET web applications to the Mono framework, using MySQL. Of course we couldn't let clients near it until MySQL make it an official release, but it gives us more hosting options. - and well - it just appeals from a geek point of view :) Has anyone else tried this yet? Any thoughts? Cheers Steven
let the stormy clouds chase everyone from the place
Why waiting for MySQL? Yo can use PostgreSQL[^] already.
My programming blahblahblah blog. If you ever find anything useful here, please let me know to remove it.
-
Hi all Was just reading that MySQL is introducing Stored Procedures (currently in version 5.0 ALPHA). Read more: ^. I was thinking that it would be interesting to try and port one of our .NET web applications to the Mono framework, using MySQL. Of course we couldn't let clients near it until MySQL make it an official release, but it gives us more hosting options. - and well - it just appeals from a geek point of view :) Has anyone else tried this yet? Any thoughts? Cheers Steven
let the stormy clouds chase everyone from the place
There are four things that make me nervious about this though. 1) I have read quite a few messages of people getting corrupt databases. Since I do not run MySql, I do not know just how fraggle it is. I have never had that problem with MS SQl and now with their new Express version does not having any performance limitations (as far as I could see from reading over docs on MSDN) that the MSDE had. 2) The licensing of MySql is anything but straight forward. They really need to clarify that! 3) Security in a Linux environment. It could be the most secure OS in all of history, but you really need to know a lot of what you are doing as you usually do not have a new service pack coming out that you can simply update to keep you out of trouble. If you are not a Linux geek, you could get hurt. At least for me it would be :) 4) Mono / Novell getting sued out of existance by MS for patent infringement if they start to put the squeeze on. The carrot is the low price though of running a server farm. CP could probably have a 30 server farm for what they paid for the MS liceneses for the SQL servers and OSs.. Rocky <>< www.HintsAndTips.com www.MyQuickPoll.com - 2004 Election poll is #33 www.GotTheAnswerToSpam.com "We plan for the future, we learn from the past, we live life in the present!"
-
There are four things that make me nervious about this though. 1) I have read quite a few messages of people getting corrupt databases. Since I do not run MySql, I do not know just how fraggle it is. I have never had that problem with MS SQl and now with their new Express version does not having any performance limitations (as far as I could see from reading over docs on MSDN) that the MSDE had. 2) The licensing of MySql is anything but straight forward. They really need to clarify that! 3) Security in a Linux environment. It could be the most secure OS in all of history, but you really need to know a lot of what you are doing as you usually do not have a new service pack coming out that you can simply update to keep you out of trouble. If you are not a Linux geek, you could get hurt. At least for me it would be :) 4) Mono / Novell getting sued out of existance by MS for patent infringement if they start to put the squeeze on. The carrot is the low price though of running a server farm. CP could probably have a 30 server farm for what they paid for the MS liceneses for the SQL servers and OSs.. Rocky <>< www.HintsAndTips.com www.MyQuickPoll.com - 2004 Election poll is #33 www.GotTheAnswerToSpam.com "We plan for the future, we learn from the past, we live life in the present!"
1. never had or heard of a corrupted database that wasnt to do with programmer error 2. licensing is very straightforward ... use the free version or pay for tech support 3. linux is inherently more secure than windows because nobody knows exactly what software you have running ... windows installs are basically all the same from a hacking pov 4. i doubt they can sue the ass off them with the spectre of anti-trust looming over everything they do these days the low cost of the LAMN (?) is very appealing to a lot of corporates and i think a lot of people will be exploring it
-
1. never had or heard of a corrupted database that wasnt to do with programmer error 2. licensing is very straightforward ... use the free version or pay for tech support 3. linux is inherently more secure than windows because nobody knows exactly what software you have running ... windows installs are basically all the same from a hacking pov 4. i doubt they can sue the ass off them with the spectre of anti-trust looming over everything they do these days the low cost of the LAMN (?) is very appealing to a lot of corporates and i think a lot of people will be exploring it
l a u r e n wrote: 1. never had or heard of a corrupted database that wasnt to do with programmer error I've never seen a database corrupted by programmer error. I have, however, seen databases corrupted (or at least the server process making an emergency shutdown) by poor administration. There is a difference. l a u r e n wrote: 2. licensing is very straightforward ... use the free version or pay for tech support Sorry, I couldn't understand it either. I can kind of see how you are making your assertion that you can "use the free version or pay for tech support". But it appears to be more complex than that. The "free" version seems to come with more restrictions on it. l a u r e n wrote: 3. linux is inherently more secure than windows because nobody knows exactly what software you have running Security through obscurity is well known to be flawed. For example, any one who cares to look closely enough at the front door on my house will see that it has a 5-lever lock on it. However, that knowledge is insufficient to gain entry unless you have the right key. Of course a brute force attack will also open the door. l a u r e n wrote: LAMN (?) LAMP l a u r e n wrote: the low cost of the LAMN (?) is very appealing to a lot of corporates and i think a lot of people will be exploring it From what I can see, corporates are just holding this over Microsoft's head as a threat to reduce licence costs without seriously thinking of implementing it. It may appear to have a lower cost, but 95% of people use Windows and Office. That is a hell of a retraining bill, and I really don't think the board of many companies will swallow that pill when the pay-off is so distant and so unknown.
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!
-
1. never had or heard of a corrupted database that wasnt to do with programmer error 2. licensing is very straightforward ... use the free version or pay for tech support 3. linux is inherently more secure than windows because nobody knows exactly what software you have running ... windows installs are basically all the same from a hacking pov 4. i doubt they can sue the ass off them with the spectre of anti-trust looming over everything they do these days the low cost of the LAMN (?) is very appealing to a lot of corporates and i think a lot of people will be exploring it
[Message Deleted]
-
Hi all Was just reading that MySQL is introducing Stored Procedures (currently in version 5.0 ALPHA). Read more: ^. I was thinking that it would be interesting to try and port one of our .NET web applications to the Mono framework, using MySQL. Of course we couldn't let clients near it until MySQL make it an official release, but it gives us more hosting options. - and well - it just appeals from a geek point of view :) Has anyone else tried this yet? Any thoughts? Cheers Steven
let the stormy clouds chase everyone from the place
I have used MySql on various projects including .Net with suprisingly good results. MySql is not as feature rich as MS Sql and really should not be in my opinion. I like the small footprint simple to use no frills nature of MySql it offers a great alternitive to larger database solutions at a fraction of the cost. The licensing is pretty clear but if you have a question shoot them an email they have always been prompt and helpful to me. I have also been using firefox another open source database with .Net and have found it to be more than adequate alternitave for small to medium size projects. It takes a little bit to get use to and the third party tools are not as rich as the MySql counterparts but after you get is figured out it is pretty stable.
-
[Message Deleted]
steven shingler wrote: Excellent typo Well, it was when I first woke up :-O steven shingler wrote: What d'you think is tricky about the MySQL licensing There is a lot of grey area as to who is required to have the commercial license and who is not. This can open up a company to legal problems if it ever came to it. Of course, I doubt they would ever do that to anyone, but it is still a doorway of attack that is not clear. Rocky <>< www.HintsAndTips.com www.MyQuickPoll.com - 2004 Election poll is #33 www.GotTheAnswerToSpam.com "We plan for the future, we learn from the past, we live life in the present!"
-
I have used MySql on various projects including .Net with suprisingly good results. MySql is not as feature rich as MS Sql and really should not be in my opinion. I like the small footprint simple to use no frills nature of MySql it offers a great alternitive to larger database solutions at a fraction of the cost. The licensing is pretty clear but if you have a question shoot them an email they have always been prompt and helpful to me. I have also been using firefox another open source database with .Net and have found it to be more than adequate alternitave for small to medium size projects. It takes a little bit to get use to and the third party tools are not as rich as the MySql counterparts but after you get is figured out it is pretty stable.
KevinMac wrote: have also been using firefox another open source database Have not heard of that one.. Wonder what they think of Mozilla :) Rocky <>< www.HintsAndTips.com www.MyQuickPoll.com - 2004 Election poll is #33 www.GotTheAnswerToSpam.com "We plan for the future, we learn from the past, we live life in the present!"
-
KevinMac wrote: have also been using firefox another open source database Have not heard of that one.. Wonder what they think of Mozilla :) Rocky <>< www.HintsAndTips.com www.MyQuickPoll.com - 2004 Election poll is #33 www.GotTheAnswerToSpam.com "We plan for the future, we learn from the past, we live life in the present!"
-
My bad I keep getting them confused for awhile I think the browser and RDMS were both called FireBird then they renamed the browser FireFox. You would think I could keep them straight since they are both installed on my machine.
:) Rocky <>< www.HintsAndTips.com www.MyQuickPoll.com - 2004 Election poll is #33 www.GotTheAnswerToSpam.com "We plan for the future, we learn from the past, we live life in the present!"
-
I have used MySql on various projects including .Net with suprisingly good results. MySql is not as feature rich as MS Sql and really should not be in my opinion. I like the small footprint simple to use no frills nature of MySql it offers a great alternitive to larger database solutions at a fraction of the cost. The licensing is pretty clear but if you have a question shoot them an email they have always been prompt and helpful to me. I have also been using firefox another open source database with .Net and have found it to be more than adequate alternitave for small to medium size projects. It takes a little bit to get use to and the third party tools are not as rich as the MySql counterparts but after you get is figured out it is pretty stable.
That's very interesting. Are you tempted to try it with Mono in place of the MS .NET framework also?
-
That's very interesting. Are you tempted to try it with Mono in place of the MS .NET framework also?
I have this strange idea that at some point I will be able to write .Net applications for Macintosh. I keep watching for Mono being used with the OS X in a stable fashion. I would be real tempted at that point to be able to use MySql or FireBird as the DB backend. Mac users are very loyal and there is so much less competition in the software market for Mac's it would be great to write an app then sell it on Mac and Windows platforms.
-
Hi all Was just reading that MySQL is introducing Stored Procedures (currently in version 5.0 ALPHA). Read more: ^. I was thinking that it would be interesting to try and port one of our .NET web applications to the Mono framework, using MySQL. Of course we couldn't let clients near it until MySQL make it an official release, but it gives us more hosting options. - and well - it just appeals from a geek point of view :) Has anyone else tried this yet? Any thoughts? Cheers Steven
let the stormy clouds chase everyone from the place
Don't believe what you hear about MySQL. MySQL is great for simple PHP web applications, but not for more advanced applications. Don't expect version 5.0 to hit production status anytime soon. Version 4.1, which finally introdces subqueries and added functions still isn't even production yet. If you need stored procedures, subqueries, views, foreign keys, transactions, triggers, etc, MySQL is not for you. InnoDB supports FK and transactions, but that's it. PostgreSQL is a much better database, has the most features out of the open source databases, and is more similar to Oracle. It supports numerous languages for writing code, with the default PL/pgSQL very similar to Oracle's PL/SQL. Firebird is another feature-rich open source database. PostgreSQL FireBird