Gordon Linoff by Ciro Santilli 40 Updated 2025-07-16
Infinitely many SQL answers.
As mentioned at Ciro Santilli's Stack Overflow contributions, he just answers every semi-duplicate immediatly as it is asked, and is therefore able to overcome the Stack Overflow maximum 200 daily reputation limit by far. E.g. in 2018, Gordon reached 135k (archive), thus almost double the 73k yearly limit due to the 200 daily limit, all of that with accepts.
This is in contrast to Ciro Santilli's contribution style which is to only answer questions as he needs the subject, or generally important questions that aroused his interest.
2014 Blog post describing his activity: blog.data-miners.com/2014/08/an-achievement-on-stack-overflow.html, key quote:
For a few months, I sporadically answered questions. Then, in the first week of May, my Mom's younger brother passed away. That meant lots of time hanging around family, planning the funeral, and the like. Answering questions on Stack Overflow turned out to be a good way to get away from things. So, I became more intent.
so that suggests his contributions also take a meditative value.
www.data-miners.com/linoff.htm mentions he's an SQL consultant that consulted for several big companies.
LinkedIn profile: www.linkedin.com/in/gordonlinoff/ says he now works at the New York Times.
2021 Reddit thread about him: www.reddit.com/r/programming/comments/puok1h/a_single_person_answered_76k_questions_about_sql/ mentions that by then he had:
answered 76k questions about SQL on StackOverflow. Averaging 22.8 answers per day, every day, for the past 8.6 years.
Magic Aids by Ciro Santilli 40 Updated 2025-07-16
His combination of politically incorrect dirt talk with amazing quirky decks captures Ciro's imagination.
Anonymous no face-reveal.
The videos are heavily edited with all pauses cut out, which makes them very quick to watch and saves viewer time.
Modern focused, with some occasional newer formats mixed in.
When Wizards publishes several useless sets in a row without a single modern playable card, he's just forced into Standard.
Video 1.
Magic Aids vs. Magic Rainbows by Magic Aids (2018)
Source. In this amazing video Magic Aids makes fun of Wizards for forcing him to change is Magic Online handle from Magic Aids to something else due to the AIDS part. He claims the Aids is not meant as a reference to the disease, but just as in "memory aid". Ciro doubts this wasn't intentional. But the video is still amazing, and happens to involve a sex doll dressed as Liliana Vess squirting glitter from her vagina. Wizards must love this guy. It is also a good criticism of political correctness in general. This is a work of art.
ZynAddSubFX by Ciro Santilli 40 Updated 2025-07-16
Contains a large database of instruments, and allows you to edit them. This is a fun toy.
Instruments are edited on a GUI. It is a multi-window program, and you open new windows from new windows from new windows, all filled with hundreds of virtual knobs that you drag with your keyboard, and which would be better done from textual software like Csound. It is a thing of beauty.
It does not seem possible to program arbitrary modular synthesizer circuits therefore. But if you understand additive synthesis and subtractive synthesis well, you can make some funky sounds with it.
It is basically a superset of all popular hardware synthesizers ever made.
Has its own built-in MIDI keyboard which is nice.
On Ubuntu 20.04 Version: 3.0.5:
sudo apt install zynaddsubfx
zynaddsubfx -O alsa
as per askubuntu.com/questions/220802/no-sound-zynaddsubfx-and-jack-wont-run/1297988#1297988
To do anything of interest, switch to the Advanced UI:
The UI is completely different form what is shown on the website as of 2020: zynaddsubfx.sourceforge.io/, it looks instead like: www.youtube.com/watch?v=iVPr6iUuO3g Maybe on the website it is the new zyn-fusion UI... www.reddit.com/r/linuxaudio/comments/bxn3ur/some_help_for_installing_zynfusion_zynaddsubfx/ so confusing.
And they have some crappy policy of asking for 45 USD for binary downloads.
Compiling from source:
git clone https://github.com/zynaddsubfx/zynaddsubfx
cd zynaddsubfx
git checkout a789866de4d45a784c1f4d95fcf5a1938347baef
sudo apt build-dep zynaddsubfx
mkdir build
cd build
cmake ..
make -j`nproc`
fails with:
Traceback (most recent call last):
  File "/usr/bin/cxxtestgen", line 7, in <module>
    import cxxtest.cxxtestgen
  File "/usr/share/cxxtest/cxxtest/__init__.py", line 33, in <module>
    from cxxtest.cxxtestgen import *
  File "/usr/share/cxxtest/cxxtest/cxxtestgen.py", line 18, in <module>
    import __release__
ModuleNotFoundError: No module named '__release__'
Ciro gives up for now.
"Turn-ons" refer to things, behaviors, or characteristics that an individual finds appealing or exciting, particularly in a romantic or sexual context. These can vary widely from person to person and may include physical attributes, personality traits, certain actions, or specific situations. For example, some common turn-ons might include a person's sense of humor, confidence, intelligence, kindness, or specific physical features. Turn-ons can play a significant role in attraction and intimacy in relationships.
"Origins Vol. 1" typically refers to a specific collection or compilation that focuses on the beginnings or backstories of characters, stories, or themes within a particular franchise. However, without additional context, it’s challenging to identify the exact "Origins Vol. 1" you're referencing, as this title could apply to various media, including comic books, video games, or book series. For example, in the realm of comic books, "Origins Vol.
Osaka Ramones is a tribute band from Japan that pays homage to the iconic American punk rock band, the Ramones. The band is known for performing Ramones songs with a high-energy style, similar to the original group's approach. Osaka Ramones has garnered a following in Japan for their faithful renditions of the Ramones' music, capturing the spirit and essence of the punk rock genre.
"Praise and Blame" can refer to various concepts depending on the context in which it is used. Generally, it can denote the practice of recognizing and rewarding good behavior or achievements (praise) while also holding individuals accountable for their actions (blame) when they fall short of expectations. In a philosophical or moral context, the discussion of praise and blame often revolves around ethics, responsibility, and the nature of moral character.

Pinned article: Introduction to the OurBigBook Project

Welcome to the OurBigBook Project! Our goal is to create the perfect publishing platform for STEM subjects, and get university-level students to write the best free STEM tutorials ever.
Everyone is welcome to create an account and play with the site: ourbigbook.com/go/register. We belive that students themselves can write amazing tutorials, but teachers are welcome too. You can write about anything you want, it doesn't have to be STEM or even educational. Silly test content is very welcome and you won't be penalized in any way. Just keep it legal!
We have two killer features:
  1. topics: topics group articles by different users with the same title, e.g. here is the topic for the "Fundamental Theorem of Calculus" ourbigbook.com/go/topic/fundamental-theorem-of-calculus
    Articles of different users are sorted by upvote within each article page. This feature is a bit like:
    • a Wikipedia where each user can have their own version of each article
    • a Q&A website like Stack Overflow, where multiple people can give their views on a given topic, and the best ones are sorted by upvote. Except you don't need to wait for someone to ask first, and any topic goes, no matter how narrow or broad
    This feature makes it possible for readers to find better explanations of any topic created by other writers. And it allows writers to create an explanation in a place that readers might actually find it.
    Figure 1.
    Screenshot of the "Derivative" topic page
    . View it live at: ourbigbook.com/go/topic/derivative
  2. local editing: you can store all your personal knowledge base content locally in a plaintext markup format that can be edited locally and published either:
    This way you can be sure that even if OurBigBook.com were to go down one day (which we have no plans to do as it is quite cheap to host!), your content will still be perfectly readable as a static site.
    Figure 2.
    You can publish local OurBigBook lightweight markup files to either https://OurBigBook.com or as a static website
    .
    Figure 3.
    Visual Studio Code extension installation
    .
    Figure 4.
    Visual Studio Code extension tree navigation
    .
    Figure 5.
    Web editor
    . You can also edit articles on the Web editor without installing anything locally.
    Video 3.
    Edit locally and publish demo
    . Source. This shows editing OurBigBook Markup and publishing it using the Visual Studio Code extension.
    Video 4.
    OurBigBook Visual Studio Code extension editing and navigation demo
    . Source.
  3. https://raw.githubusercontent.com/ourbigbook/ourbigbook-media/master/feature/x/hilbert-space-arrow.png
  4. Infinitely deep tables of contents:
    Figure 6.
    Dynamic article tree with infinitely deep table of contents
    .
    Descendant pages can also show up as toplevel e.g.: ourbigbook.com/cirosantilli/chordate-subclade
All our software is open source and hosted at: github.com/ourbigbook/ourbigbook
Further documentation can be found at: docs.ourbigbook.com
Feel free to reach our to us for any help or suggestions: docs.ourbigbook.com/#contact