Reviews are the m:n mapping table between books and shelves. This means books that are just on your to-read shelf still have a review, connecting the book with your shelf. I don't make the rules.

1 row where book_id = 101869

View and edit SQL

Suggested facets: date_added (date), date_updated (date), read_at (date), started_at (date)

id ▼ book_id user_id rating text date_added date_updated read_at started_at
1250234058 The Atrocity Archives 101869 rixx 41972609 5 (My reviews are mostly to help me remember what happened in a book and why I liked/disliked it.)<br /><br />Soo, the beginning of my favourite Stross series. You know: magic is advanced maths, kinda powerful geeks and really powerful burocracy.<br /><br />I think it's noticable that Atrocity Archives is an early Stross book. In the first half, the Shibboleth/Shibboleet dropping is sometimes very obvious and a bit annoying. (Redeeming Stross though, he is actually knowledgable enough to actually use all those jokes, tropes and catchphrases, so it's ok.)<br /><br />Plot: We meet Bob, who wants to join Active Service in the Laundry. Angleton and Andy, his bosses, send him to the USA, where he meets and saves Mo, who then returns to London and moves in with him (after Bob saves her again at her own doorstep).<br /><br />To draw out their enemies Mo, Bob and secret reinforcements travel to Amsterdam for research, where Mo is promptly abducted to another universe. Bob joins the reconnaissance team. Turns out, in a close parallel universe to our own one, the Nazis finished their arcane project by summoning an Infovore and travelling to that world (some ice giants included). The Infovore sucked the universe dry and is now trying to get all of itself over to Bob's universe. With judicious use of some Hands of Glory and an H-Bomb they manage to save Mo, Bob and about half the crew. 2015-04-09T06:21:57-07:00 2015-07-02T23:27:05-07:00 2015-07-02T00:00:00-07:00 2015-07-01T00:00:00-07:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [reviews] (
   [id] TEXT PRIMARY KEY,
   [book_id] TEXT REFERENCES [books]([id]),
   [user_id] TEXT REFERENCES [users]([id]),
   [rating] TEXT,
   [text] TEXT,
   [date_added] TEXT,
   [date_updated] TEXT
, [read_at] TEXT, [started_at] TEXT);