Moon Updated 2025-07-16
MySQL Updated 2025-07-16
Login without password: askubuntu.com/questions/915585/how-to-login-mysql-shell-when-mysql-have-no-passwordworks on Ubuntu 20.10.
sudo mysqlCreate user for further logins without
sudo askubuntu.com/questions/915585/how-to-login-mysql-shell-when-mysql-have-no-password/1325689#1325689:sudo mysql -e "CREATE USER $USER"Run command from CLI stackoverflow.com/questions/1602904/how-do-you-run-a-single-query-through-mysql-from-the-command-line
mysql -e 'SHOW DATABASES'Create test user with password:and login as that user:Login with password given on the command line:The
sudo mysql -e 'CREATE USER user0 IDENTIFIED WITH mysql_native_password BY "a"'
sudo mysql -e 'GRANT ALL PRIVILEGES ON database_name.* TO "user0"'mysql -u user0 -pmysql -u user0 -pmypasswordIDENTIFIED WITH mysql_native_password part is to overcome "Client does not support authentication protocol requested by server" when connecting from Node.js.List users:
sudo mysql -e 'SELECT * FROM mysql.user'View permissions for each user on each DB: serverfault.com/questions/263868/how-to-know-all-the-users-that-can-access-a-database-mysql
sudo mysql -e 'SELECT * FROM mysql.db'List databases:
sudo mysql -e 'SHOW DATABASES'Create database:
sudo mysql -e 'CREATE DATABASE mydb0'Destroy database:
sudo mysql -e 'DROP DATABASE mydb0' Neil Fernandez Updated 2025-07-16
Article likely written by him: www.theguardian.com/commentisfree/2010/feb/22/home-schooling-register-families
“Especially my father. He was doing most of it and he is a savoury, strong character. He has strong beliefs about the world and in himself, and he was helping me a lot, even when I was at university as an undergraduate.”An only child, Arran was born in 1995 in Glasgow, where his parents were studying at the time. His father has Spanish lineage, having a great grandfather who was a sailor who moved from Spain to St Vincent in the Carribean. A son later left the islands for the UK where he married an English woman. Arran’s mother is Norwegian.
One of the articles says his father has a PhD. TODO where did he work? What's his PhD on? Photo: www.topfoto.co.uk/asset/1357880/
www.thetimes.co.uk/article/the-everyday-genius-pxsq5c50kt9:
Network switch Updated 2025-07-16
A switch is a box with a bunch of Ethernet wires coming into it:Except that it doesn't have to be Ethernet, e.g. it would also be a Wi-Fi.
+--------------------+
| +-+ +-+ +-+ +-+ |
| |1| |2| |3| |4| |
| +-+ +-+ +-+ +-+ |
+--------------------+What the switch does is:
After the destination is found, a confirmation is somehow sent back to the switch, which then learns which wire to send each MAC address to.
A switch is a bit like a router but it is a bit dumber/operates at a lower level: it basically operates only on MAC addresses, not on IP addresses.
The Internet service provider boxes most people have at home combines a switch for the local network and a router for the ISP communication.
Nick Leeson Updated 2025-07-16
Good documentary about it: Nick Leeson and the Fall of the House of Barings by Adam Curtis (1996).
One is reminded of Annie Dookhan.
One-form Updated 2025-07-16
www.youtube.com/watch?v=tq7sb3toTww&list=PLxBAVPVHJPcrNrcEBKbqC_ykiVqfxZgNl&index=19 mentions that it is a bit like a dot product but for a tangent vector to a manifold: it measures how much that vector derives along a given direction.
Onion service Updated 2025-07-16
This is a way to host a server that actually hide the IP of the server from the client, just like Tor hides the IP of the client from the server. Amazing tecnology!
This is why it enables hosting illegal things like the Silk Road: law enforcement is not able find where the server is hosted, and take it down or identify the owner.
Online forums that lock threads after some time Updated 2025-07-16
And of course, 4chan just takes that to a whole new level, usually closing on the same day, and then getting deleted within a week. Why would anyone contribute non-illegal content to that king of system?!
Ridiculous, so when new information comes out, we just duplicate all the old comments on a new thread again?
Remember, Ciro Santilli is the Necromancer God.
silkqin.com Updated 2025-07-16
Holy crap amazing list of Guqin pieces by the guy for MP3 download! www.silkqin.com/06hear.htm And the explanations are insane. What a dude. Ciro Santilli's hero.
Download all MP3:
wget -r -np -l 1 -A mp3 http://www.silkqin.com/06hear.htmCiro Santilli Contacted John by email in 2019 telling him to put his stuff on YouTube and offering help, and he replied, but nothing came of it unfortunately. Edit: he uploaded a bunch of videos of him playing live in 2020! www.youtube.com/user/silkqin/videos
John focuses on playing the tunes in a "historically informed performance", in particular using silk strings rather than metal ones which are used by most modern artists: www.silkqin.com/08anal/hip.htm
Dialog between Fisherman and Woodcutter performed by John Thompson (2020)
Source. OpenStreetMap Updated 2025-07-16
E.g., as of 2020, their help login help.openstreetmap.org/ shows MyOpenID as an option, which was discontinued in 2014, and not Google OAuth.
They do still seem to have a bit more activity than gis.stackexchange.com/questions/tagged/openstreetmap on Stack Exchange.
Complaints:
- Transliteration is off by default!...... wiki.openstreetmap.org/wiki/Translation You just have to learn all scripts ever. Good luck with the Chinese characters. Genius.
- In order to see information about places, you have to click "Query features" on the toolbar first. Who made such a terrible UI? Direct click is a much, and so easy to implement?
- It is impossible to discern different types of paths and other walking path symbols, the symbols are too small, and just scale down to a line no matter how much you zoom in.
- Power lines are way too visible. While that is kind of cool, it is useless and distracting to most people most of the time.
- No street-level imagery...: help.openstreetmap.org/questions/1178/adding-photos
- No aerial imagery: help.openstreetmap.org/questions/6849/how-can-i-see-the-aerial-imagery-without-editing-the-map But that is kind of understandable, as that one might not be free.
- No restaurant ratings: help.openstreetmap.org/questions/64852/ratings-for-pois because it is "Subjective". OMG those people, such a huge value powerhouse wasted.
Open University Updated 2025-07-16
Not really dedicated to open source course material, nor to free courses...
The "Open" in its name only made sense in the 60's, when it was founded, nowadays, there isn't much about this institution that is very different compared to traditional Oxbridge. "Cheap more online university" would be a more adequate name for it.
A system that would truly live up to the name "Open" in the year 2020 is the one described at the ideal university by Ciro Santilli.
Wikipedia even says that the initial focus was on broadcasting learning material on television and radio, so what happened to that now that we have an even more powerful on-demand tool called Internet!
They even created their own MOOC website, FutureLearn. But www.freecodecamp.org/news/massive-open-online-courses-started-out-completely-free-but-where-are-they-now-1dd1020f59/ mentions:OMG. God why.
The course content is still free to access, but it’s only available for the duration of the course, and for two weeks after it ends.
A few open sources at: www.open.edu/openlearn/free-courses. The 5-hour course on particle physics says it all. Stated as of 2023 at www.open.ac.uk/about/open-educational-resources/openlearn/free-learning:
www.youtube.com/watch?v=Pj0rbafFBak What's an Open University Degree Like? by Luke Cutforth (2021) mentions that it is more autodidactic/online, and it encourages part time learning.
youtu.be/rsWwffX-u0A?t=99 Open University - How does it work? by Matt Greg Vlogs (2017) shows that they do have their own custom institutional material. And it is not open???? Please. youtu.be/rsWwffX-u0A?t=222 mentions that there is no entry exam, and you can change your courses at any time, that is good at least.
Israel apparently also created their own version in the 70's inspired by the British one: Open University of Israel. Same story it seems.
OurBigBook.com Consulting Updated 2025-07-16
Start with consulting for universities to get some cash flowing.
Help teachers create perfect courses.
Choose a domain of knowledge, generate perfect courses for it, and find all teachers of the domain in the world who are teaching that and help them out.
Then expand out to other domains.
TODO: which domain of knowledge should we go for? The more precise the better.
- maths is perfect because it "never" changes. But does not make money.
- computer science might be good, e.g. machine learning.
OurBigBook.com Knowledge graph editors Updated 2025-07-16
A list of reviews of such systems is maintained at:
This is the class of existing software the perhaps comes the closest to OurBigBook, in particular systems such as:
- Roam Research and its open source clone Foam
- Forester
While we believe that OurBigBook can hold its own against most of them as a personal knowledge base, there is one feature which we believe truly distinguishes OurBigBook from all others in a big way: trustless mind meld with the OurBigBook topic feature, which no other system seems to have.
Many such systems are also no publishing focused enough, and are more focused only in maintaining people's private knowledge bases. Some of them don't even have publishing at all, or its complicated. While publishing is optional in OurBigBook, it is a crucial feature and extremely well supported.
OurBigBook.com Knowledge market Updated 2025-07-16
Teachers have the incentive of making open source to get more students.
Students pay when they want help to learn something.
OurBigBook.com Wikipedia Updated 2025-07-16
- you don't get any/sufficient recognition for your contributions. The closest they have to upvotes and reputation is the incredibly obscure "thank" feature which is only visible to the receiver itself: en.wikipedia.org/wiki/Help:Notifications/Thanks
- deletionism is a tremendous problem on Wikipedia, for two main causes:The stuff you wrote can be deleted anytime by some random admin/opposing editor, examples at: Section "Deletionism on Wikipedia".
- tutorial-like subjectivity
- notability
- Scope too limited, and politics defined. Everything has to sound encyclopedic and be notable enough. This basically excludes completely good tutorials.
- Insane impossible to use markup language-base talk pages instead of issue trackers?! Ridiculous!!! That change alone could make Wikipedia so much more amazing. Wikipedia could become a Stack Exchange killer by doing that alone + some basic reputation system. Some work on that is being done at: www.mediawiki.org/wiki/Extension:DiscussionTools, already in Beta as of 2022.
- Edit wars
How to use an Oxford Nanopore MinION to extract DNA from river water and determine which bacteria live in it Filtration with vacuum pump Updated 2025-07-16
The first thing we did was to filter the water samples with a membrane filter that is so fine that not even bacteria can pass through, but water can.
Therefore, after filtration, we would have all particles such as bacteria and larger dirt pieces in the filter.
From the 1 liter in each bottle, we only used 400 ml because previous experiments showed that filtering the remaining 600 ml is very time consuming because the membrane filter gets clogged up.
Therefore, the filtration step allows us to reduce those 400 ml volumes to more manageable Eppendorf tube volumes: Figure 1. "An Eppendorf tube". Reagents are expensive, and lab bench centrifuges are small!
Labelled Eppendorf tubes on a rack
. Source. Since the filter is so fine, filtering by gravity alone would take forever, and so we used a vacuum pump to speed thing up!
For that we used:
Peeling the vacuum pump filter protection peel before usage
. Source. 
Placing the vacuum pump filter
. Source. How to use an Oxford Nanopore MinION to extract DNA from river water and determine which bacteria live in it Post filtration purification Updated 2025-07-16
After filtration, all DNA should present in the filter, so we cut the paper up with scissors and put the pieces into an Eppendorf: Video 1. "Cutting vacuum pump filter and placing it in Eppendorf".
Cutting vacuum pump filter and placing it in Eppendorf
. Source. Now that we had the DNA in Eppendorfs, we were ready to continue the purification in a simpler and more standardized lab pipeline fashion.
First we added some small specialized beads and chemicals to the water and shook them Eppendorfs hard in a Scientific Industries Inc. Vortex-Genie 2 machine to break the cell and free the DNA.
Once that was done, we added several reagents which split the solution into two phases: one containing the DNA and the other not. We would then pipette the phase with the DNA out to the next Eppendorf, and continue the process.
In one step for example, the DNA was present as a white precipitate at the bottom of the tube, and we threw away the supernatant liquid: Figure 1. "White precipitate formed with Qiagen DNeasy PowerWater Kit".
At various stages, centrifuging was also necessary. Much like the previous vacuum pump step, this adds extra gravity to speed up the separation of phases with different molecular masses.
Then, when we had finally finished all the purification steps, we measured the quantity of DNA with a Biochrom SimpliNano spectrophotometer to check that the purification went well:
How to use an Oxford Nanopore MinION to extract DNA from river water and determine which bacteria live in it Pre-sequencing preparation Updated 2025-07-16
One cool thing we did in this procedure was to use magnetic separation with magnetic beads to further concentrate the DNA: Figure 1. "GE MagRack 6 pipetting.".
The beads are coated to stick to the DNA, which allows us to easily extract the DNA from the rest of the solution. This is cool, but bio people are borderline obsessed by those beads! Go figure!
Then we prepared the DNA for sequencing with the Oxford Nanopore specific part: Oxford Nanopore SQK-LSK109 Ligation Sequencing Kit.
Path integral formulation Updated 2025-07-16
This one might actually be understandable! It is what Richard Feynman starts to explain at: Richard Feynman Quantum Electrodynamics Lecture at University of Auckland (1979).
The difficulty is then proving that the total probability remains at 1, and maybe causality is hard too.
The path integral formulation can be seen as a generalization of the double-slit experiment to infinitely many slits.
Feynman first stared working it out for non-relativistic quantum mechanics, with the relativistic goal in mind, and only later on he attained the relativistic goal.
TODO why intuitively did he take that approach? Likely is makes it easier to add special relativity.
This approach more directly suggests the idea that quantum particles take all possible paths.
There are unlisted articles, also show them or only show them.