Support for Foreign Keys and relationships

pudo / dataset

Easy-to-use data handling for SQL data stores with support for implicit table creation, bulk loading, and transactions.

https://dataset.readthedocs.org/

MIT License

4.78k stars 298 forks source link

Support for Foreign Keys and relationships #322

Closed jgburd79 closed 4 years ago

jgburd79 commented 4 years ago

Is there support for Foreign Keys? How does one normalize the database and create relationships?

pudo commented 4 years ago

It's always been a sort of magic line for us: if the schema you are doing is complex enough that foreign keys are a good idea, you need to start using a proper ORM instead of dataset. Foreign keys and relationships bring with them a whole different level of need for metadata, and I don't know how it could be made to behave like "just a dict"...

jgburd79 commented 4 years ago

I figured as much since there wasn't anything in the documentation but thought I would ask anyway. I think I can kind of do it manually. I will have to see what I can get to work.