ben
July 8, 2022, 3:41am
1
When I follow this tutorial
Intro
NOTE: This option is currently available for NodeJS server model only. Support for other server models is coming next weeks.
The sub tables in Wappler provide an easy way to create and access nested data structures much easier. The relational databases make sense now, as you can easily nest data structures in sub tables.
Then you can query these tables and their sub tables without the need of complex queries - Wappler handles it all for your in a single query and builds the required ne…
Using SQLite I finish up with
Using MariaDB the result is
Querying the SQLite version
Doing the same for MariaDB
In other words, is it possible to use the sub-tables for MariaDB?
Edit: In one of my projects I cheated. I created the project using SQLite to get the sub-tables working. When I finished the project, I changed the connection to MariaDB. Works well.
Well subtables should work just fine in mariaDB as well.
I think there are some glitches in recognizing them when the tables are created in different order or edited afterwards, that we need to smoothen out.