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
By Marjaana Jokinen on February 20, 2019: This is the story of my learning journey teaching myself how to use xAPI. I share resources and xAPI examples that helped me get started.
S. Keidel, W. Pfeiffer, and S. Erdweg. Proceedings of the 2016 ACM SIGPLAN International Conference on Software Language Engineering, page 152--162. ACM, (2016)