PGTera is a PostgreSQL extension that provides functions for using Tera to render HTML templates.
When used with a tool like Postgrest, you can serve HTML directly from the database without managing an intermediate layer.
Template files in: /var/www
/var/www/
index.html
about.html
Code in index.html
<html>
<title>Home Page</title>
<body>
{% for link in links %}
<a href="{{ link.href | safe }}">{{ link.name }}</a>
{% endfor %}
</body>
</html>
Render the template in your SQL code. The Second argument of pgtera_render is the context which must be passed in as an array of JSON objects that conforms to the following type:
struct CtxInput {
name: String,
value: Value
}
Where Value is the serde_json Value enum.
create extension pgtera;
select pgtera_set_render_path('/var/www/**/*.html');
select pgtera_render(
'index.html',
$ctx$
[{
"name": "links",
"value": [
{ "name": "Tera Docs", "href": "https://keats.github.io/tera/docs/" },
{ "name": "PGTera", "href": "https://github.com/f-prime/pgtera" }
]
}]
$ctx$
);
Which will return
<html>
<title>Home Page</title>
<body>
<a href="https://keats.github.io/tera/docs/">Tera Docs</a>
<a href="https://github.com/f-prime/pgtera">PGTera</a>
</body>
</html>
If you would like to write your HTML directly in your SQL, you can use the pgtera_render_str function:
select pgtera_render_str(
$template$
<ul>
{% for x in people %}
<li>{{ x }}</li>
{% endfor %}
</ul>
$template$,
$ctx$
[
{ "name": "people", "value": ["John", "Jake", "James", "Jeff"] }
]
$ctx$
);
This will install pgtera to the default Postgres installation on your system. For more detailed installation options, checkout the cargo-pgrx README
cargo install cargo-pgrxcargo pgrx install
63 Dec 27, 2022
7 Sep 7, 2023
3 Nov 3, 2023
6 Nov 13, 2023
16 Dec 15, 2023
4 Apr 9, 2024
22k Jan 3, 2023
1 Apr 6, 2022
8 Dec 22, 2022
315 Apr 10, 2023
14 Dec 15, 2022
3 Jan 15, 2023
1 Dec 20, 2022
22 Mar 27, 2023
11 Apr 4, 2023
3 Jul 5, 2023
7 Dec 4, 2022
1 Feb 18, 2022
9 Oct 9, 2022