dataset provides two key functions that make using SQL databases in
Python a breeze:
A simple abstraction layer removes most direct SQL statements without the necessity for a full ORM model – essentially, databases can be used like a JSON file or NoSQL store.
Database contents can be exported (frozen) using a sophisticated plain file generator with JSON and CSV support. Exports can be configured to include metadata and dynamic file names depending on the exported data. The exporter can also be used as a command-line tool,
From the JSON API website:
If you’ve ever argued with your team about the way your JSON responses should be formatted, JSON API can be your anti-bikeshedding tool.
By following shared conventions, you can increase productivity, take advantage of generalized tooling, and focus on what matters: your application.
Clients built around JSON API are able to take advantage of its features around efficiently caching responses, sometimes eliminating network requests entirely.