Pages without sql file, from database

[jeneizs-74]

Hello!

My idea is that I want to use minimal SQL files in my project.
Index, LogIn, LogOut.

Everything else would be stored in a database.
index.sql would build the menu based on a query and compile the links as well.
All links would work based on SQL query.
So there is no partners.sql, but a partners query, which produces all the information needed for the appearance of the page in JSON.

Is this possible?

Thanks for your answer!

[lovasoa]

Hello and welcome to SQLPage !

You can host your sql queries directly inside the database itself using the sqlpage_files table. If you do that, you do not even need an index.sql file outside the database.

All the menus, the components and their contents can be generated dynamically by sql queries; they should just return data in the format sqlpage expects, as per the documentation.

[jeneizs-74]

Super! Thanks for the quick reply!