Regardless of whether it's a web application, mobile app, or internal BI reporting system - don't let the front-end application interface with the database directly. Don't even let them have...

There is a great deal of misunderstanding about relational DBMSs and you will find a lot of this misunderstanding out there on the internet.

For example, people talk about a  "relational...

I think we could do more to promote the advantages of using a SQL-DBMS.

I can understand that some developers might have developed an aversion because of the behaviour of some...

To throw a curved ball in here - knowing people who try and make a living from their music,  I will not use Spotify as it pays them spit all....

If you know there are better practices you should follow, then take the few extra moments to implement them. If you don't know of good practices, start compiling a list,...

• This reply was modified 3 years, 5 months ago by  will 58232.

Thanks Jeff

That and control characters 28 thru 31.

I'm writing them how I would decode them in JavaScript -

Row split:

data.split("\u001e")

column split:

data.split("\u001f")

It is possible to define a whole set of JavaScript functions...

• This reply was modified 3 years, 5 months ago by  will 58232.
• This reply was modified 3 years, 5 months ago by  will 58232.
• This reply was modified 3 years, 5 months ago by  will 58232.
• This reply was modified 3 years, 5 months ago by  will 58232.
• This reply was modified 3 years, 5 months ago by  will 58232.

With the proliferation of file formats, perhaps it is time to revisit the delimited file and how its problems can be overcome.

CSV stands for comma separated values. As we know...

For a sceptical and very knowledgeable view of the current state of AI and robotics I can recommend Rodney Brooks' blog

https://rodneybrooks.com/predictions-scorecard-2021-january-01/

Brooks was the director of the AI lab...

David.Poole

Graph databases are ones where I feel there is a lot of potential but now we have graph capabilities in SQL Server. I think we need some really good examples...

a relational store is likely better

It is important to remind everyone that a relational DBMS is not a way of "storing" data. The relational model provides a logical interface to...

Dr Codd described a relation in a way that described what we think of as a record or tuple

A relation (in the relational model) is more equivalent to a table...

Although ERD are typically used to visualize relational models, it could also apply to multi-dimensional and other models, so long as you have a more flexible definition of what an...

Despite the apparent complexity at the mathematical level

The mathematical level is much simpler than SQL. The mathematical definition of a function is much simpler than the programming language definition -...

any restrictions on the level of temporal resolution

Is there ever a business case for having the time expressed down to microseconds? I recommend reading Flash Boys - A Wall Street...

• This reply was modified 3 years, 6 months ago by  will 58232.

It just because data is related to other data.

Codd called his invention relational because it is based on the mathematical construct of a relation. This represents a relation between sets....

• This reply was modified 3 years, 6 months ago by  will 58232.
• This reply was modified 3 years, 6 months ago by  will 58232.
• This reply was modified 3 years, 6 months ago by  will 58232.
• This reply was modified 3 years, 6 months ago by  will 58232.