Top all-time · #2759
Gregory Trubetskoy
Personal blog · grisha.org/blogprogrammingdata
Gregory Trubetskoy's personal blog at grisha.org covers programming and data. Since 2013, 27 different Hacker News readers have linked it 88 times, most often “Tgres – Time Series with Go and PostgreSQL”. The last post was in 2018, but the archive is still widely read.
Notes to self.
Most-linked posts?
- Tgres – Time Series with Go and PostgreSQL4 people · 4 mentions · first linked 2017-03-23
- Holt-Winters Forecasting for Dummies (or Developers)4 people · 4 mentions · first linked 2018-11-29
- Building a Go Web App in 20173 people · 4 mentions · first linked 2017-04-30
- Storing Time Series in PostgreSQL Efficiently – Grisha Trubetskoy3 people · 3 mentions · first linked 2017-08-11
- Proof-Of-Work is a Decentralized Clock2 people · 8 mentions · first linked 2018-02-12
- Introducing Tgres – A Time Series DB on Top of PostgreSQL2 people · 3 mentions · first linked 2016-08-01
- /blog/2017/09/25/bitcoin-value-2/2 people · 3 mentions · first linked 2017-11-01
- Graceful Restart in Golang2 people · 2 mentions · first linked 2016-12-19
- My Thoughts on WSGI2 people · 2 mentions · first linked 2013-10-26
- /blog/2013/05/29/sqlite-db-stored-in-a-redis-hash/2 people · 2 mentions · first linked 2019-10-05
What Hacker News says?
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/relatio…
Comment linking /blog/2013/05/29/sqlite-db-stored-in-a-redis-hash/
on “How Does Sqlite Work? (2014)”Submitted Proof-Of-Work is a Decentralized Clock as a story · 232 points
HN discussionThere's still one thing missing - graceful restart: https://grisha.org/blog/2014/06/03/graceful-restart-in-golan... BTW - to people new to Go this article may make it look like serving HTTP is complicated, but it's actually remarkably easy. And if you consider that it is actually _possible_ to have a complete server with just the standard lib (and with TLS and HTTP/2 to boot) running as a single process - compared t…
Comment linking /blog/2014/06/03/graceful-restart-in-golang/
on “So you want to expose Go on the Internet”Submitted Mod_python - the long story as a story · 147 points
HN discussionI don't have the time to figure out how it works, but I bet it uses the same principle that I presented about 3 years ago (basically there is a "master password"): http://grisha.org/blog/2013/05/31/simple-solution-to-passwor...
Comment linking /blog/2013/05/31/simple-solution-to-password-reuse/
on “LessPass: sync-less open source password manager”Submitted Mod_python development resumes after a 5 year pause as a story · 47 points
HN discussionCould be this? https://grisha.org/blog/2013/05/29/sqlite-db-stored-in-a-red...
Comment linking /blog/2013/05/29/sqlite-db-stored-in-a-redis-hash/
on “Sqlite 3.30.0”Submitted Building a Go Web App in 2017 as a story · 23 points
HN discussionI did something similar [1] though not nearly as detailed, whereby as of Sep 2017 I estimated the total hash power to be equivalent to 712,672 S9 miners, which roughly adds up to 8.584 TWh/year 8.584 / 109613 = 0.00008 = 0.008% (109613 TWh is the annual world consumption number you used) [1] - Electricity cost of 1 BTC https://grisha.org/blog/2017/09/28/electricity-cost-of-1-bit... P.S.: I think this is a high estim…
Comment linking /blog/2017/09/28/electricity-cost-of-1-bitcoin/
on “Bitcoin Mining Now Consuming More Electricity Than Many Countries”Submitted Simple solution to the password reuse problem as a story · 23 points
HN discussionThe guy wrote something about TimescaleDB as well: https://grisha.org/blog/2017/07/13/timescaledb/
Comment linking /blog/2017/07/13/timescaledb/
on “Timescale, an open-source time-series SQL database for PostgreSQL”Submitted Tgres – Time Series with Go and PostgreSQL as a story · 13 points
HN discussion> Regarding native storage, the insert rate really goes down as your table gets large, e.g., Timescale gets 20x higher throughput than PG: https://blog.timescale.com/timescaledb-vs-6a696248104e I actually looked at this benchmark briefly, but couldn't find what kind of PostgreSQL schema you used there. Did you use similar array based schema as was described by Tgress author in his post? https://grisha.org/blog/2015/…
Comment linking /blog/2015/09/23/storing-time-series-in-postgresql-efficiently/
on “Timescale, an open-source time-series SQL database for PostgreSQL”Submitted Introducing Tgres – A Time Series DB on Top of PostgreSQL as a story · 13 points
HN discussionCould you contrast this with the approaches mentioned in the series of blog posts starting here: https://grisha.org/blog/2015/09/23/storing-time-series-in-po... That blog post grew to be tgres http://github.com/tgres/tgres https://grisha.org/blog/2017/03/22/tgres-0-dot-10-dot-0b-tim...
Comment linking /blog/2017/03/22/tgres-0-dot-10-dot-0b-time-series-with-go-and-postgresql/
on “Timescale, an open-source time-series SQL database for PostgreSQL”Submitted Proof-Of-Work is a Decentralized Clock as a story · 10 points
HN discussionIncidentally I just wrote up some thoughts today on what Bitcoin is: https://grisha.org/blog/2017/09/22/bitcoin-value/ In some way it is fiat, Satoshi's fiat, but that's not the same as USD. The most puzzling thing is how things like Bitcoin get priced, since it's just a number, but I haven't finished my research on it yet.
Comment linking /blog/2017/09/22/bitcoin-value/
on “Bitcoin is fiat money, too”Submitted Tgres – Time Series with Go and PostgreSQL as a story · 6 points
HN discussionAnd Tgres requires no extensions to Postgres, you can use Postgres as-is (I know because I wrote it :) ). I'd also add the link to the post explaining the principle of how time series is actually stored which makes it capable of receiving 150K+ data points per second on relatively small hardware: https://grisha.org/blog/2017/01/21/storing-time-seris-in-pos... Fundamentally though, what timescale does is different in…
Comment linking /blog/2017/01/21/storing-time-seris-in-postgresql-optimize-for-write/
on “Building a scalable time-series database on PostgreSQL”Submitted Linus on Understanding Pointers as a story · 6 points
HN discussionIf your main use case for timeseries is a graphite/statsd replacement, another PostgesSQL-based project worth looking at is tgres. https://grisha.org/blog/2017/03/22/tgres-0-dot-10-dot-0b-tim... https://github.com/tgres/tgres
Comment linking /blog/2017/03/22/tgres-0-dot-10-dot-0b-time-series-with-go-and-postgresql/
on “Building a scalable time-series database on PostgreSQL”Submitted Storing Time Series in PostgreSQL as a story · 5 points
HN discussionThe problem that proof-of-work blockchain solves is widely misunderstood. It uses proof-of-work to establish consensus over points in time which are universally unique. Prior to the publication of Satoshi's paper we did not have a solution to this problem and for that reason it is a significant advance in technology. I wouldn't call it crappy, it's actually quite brilliant. For a detailed description see this: https…
Comment linking /blog/2018/01/23/explaining-proof-of-work/
on “Systems built on trust, norms, and institutions function better than blockchain”Submitted Is Time Series Database a Thing? as a story · 5 points
HN discussionA post [1] shared a couple of days ago made a thesis that BTC price needs to grow for it to become a viable "store of value." Maybe this is what we are seeing. "Market cap size is critical for adoption of a store of value. It needs to be large enough to “fit” even very large amounts of fiat, ideally without affecting the market. Gold market cap is estimated at 7 trillion USD, which means that even the richest people…
Comment linking /blog/2017/09/25/bitcoin-value-2/
on “Bitcoin Surges Past $7,000 to Extend Record Rally”Submitted Blockchain Proof-of-Work Is a Decentralized Clock as a story · 4 points
HN discussionBack when I was tinkering with mod_python performance[0] there was this web server called nxweb[1], which out-performed nginx consistently by quite a bit. [0] http://grisha.org/blog/2013/11/07/mod-python-performance-rev... [1] https://bitbucket.org/yarosla/nxweb/overview
Comment linking /blog/2013/11/07/mod-python-performance-revisited/
on “The Architecture of Open Source Applications: Nginx”Submitted Tgres – A Time Series DB on Top of PostgreSQL as a story · 4 points
HN discussionBack in September I've written down my thoughts on how Bitcoin price is determined in a two part blog (the second part is about pricing), and back then I concluded that Bitcoin will falter if it does not reach the cap closer to that of gold, which has to do with the total "capacity" of Bitcoin as store of value, which is its market cap. It still has more than 10x of growth to get there. [1] https://grisha.org/blog/2…
Comment linking /blog/2017/09/25/bitcoin-value-2/
on “Bitcoin hits $10,000”Submitted Bitcoin: Better Ink Than Gold? as a story · 3 points
HN discussion
