gtrubetskoy

5 ms·

1.
by gtrubetskoy 2y ago
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 examining the SQL. It's written in Go and is BigQuery-specif
2.
by gtrubetskoy 3y ago
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.' | sha256sum 77f0abb54
3.
by gtrubetskoy 5y ago
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, more details here: http
4.
by gtrubetskoy 6y ago
Python becoming Tcl
5.
by gtrubetskoy 6y ago
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 all relational databases use some variation
6.
by gtrubetskoy 6y ago
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 before the x86/Linux server domination. Architecture div
7.
by gtrubetskoy 6y ago
> Also, what is the pollution you are talking about? For example reactive oxygen species. https://www.ncbi.nlm.nih.gov/pmc/articles/PMC1865572/
8.
by gtrubetskoy 6y ago
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 still a (much) "better battery".
9.
by gtrubetskoy 6y ago
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 - you might want to look at Maestro, it writ
10.
by gtrubetskoy 6y ago
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
11.
by gtrubetskoy 6y ago
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 else reads it, fine. But you might be surprised, a lot of
12.
Ask HN: Do you blog under your own domain? How?
27 points by gtrubetskoy 6y ago|39 comments
13.
by gtrubetskoy 6y ago
I didn't :)
14.
by gtrubetskoy 6y ago
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 without realizing it. http://modpython.org/li
15.
by gtrubetskoy 6y ago
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 to work around it".
16.
by gtrubetskoy 7y ago
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. With a little work, all that it offers can be done without any
17.
by gtrubetskoy 7y ago
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-proof-of-work/
18.
by gtrubetskoy 7y ago
RecursionError: maximum recursion depth exceeded
19.
by gtrubetskoy 7y ago
Github goes down on Monday around 9am pacific time - must be totally random.
20.
by gtrubetskoy 7y ago
Any compact disk works as a spectrometer. https://www.cs.cmu.edu/~zhuxj/astro/html/spectrometer.html
21.
by gtrubetskoy 7y ago
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 it does better, so I did and it went to the top. [1] -
22.
by gtrubetskoy 8y ago
FWIW - my notes on how locking was done in Thredis: https://github.com/grisha/thredis/blob/master/README-THREDIS
23.
by gtrubetskoy 8y ago
Heh, I did this back in 2012: http://thredis.org/ (Not only is it threaded, it also supports SQL).
24.
by gtrubetskoy 8y ago
Here is my own version: $ echo -n 'The SHA256 for this sentence begins with: one, eight, two, a, seven, c and nine.' | sha256sum 182a7c930b0e5227ff8d24b5f4500ff2fa3ee1a57bd35e52d98c6e24c2749ae0 (Edit: a better version).
25.
by gtrubetskoy 8y ago
The piano keyboard (usually) has 7 octaves. Frequency doubles every octave, therefore if the lowest key is C, then the highest C all the way on the right is C*2^7 You can also follow fifths and arrive at the same note after 12 fifth
26.
by gtrubetskoy 8y ago
There was a fascinating Defcon 26 talk on "predatory publishing" which may explain how this kind of thing happens: https://www.youtube.com/watch?v=ras_VYgA77Q https://en.wikipedia.org/wiki/Pre
27.
by gtrubetskoy 8y ago
My guess is that this is in line with the Go tradition of first handling all the odd cases leaving the essential part of what the function (or block of code in this case) attempts to do as the last part. So "if !found" to me sugge
28.
by gtrubetskoy 8y ago
It's interesting that this happened on the same day Trump and Jinping met, there is a possibility they both knew about this prior to the meeting. On Monday stock market goes up on "improving China relations", on Tuesday the D
29.
by gtrubetskoy 8y ago
You might like to read my BP from 2017: https://grisha.org/blog/2017/04/27/simplistic-go-web-app-par... I have been using this layout in many projects and it worked out really well. When having multiple
30.
by gtrubetskoy 8y ago
Would it be fair to say that the second law of thermodynamics is only "a law" given our human perspective of the direction of time? If time has no "arrow", but a memory is only possible in non-decreasing entropy which is

More ›