Example: SQL differentiates between views and tables. You can't usually update a view. However the relational model says, you should be able to interchange views and tables completely. This means the most powerful abstraction feature of the relational model is completely missing! It's like programming in a language without subroutines or functions. (Yes some DBs allow a limited subset of updateable views, and some allow you to specify your own SQL triggers to update them, but that's not exactly the same as having the DB *infer* the constraints and rules itself for any view).
CREATE VIEW vw_CantUpdateMe as
SELECT CustomerID, SUM(TransactionCharge) as TransactionTotal FROM CustomerTransactions GROUP BY CustomerID
go
UPDATE vw_CantUpdateMe SET TransactionTotal = 496.95 WHERE CustomerID = 12
What exactly should happen in the mythically perfect updatable views universe?
It is not stupid. If you have users who often need to pull data into a spreadsheet, but who need an interface to guide them on the report's input parameters, it is incredibly handy to be able to output a table WITH CSS FORMATTING and just changed the content-type to application/vnd.ms-excel.
Does anybody remember::Blex's Page of Good MP3:: ? Before Audiogalaxy came along and supplanted everything with its Remote Queueing Goodness I always hit the FTPs listed there. Updated everyday like clockwork.
For that matter, does anybody remember hassling with ratio FTP sites? Am I the only one who actually used something along the lines of XFree86.src.tar.mp3 to get a big ratio credit?
I did something similar exactly once -- then I made for damn sure to always set implicit_transations on when working with SQL Server.
What's great is when you're watching it happen, after like 2 seconds it suddenly dawns on you that this query is taking *way* too long... And then the panic sets in.
Slashdot Mirror
I prefer "+1, Bitter" myself.
It is not stupid. If you have users who often need to pull data into a spreadsheet, but who need an interface to guide them on the report's input parameters, it is incredibly handy to be able to output a table WITH CSS FORMATTING and just changed the content-type to application/vnd.ms-excel.
http://freshmeat.net/projects/vigor/
Why would this still not be a "world?" For those involved, I'd imagine it is sufficiently time/passion-consuming to be considered such.
Does anybody remember ::Blex's Page of Good MP3:: ? Before Audiogalaxy came along and supplanted everything with its Remote Queueing Goodness I always hit the FTPs listed there. Updated everyday like clockwork.
For that matter, does anybody remember hassling with ratio FTP sites? Am I the only one who actually used something along the lines of XFree86.src.tar.mp3 to get a big ratio credit?
I did something similar exactly once -- then I made for damn sure to always set implicit_transations on when working with SQL Server.
What's great is when you're watching it happen, after like 2 seconds it suddenly dawns on you that this query is taking *way* too long... And then the panic sets in.