|
|
|
Doesn't say SQL-92 compliant, only that it has at least some features.
"
SQL-92 Compliance
The SQL-92 standard is imprecise with regard to arithmetical operator precedence; assumptions on this matter differ amongst SQL implementations. Caché SQL supports two system-wide alternatives for SQL arithmetic operator precedence:
By default, Caché SQL parses arithmetic expressions in strict left-to-right order, with no operator precedence. This is the same convention used in ObjectScript. Thus, 3+3*5=30. You can use parentheses to enforce the desired precedence. Thus, 3+(3*5)=18.
You can configure Caché SQL to parse arithmetic expressions using ANSI precedence, which gives higher precedence to multiplication and division operators than addition, subtraction, and concatenation operators. Thus, 3+3*5=18. You can use parentheses to override this precedence, where desired. Thus, (3+3)*5=30.
Caché SQL supports the complete entry-level SQL-92 standard with the following exceptions:
There is no support for adding additional CHECK constraints to a table definition.
The SERIALIZABLE isolation level is not supported.
Delimited identifiers are not case-sensitive; the standard says that they should be case-sensitive.
Within a subquery contained in a HAVING clause, one is supposed to be able to refer to aggregates which are “available” in that HAVING clause. This is not supported.
" -- Introduction to Caché SQL | Using Caché SQL | Caché & Ensemble 2018.1.4 – 2018.1.9[^]
|
|
|
|
|
It's the portability aspect.
Things went many directions at once.
Value outpaced usefulness.
|
|
|
|
|
jochance wrote: Oracle does 'sequences' and MSSQL has 'identity'.
SQL Server has sequences and everyone should use them. No one should ever use identities or other auto-numbers.
|
|
|
|
|
Yeah they haven't been around forever on that side but I remember liking them on the other.
|
|
|
|
|
I liked sequences in Oracle enough to implement my own in SQL Server before they were built-in.
"
When were sequences added to SQL Server?
The sequence object was introduced with the rollout of SQL Server 2012.
"
modified 20-Jul-24 9:47am.
|
|
|
|
|
honey the codewitch wrote: Mysql is another option and might be worth learning
There are two parts: Programming and Operations.
For the first the vast majority between the major SQL databases are similar enough that one can get through it. There can be gotchas for things like the exact way one creates a stored proc but examples allow one to get through it.
At least for me one problem with MySQL which I only just recently learned is that it has a history of 'losing' the seed indexes (auto increment). I can't state for certain how significant a problem it is in general but it seemed pretty significant to me that it happened at all.
As for Operations I think you need to carefully consider your commitment to handling this for your users. Given your other posts maybe this must be a server only solution but I will say that the cloud solutions eliminate the vast majority of maintenance work and can be very low cost as long as one very carefully throttles everything.
|
|
|
|
|
I don't really want to add another paid service to my list of worries, as anything that costs me money is just more potential source for anxiety - like for example, when my bank card's fraud protection kicks in and cancels my card even though it shouldn't have, and then all my autopays need to be redone.
So like, I keep it minimal. I'm more concerned about operations than programming, so otherwise a cloud solution would be ideal, but maybe I'll check to see if my existing VPS provider offers it. Adding extra cost to an existing bill is something i'm much more inclined to do vs adding another bill.
Check out my IoT graphics library here:
https://honeythecodewitch.com/gfx
And my IoT UI/User Experience library here:
https://honeythecodewitch.com/uix
|
|
|
|
|
I once tried the free Postgres hosting option of Heroku, but could not get it working sadly, it all seemed geared towards their "app ecosystem" which I was not interested in. Anyway they stopped offering the free option, so it's best to look elsewhere.
Maybe one of these: Top 9 free online databases[^]
|
|
|
|
|
>history of 'losing' the seed
Was it multi-instanced?
|
|
|
|
|
Yes? I didn't research it that much.
|
|
|
|
|
If you want an easy setup for Postgresql you can try this: https://pigsty.io/
|
|
|
|
|
|
From what I know, MSSQL exists for Linux also.
growing up with Multics, learning UNIX and then Linux for over 25 years, I abandoned that platform completely for Microsoft when I found that my peers had used Microsoft products and they were able to upgrade their solutions as time passed. I had to fight every time with Unix/Linux changes.
After 15 years on the Microsoft path I have never looked back and I am going on 40 years of developing software and I can maintain and upgrade applications from even 20 years ago.
Having software out there bringing you rent, the better off you are and the more time you have to develop.
That learning curve is bad enough with new technology alone, so I advise you to stick with your tools.
I wish you luck!
|
|
|
|
|
I have administered a system for 9 years based on PostgreSQL, another system for 17 years based on SQL Server, and maintain a private Linux system based on MySQL.
Of all the systems mentioned in this thread, PostgreSQL is my favorite for three main reasons:
1. It is free, unless you want to pay for support.
2. It is object oriented. Writing procedures that work together is very pleasant in PostgreSQL.
3. It is pure, not beset with encumbering licenses from corporations wanting to take over the world.
4. I can and have fairly easily written my own extension for it. In my case, it was my own version of SOUNDEX.
For SQL Server:
1. It is not free.
2. When I write a View2 that uses a View1, if View1 is ever updated, View2 does not see the update until I ALTER (with no changes needed) View2.
3. I use the Microsoft OPENQUERY a lot to do joins on remote databases before the data is received on my end. One problem with it is that it does not accept variables of any sort.
4. The interface is generally polished and familiar to me. My main irritation is the line numbering used on error messages that don't match my source without doing arithmetic.
For MySQL:
1. It is free up to a point.
2. It has ubiquitous documentation.
3. It is maintained poorly by Oracle, with whom I have had unpleasant communications with an arrogant salesman.
4. It has been patched to use multiple engines in an attempt to get wanted features. I.e., it is a bit of a mess.
5. I think I would rather use MariaDB, but haven't had the opportunity.
|
|
|
|
|
Quote: When I write a View2 that uses a View1, if View1 is ever updated, View2 does not see the update until I ALTER (with no changes needed) View2.
Do you mean if it is created without schemabinding?
Postgresql was different, there it was the default. Oh the joys of cascade dropping and recreating views and functions ... (Firebird 1.5 is the same) Oracle is wise .
Creating views on views therefore considered a bad practice.
|
|
|
|
|
I try to avoid views of a view, but it fit my desire for DRY (Don't Repeat Yourself) and laziness. 
|
|
|
|
|
Bruce Patin wrote: When I write a View2 that uses a View1, if View1 is ever updated, View2 does not see the update until I ALTER (with no changes needed) View2.
Seek ye the sp_refreshview procedure. Use it as needed.
At my last job I implemented a procedure which ran it on all views in accordance with their dependencies. It was part of our standard prod deployment process.
|
|
|
|
|
|
Support them all and allow the user to choose what he wants. 
|
|
|
|
|
Wordle 1,125 5/6
⬜⬜⬜🟨⬜
⬜⬜⬜🟨🟨
⬜🟩⬜⬜🟨
⬜🟩🟨🟩🟩
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 1,125 3/6*
⬜⬜⬜⬜🟨
🟨⬜🟨🟨🟨
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 1,125 3/6*
⬜🟨⬜⬜🟨
⬜⬜🟨🟨🟨
🟩🟩🟩🟩🟩
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Wordle 1,125 3/6*
⬜⬜⬜⬜🟨
⬜⬜🟩🟨⬜
🟩🟩🟩🟩🟩
Happiness will never come to those who fail to appreciate what they already have. -Anon
And those who were seen dancing were thought to be insane by those who could not hear the music. -Frederick Nietzsche
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
