No they don't require a network at all. The only drawback if there is no network is that the initial finding of the position takes longer. And maps can be downloaded so that they are available offline.
GPS receiver have been working without a "web connection" for ages (e.g. Garmins outdoor devices).
I use my smartphone in "airplane" mode but GPS enabled when hiking. No problems whatsoever.
> If you want something that is more like actual recursion (I.e., depth-first), Oracle has CONNECT BY which does not require the same kind of tracking. It also comes with extra features to help with cycle detection, stack depth reflection, etc.
All that is supported with CTEs as well. And both Postgres and Oracle support the SQL standard for these things.
You can't choose between breadth first/depth first using CONNECT BY in Oracle. Oracle's manual even states that CTE are more powerful than CONNECT BY
Some people are investigated because they spread lies, insults and threats. Things that would be investigated (and punished) as well, if done "off line".
The freedom of speech does not mean "freedom to harass, threat or insult people".
The oppression of free speech seems to be happening much more in the USA, where you are not allowed to criticize the politics of the ruling party any more.
So what's his "Drill, baby, drill" about? He thinks renewable energy is the something sent by the anti-christ. The only energy source he accepts is burning fossil fuels or nuclear power.
I have seen a lot of people sort by (generated) integer values to return the rows "in creation order" assuming that sorting by an integer is somehow magically faster than sorting by a proper timestamp value (which give a more robust "creation order" sorting than a generated integer value).
But you were always allowed to run your own benchmarks internally.
Back then, you could have installed 10gR1 and 10gR2 and compare the sort performance on identical data sets and queries.