PostgreSQL generate_series by Ciro Santilli 37 Created 2024-12-31 Updated 2025-07-16
Pattern you always want to generate Generate random text in PostgreSQL:
CREATE TABLE "mytable" ("i" INTEGER, "j" INTEGER);
INSERT INTO "mytable" SELECT i, i*2 FROM generate_series(1, 10) as s(i);
Ubuntu 24.10 by Ciro Santilli 37 Created 2024-12-31 Updated 2025-07-16
Generated column by Ciro Santilli 37 Created 2024-12-31 Updated 2025-07-16
Notable private tutor by Ciro Santilli 37 Created 2024-12-31 Updated 2025-07-16
  • Joseph Priestley was employed as tutor to Lord Shelburne's children, which gave him much needed financial stability and allowed him to pursue some of his most important works
Amazing mentor by Ciro Santilli 37 Created 2024-12-31 Updated 2025-07-16
Private tutor by Ciro Santilli 37 Created 2024-12-31 Updated 2025-07-16
Mentor by Ciro Santilli 37 Created 2024-12-31 Updated 2025-07-16
PBS program by Ciro Santilli 37 Created 2024-12-31 Updated 2025-07-16
Chemistry: A Volatile History by Ciro Santilli 37 Created 2024-12-31 Updated 2025-07-16
This is OK, but definitely inferior to The Mystery of Matter overall because it is much more interesting to watch period reenactments than Jim Al-Khalili going places. But the latter also has its value.
BBC program by Ciro Santilli 37 Created 2024-12-31 Updated 2025-07-16
Teacher by Ciro Santilli 37 Created 2024-12-31 Updated 2025-07-16
Jim Al-Khalili by Ciro Santilli 37 Created 2024-12-31 Updated 2025-07-16
His documentary style is mostly "travel to places" and "show equations without explaining them". But there is some value to that as well.

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