Please sit down and imagine...
-
... a database, that was designed 25 years ago (SQL 6.5) and since then only upgraded, but never updated... Do you feel me?!
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
... a database, that was designed 25 years ago (SQL 6.5) and since then only upgraded, but never updated... Do you feel me?!
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
... a database, that was designed 25 years ago (SQL 6.5) and since then only upgraded, but never updated... Do you feel me?!
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
MS-Access isn't totally useless; I used it to write a single-user database to manage my book collection.
If you have an important point to make, don't try to be subtle or clever. Use a pile driver. Hit the point once. Then come back and hit it again. Then hit it a third time - a tremendous whack. --Winston Churchill
-
... a database, that was designed 25 years ago (SQL 6.5) and since then only upgraded, but never updated... Do you feel me?!
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
MS-Access isn't totally useless; I used it to write a single-user database to manage my book collection.
If you have an important point to make, don't try to be subtle or clever. Use a pile driver. Hit the point once. Then come back and hit it again. Then hit it a third time - a tremendous whack. --Winston Churchill
And now imagine a 500+ company, managing its inventory (worth of millions), employee, customers, contact and so on, on Access... (They where located in Lod, just near enough to get infected)
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
No, me neither. How do you define upgraded vs updated? Is an update 'throw everything away and start again'? Windows was launched 35 years ago - has it been updated? Or upgraded? Or both? I don't see the difference. Semantics...
update - take the schema as-is and put it on a newer version of SQL upgrade - make changes to the schema using the new features of the new SQL
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
And now imagine a 500+ company, managing its inventory (worth of millions), employee, customers, contact and so on, on Access... (They where located in Lod, just near enough to get infected)
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
:omg: :wtf: X|
If you have an important point to make, don't try to be subtle or clever. Use a pile driver. Hit the point once. Then come back and hit it again. Then hit it a third time - a tremendous whack. --Winston Churchill
-
update - take the schema as-is and put it on a newer version of SQL upgrade - make changes to the schema using the new features of the new SQL
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
Ah OK, my mistake. Thought you were talking about SQL itself, not the database. I suspect 99% of databases live as long as the product they serve without significant rewrites.
pt1401 wrote:
I suspect 99% of databases live as long as the product they serve without significant rewrites.
You are probably right. So I should add - the product has been updated 6 times (only major counted) since then... The original version was a desktop application in C and now it is a full web based including support for handheld devices...
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
... a database, that was designed 25 years ago (SQL 6.5) and since then only upgraded, but never updated... Do you feel me?!
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
Nope. Database-theory has not changed. You state it was 'designed 25 years ago'; the word designed implies that it has been normalized. Perhaps you prefer entities without any upfront design? (As in, evolving by Agile)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
-
Nope. Database-theory has not changed. You state it was 'designed 25 years ago'; the word designed implies that it has been normalized. Perhaps you prefer entities without any upfront design? (As in, evolving by Agile)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
Eddy Vluggen wrote:
Database-theory has not changed.
But we got better tools to get close to it... Like using SF, Func, Trigger, XML data (as XML data and not string manipulated by SQL string methods), CTE, new kwywords, like OUTPUT, built in paging and so... We got a lot of it in the last 25 years...
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
Eddy Vluggen wrote:
Database-theory has not changed.
But we got better tools to get close to it... Like using SF, Func, Trigger, XML data (as XML data and not string manipulated by SQL string methods), CTE, new kwywords, like OUTPUT, built in paging and so... We got a lot of it in the last 25 years...
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
Triggers aren't new in the database-world, and XML is not exactly the ideal format for an RDBMS.
Kornfeld Eliyahu Peter wrote:
We got a lot of it in the last 25 years...
Yes. Doesn't mean it has to be used.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
-
Triggers aren't new in the database-world, and XML is not exactly the ideal format for an RDBMS.
Kornfeld Eliyahu Peter wrote:
We got a lot of it in the last 25 years...
Yes. Doesn't mean it has to be used.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
Eddy Vluggen wrote:
XML is not exactly the ideal format for an RDBMS
Exactly. But it has been used - so please take a moment and move from string manipulation to faster and better options, now you have them!!!
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
And now imagine a 500+ company, managing its inventory (worth of millions), employee, customers, contact and so on, on Access... (They where located in Lod, just near enough to get infected)
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
Eddy Vluggen wrote:
XML is not exactly the ideal format for an RDBMS
Exactly. But it has been used - so please take a moment and move from string manipulation to faster and better options, now you have them!!!
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
Kornfeld Eliyahu Peter wrote:
so please take a moment and move from string manipulation to faster and better options, now you have them!!!
Ehr.. databases existed before we had XML. So, the faster and better option would be - the database. ..and there will always be this bright genius who is going to store 32 flags as a bit-string, manipulating the thing with .Left$ en .Right$ until he gets his flag.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
-
Kornfeld Eliyahu Peter wrote:
so please take a moment and move from string manipulation to faster and better options, now you have them!!!
Ehr.. databases existed before we had XML. So, the faster and better option would be - the database. ..and there will always be this bright genius who is going to store 32 flags as a bit-string, manipulating the thing with .Left$ en .Right$ until he gets his flag.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
Eddy Vluggen wrote:
this bright genius
And I got this DB from that 'bright genius' :((
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
Eddy Vluggen wrote:
this bright genius
And I got this DB from that 'bright genius' :((
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
Kornfeld Eliyahu Peter wrote:
so please take a moment and move from string manipulation to faster and better options, now you have them!!!
Ehr.. databases existed before we had XML. So, the faster and better option would be - the database. ..and there will always be this bright genius who is going to store 32 flags as a bit-string, manipulating the thing with .Left$ en .Right$ until he gets his flag.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
Eddy Vluggen wrote:
..and there will always be this bright genius who is going to store 32 flags as a bit-string, manipulating the thing with .Left$ en .Right$ until he gets his flag.
Most likely 16 bits (or 15 coz top bit made number -ve and messy). Also smaller numbers applied to hard disks - measured in [often single or if lucky double digit] megabytes memory was in kilobytes - everything got squeezed. 25 years ago all numbers were a lot smaller than they are today. (But the best part: no damn cell phones, once ya left the office work was really over.)
Sin tack the any key okay
-
No :-D I had to work with other "SQL Servers" e.g. Interbase. I'm happy now to go on with this 25 year old one from MS :laugh: [Edit] Interbase has a nice Trigger Strategy, which I'm missing in MSSQL, but that's the only thing I'm missing in MSSQL :(
