Through the course of this blog we will encounter a diverse cast of algebraic structures generalizing the concept of a graph. In this post we start at the very beginning, with how category theorists understand graphs, how graphs are an example of a general class of structures called “C-sets,” and how C-sets can be used as data structures in Julia through Catlab.jl.

I’m finally doing it. This post is not too bad now that I’ve picked up on a lot of the core ideas over the past few months.

via: https://github.com/AlgebraicJulia/ACSets.jl?tab=readme-ov-file#learning

A user friendly TUI for SQL databases. Written in python. Supports SQL server, Mysql, PostreSQL and SQLite, Turso and more. - Maxteabag/sqlit

This blog post provides a detailed look at various techniques and methods for performing data sampling using SQL, including stratified and random sampling, and discusses the nuances and pitfalls of each approach.

Open-source CQL and its integrated development environment (IDE) performs data-related tasks — such as querying, combining, migrating, and evolving databases — using category theory, a branch of mathematics that has revolutionized several areas of computer science.

Open-source CQL and its integrated development environment (IDE) performs data-related tasks — such as querying, combining, migrating, and evolving databases — using category theory, a branch of mathematics that has revolutionized several areas of computer science.

Acsets are a novel infrastructure for handling data of different shapes, based on category theory and implemented in Catlab.jl. Acsets generalize both graphs and dataframes, and allow a much more general approach to data manipulation than was previously available. We will discuss both the mathematics of acsets and some of the metaprogramming techniques we used to implement them in Julia. Finally, we will give examples of how acsets have been key in developing many projects in AlgebraicJulia.

Probably the best AlgebraicJulia tutorial on the planet LOL.

Good presentation on ologs.

Good presentation on ologs.

The power of monoids strikes again.

via: https://www.marginalia.nu/log/a_123_index_io/

see: https://db.cs.cmu.edu/mmap-cidr2022/