CLR: THREAT OR MENACE?
 |
(Joe Celko) Follow up to article in INTELLIGENT ENTERPRISE on the dangers of CLR languages inside a database. |
|
| | Related Articles - For Members.
|
|
Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content
Reader Comments: Post Your Comments/Feedback
RE: CLR: THREAT OR MENACE?
(posted: 3/28/2005 7:35:30 AM)
This is a long winded article that gives a history of computing (I wrote my first program on a 029 keypunch machine.) and concludes that Microsoft does not like standards. IMHO, the CLR will be good because processing is more distributed and broken into smaller components with more operating system control. CLR will be a challenge to manage but will continue the move to standalone databases and storage.
RE: CLR: THREAT OR MENACE?
(posted: 3/28/2005 8:42:46 AM)
After using paragraphs to convince us that a programatic language is bad in a SQL Database Joe then tells us that there is an ANSI/ISO Standard to do the same. The difference is that this implementation is not propriatary. Which way do you want to have it, Joe? Can we code procedureally in the database or not?
RE: CLR: THREAT OR MENACE?
(posted: 3/28/2005 10:22:08 AM)
Not sure that this article is disagreeable in any way, shape, or form. Basically, he is right, the CLR stuff is going to be extremely messy if people replace reasonable SQL code with CLR code. He is also correct that we should be using standard SQL type code that is in the standards (perhaps compiled to CLR code.) But, You cannot blame Microsoft for going this way. They have bet the farm on CLR, and it works as marketing and it is fast.
RE: CLR: THREAT OR MENACE?
(posted: 3/29/2005 8:42:18 PM)
> Quick example: if I add geometric data types, is a point on the boundary of a circle inside or outside of the circle?
A circle may be defined by a line consisting of the set of points within a given plane equidistant from a given [center] point. To wit, (by definition) such a point must be part of that circle itself (and thus neither inside or outside).
> Says who?
AFAIK That would likely be Euclid (in one of the books of the elements ca. 220 - 250 BC). HTH
SM
RE: CLR: THREAT OR MENACE?
(posted: 4/1/2005 8:56:48 AM)
I have been doing this for 31 years. I came to a DBA role through a developer path. The CLR is here, it can do neat stuff, make the best of it. I sympathize with with DBAs who cannot or have never written procedural code but you will have to learn. Also management is paid to be cheap. My brother (a CPA) still uses DOS based accounting programs.
|
