puntoblogspot

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 ...

I realized today I haven't mentioned Brian Cantwell Smith in this blog before.  I'm not intimately familiar with his work, but I...

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 ...

Dan Ingalls and Brian Kernighan are the few people that I can listen for N hours straight, no x2, just x1, and just listen and be in awe.   ...