Deleting data

Now that we have some data in our database, we can look at how we can delete specific documents. As usual, the query is very straightforward. The first thing to do is select the document to be deleted. This can be done using the document's primary key or using the filter() command. The next step is chaining the delete() command at the end of the query.

As an example, let's delete Ted's document from the people table:

r.table('people').filter({"name": "Ted"}).delete()

First, we select the correct table, then we use the filter() command to specify the predicate. In this case, we filter documents that have the name attribute equal to Ted. Finally, we call the delete() command. The resulting JSON indicates that one document has indeed been ...

Get Getting Started with RethinkDB now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.