OurBigBook.com (beta) About$ Donate
Sign inSign up
by Ciro Santilli (@cirosantilli, 25)


Link to an image or video in another file that has an \x on title from another file


Issue report at: github.com/ourbigbook/ourbigbook/issues/198 Suppose you had:

programming-language.ciro

= Programming language

\Image[https://raw.githubusercontent.com/cirosantilli/media/master/python-logo.jpg]
{title=The \x[python-programming-language] logo}

== Python
{c}
{disambiguate=programming-language}

logos-i-like.ciro

= Logos I like

\x[image-the-python-logo]

Now, when rendering \x[image-the-python-logo], we would need to fetch two IDs:
  • image-the-python-logo for the The and logo part
  • python-programming-language itself, to know that \x[python-programming-language] should render as Python

But after group all SQL queries together was done, there was no way to know that rendering image-the-python-logo would imply also fetching python-programming-language.

This was solved by adding a new database entry type, REFS_TABLE_X_TITLE_TITLE to the existing References table, which tracks dependencies between IDs.

After this was setup, we can now know that image-the-python-logo depends on image-the-python-logo, and then fetch both of them together in a single JOIN.

 Ancestors

  1. Make \Include headers show on table of contents work for cirosantilli.com
  2. Advances
  3. ourbigbook.com
  4. Ciro's Edict #5
  5. Sponsor update list
  6. Ciro Santilli
  7. Index

 Incoming links

  • Make \Include headers show on table of contents work for cirosantilli.com

Discussion (0)

Sign up or sign in create discussions.

There are no discussions about this article yet.

About$ Donate Content license: CC BY-SA 4.0 unless noted Website source code Contact, bugs, suggestions, abuse reports @OurBigBook @OurBigBook