Analog electronics Updated +Created
Lead Updated +Created
List of systems of units Updated +Created
Mathematics course of the University of Oxford Updated +Created
The Oxford mathematics Moodle has detailed course listings, and most PDFs are not paywalled.
E.g. the 2024 course:
Mixed strategy Updated +Created
Shift-left testing Updated +Created
Andrew Dotson YouTube channel Updated +Created
Too many fun skit videos for Ciro Santilli's taste, but does have some serious derivations in quantum electrodynamics.
Assertion (software development) Updated +Created
Google Quantum AI Updated +Created
Google's quantum hardware/software effort.
The "AI" part is just prerequisite buzzword of the AI boom era for any project and completely bullshit.
According to job postings such as: archive.ph/wip/Fdgsv their center is in Goleta, California, near Santa Barbara. Though Google tends to promote it more as Santa Barbara, see e.g. Daniel's t-shirt at Video "Building a quantum computer with superconducting qubits by Daniel Sank (2019)".
Video 1.
Control of transmon qubits using a cryogenic CMOS integrated circuit (QuantumCasts) by Google (2020)
Source. Fantastic video, good photos of the Google Quantum AI setup!
Lossy compression Updated +Created
Software engineer stereotype Updated +Created
Sphere Updated +Created
Test driven development Updated +Created
This is a good approach. The downside is that while you are developing the implementation and testing interactively you might notice that the requirements are wrong, and then the tests have to change.
One intermediate approach Ciro Santilli likes is to do the implementation and be happy with interactive usage, then create the test, make it pass, then remove the code that would make it pass, and see it fail. This does have a risk that you will forget to test something, but Ciro finds it is a worth it generally. Unless it really is one of those features that you are unable to develop without an automated test, generally more "logical/mathematical" stuff. This is a sort of laziness Driven Development.
Not Just Bikes Updated +Created
SQL 2D histogram Updated +Created
Let's try it on SQLite 3.40.1, Ubuntu 23.04. Data setup:
sqlite3 tmp.sqlite 'create table t(x integer, y integer)'
sqlite3 tmp.sqlite <<EOF
insert into t values
  (0, 0),
  (1, 1),
  (2, 2),
  (3, 3),
  (4, 4),
  (5, 5),
  (6, 6),
  (7, 7),
  (8, 8),
  (9, 9),
  (10, 10),
  (11, 11),
  (12, 12),
  (13, 13),
  (14, 14),
  (15, 15),
  (16, 16),
  (17, 17),
  (18, 18),
  (19, 19),

  (2, 18)
EOF
sqlite3 tmp.sqlite 'create index txy on t(x, y)'
For a bin size of 5 ignoring empty ranges we can:
sqlite3 tmp.sqlite <<EOF
select
  floor(x/5)*5 as x,
  floor(y/5)*5 as y,
  count(*) as cnt
from t
group by 1, 2
order by 1, 2
EOF
which produces the desired:
0|0|5
0|15|1
5|5|5
10|10|5
15|15|5
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, y, sum(cnt) from (
  select
      floor(x/5)*5 as x,
      floor(y/5)*5 as y,
      count(*) as cnt
    from t
    group by 1, 2
  union
  select *, 0 as cnt from generate_series(0, 15, 5) inner join (select * from generate_series(0, 15, 5))
)
group by x, y
EOF
which outputs the desired:
0|0|5
0|5|0
0|10|0
0|15|1
5|0|0
5|5|5
5|10|0
5|15|0
10|0|0
10|5|0
10|10|5
10|15|0
15|0|0
15|5|0
15|10|0
15|15|5
Typography Updated +Created
SQL aggregate function Updated +Created

There are unlisted articles, also show them or only show them.