wolverine
DTDrizzle Team
•Created by prabhatpal on 9/22/2023 in #help
Can I create tables at runtime?
@Angelelz any thoughts?
9 replies
DTDrizzle Team
•Created by prabhatpal on 9/22/2023 in #help
Can I create tables at runtime?
I am planning to migrate my entire stack to javascript (drop fastapi and sqlmodel) as working with a separate fastapi backend litters my code with uncountable fetch requests. Sveltekit provides a super simple action api and if somehow i can create tables from my app for each individual business I will be a step closer to my goal.
9 replies
DTDrizzle Team
•Created by prabhatpal on 9/22/2023 in #help
Can I create tables at runtime?
Hi, new to the discussion here. I made an accounting app using sveltekit and fastapi as backend. I had a main database which contained information regarding business i.e name, address, tax identifiers, sales identifiers, govt regulation identifiers e.t.c.
Whenever a new business was created in the main database a new database associated with that particular business was created which contained tables for voucher entries, sales orders, purchase, inventory e.t.c.
This can be achieved in a single sqlite db as well but lookup times are significantly better when each business has its own database which may contain thousands of records and its easier to keep backup of the data as well.
9 replies