List topics on home page Updated +Created
The new default homepage for a logged out user how shows a list of the topics with the most articles.
This is a reasonable choice for default homepage, and it immediately exposes users to this central feature of the website: the topic system.
Doing this required in particular calculating the best title for a topic, since it is possible to have different titles with the same ID, the most common way being with capitalization changes, e.g.:
JavaScript
Javascript
would both have topic ID javascript.
With this in place we also added the preferred topic title to the top topic page.
The algorithm chosen is to pick the top 10 most upvoted topics, and select the most common title from amongst them. This should make topic title vandalism quite hard. This was made in a single SQL query, and became the most complext SQL query Ciro Santilli has ever written so far: twitter.com/cirosantilli2/status/1549721815832043522
Figure 1.
Screenshot showing the list of topics
. The page is: ourbigbook.com for the logged out user, ourbigbook.com/go/topics for the logged in user.
Figure 2.
Screenshot showing a topic page
. The page is: ourbigbook.com/go/topic/vector-space. Before this sprint, we didn't have the "Vector Space" at the top, as it wasn't necessarily trivial to determine what the preferred title would be.
Sport Updated +Created
SQL example Updated +Created
We have some runnable SQL examples with assertion under the sequelize/raw directory.
These examples are written in the Sequelize library using raw queries.
Sequelize is used minimally, just to feed raw queries in transparently to any underlying database, and get minimally parsed results out for us, which we then assert with standard JavaScript. The queries themselves are all written by hand.
By default the examples run on SQLite. Just like the examples from sequelize example, you can set the database at runtime as:
  • ./index.js or ./index.js l: SQLite
  • ./index.js p: PostgreSQL. You must manually create a database called tmp and ensure that peer authentication works for it
Here we list only examples which we believe are standard SQL, and should therefore work across different SQL implementations:
SsethTzeentach Updated +Created
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:
Ever since going full time, I'm usually very clean and stay out of trouble, but in the past a fair number of my videos were taken down.
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.
www.youtube.com/watch?v=yG9g2byXR2c Might and Magic VI (Re)Review is another good video (2021)
Sseth has a certain vaporwave aesthetic, which Ciro also enjoys.
youtu.be/se6Y2o3OqJQ?t=2 shows what could actually be outside of his real window.
Stack Overflow Updated +Created
The best place to get answers to programming questions as of 2019. Google into Stack Overflow is always the best bet.
An overview of Ciro Santilli's Stack Overflow contribution can be found at: Ciro Santilli's Stack Overflow contributions.
Figure 1.
Stack Overflow in a nutshell
. Source.
As the "WTF look at my points" guy, Ciro Santilli approves of this meme. A few more elements could be added, notably deletion of the last link-only answer, but good enough.
By the profile image, the "Grammar Nazi" editor is actually appropriately the notorious serial editor Peter Mortensen. Ciro Santilli welcomes grammar fixes, but more subjective style fixes can be a bit annoying.
Figure 2.
Catching mice by Nakanoart
. Possible non-canonical source: twitter.com/nixcraft/status/1376023938749190147
Stack Overflow content deletion Updated +Created
Stack overflow allows deleting content/making it visible only to 10k rep users.
Ciro Santilli is strictly against this, and this is an intended core policy of OurBigBook.com.
If you delete people's content randomly, they will be much less likely to write anything.
Getting downvoted to oblivion is one thing, but data loss? Unacceptable.
Only illegal content must ever be deleted. Or extremely obvious spam. But anything in a gray area should never be removed.
Deletion can be done by either:
  • votes of high reputation users
  • moderators
  • or worse of all, which happens often on the smaller websites: auto-deletion because come content has not received enough views/votes above some treshold! stackoverflow.com/help/auto-deleted-questions. The most illogical thing of all is that the question is not even permanently removed from the system, only hidden from other/low reputation users! So it does not save any disk space at all! Mind blowing!
Stack Overflow is doomed Updated +Created
Stack Overflow does have an super naive reputation and moderation system and overly restrictive subject matter, which Ciro Santilli wants to improve upon with OurBigBook.com.
However, it is the best that we have now, and if you use it like Ciro, you won't get tired:
  • monitor only rare tags that you know a lot about, let others answer duplicates on big tags for you
  • only answer on bigger tags when you find a better answer than can be found on the page
  • accept that sometimes things are bound to go wrong, that reputation is meaningless, and move on
What else would you expect from a naive algorithm system that has 10 million newbies asking stuff?
The key problem of Stack Overflow is closurism. The answer close feature is just not made for purpose. The sole purpose of "closing" should be to prevent easy reputation farming. What it should do instead, is remove points gained from duplicates and off topic questions. But it should not prevent new answers. The disk space costs nothing, and Google doesn't care about the closed status of a question.
As of 2024, the only competitor of Stack Overflow is Reddit (besides LLMs, which do nothing but extract data from those two and other sites). Reddit removed the mandatory thread locking after 6 months, but still lacks the Q&A focus required for greatness. Its community however is much more chill and doesn't close and downvote the fuck out of everything.
Stack Overflow users Ciro Santilli dislikes Updated +Created
Nothing personal, just Ciro Santilli strongly disagrees with the moderation philosophies of these users.
One particular type of user Ciro particularly dislikes are those who do more moderation than content. Ciro finds it very hard to understand why some people spend so much time moderating. Maybe that's how politicians exist, some people just like that kind of activity.
The moderators tend to have lower intermediate rep. They spend too much time moderating and too little time coding.
Star Trek: The Next Generation Updated +Created
Ciro Santilli likes this.
He doesn't have the patience to actually watch full episodes with rare exceptions, rather just watching selected scenes from: www.youtube.com/channel/UCdeIGY2DIjpGf0A2m9GSE3g, but still, it is interesting.
What appeals to Ciro in this series is how almost nothing is solved by violence, almost everything is decided in the bridge, at the "cerebral" level of the command structure. This reminds Ciro of a courtroom of law sometimes.
Maybe there's also a bit of 90's nostalgia involved too though, as this is something that would show on some random cable channels a bored young Ciro would have browsed during weekends, never really watching full episodes.
One crime of many episodes is being completely based on some stupid new scientific concept, which any character to back it up.
Another thing that hurt is that due to their obsession with the senior members of the crew, sometimes those senior members are sent in ridiculously risky operations, which is very unrealistic.
Episodes that Ciro watched fully and didn't regret:
Semi worth it:
Not worth it:
  • Cause and effect
TODO
  • s06e11 Chain of command
Stephen Hawking Updated +Created
While learning black-hole stuff is not on top of Ciro Santilli's priorities, Hawking's spirit is to be admired.
To never give up even when everything seems lost, and still have a sense of humour is respectable.
An ex-physicist colleague who had met Hawking told an anecdote. Hawking was around in the department one day, they said hi and all. But then Hawking wanted to tell a joke. It took like 5 minutes of typing, and you can imagine that things were pretty awkward and the joke's timing was "a bit off". But Hawking did tell the joke nonetheless.
This is also suggested in the The Theory of Everything (2014) film, and therefore likely the biographies.
Steve Jobs Updated +Created
Co-founder of Apple.
Is Jobs evil? Is he interesting? Undoubtedly.
Good quotes:
Evil deeds:
Steve Wozniak plays magic the gathering Updated +Created
Street reclamation Updated +Created
Only people who need to drive a car should be allowed to drive a car anywhere near a city, e.g. people who work door to door, people who are disabled, etc.
Countryside driving is fine. If going to a city, you just have to drive to a parking outside of the city where you then take the public transport. And those who live in cities must leave their cars there too.
Everyone else must walk or cycle from home to public transport.
Cars just destroy everything, they make everything ugly:
  • this was extremely clear to Ciro Santilli as a cyclist. He previously lived in a place with few cars and the countryside was so pleasant. Then he moved to a place with more cars and it was shocking. It's a mixture of pollution, noise, and the fact that roads cut up the countryside that just make things not pleasant at all. Dual lane roads in particular are just a terrible thing. You can hear them from afar, much before you see them.
    You can just see as tiny little villages surrounding the bit city and it's oversized motorways are more or less homogenized into one big city mass, the process is clearly visible as you cycle out of the big city and the villages become nicer and more unique as you go along further out.
  • even within cities, cars completely dehumanize the streets. For example, Ciro once lived in a small dead end street, and he would have gladly opened his front window more often to meet the neighbours. But just the noise of cars passing by every so often makes it impractical to work like that.
The Zatoichi effect applies well to the problem of cyclists:
  • they are not really pedestrians, and pedestrian paths are not suitable to them because they are too narrow, of not smooth, or curved. But pedestrians will always have enough political power to have their paths, because they live around the paths
  • they are not really motor vehicles, because motor vehicle paths are too wide and too fast for them. But motor vehicles will always have enough political power to have their paths, because people are lazy and stupid, and because as the world stands, individually you just don't have any reasonable choice to go anywhere.
This is the main drama faced by cyclists.
Lobbying groups:
Video 1.
Why isn't cycling normal in London? by Jay Foreman (2018)
Source.
Students must have a flexible choice of what to learn Updated +Created
This is one of the main reasons why Ciro Santilli invested in OurBigBook.com.
Ciro believes that the only thing students must be forced to learn is to speak read and write English and that a teacher's main job after that is to help students find their next big goals and also ties into the backward design philosophy.
Everything else, the student must choose.
This idea is generally known as self-directed learning.
This is most notable in University entry examinations of poor countries, where students often have to waste one extra year of their lives to go through preparation for the useless university entry exams. And then, surprise surprise, if they actually get in, they find that this is not what they really wanted to do, and they just go through to the end miserably because they understandably they don't want to risk another year of their lives.
Ciro saw this first hand École Polytechnique which was way freer than his university in Brazil.
Steve Jobs's university dropout stories from Steve Jobs' 2005 Stanford Commencement Address also come to mind.
Video 1.
The Purpose of Education by Noam Chomsky (2012)
Source.
  • 0:00 discusses education as a system of indoctrination: indoctrination for people to comply with the Establishment and pass tests, vs the Age of Enlightenment in which education should help you achieve your own intellectual/life goals. He suggests without specific evidence that after the 60's there was explicit intervention in the US to increase the indoctrination aspect, of which debt is a part.
  • 15.45: assessment vs autonomy: exams are useless, except as a tool to help improve teaching and self assess. Tells anecdote about little girl who wanted to learn more about a subject, asked teacher how to learn more, teacher said you can't, you have to study for this useless national exam instead which will determine your future, and if I'm rehired or not.
Godfrey Hounsfield, 1979 Nobel Prize in Physiology and Medicine:[ref]
They tried hard to educate me but I responded only to physics and mathematics
Suikoden Updated +Created
This game (1 or 2, can't remember) made an impression on Ciro Santilli for some reason.
Only many many years after playing it, after Ciro started getting more interested, did he learn that it was actually an adaptation of the Chinese mega-classic Water Margin.
"Suikoden" is the actual Japenese transliteration for the Chinese name of the original Water Margin novel.
The game puts great emphasis on the concept of the 108 Stars of Destiny, which never left Ciro's mind: making 108 allies, the main collectible of the game, allows you to make a more powerful alliance, and unlock better endings.
Sun Microsystems Updated +Created
Although Ciro Santilli is a bit past their era, there's an aura of technical excellence about those people. It just seems that they sucked at business. Those open source hippies. Erm, wait.
Bibliography:
Video 1.
The Dawn and Dusk of Sun Microsystems by Asianometry (2022)
Source. One of the main inspirations for the creation of their workstations were CAD applications.
Super Mario 64 Updated +Created
And as a result, adult Ciro really enjoys tool-assisted speedruns of the game.
Super Mario 64 reverse engineering project Updated +Created
OMG, both of those just fucking work on Ubuntu 20.04 with README instructions, it is unbelievable, those people don't have lives. And it builds the ROM byte by byte equal from source!
There are a few different versions:
Tested with the USA ROM at sha1sum 9bef1128717f958171a4afac3ed78ee2bb4e86ce (you need a ROM to extract assets, which the project automates), which is also documented in the project itself: github.com/sm64-port/sm64-port/blob/6b47859f757a40096fedd6237f2bc3573d0bc2a4/sm64.us.sha1. Disclaimer: Ciro Santilli owns a copy of Super Mario 64.
The only dependency missing from Ubuntu packages is the IRIX QEMU user mode which they need for their tooling. The project also has a QEMU fork for that, and provide a working deb.
From this project it was also noticed that certain ROM releases were not compiled with optimizations enabled, presumably because as a release title the compiler had optimization bugs! www.resetera.com/threads/so-apparently-the-ntsc-build-of-mario-64-didnt-use-any-compiler-optimizations.166277/ But now they do have a working compiler, and by turning that switch FPS increases in certain levels!!!
It is good to know that this game will "never die".
Some quick stupid patches:
  • jump really high:
    diff --git a/src/game/mario.c b/src/game/mario.c
    index 5b103fa..83c9f40 100644
    --- a/src/game/mario.c
    +++ b/src/game/mario.c
    @@ -826,7 +826,7 @@ static u32 set_mario_action_airborne(struct MarioState *m, u32 action, u32 actio
             case ACT_JUMP:
             case ACT_HOLD_JUMP:
                 m->marioObj->header.gfx.unk38.animID = -1;
    -            set_mario_y_vel_based_on_fspeed(m, 42.0f, 0.25f);
    +            set_mario_y_vel_based_on_fspeed(m, 200.0f, 0.25f);
                 m->forwardVel *= 0.8f;
                 break;
Interesting entry points:
  • src/game/game_init.c
TODO: enable the level select debug feature! tcrf.net/Super_Mario_64_(Nintendo_64)/Debug_Content#Classic_Debug_Display They actually shipped quite a few debug features into the retail game, and they have been reversed too. I tried this but it didn't work (or I don't know how to enable the level select menu):
diff --git a/src/game/main.c b/src/game/main.c
index 9e53e50..b7443a8 100644
--- a/src/game/main.c
+++ b/src/game/main.c
@@ -65,7 +65,7 @@ s8 sAudioEnabled = 1;
 u32 sNumVblanks = 0;
 s8 gResetTimer = 0;
 s8 D_8032C648 = 0;
-s8 gDebugLevelSelect = 0;
+s8 gDebugLevelSelect = 1;
 s8 D_8032C650 = 0;

 s8 gShowProfiler = FALSE;
The enhancements/ folder contains a few sample patches.
Figure 1.
Screenshot of mupen64Plus running on Ubuntu 20.04 emulating Super Mario 64 with the title screen hacked by Ciro Santilli based on the Super Mario 64 reverse engineering project
. The title was on a string, so the hack was trivial! The patch used was:
diff --git a/include/text_strings.h.in b/include/text_strings.h.in
index 749179b..626f87e 100644
--- a/include/text_strings.h.in
+++ b/include/text_strings.h.in
@@ -131,7 +131,7 @@
  */
 // Main Screens
 #define TEXT_MARIO _("MARIO") // View Score Menu
-#define TEXT_SELECT_FILE _("SELECT FILE")
+#define TEXT_SELECT_FILE _("HACKED BY CIRO")
 #define TEXT_CHECK_FILE _("CHECK FILE")
 #define TEXT_COPY_FILE _("COPY FILE")
 #define TEXT_ERASE_FILE _("ERASE FILE")
Some tutorials of hacking it:
Video 1.
FIXING the ENTIRE SM64 Source Code by Kaze Emanuar (2022)
Source. Now that we have the source, modders like this are going nuts.