How to create a table on database over controller

[stripedbug]

Hi

I need to create a table and if possible a model for the table from a controller .
I know i can do that with some third party node pack but is there a built in way to do that in adonis.

[RomainLanz]

Hey @stripedbug! 👋🏻

May I ask why would you want to do that? In my opinion, it looks like a XY Problem.
But if you really need to do that, you could use ace as a child_process to generate those.

[RomainLanz]

It seems that you need to cache the result of heavy computation.
Any reason not to store those results in a cache (like Redis) instead of keeping them in the database?

[stripedbug]

It seems that you need to cache the result of heavy computation. Any reason not to store those results in a cache (like Redis) instead of keeping them in the database?

The results will gradually get bigger as users keep submitting and i dont think cache is a solid way to store those data. Also the user submission process might take months so redis or any kind of cache method is not ideal

[andrew-connell]

Why don't you just use Postgresql and have just one table with a jsonb column for user specified data. Or a NoSQL db like Mongo.
Creating a lot of tables is a terrible idea, you're definitely overcomplicating things.

[stripedbug]

Thank u for the advice. Original question was "how to create a table on controller"

do u have an advice on that matter?

[andrew-connell]

No - as @RomainLanz says, this is definitely an XY problem