Viewing profile — gtrubetskoy

The name Maestro has already been used for a workflow orchestrator which I worked on back in 2016. That maestro is SQL-centric and infers dependencies automatically by simply exami…

The original from July 2019 https://twitter.com/humblehack/status/1088982929940848647 $ echo -n 'The SHA256 for this sentence begins with seven, seven, f, zero, a, b, b and five.' …

I forked Redis to create Thredis almost 9 years ago. Some notes on how it was implemented: https://github.com/grisha/thredis/blob/master/README-THREDIS Then I added SQLite to it, m…

Python becoming Tcl

The details of how the data is stored are described in this 1979 paper by Douglas Comer: "The Ubiquitous B-Tree" [1]. Since it was invented, much hasn't really changed: practically…

I remember the days when having to switch between x86, ppc, sparc, etc was a thing (not to mention the many flavors of UN*X) and we survived. In fact I think it was more fun back b…

> Also, what is the pollution you are talking about? For example reactive oxygen species. https://www.ncbi.nlm.nih.gov/pmc/articles/PMC1865572/

I wouldn't rank glucose above fats. As I understand it, it's not exactly a "shorter battery" than fat - it is simply a form of energy that is abundant in plant life, but fat is sti…

If you are using BigQuery and your "workflow" amounts to importing data from Postgres/MySQL databases into BQ and then running a series of SQL statements into other BigQuery tables…

Related - see my Ask HN on how to host your own blog without giving it to the centralized blogging services (I won't name): https://news.ycombinator.com/item?id=23206094

My take on it is - just write for yourself. If, when you read it, it sounds like a good write up to you for whatever your own reasons are, that is all that's required. If no one el…

I'm put off by increasing centralization (I won't name companies, you know them) and would like to know who still does it "old school", hosting their own blog. I'm especially inter…

I didn't :)

Subinterpreters existed from the very early days in the C API and were key to the implementation of mod_python (which I wrote). So if you used mod_python, you used subinterpeters w…

One problem with this article is the number of times the solution involves COUNT(DISTINCT). One of the best SQL interview questions is "Explain what is wrong with DISTINCT and how …

Github was cool when git was new years back - but these days, and especially given how git inherently is not centralized, it is not very clear to me why we all cling to github. Wit…

I've spent a lot of time trying to understand PoW and came to the conclusion that is a distributed clock of sorts, described here https://grisha.org/blog/2018/01/23/explaining-proo…

RecursionError: maximum recursion depth exceeded

Github goes down on Monday around 9am pacific time - must be totally random.

Any compact disk works as a spectrometer. https://www.cs.cmu.edu/~zhuxj/astro/html/spectrometer.html

I once submitted a blog post [1] and later received an email from someone at HN saying that it was a great article but didn't do so well and if I re-submit it, they will make sure …

FWIW - my notes on how locking was done in Thredis: https://github.com/grisha/thredis/blob/master/README-THREDIS

Heh, I did this back in 2012: http://thredis.org/ (Not only is it threaded, it also supports SQL).