If you give me update and insert on a database for, say, an accounting application, there is nothing you can do with constraints to stop me from creating a vendor,...

• This reply was modified 2 hours, 58 minutes ago by will 58232.
• This reply was modified 2 hours, 56 minutes ago by will 58232.
• This reply was modified 2 hours, 50 minutes ago by will 58232.
• This reply was modified 2 hours, 49 minutes ago by will 58232.

If users have update access, how do you stop them from randomly changing data outside an application? Users cannot be trusted to not break things on a regular basis.

By having...

The solution to SQL injection is to write applications in a manner that makes injection impossible. And set up security to prevent users from doing anything outside an application.

There might...

• This reply was modified 4 days ago by will 58232.
• This reply was modified 4 days ago by will 58232.

Database level security offers security of the data against SQL injection completely independently of how the database is accessed either through applications or ad-hoc queries. There need be no duplication...

Implementing the database level security would open up the database to flexible access independent of applications. This is one of the reasons that we have relational DBMSs to begin with.

This...

The solution to SQL injection is to place all user identification and security in the database.

Using a combination of table and row level security is possible to define exactly which...

The dinosaurs didn't die out. They grew feathers and took to the air.

I find there are a lot of people in management nowadays who have learned statistics in their MBA and are proficient in R.

R dataframes implement the relational model and they...

Can we please, please stop talking about relational data stores?

The relational model is about the logical organization of data. One of the central aims of the model is to ensure...

My go to source for a very well informed and refreshingly sceptical view of artificial intelligence is the blog of Rodney Brooks, former head of the MIT AI Lab: https://rodneybrooks.com/blog/

There are a great many features missing from SQL Server but they are missing from the competition as well and some of the things are integral to SQL so it...

Failure is a great teacher, but the more you see it as the primary way a lot of people learn (or even don't learn), I guess this is what actually...

deleted

• This reply was modified 1 years, 2 months ago by will 58232.

Useful if you need to learn DAX. But I think some of this is misleading.

The basis of the relational model is a relation, a mathematical structure that represents a relation...

• This reply was modified 1 years, 2 months ago by will 58232.

My point was how you solve serialisable with adequate performance in principle independent of platform, I am well aware of the drawbacks in current methods.

My other point is that concurrency...