rm -f tmp.sqlite
sqlite3 tmp.sqlite "create table t (id integer, val integer)"
sqlite3 tmp.sqlite <<EOF
insert into t values
(0, 0),
(1, 5),
(2, 10),
(3, 14),
(4, 15),
(5, 16),
(6, 20),
(7, 25),
(8, 29),
(9, 30),
(10, 30),
(11, 31),
(12, 35),
(13, 40)
EOF
Show how many neighbours each column has with Output:
val
between val - 2
and val + 2
inclusive:sqlite3 tmp.sqlite <<EOF
SELECT id, val, COUNT(*) OVER (
ORDER BY val RANGE BETWEEN 2 PRECEDING AND 2 FOLLOWING
) FROM t;
EOF
0|0|1
1|5|1
2|10|1
3|14|3
4|15|3
5|16|3
6|20|1
7|25|1
8|29|4
9|30|4
10|30|4
11|31|4
12|35|1
13|40|1
val - 1
and val + 1
inclusive instead:sqlite3 tmp.sqlite <<EOF
SELECT id, val, COUNT(*) OVER (
ORDER BY val RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING
) FROM t;
EOF
0|0|1
1|5|1
2|10|1
3|14|2
4|15|3
5|16|2
6|20|1
7|25|1
8|29|3
9|30|4
10|30|4
11|31|3
12|35|1
13|40|1
There seems to be no analogue to HAVING for window functions, so we can just settle for a subquery for once, e.g.:which outputs:
sqlite3 tmp.sqlite <<EOF
SELECT * FROM (
SELECT id, val, COUNT(*) OVER (
ORDER BY val RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING
) as c FROM t
) WHERE c > 2
EOF
4|15|3
8|29|3
9|30|4
10|30|4
11|31|3
Calculus of variations is the field that searches for maxima and minima of Functionals, rather than the more elementary case of functions from to .
Dumping examples under nodejs/sequelize/raw/many_to_many.js.
Not possible without subqueries in the standard syntax, a huge shame: stackoverflow.com/questions/1293330/how-can-i-do-an-update-statement-with-join-in-sql-server
£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.
Still working checks: May 2024.
It allows you to do two things:
Some smart people just brought up to my attention that OurBigBook.com is a bit like: roamresearch.com/ and other graph knowledges. I feel ashemed for not having seen this software and its alternatives before. I was so focused on the "book aspect" of it that I didn't search much in there. I couldn't find an immediate project killer superset from the options in that area, but maybe one exists. We'll see.
The key difficulties of cryptocurrencies are:
- how do transaction fees/guarantees/times compare to centralized systems such as credit cards:Obviously, decentralized currencies cannot be cheaper to maintain than centralized ones, since with decentralization you still have to send network messages at all times, and instead of one party carrying out computations, multiple parties have to carry out computations.
- bitcoin.stackexchange.com/questions/1261/is-it-possible-to-send-bitcoins-without-paying-a-fee "The Blockchain Scalability Problem & the Race for Visa-Like Transaction Speed" (2019)
- towardsdatascience.com/the-blockchain-scalability-problem-the-race-for-visa-like-transaction-speed-5cce48f9d44
Crypto could however be close enough in price to centralized systems that it becomes viable, this can be considered. - how can governments tax cryptocurrency. Notably, because:See also globalization reduces the power of governments.
- taxation has to be progressive, e.g. we have to tax the rich more than the poor, and anonymity in transactions would weaken that
- it would be even easier to move money into fiscal paradises, and then just say, oops, lost my passwords, those coins are actually gone
Until those problems are solved, the only real applications of cryptocurrency will by illegal activities, notably buying drugs, paying for ransomware. But also paying for anti-censorship services from inside dictatorships. Illegal activity can be good when governments are bad, and arguably selling drugs should be legal.
For this reason Ciro Santilli believes that privacy coins like Monero are currently the most useful cryptocurrencies. Also, people concerned with their privacy are likely to more naturally make fewer larger payments to reduce exposure rather than a bunch of small separate ones, and therefore transaction fees matter less, and can be seen as a reasonable privacy tax. Also drugs are expensive, just have a look at any uncensored Onion service search engine, so individual transactions tend to be large.
Hedgint against inflation due to money creation in fiat currencies is a another valid argument for cryptocurrencies. Money printing is a bad form of tax. But why not just instead invest in bonds or stocks, which actually have a specific intrinsic value and should therefore increase your capital and beat inflation? Even if crypto did take over, its value would eventually become constant, and just holding it would lose out to stocks and bonds. And pre-crypto, salaries should adjust relatively quickly to new inflation levels as they come, though there is always some delay. Also, without anonymity, governments will sooner or later find a way to regulate and pervert it. If you want to do things without anonymity, then what you really have to fight for is to change government itself, perhaps with a DAO-like approach, or pushing for a more direct democracy.
If crypto really takes off, 99.99% of people will only ever use it through some cryptocurrency exchange (unless scalability problems are solved, and they replace fiat currencies entirely), so the experience will be very similar to PayPal, and without "true" decentralization.
For those reasons, Ciro Santilli instead believes that governments should issue electronic money, and maintain an open API that all can access instead. The centralized service will always be cheaper for society to maintain than any distributed service, and it will still allow for proper taxation.
Ciro believes that it is easy for people to be seduced by the idealistic promise that "cryptocurrency will make the world more fair and equal by giving everyone equal opportunities, away from the corruption of Governments". Such optimism that new technologies will solve certain key social problems without the need for constant government intervention and management is not new, as shown e.g. at HyperNormalisation by Adam Curtis (2016) when he talks about the cyberspace (when the Internet was just beginning): youtu.be/fh2cDKyFdyU?t=2375. Technologies can make our lives better. But in general, some of them also have to be managed.
In any case, cryptocurrencies are bullshit, the true currency of the future is going to be Magic: The Gathering cards. And Cirocoin.
One closely related thing that Ciro Santilli does think could be interesting exploring right now however, notably when having Monero-like anonymity in mind, would be anonymous electronic voting, which is a pre-requisite to make direct democracy convenient so people can vote more often.
TODO evaluate the possible application of cryptocurrency for international transfers:Of course, the ideal solution would be for governments to just allow for people from other countries to create accounts in their country, and use the centralized API just like citizens. Having an account of some sort is of course fundamental to avoid money laundering/tax evasion, be it on the API, or when you are going to cash out the crypto into fiat. So then the question becomes: suppose that governments are shit and never make such APIs, are international transfers just because traditional banks are inefficient/greedy? Or is it because of the inevitable cost of auditing transfers? E.g. how does TransferWise compare to Bitcoin these days? And if cryptocurrency is more desirable, why wouldn't TransferWise just use it as their backend, and reach very similar fees?
Feynman's first wife, previously his local-high school-days darling. Feynman was like an reversed Stephen Hawking: he married his wife knowing that she had a serious illness, while Hawking's wife married him knowing that as well. Except that in Feynman's case, the disease outcome (tuberculosis) was much more uncertain, and she tragically died in 1945 much earlier while Feynman was at Los Alamos Laboratory, while Hawking, despite his decline, lived much longer.
Feynman first noticed Arline on the beaches on the region of his home in Far Rockaway, in the Queens, New York, near Long Beach. She lived a bit further inland in Cedarhurst. Arline was beautiful and boys competed for her, but Richard persisted, stalking her at an after-school social league sponsored by the local Synagogue and joining an art class she went to, until he eventually won it out. The region was highly Jewish, and both were from Jewish families, as also suggested by their family names.
Reading about her death e.g. at Genius: Richard Feynman and Modern Physics by James Gleick (1994) is a major tearjerker, it's just too horrible. The book mentions on chapter "The Last Springtime" that at last, during the last months of her life, after much hesitation, they did fuck in the sanatorium Arline where was staying at in Albuquerque, the nearest major city to Los Alamos (154 km), despite the risk of Feynman being infected, which would be particularly serious given that Feynman would be in constant contact with students and possibly infect others as part of his career as a researcher/teacher. Feynman would visit her on weekends by bus, and stay in Los Alamos during the week.
Arline finally died on June 16th 1945, exactly one month before the Trinity nuclear test was carried out. The atomic bombings of Hiroshima and Nagasaki were a little later on 6 and 9 of August 1945.
On one of his last trips to Oak Ridge town late 1945, after her death, Feynman walked past a shop window and saw a pretty dress. He thought to himself, "Arline would have liked that", and the reminder made him cry for the first time after Arline's death.
It is even sadder to think that the first antibiotics for tuberculosis, streptomycin, finished its first major clinical trial at around 1948, not long after her death.
Ciro Santilli considers this tragedy a cause of Feynman was a huge womanizer during a certain period of his life.
Richard Feynman with his first wife Arline Greenbaum
. Source. TODO date, location, original source.Abacus scene from the film Infinity (1996)
Source. The film suggests that Feynman and Arline fucked a lot before the final Los Alamos fuck, that fuck story from book being only "fuck after tuberculosis diagnosis", after which they had to slow it down a bit.
This is likely true given how long they had been together for at that point. Ciro Santilli is such a pure soul for not having thought that! They were not very conservative at all those two.
Also their wedding got slowed down because there was a clause in Feynman's scholarship at Princeton University stating that the recipient could not be married, those were different times altogether.
Cirism is totally not a cult, has been officially verified to be compatible with all major world religions.
Enlightened Cirists donate money to the cause at: Section "Sponsor Ciro Santilli's work on OurBigBook.com". It is totally optional of course, your soul will just be eternally damned if you don't.
Ciro Santilli once proclaimed:
Thou shalt eat thy watermelon in the morning, and thy melon in the evening. Thou shalt not eat thy watermelon in the evening, nor shalt thou eat thy melon in the morning.
There are unlisted articles, also show them or only show them.