small medium large xlarge

Errata for Seven Databases in Seven Weeks

 

The latest version of the book is P2.0, released over 3 years ago. If you've bought a PDF of the book and would like to upgrade it to this version (for free), visit your home page.

By default this page displays the errata for the latest version of the book. If you have a previous version, select it here:

If you've found a new error, please submit it.

  • Typo
  • Tech. error
  • Suggestion
  • Maybe next edition
  • Not a problem
  • Reported in: P1.0 (09-Sep-12)
#49791
PDF page: 18
Figure 2: it seems countries => cities relationship should have cardinality "zero or many" rather than "one or more". At least the database doesn't en...more...
  • Reported in: P1.0 (09-Sep-12)
#49792
PDF page: 19
I don't think Postgres will create an implicit index on the column(s) of the table that is the target of REFERENCES keyword. From the official docs on...more...
  • Reported in: P1.0 (02-Aug-12)
#49620
Paper page: 23
The output of the aggregate query on the bottom half of the page "SELECT venue_id FROM events GROUP BY venue_id HAVING count(*) >=2 AND venue_id IS NO...more...
  • Reported in: P1.0 (10-Aug-12)
#49636
PDF page: 26/27
Using the function input parameters 'title', 'starts' and 'ends' leads to following error: psql:add_event.sql:25: ERROR: syntax error at or near "...more...
  • Reported in: P2.0 (04-Dec-14)
#77883
Paper page: 27
On code postgres/add_event.sql you declare variable called found_count but it is never used in the function. It is hard for the reader to know if it i...more...
  • Reported in: P1.0 (07-Nov-12)
#50142
PDF page: 27
The INSERT INTO events(title, starts, ends, venue_id) gave a syntax error. I'm not familiar with the language, but I suspect that the insert parameter...more...
  • Reported in: P1.0 (07-Nov-12)
#50143
PDF page: 27
There is probably some way that I could have prevented this, but if event_id is not present in the insert, I get 'duplicate value violates unique cons...more...
  • Reported in: P1.0 (15-Aug-12)
#49696
Paper page: 30
The last sentence on the page says "Now it's a matter of setting an array OR color strings..." when it should say "Now it's a matter of setting an arr...more...
  • Reported in: P1.0 (07-Nov-12)
#50144
PDF page: 40

There is an & where there should be just an &
(html error?)--Leen Torenvliet

  • Reported in: P1.0 (20-Dec-12)
#50399
Paper page: 52

"Erlang is also required to run Riak." Some readers will have no clue what Erlang is, so add a few words here to help them. --Bob DuCharme

  • Reported in: P2.0 (05-Dec-14)
#77892
PDF page: 53

The join command has been deprecated in favor of clustering commands provided by riak-admin cluster.--Leen Torenvliet

  • Reported in: P1.0 (03-Nov-12)
#50130
PDF page: 53

The riak-admin join command is now deprecated: riak-admin cluster join dev2@127.0.0.1 appears to be the equivalent--John Daily

  • Reported in: P2.0 (05-Dec-14)
#77893
PDF page: 54

Ports have changed to 10018. It is better to look at the config file, which is now called riak.conf by the way first.--Leen Torenvliet

  • Reported in: P1.0 (20-Nov-12)
#50186
PDF page: 58
It may be a version problem, but the , doesn't seem to work in the Link here. I got an "empty" response from the server as is. I tried -H "Link:</ri...more...
  • Reported in: P1.0 (19-Dec-12)
#50392
Paper page: 61
In the "Since we" paragraph, shouldn't "You link the direction" be "You link in the direction"? (I have several more picky ones like that...)--Bob DuC...more...
  • Reported in: P2.0 (31-May-13)
#51676
PDF page: 66ff
Several nodes are started and used to build a Riak ring. However, to actually make the nodes a cluster some commands are missing: bin/riak-admin clus...more...
  • Reported in: P1.0 (15-Nov-12)
#50162
PDF page: 67

changing "inputs" to "rooms" gives me error preflist exhausted. Could be my machine, could be settings, but is not very insightful.--Leen Torenvliet

  • Reported in: P1.0 (21-Sep-12)
#49845
PDF page: 86
After enabling riak_search and configuring the pre-commit hook on the bucket, you need to restart the servers before trying to add any more data to th...more...
  • Reported in: P1.0 (21-Sep-12)
#49846
PDF page: 89
The examples for the secondary index are against a server running on port 8098 rather than ports 8091-8093, on which the reader is running Riak nodes....more...
  • Reported in: P1.0 (19-Dec-12)
#50393
Paper page: 99
"adding 'Welcome to the wiki!' to the column called 'text:'." At first I thought "but you just said that text is a column family, not a column. " ...more...
  • Reported in: P2.0 (16-Nov-15)
#79164
PDF page: 107
shout text = String.toUpper text whisper text = String.toLower text surely shout = String.toUpper whisper = String.toLower is preferable--R...more...
  • Reported in: P1.0 (12-Jan-13)
#50463
Paper page: 140
Example census dates are in the wrong format. They should be entered as "2008-01-31" and "2007-09-20" (ISO format) instead of "2008-31-01" and "200...more...
  • Reported in: P2.0 (14-Jun-14)
#76862
PDF page: 142
The 'find' query in the first half of the page has an error: the date should be ISODate('2008-01-31') and not ISODate('2008-31-01') (month and day num...more...
  • Reported in: P1.0 (19-Dec-12)
#50394
Paper page: 149

"your city or meant to querying on" ("query on")--Bob DuCharme

  • Reported in: P1.0 (14-Aug-12)
#49649
PDF page: 154
The sentence that describes the entry in the system.profile collection says "info is a string description of the operation". I don't see a field named...more...
  • Reported in: P1.0 (14-Aug-12)
#49650
PDF page: 156
The output of the first group command doesn't match what I get. The text has: [ { "800" : 50000, "855" : 50000 } ] while I get: [ { "com...more...
  • Reported in: P1.0 (15-Aug-12)
#49693
PDF page: 158
The update_area function from mongo/update_area.js is broken. The line that applies the update reads db.phone.update... when it should be db....more...
  • Reported in: P1.0 (04-Aug-12)
#49627
PDF page: 158
Paper page: 145
On page 158 (pdf) there is this following quote : "Boolean Ops So far, all of our criteria are implicitly *and* operations." But on the previou...more...
  • Reported in: P1.0 (28-Jul-14)
#77067
PDF page: 210
Paper page: 198
Hello, The second cURL call has an extra backslash on the second line. Once I took it out the code worked just fine: Note: I had pasted the orig...more...
  • Reported in: P2.0 (26-Nov-14)
#77846
PDF page: 223
It seems that the makers of Neo4j no longer let their browser support gremlin. There is some technical doc on "not allowed hyperling, referring to gro...more...
  • Reported in: P1.0 (11-Sep-12)
#49795
PDF page: 224

Figure 34 has riesling misspelled as reisling.--Mick Brooks

  • Reported in: P1.0 (19-Dec-12)
#50395
Paper page: 232

"loop() invokes the given in the closure" (invokes the code given in the closure?)--Bob DuCharme

  • Reported in: P2.0 (21-Aug-14)
#77234
Paper page: 233

"We can preform..." should be "we can perform..."

  • Reported in: P1.0 (12-Sep-12)
#49801
PDF page: 235
...this new step should attach to both Vertex and Pipe classes (when in double, just use both)... Should that be "when in doubt, just use both"?--M...more...
  • Reported in: P1.0 (19-Dec-12)
#50396
Paper page: 245
"We didn't know who Roddy McDowall was" I hope you've remedied that! You can be forgiven for not knowing that he was one of the lesser known but coole...more...
  • Reported in: P1.0 (24-Sep-12)
#49858
PDF page: 247

"and a count to set a maximum number or loops." should probably be "and a count to set a maximum number of loops."
--Mick Brooks

  • Reported in: P1.0 (24-Sep-12)
#49859
PDF page: 248
The example creates a scorer barycenter = new BarycenterScorer<Vertex,Edge>( j, t ) then later: bacon.costars.each{ score = b.getVertexSco...more...
  • Reported in: P1.0 (05-Oct-12)
#49922
Paper page: 266
When I try the RPUSH command in the redis cli, it doesn't return the number of values pushed. It returns the length of the list. So "RPUSH eric:wishli...more...
  • Reported in: P1.0 (03-Aug-12)
#49625
PDF page: 282
The book states: "...low and high range numbers are inclusive by default...So, this will return all scores where 9 <= score <= 10,000: redis 127.0...more...
  • Reported in: P2.0 (26-Mar-13)
#51138
PDF page: 284

The dataset for running isbn.rb (isbn.tsv) is not in the code downloads.--Dale Visser

  • Reported in: P2.0 (08-Mar-13)
#50989
Paper page: 324

script "node populate_couch.js" throws error: http.createClient is deprecated