OpenStreetMap SQLite Experiment

This is an experiment to conduct some investigations if (and how) it is possible to load the OpenStreetMap planet.pbf data into an SQLite database.
A new planet file seems to be created weekly, each friday.
The size of the planet file is (2024-05-24) 75 MB. The size of the SQLite DB is, including indexes and some precalculated tables, a little more than 1 TB.

Statistics
Keys with one value only

Query nodes, ways and/or relation with their id.

Parametrized queries:

Nodes related to ISO-3166-1 (countries)
Relations related to swisstopo

Things in OSM that are unclear to me.

TODO

SQLite version: 3.40.1
IP = 142.132.251.39