gtrubetskoy
Joined 14 years ago
Karma
2,838
Submissions
522
Member since
Dec 28
Recent submissions
Comment · 2 years ago
Comment · 3 years 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 77f0abb54cd09ad7b654bd5e762d7be58e7daffd1a0da6a56f5135bd667856a3 -
Comment · 5 years 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:
This was all done mostly for fun, though I did use it in a an actual project for a while.
Comment · 6 years ago
Python becoming Tcl
Comment · 6 years 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 of this structure. I wrote about it in [2], which might help explain some aspects of how it works.
[1] https://dl.acm.org/doi/10.1145/356770.356776
[2] https://grisha.org/blog/2013/05/11/relational-database-on-to...
Edit: also [3] is about how to store SQLite in a Redis hash (rather than on-disk file).
[3] https://grisha.org/blog/2013/05/29/sqlite-db-stored-in-a-red...
Comment · 6 years 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 diversity is good.
Comment · 6 years ago
> Also, what is the pollution you are talking about?
For example reactive oxygen species.
Comment · 6 years 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".
The reason our body always favors burning glucose first is NOT because glucose is "better" but actually because it is an inferior type of fuel (it creates "pollution" and is difficult to burn - you can develop diabetes from too much of it) - so our evolved system tries to get rid of it first, while hanging on to the "good stuff" for as long as it can.
Comment · 6 years 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 written in Go and is SQL-centric, there is no Python dependency hell to sort out:
https://github.com/voxmedia/maestro/
With the SQL-centric approach you do not need to specify a DAG because it can be inferred automatically, all you do is maintain your SQL and Maestro takes care of executing it in correct order.
Comment · 6 years 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):
Comment · 6 years 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 other people may find it interesting as well :)
Comment · 6 years ago
I didn't :)
Comment · 6 years 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/live/current/doc-html/pythonapi.html#mu...
EDIT: And it looks like I had subinterpreters in the first released version in May 2000, so the initial git (formerly SVN) commit already had them https://github.com/grisha/mod_python/blob/9b211b7e8a65f1af4b...
EDIT2: Just noticed this comment:
* Nov 1998 - support for multiple interpreters introduced.
https://github.com/voxmedia/maestro/