Puzzle Updated 2025-07-16
SQL histogram Updated 2025-07-16
Let's try it on SQLite 3.40.1, Ubuntu 23.04. Data setup:
sqlite3 tmp.sqlite 'create table t(x integer)'
sqlite3 tmp.sqlite <<EOF
insert into t values (
  0,
  2,
  2,
  3,

  5,
  6,
  6,
  8,
  9,

  17,
)
EOF
sqlite3 tmp.sqlite 'create index tx on t(x)'
For a bin size of 5 ignoring empty ranges we can:
sqlite3 tmp.sqlite <<EOF
select floor(x/5)*5 as x,
       count(*) as cnt
from t
group by 1
order by 1
EOF
which produces the desired:
0|4
5|5
15|1
And to consider empty ranges we can use SQL genenerate_series + as per stackoverflow.com/questions/72367652/populating-empty-bins-in-a-histogram-generated-using-sql:
sqlite3 tmp.sqlite <<EOF
select x, sum(cnt) from (
  select floor(x/5)*5 as x,
         count(*) as cnt
    from t
    group by 1
  union
  select *, 0 as cnt from generate_series(0, 15, 5)
)
group by x
EOF
which outputs the desired:
0|4
5|5
10|0
15|1
Yitang Zhang's theorem Updated 2025-07-16
There are infinitely many primes with a neighbor not further apart than 70 million. This was the first such finite bound to be proven, and therefore a major breakthrough.
This implies that for at least one value (or more) below 70 million there are infinitely many repetitions, but we don't know which e.g. we could have infinitely many:
or infinitely many:
or infinitely many:
or infinitely many:
but we don't know which of those.
The Prime k-tuple conjecture conjectures that it is all of them.
Also, if 70 million could be reduced down to 2, we would have a proof of the Twin prime conjecture, but this method would only work for (k, k + 2).
Gamma Updated 2025-07-16
It is fun to see that C and G have been confused since antiquity:
  • the modern sound is G
  • in terms of modern letters, both C and G split from gamma
Mineralogy Updated 2025-07-16
Eric Schmidt Updated 2025-07-16
Qijue Updated 2025-07-16
Four Great Classic Novels Updated 2025-07-16
In Chinese lit. just "Four Great Masterpieces".
Ubuntu 16.04 Updated 2025-07-16
Physical Review Updated 2025-07-16
List of the sub-journals at: journals.aps.org/browse
Looking Glass Universe Updated 2025-07-16
Cute simple paper-cut stop motion animations videos by Mithuna Yoganathan, a PhD in theoretical physics at the University of Cambridge: www.damtp.cam.ac.uk/person/my332.
This has the seeds of direct good intuition, but often stops a bit too short. Worth a look though, there is value in them for beginners.
Ludic Science Updated 2025-07-16
Maybe Spanish accent, but might also be from some other european language.
Very practical, low-cost experiments.

Unlisted articles are being shown, click here to show only listed articles.