Ciro Santilli @cirosantilli  40

£112.99

Buying October 2023 as an immediate backup phone after the Google Pixel 3a (2020) touchscreen died, and Motorola Moto G6 Play (2018) wouldn't connect to giffgaff.

June 2026: screen stopped working, unknown cause, was seeing low usage. Android splash, Vertical lines and flashing on power on, then black. Didn't manage to recover.

Still working checks: May 2024.

This mini-project walks the category hierarchy Wikipedia dumps and dumps them in various simple formats, HTML being the most interesting!

Scripts used:

Ciro Santilli has enjoyed doing projects dealing with with lots of data! They usually have a large overlap with Ciro Santilli's naughty projects, but not always!

Here we list public domain academic papers. They must be public domain in the country of origin, not just the US, which had generally less stringent timings with the 95 year after publication rule rather than life + 70, which often ends up being publication + 110/120. Once these are reached, they may be upload to Wikimedia Commons!

The Planck's law paper.

hermes.ffn.ub.es/luisnavarro/nuevo_maletin/Planck%20(1900),%20Distribution%20Law.pdf contains a replica of the translation present in The Old Quantum Theory by Dirk ter Haar (1967).

Related: stackoverflow.com/questions/32026398/transform-sql-insert-script-into-csv-format

Example under: nodejs/sequelize/raw/tree.js

Often known simply as SQL Server, a terrible thing that makes it impossible to find portable SQL answers on Google! You just have to Google by specific SQL implementation unfortunately to find anything about the open source ones.

Minimal example: nodejs/sequelize/raw/recursive.js

More advanced SQL tree traversal examples: nodejs/sequelize/raw/tree.js

PostgreSQL docs: www.postgresql.org/docs/16/queries-with.html#QUERIES-WITH-RECURSIVE