Top all-time · #15352
Stuff about Things
Personal blog · blog.coelho.netdataprogramming
Stuff about Things is a personal blog at blog.coelho.net about data and programming. Since 2014, 5 different Hacker News readers have linked it 6 times, most often “Data Loading Performance of Postgres and TimescaleDB”. The last post was in 2024, but the archive is still widely read.
Too few sampled comments (3) to say how often HN recommends it.?
Why HN links it
HN commenters link this blog's posts on SQL and Postgres, such as its write-up on SQL's Turing completeness via cyclic tag systems, as sources in discussions of what SQL can compute. The comments only cite the posts.
Summarised by Claude from a sample of 3 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Fabien's Blog
Most-linked posts?
- Data Loading Performance of Postgres and TimescaleDB2 people · 3 mentions · first linked 2019-09-13
What Hacker News says?
> Prolog is Turing complete, SQL is not. This is actually not true. Behold, a cyclic tag system in SQL:2003-conformant SQL: http://wiki.postgresql.org/wiki/Cyclic_Tag_System Here's a blog diving into more detail: http://blog.coelho.net/database/2013/08/17/turing-sql-1.html Although this is less strictly conforming. The original thread was in the context of SQLite, which is trivially of equivalent computational power…
Comment linking /database/2013/08/17/turing-sql-1.html
on “SQL query to generate the Mandelbrot set as ASCII art”Submitted Data Loading Performance of Postgres and TimescaleDB (2019) as a story · 3 points
HN discussionI've been considering TimescaleDB for some use cases. Specifically to keep a transactional log of messages sent out. Has anyone independently benchmarked TimescaleDB vs Postgres w/ B-Tree vs Postgres w/ BRIN? Given that most timescale data would benefit greatly from BRIN, I'm surprised their various blog posts never cover it. I have discovered one person who tried to replicate some of the benchmarks around Postgres…
Comment linking /database/2019/09/13/postgresql-vs-timescaledb-data-loading-performance.html
on “Faster DISTINCT queries on PostgreSQL”Submitted Data Loading Performance of Postgres and TimescaleDB as a story · 3 points
HN discussionPostgreSQL is Turing-complete, as proven by implementations of a cyclic tag system[0] and Turing machine[1]. The Mandelbrot set[2] and travelling-salesman problem[3] have also been implemented in it. Transact-SQL is also Turing-complete, as proven by a Brainfuck implementation[4]. With that, you can theoretically compute anything :). [0]: https://wiki.postgresql.org/wiki/Cyclic_Tag_System [1]: https://blog.coelho.ne…
Comment linking /database/2013/08/17/turing-sql-1.html
on “Craziest thing I ever used SQLite for: partial file deduplication”Submitted PostgreSQL page size for SSD as a story · 3 points
HN discussion