|
phil.o wrote: severe brain damages
Causing you to miss the Reply button and hit Email instead? 
phil.o wrote: Better stick to Excel as early as possible
Better, I started in VB! 
|
|
|
|
|
Sander Rossel wrote: Causing you to miss the Reply button and hit Email instead?
I wondered why I had to reply twice ^^ Now I know.
Sander Rossel wrote: Better, I started in VB!
Beware! VB is extremely dangerous. VB destroys ozone layer. VB causes cancer and other funny diseases.
I never finish anyth
|
|
|
|
|
BTW allready your subject does not work, it has to be "SQL <> SQL"
modified 19-Jan-21 21:04pm.
|
|
|
|
|
|
Works in SQL Server
PooperPig - Coming Soon
|
|
|
|
|
Sander Rossel wrote: When does the hurting stop
When you stop doing presentation logics in the database.
I also agree with Phil, why do you need to support more than one database?
|
|
|
|
|
Why? Layers are soooo last decade.
The language is JavaScript. that of Mordor, which I will not utter here
This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a f***ing golf cart.
"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."
If software development were a circus, we would all be the clowns.
|
|
|
|
|
Our company uses Oracle and SQL Server, both from C#.
SQL Server support isn't really a requirement (now), but I was pretty sure it would work as it's SQL in it's simplest form (although apparently there is no 'simple' form of SQL)...
Anyway, screw SQL Server support.
|
|
|
|
|
It'll get even funnier when you realize that even when the SQL is completely compatible, the results may not be.
For example: Oracle doesn't have an empty string.
|
|
|
|
|
Jörgen Andersson wrote: For example: Oracle doesn't have an empty string.
Or a bit/bool data type...
Jörgen Andersson wrote: It'll get even funnier
I'm not laughing
|
|
|
|
|
Jörgen Andersson wrote: Oracle doesn't have
A GUID type. 
In some databases a one-byte integer is signed; in others it's unsigned. 
|
|
|
|
|
PIEBALDconsult wrote: A GUID type
Syntactic sugar. Use myguid RAW(16) default SYS_GUID()
Or rather, don't use them at all.
The only serious place where GUIDs have the edge over sequences is on distributed systems.
|
|
|
|
|
Jörgen Andersson wrote: is on distributed systems
They're all distributed systems.
|
|
|
|
|
Jörgen Andersson wrote: why do you need to support more than one database?
Because one features premium pay and the other features ubiquitous jobs?
|
|
|
|
|
If the minor differences between databases already make you cry, then please stay away from anything that has to do with browsers.
The language is JavaScript. that of Mordor, which I will not utter here
This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a f***ing golf cart.
"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."
If software development were a circus, we would all be the clowns.
|
|
|
|
|
CDP1802 wrote: stay away from anything that has to do with browsers
As a full-stack web developer that'll be difficult.
And yes it makes me cry and gives me nightmares, why can't we all just get along?
Sometimes I want to go back to my safe and simple WinForms, now that's good technology 
|
|
|
|
|
Very true, but some people think it just does not feel right if it is not as complicated and convoluted as possible. Browsers, CSS, JavaScript HTMl, throw them all away and build a native client where ever possible. Then you will certainly have a better UI.
As for the databases, perhaps you should use a ORM as abstraction. Then you can be fairly independent of the actual database that is used. At the price (as someone already noted) that you will do everybody a favor and not do any more presentation layer stuff in the data layer.
The language is JavaScript. that of Mordor, which I will not utter here
This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a f***ing golf cart.
"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."
If software development were a circus, we would all be the clowns.
|
|
|
|
|
CDP1802 wrote: perhaps you should use a ORM as abstraction
This is the 'dynamic everything should be possible' kind of code. In my experience ORM's don't handle that very well... We've tried some solutions, but ultimately decided to build our own solution, which is what I'm now doing 
CDP1802 wrote: you will do everybody a favor and not do any more presentation layer stuff in the data layer
I'm not 
|
|
|
|
|
Sander Rossel wrote: This is the 'dynamic everything should be possible' kind of code.
Good luck. Everybody and his dog must give it a try, I guess.
The language is JavaScript. that of Mordor, which I will not utter here
This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a f***ing golf cart.
"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."
If software development were a circus, we would all be the clowns.
|
|
|
|
|
CDP1802 wrote: perhaps you should use a ORM as abstraction
Works fine for CRUD, but...
|
|
|
|
|
Yes, and most things where CRUD does not work are the direct road to hell. I have seen many failed 'dynamic' SQL thingies and every time the 'creators' finally noticed that they could not swim when they were in the middle of the ocean.
I'm patching up another interesting creation right now. Each table in the database has more triggers than an average piece of sh.t . Not just 'normal' triggers, if there is such a thing. Those triggers contain real application logic and also try to do everything at once, triggering even more triggers. The whole avalanche is stopped by setting special columns in the data rows.
Now, I need to change a value in a primary key of one row, which usually means deleting and then inserting the row with its new key. If I do that, the wrong triggers will start triggering and everything goes to hell (GOTO is very bad).
Our geniuses did an update on the data row with the new key and then the (hopefully) right triggers will take over. The problem is that I really use an ORM and updating on a new primary key value will not cause an error, but also update nothing.
There hopefully is a special place in hell reserved for those people.
The language is JavaScript. that of Mordor, which I will not utter here
This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a f***ing golf cart.
"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."
If software development were a circus, we would all be the clowns.
|
|
|
|
|
CDP1802 wrote: more triggers than an average piece of sh.t
I think you mean "more triggers than Texas".
|
|
|
|
|
I used to live there. Don't mess with Texas
The language is JavaScript. that of Mordor, which I will not utter here
This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a f***ing golf cart.
"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."
If software development were a circus, we would all be the clowns.
|
|
|
|
|
Saw a t-shirt once: "Don't mess with Texas, it's not nice to pick on retards"
A very brave fellow I might add.
|
|
|
|
|
Anyone using triggers for anything else than logging, or with any recursion whatsoever, should get publically flogged.
Just a personal opinion.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
