3 ms·
You could but then you're really trying to jam a JSON style modal into a relational database. You CAN do it. But the tools and query language will make it much
by taligent 14y ago
You could but then you're really trying to jam a JSON style modal into a relational database. You CAN do it. But the tools and query language will make it much harder to work with. Not to mention lack of indexes on individual fields.
- jeffdavis 14y agoPeople avoid introducing new data stores because it adds complexity and it's harder to do queries across data sets. Jamming different data models together in one system is a very viable strategy. Postgres supports functional indexes, so indexing individual fields within a JSON document is already possible. If it's not easy now it will be easy soon. Remember XML databases? They became extremely marginalized when relational systems started adding basic support.