Is there any reason that TinyDb in its current form can't store Python Code? I have inserted code into a db with some dicts defined inside the code, it appears to work fine. But before I go further, just wanted to ask if there any gotcha's I should be aware about. I can see I can also query lists inside json records, which sounds good use for tagging.
If it's safe to insert code I can stress test the performance using Faker to just generate text of various lengths to simulate the code to see how many records it's comfortable dealing with.
I also assume that having multiple tables in a database only act as partitions so to speak. maybe searching could be a little faster, but what about inserts? Sorry, not sure if this is documented, I didn't see it. But it would be great to know the effect on using multiple tables vrs just using the default table