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 = 30987220 sorted by started_at

View and edit SQL

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

id book_id user_id rating text date_added date_updated read_at started_at ▼
2775041821 Elanus 30987220 rixx 41972609 3 **Elanus** by *Ursula Poznanski* is an alright YA thriller/mystery. (Keep in mind that I'm not the intended audience anymore, though). She writes a very good unreliable/unsympathetic protagonist – a way too smart 17-year old boy, who by way of his self-built illicit drone stumbles into a dangerous secret at his new school. Very solid writing. It's very clear from the start that the protagonist is kind of an asshole, but I guess with YA you'd want to make this clear, to encourage engagement with the book (and to prevent any kids from finding him too much of a role model). Well-researched in terms of technical capacity, well-written, and while the twist is a bit predictable, the book is still pretty solid. 2019-04-04T12:29:47-07:00 2020-02-23T11:40:32-08:00 2019-04-04  

Advanced export

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

CSV options:

CREATE TABLE [reviews] (
   [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);
Powered by Datasette · Query took 63.453ms