2 ms·
Modern SQL databases like PostgreSQL offer full JSON capabilities to serve this need.
by stuartaxelowen 9y ago
Modern SQL databases like PostgreSQL offer full JSON capabilities to serve this need.
- exogen 9y agoI've used its JSON support extensively and no, it's not really the same at all. What you're saying is that you're OK with (1) planning to not use columns to store your individual data fields in the first place, forgoing the primary SQL features of column-based lookup, joins, etc., or (2) having the client write complicated Postgres-specific SQL queries that dynamically construct JSON strings built from the fields that are stored in the real row structure.