Postgres
Maybe MS could contribute. Starter for 10 - how about allowing changes to a table without having to drop every view that queries the table.
Microsoft’s Corporate Vice President for Azure Data, Rohan Kumar, told The Reg the org had no “thought process” around changing current long-term support terms for SQL Server. We were talking to the corporate veep as Microsoft slapped the Azure Arc sticker onto its veteran SQL product, with Kumar discussing both the update and …
"That was a key learning for us"
I'm quite a mild sort of person but I suddenly want to continuously punch someone in the face quite hard. English is a pretty flexible language and I personally encourage verbal widdling around the boundaries to see what pops out.
The sort of wanker who unthinkingly deploys a phrase like: "a very key learning" deserves to be hung by the smaller of their testicles until they say soz or perhaps scream for mercy. IDK. lol. etc.
This Azure Cosmos thing. Does anyone actually use it?
It claims compatibility with MongoDB, which I use a lot.
But it also apparently doesn't support date fields?
Literally every single document I have on my Mongo server has a date field in it somewhere. The only exceptions are a few that have more than one date field.
Is there a use-case anywhere that doesn't require dates somewhere?
Yes you could store the dates as a string, but then you wouldn't be able to query documents with a particular date range. Or use an integer I suppose?
Or spin up a FreeBSD instance and do "pkg install monogodb50"
It has partial MongoDB compatibility, but it's weird. It calls itself "multi-modal", in that you can talk MongoDB or SQL(ish) or DocumentDB or...another one, I forget. But you have to pick that interface up front and then you can't change it. Something weird about it.
I think its primary feature is "lockin".
I am pretty sure I've read it sometime around 3 years ago. Thinking about it since a couple of weeks since we are evaluating db options for a new project and I'm suggesting Postgre.
Does anybody else remember?
A virtual pint ---> to whoever is able to dig it up.