Homotopy Updated 2025-07-16
Nitroglycerin Updated 2025-07-16
Nmap Updated 2025-07-16
NNSA laboratory Updated 2025-07-16
SsethTzeentach Updated 2025-07-16
Reviews mostly old RPG and strategy games. And hentai games when it is possible to hide the porn from YouTube. He also sponsors Hentai and uploads it on his website: www.ssethtzeentach.com/nsfw
Ciro Santilli really likes his sense of humor, always going into "politically incorrect" areas, and often making fun of both dictatorships and the USA. He actually knows a bit about politics. Due to the nature of his humour, many of his earlier videos have been taken down from YouTube apparently, www.ssethtzeentach.com/videos mentions:
The videos are also incredibly packed full of well selected edited-in "memes jokes". He particularly likes very short snippets of gay porn which cannot actually be taken down as porn, even though the obviously are porn excerpts, like the buffed dude blowing a kiss to his tit.
www.youtube.com/watch?v=sw8v5__Ytf4 Heroes of Might and Magic III (2018) is one of the best reviews. Sseth likes to find and make fun of game breaking imbalances, something that Ciro likes due to his Ciro Santilli's self perceived creative personality.
www.youtube.com/watch?v=rOJdDvf-tUs The Sseth Streaming Experience (2019), being a live stream, likely shows more realistically how Seth actually talks in real life.
knowyourmeme.com/memes/people/ssethtzeentach gives his profile image from: www.aljazeera.com/features/2012/7/30/the-two-most-loyal-soldiers-in-the-dr-congo
youtu.be/se6Y2o3OqJQ?t=2 shows what could actually be outside of his real window.
Watercraft Updated 2025-07-16
Local group Updated 2025-07-16
Noble Eightfold Path Updated 2025-07-16
This feels so right. Doesn't have to be taken so literally for non-Monks, but all have clear less-extreme applications to non monks.
Nuclear force Updated 2025-07-16
PostgreSQL getting started Updated 2025-07-16
On Ubuntu 20.10 PostgreSQL 12.6, login with
psql
on my default username without sudo fails with: stackoverflow.com/questions/11919391/postgresql-error-fatal-role-username-does-not-existThis is the one that worked on Ubuntu 21.04: stackoverflow.com/questions/11919391/postgresql-error-fatal-role-username-does-not-exist/38444152#38444152Explanation:
sudo -u postgres createuser -s $(whoami)
createdb $(whoami)
You can now run shows that peer authentication is available to all users apparently:
psql
without any password. This works without password due to peer authentication:sudo cat /etc/postgresql/12/main/pg_hba.conf
local all postgres peer
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
List users:output:
psql -c '\du'
List of roles
Role name | Attributes | Member of
-------------+------------------------------------------------------------+-----------
ciro | Superuser, Create role, Create DB | {}
owning_user | | {}
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
Delete user later on:
psql -c 'DROP USER username;'
Help toplevel:
help
List supported SQL commands:
\h
Show syntax for one type of command:
\h SELECT
List all databases:which shows:
psql -c '\l'
Name | Owner | Encoding | Collate | Ctype | Access privileges
-------------+----------+----------+-------------+-------------+-----------------------
ciro | postgres | UTF8 | en_GB.UTF-8 | en_GB.UTF-8 |
postgres | postgres | UTF8 | en_GB.UTF-8 | en_GB.UTF-8 |
template0 | postgres | UTF8 | en_GB.UTF-8 | en_GB.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_GB.UTF-8 | en_GB.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
testdb0 | postgres | UTF8 | en_GB.UTF-8 | en_GB.UTF-8 |
(6 rows)
If you didn't give a database from the command line e.g.:you can do that afterwards with:
psql
\c testdb0
Let's create a table and test that it is working:
psql testdb0 -c 'CREATE TABLE table0 (int0 INT, char0 CHAR(16));'
List tables, no special tables:gives:
psql testdb0 -c '\dt'
List of relations
Schema | Name | Type | Owner
--------+--------+-------+-------
public | table0 | table | ciro
(1 row)
View table schema: stackoverflow.com/questions/109325/postgresql-describe-tableoutput:
psql testdb0 -c '\d+ table0'
Table "public.table0"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
--------+---------------+-----------+----------+---------+----------+--------------+-------------
int0 | integer | | | | plain | |
char0 | character(16) | | | | extended | |
Insert some data into it and get the data out:output:
psql testdb0 -c "INSERT INTO table0 (int0, char0) VALUES (2, 'two'), (3, 'three'), (5, 'five'), (7, 'seven');"
psql testdb0 -c 'SELECT * FROM table0;'
int0 | char0
------+------------------
2 | two
3 | three
5 | five
7 | seven
(4 rows)
Delete the table:
psql testdb0 -c 'DROP TABLE table0;'
Skills Other technologies Updated 2025-07-16
youtube-dl Updated 2025-07-16
Academic publishing Updated 2025-07-16
Cryptocurrency exchange Updated 2025-07-16
Islam Updated 2025-07-16
Skills Programming languages Updated 2025-07-16
Grade | Name | Notes |
---|---|---|
4 | C / C++ | Cheatsheets: C, C++, POSIX C API |
3 | x86 assembly, ELF | Cheatsheet, x86 Paging Tutorial, Bare Metal |
4 | Python | Cheatsheet |
4 | Bash | Cheatsheets: language, POSIX / GNU utils |
4 | HTML, CSS, JavaScript | web technology, Node.js, CoffeScript |
4 | Java | Cheatsheet, school projects |
3 | Ruby, Rails | GitLab contributions, cheatsheets: Ruby, rails-cheat |
3 | GDB | Cheatsheet |
2 | MySQL | Tutorial |
3 | LaTeX, Markdown | LaTeX cheatsheet, Markdown style guide, Markdown Testsuite contributions, Jekyll cheatsheet |
Cytoplasm Updated 2025-07-16
German physics journal Updated 2025-07-16
Lab vs cyclotron X-ray crystallography Updated 2025-07-16
cyclotrons produce the better images, but they are expensive/you have to move to them and order a timeslot.
Lab-based just use some X-ray source from the lab, so it is much move convenient e.g. for a pharmaceutical company doing a bunch of images. The Wikipedia image shows such a self-contained lab system: en.wikipedia.org/wiki/File:Freezed_XRD.jpg
MediaWiki Updated 2025-07-16
Unlisted articles are being shown, click here to show only listed articles.