Quantum approximate optimization algorithm Updated 2025-07-16
TODO clear example of the computational problem that it solves.
MiniGo Updated 2025-07-16
tket Updated 2025-07-16
AlphaGo Zero open source implementation Updated 2025-07-16
Upsert with
NOT NULL column Updated 2025-07-16Attempt at nodejs/sequelize/raw/upsert.js:
- stackoverflow.com/questions/48816629/on-conflict-do-nothing-in-postgres-with-a-not-null-constraint OP unable to provide a minimal exampe, but it is likely the problem
- dba.stackexchange.com/questions/292428/postgresql-upsert-issue-with-not-null-columns
DELETE with JOIN (SQL) Updated 2025-07-16
Demo under: nodejs/sequelize/raw/many_to_many.js.
NO way in the SQL standard apparently, but you'd hope that implementation status would be similar to UPDATE with JOIN, but not even!
- PostgreSQL: possible with
DELETE FROM USING: stackoverflow.com/questions/11753904/postgresql-delete-with-inner-join - SQLite: not possible without subqueries as of 3.35 far: stackoverflow.com/questions/24511153/how-delete-table-inner-join-with-other-table-in-sqlite, Does not appear to have any relevant features at: www.sqlite.org/lang_delete.html
ORM
- Sequelize: no support of course: stackoverflow.com/questions/40890131/sequelize-destroy-record-with-join
Ubuntu 23.04 boot broken on kernel 6.2 Updated 2025-07-16
The solution on kernel 6.2 was:as per comments under: bugs.launchpad.net/ubuntu/+source/linux/+bug/2012559. This also made the nvidia driver work: Find GPU information in Ubuntu.
sudo apt instal nvidia-driver-515Previously I had:and it blew up before reaching disk decryption.
nvidia-driver-510I also tried:but that broke in a different way:
nvidia-driver-525Finished apport-autoreport.service - Process error reports when automatic reporting is enabled.
nvidia-modeset: ERROR: GPU:0: Idling display engine timed out: 0x0000947d:0:0:407
(1 of 2) Job systemd-backlight@backlight: nvidia_e.service/start running (32s no limit) Deepmind soccer simulation Updated 2025-07-16
SQL TRIGGER in Sequelize Updated 2025-07-16
Example: nodejs/sequelize/trigger_count.js
There is of course no built-in support for SQL TRIGGERs in Sequelize, but we can add our own: stackoverflow.com/questions/29716346/how-to-create-a-trigger-in-sequelize-nodejs/76215728#76215728
python/getitem_complex.py Updated 2025-07-16
python/getitem.py Updated 2025-07-16
PostGIS Updated 2025-07-16
The third part module, which clutters up any serches you make for the built-in one.
PostgreSQL GIST Updated 2025-07-16
The highly underdocumented built-in module, that supports SQL spatial index and a lot more.
Quite horrendous as it only seems to work on geometric types and not existing columns. But why.
And it uses custom operatores, where standard operators would have been just fine for points...
Minimal runnable example with points:The index creation unfortunately took 100s, so it will not scale to 1B points very well whic his a shame.
set -x
time psql -c 'drop table if exists t'
time psql -c 'create table t(p point)'
time psql -c "insert into t select (point ('(' || generate_series || ',' || generate_series || ')')) from generate_series(1, 10000000)"
time psql -c 'create index on t using gist(p)'
time psql -c "select count(*) from t where p <@ box '(1000000,1000000),(9000000,2000000)'" Lumai Updated 2025-07-16
Funding:
- 2023: 1.1m pounds www.uktech.news/deep-tech/lumai-grant-20230215
Celestial AI Updated 2025-09-09
Quantum optimization algorithm Updated 2025-07-16
Variational quantum eigensolver Updated 2025-07-16
TODO clear example of the computational problem that it solves.
NeuroMechFly Updated 2025-07-16
Zebrafish Updated 2025-07-16
Mudfish Updated 2025-07-16
There are unlisted articles, also show them or only show them.