News for hackers. Stuff that matters.
Re:How category theory is applied by twic on Tuesday April 30, 2019 @02:37AM (#19785639)
> The most interesting "application" of category theory that I've seen (as it relates to software engineering) is the connection between databases and category theory

So is this application productive? It's nice to be able to describe something that already exists in terms of category theory, and even nicer if those descriptions are concise and satisfying. But does that description enable anything new? Did we get any new migration operations, normal forms, etc?

Re:How category theory is applied by wisnesky on Tuesday April 30, 2019 @05:52AM (#19786480)
Yes, for example the dual of join (called 'sigma'), which only exists for databases in categorical normal form. There are many academic papers and an open-source project ('categorical query language') here: http://www.categoricaldata.net.
Re:How category theory is applied by twic on Tuesday April 30, 2019 @08:12AM (#19787188)
Sounds interesting! I had a look, but couldn't find out what sigma does. This is not quite the same level as, say, the PostgreSQL documentation:

http://www.categoricaldata.net/help/instancesigma.html

Is there somewhere i can go for a worked example of using sigma?

Re:How category theory is applied by wisnesky on Tuesday April 30, 2019 @02:19PM (#19790516)
Sure, here is an example that uses sigma to compute an equivalence relation:

http://cql.conexus.ai/quotient.php