Can SQLPage customizations (e.g. handlebar templates) live in sqlpage_files table?

[shah]

We keep all our SQLPage content in sqlpage_files table and it works great. Now we need to do some customizations and need to use handlebars templates but I wasn't sure if those templates could also reside in sqlpage_files or if those need to kept in the file system.

Can SQLPage customizations (e.g. handlebar templates) live in sqlpage_files table?

[lovasoa]

Yes they can !

Example

Database structure

CREATE TABLE sqlpage_files(
  path VARCHAR(255) NOT NULL PRIMARY KEY,
  contents BLOB,
  last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

insert into sqlpage_files VALUES (
    'sqlpage/templates/my_component.handlebars',
    'Hello {{name}} !',
    now()
);

index.sql:

select 'my_component' as component, 'world' as name;

Result

[shah]

Fantastic, thanks for a great OSS project and the quick answer!