Aljaž Mur Eržen

I've recently read a blog post where the author is documenting one of their struggles when migrating from Oracle Database to PostgreSQL.

Lutra General-purpose query language Home Docs Code Zulip chat For the past year I've been working on my own query language that I now call Lutra.

This simple query does what we expect it to do.

I want to write down how like to deal with projects in software development.

In a way, writing programs is just attaching names to pieces of data and then passing them trough functions.

In the age of Single-Page-Applications and REST APIs (JSON over HTTP), the cool kids use JSON as the data serialization format.

When GROUPing an SQL relation, additional constraints are applied to what columns can be used elsewhere in the query.

When SQL contains a query parameter (i.e. $1), PostgreSQL will try to determine types of that parameter or determine that the type is unknown and fallback to string encoding.

In SQL, VALUES query is used to construct a "relation literal".

Most modern databases use data model named Relational Algebra (RA), which defines a relation as a set of tuples and a few operation you can do on relations.

In the last decade I noticed a shift in culture of watching movies.

Command line shells are interactive programs for running other programs.

TLDR; use vscode, it's very simple.

I have a few repositories that I don't want to share with the world or even GitHub, BitBucket or GitLab.

A few weeks back I've seen a post about how an organized file system is not the way many people today use computers.

TLDR; Let's make a framework for protocols that introduces the notion of 'user' and handles federation and user device connectivity.