puntoblogspot

SQL's window functions are such a huge topic that some see them as a DSL inside SQL itself. You can do amazing things in sql without win...

In kdb+ there's a great way of showing aggregated information called `aj` for asof join . This way of joining data is a neat way to get ...

REPLs are great, but they are only a part of the "have fun" experience. Sometimes, you need data to work on a repl and to be able ...

If you have two tables with a foreign_key relationship, and you want to update the value of a primary key, postgresql will fail, telling you...

`scan` is an adverb in apl / j / k which is used to reduce an array over an operation, while keeping all the intermediate results. It's...

I've been learning more and more sql, both the language, the implementations, and as always, looking for the extreme cases of "you ...