Rendering two charts/tables side by side

[lorefnon]

I think it would be useful to have some generic way to control the layout of chart/table panels. I was not able to figure out from docs and a cursory examination of the templates but maybe there is some trick already?

I was initially looking to embed charts within cards which do seem to have multi-column support but it looks like components can't be composed (yet?).

[lovasoa]

Hello !

Indeed, there is no way to compose components or to create complex layouts at the moment, and it is not on the roadmap. You can always create your own custom components if you want, of course.

If you do have an idea for how sqlpage could add multi-column layouts without becoming more complicated to use, I'm open to discussion :)

[lorefnon]

One solution I can think of is to have a row level parameter in card like embed=somefile.sql that embeds the rendered output of another file (without the shell of course) within the card. I am not sure if it would fall within your acceptable complexity criteria but I think some flexibility on the layouts will benefit many users. It's been a while I have done anything complex with handlebars but I can take a stab at this if you find the feature acceptable. The issue with creating a custom component is that I don't seem to have a good way to create a container and reuse your built in components within them.

…

On Tue, Jan 2, 2024, 2:09 AM Ophir LOJKINE ***@***.***> wrote: Hello ! Indeed, there is no way to compose components or to create complex layouts at the moment, and it is not on the roadmap. You can always create your own custom components <https://sql.ophir.dev/custom_components.sql> if you want, of course. If you do have an idea for how sqlpage could add multi-column layouts without becoming more complicated to use, I'm open to discussion :) — Reply to this email directly, view it on GitHub <#168 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AALB4FFRGNXEB4WHDVI5NMDYMMNIDAVCNFSM6AAAAABBJIMLT6VHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM3TSOBYHEYTQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[lovasoa]

Yes, I think that would be acceptable !

select 'card' as component;
select 'other.sql?id=' || id as embed from my_table;

But this isn't trivial to implement, and you'll need more than just handlebars.

[lovasoa]

If we implement that with <iframes>, then it's way easier, but it may be less appealing for the user...