TheLogothete

Why is a glorified calculator considered "AI"?

I guess we have to agree to disagree.

Vendors are standardizing on R, so I don't think the situation is as severe as you make it out to be.

>Since the times when you need "just scripting" are about 0.00001% of real-world cases

I would argue the opposite is true.

Most of the time an analyst builds regression trees in the mktg department for a retailer. Or similar situations like this.

Dynamo started as a document store. Bigtable is not but I included it because it is another very good option for analytics and is still lumped under the nosql umbrella.

Using relational database for event analytics means that you have a trivial use case. You might have a lot of rows, but your data is dead simple. Otherwise you would refactor every week to change the schema and sharding. Not to mention how much money you would spend on hardware.

We have found Sheldon Cooper.

Look at every mobile gaming company and you will see document stores. Dynamo, BigTable, DocumentDB. Google's very own analytics is built on BigTable. The examples are countless.

What product?

edit: After some stalking, I see you work on PowerQuery. Great product! Improving the SQL editing capabilities would make it much better!

You are being obtuse. It is obvious what I'm talking about.

I wouldn't use postgres for that at all! A NoSQL store is much better suited for that task.

Do you work on the database products? Please, PLEASE collaborate more with the analytics team. We want export to BQ for regular accounts. It's not a big ask and it will improve the lives and businesses of MANY people. I think it will affect google cloud revenues quite positively too.

Why do you think that people want to use it to build BREs?

Not everything in enterprises in a giant monolith. People make "apps" for various reasons.

Can you name 1 or 2 telcos that don't have hordes of angry customers cursing them?

multirbl.valli.org

mxtoolbox.com

It can in some circumstances. If the action is illegal in the first place, no contract can make it OK.

This is not an appropriate analogy. You are reversing the situation.

Terms and conditions and even contracts are often inadmissible. Just because you signed something, doesn't mean it's valid. Being handcuffed to a contract happens only in the movies,

I am not a lawyer.

No one smart ever believed that. Dumb people believed (and still do) that. Politicians just seized the opportunity to score some points. Same thing happens now with different topics.

No one actually believes that. Not anyone with any kind of power anyways.

The very next sentence:

Both Oracle and SQL Server has some way to restrict the growth of version information whereas PostgreSQL/PPAS doesn't have any way.

My question was why did the US government do that.

Why did the US gvmnt do that?

Postgres MVCC is anything but decent. It will take over control of the main heap. Good luck tackling that.

Yes, that's why I said this statement will be true for the upcomming release. I don't think this particular feature is that important anyway. Being Windows only has allowed SQL Server to e much more performent in many cases. Cost is not a factor.

The comparison with SQL Server is not very sound. SQL Server is MUCH cheaper. I would venture to say it is more performent and is on-par with features (certainly will be after the next realease). Moreover. SQL Server is not brute forced in the way you say Oracle is, especially with CRM. Maybe something like that happens with the ERP products, but much more mildly.

The most important difference is that SQL Server has everything that Oracle has to offer at a much, much cheaper price.

I agree that comparison with postgres and mysql are pointless. They offer a tiny fraction of what enteprise products have. If you need it, you will know.

No, it doesn't. If you make an M/R job work 1000 times more efficiently you save money for the company. It doesn't matter if you are a profit center or a cost center.

I'm dismissive of pointless hard work.

Or, you know, use a search engine. There are countless little things like that and out-of-the-box search in DBs will never catch up with.

Yeah, I definitely need the CEO's emails with cat pictures for my predictive maintenance models.

I disagree with you.

This is getting tiresome. You cannot access key objects with webworkers. It's a lipstick on a pig. If you want to kiss it, be my guess, but please do not try misguide other people to do so.