Creating data tables dynamically

I am trying to create an application of seat booking for my classes.
I want a separate data table to be created from code when new batch is created.

But right now, I can only create table from IDE. Do we have any option to create table from code.
something like. app_tables.create_new(name,schema)

1 Like

No, but you could instead use a single table with some sort of batch ID as one of its columns.

2 Likes

Yeah, It seems interesting… will try this one…

Also look at simple object columns.

If your tables are small and if you don’t need any fancy searching features, adding one list of dictionaries in one row could do the job.

I have an app with a table called Tables with 5 columns: table_name, created_by, created_time, created_version, table. Each row contains the table the user needs in the simple object table column.

1 Like

Option #3 as always is to use an external database, either connected directly to a server module if it was a stand alone DB, or to use uplink with another system within your control.

If you are running uplink on the other system you are using python, which means you at the very least have SQLite installed already as it is within the standard library and you can test it out.

Also, welcome to the forums :wave:

1 Like

Thank you so much, this is going to help me a lot. Will try it.

Thanks, but I don’t have external DB. This idea might help me in future.