[hatefulheart]

Despite reading the README and the article I am still unclear about how these templated values are populated. So presumably we store our HTML on the sql server along with some templating syntax then how do we plug that value so to speak?

Secondly, what do we do about things like HTML fragments à la HTMX / Datastar hypermedia approach? Do we just hit the DB for 10 lines of HTML to populate the next card in a multi step form?

[sivers]

I edit my HTML templates in the templates/ directory.

Then I use this little Ruby script to sync them into the database, which is where they're actually used:

https://github.com/sivers/sivers/blob/master/scripts/templat...

I haven't done HTMX fragments yet. This repository is quite new, and only like 5% done.

[hatefulheart]

Hey,

Thanks for your response. I didn’t explain myself properly.

Suppose I have a html template that contains the dynamic value {{ foo }}, that template is on my SQLDB, how do I populate {{ foo }} whilst querying the template table?

I hope that makes more sense.

[sivers]

Ah, sorry. I misunderstood. The parser for Mustache templates - https://mustache.github.io/ - is in the PostgreSQL functions.

See it in practice here in the unit tests:

https://github.com/sivers/sivers/blob/master/omni/test/templ...

https://github.com/sivers/sivers/blob/master/omni/test/must_...

It comes from these three functions, but really only using the top-level "o.template" function:

https://github.com/sivers/sivers/blob/master/omni/template.s...

https://github.com/sivers/sivers/blob/master/omni/must_templ...

https://github.com/sivers/sivers/blob/master/omni/must_secti...

I'm using it for https://nownownow.com/ and https://my.nownownow.com/ already. Example test:

https://github.com/sivers/sivers/blob/master/nnn/test/mynow-...

[hatefulheart]

Thank you very much!