https://www.postgresql.org/docs/17/textsearch-controls.html


`to_tsvector`

<code>to_tsvector</code>

to_tsvector

https://www.postgresql.org/docs/17/functions-srf.html

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);
``


PostgreSQL `generate_series`

PostgreSQL <code>generate_series</code>

PostgreSQL generate_series

{tag=SQL function}

https://www.postgresql.org/docs/17/functions-srf.html


PostgreSQL function

Ubuntu 24.10

Generated column

* <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


Notable private tutor

Amazing mentor

Private tutor

Mentor

PBS program

{c}
{tag=Show hosted by Jim Al-Khalili}
{title2=2010}
{wiki}

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.


Chemistry: A Volatile History

BBC program

https://knowyourmeme.com/memes/work-safe-porn

\Image[https://web.archive.org/web/20241217073636im_/https://i.kym-cdn.com/entries/icons/facebook/000/000/986/worksafe.jpg]
{source=https://knowyourmeme.com/memes/work-safe-porn}

\Image[https://web.archive.org/web/20241217073636im_/https://i.kym-cdn.com/photos/images/newsfeed/000/020/356/sfw-porn-1225101702-97208.jpg?1253736537]
{source=https://knowyourmeme.com/memes/work-safe-porn}

\Image[https://web.archive.org/web/20241217073636im_/https://i.kym-cdn.com/photos/images/newsfeed/000/039/485/RoughRider_pianist.gif?1265902475]
{source=https://knowyourmeme.com/memes/work-safe-porn}


Work-safe porn

{c}
{wiki}

https://knowyourmeme.com/memes/welcome-aboard

\Image[https://web.archive.org/web/20240320080419im_/https://i.kym-cdn.com/photos/images/newsfeed/000/303/748/65c.png]
{source=https://knowyourmeme.com/memes/welcome-aboard}


Welcome Aboard!

Show hosted by Jim Al-Khalili

{tag=Documentary film}

Lists:
* <Reddit>:
  * https://www.reddit.com/r/chemistry/comments/1hddrh/have_you_ever_come_across_a_good_documentary/
  * https://www.reddit.com/r/chemistry/comments/o11eba/good_chemistry_documentary/


History of chemistry documentary

Teacher

{c}
{wiki}

His documentary style is mostly "travel to places" and "show equations without explaining them". But there is some value to that as well.

\Image[https://upload.wikimedia.org/wikipedia/commons/6/6c/Jim_Al-Khalili_Royal_Society.jpg]
{height=600}


Jim Al-Khalili

History of chemistry bibliography

{c}
{tag=Notable private tutor}
{title2=1733-1804}
{wiki}

\Image[https://upload.wikimedia.org/wikipedia/commons/2/20/Joseph_Priestley.jpeg]
{title=Joseph Priestley in 1801}


Ciro Santilli @cirosantilli 40