Learn more about how the same JSON document can be parsed with different values across microservices, leading to a variety of potential security risks.
CREATE TABLE books (
book_id serial NOT NULL,
data jsonb
);
INSERT INTO books VALUES (1, '{"title": "Sleeping Beauties", "genres": ["Fiction", "Thriller", "Horror"], "published": false}');
SELECT data->'title' AS title FROM books WHERE data->'published' = 'false';
CREATE INDEX idx_published ON books ((data->'published'));
All the Star Wars data you've ever wanted: Planets, Spaceships, Vehicles, People, Films and Species from all SEVEN Star Wars films now with The Force Awakens data!
A JSON alternative that retains references, handles circular dependencies, and encodes almost every data type available to standard JavaScript. - cierelabs/json-complete
JSON itself does not specify how dates should be represented, but JavaScript does.
You should use the format emitted by Date's toJSON method:
2012-04-23T18:25:43.511Z
S. Keidel, W. Pfeiffer, и S. Erdweg. Proceedings of the 2016 ACM SIGPLAN International Conference on Software Language Engineering, стр. 152--162. ACM, (2016)