pysonDB-v2 icon indicating copy to clipboard operation
pysonDB-v2 copied to clipboard

Question - What's the best route for multiple tables?

Open molinto opened this issue 3 years ago • 1 comments

Hi, what's the best route for using PysonDb(-v2) fir multiple table please?

Create a json file for each table, then merge at the end?

molinto avatar Jul 11 '22 10:07 molinto

@molinto Since this is a NoSQL database, the concept of "tables" doesn't really apply here. If you have two distinct datasets that you want to store, your best bet is to keep them in different documents (files). There's also no concept of "join" or "union" that exist in relational DBs. If you need a relational db that you can store in local files, I'd recommend SQLite.

builder555 avatar Dec 09 '23 20:12 builder555