RethinkDB Primer

A short introduction to RethinkDB

Transcript

1. RethinkDB a primer
2. What is RethinkDB? An open-source distributed database built with . "MongoDB with joins"
3. Features JSON data model Distributed joins, subqueries, aggregation and atomic updates Hadoop-style map/reduce Friendly web and command-line administration tools Multi-datacenter replication and failover Sharding and replication Queries are automatically parallelized and distributed
4. Getting Started
5. Installation tyrion@kings-landing:~$ brew update tyrion@kings-landing:~$ brew install rethinkdb
6. Set Up tyrion@kings-landing:~$ rethinkdb
7. Web UI
8. Clustering tyrion@kings-landing:~$ rethinkdb create –d /tmp/db1 tyrion@kings-landing:~$ rethinkdb –j –d /tmp/db1 --port-offset 1
9. Clustering
10. Clustering
11. Gem tyrion@kings-landing:~$ gem install rethinkdb [1] pry(main)> require "rethinkdb" [2] pry(main)> include RethinkDB::Shortcuts [3] pry(main)> r.connect(host: 'localhost', database: 'marvel').repl()
12. Working with RethinkDB
13. Get All [1] pry(main)> r.table('characters').run
14. Get Document [1] pry(main)> r.table('characters').get(1).run
15. Filter [1] pry(main)> r.table('characters').filter({ age: 30 }).run
16. Update [1] pry(main)> r.table('characters').get(1).update({ age: 50}).run
17. Delete [1] pry(main)> r.table('characters').get(1).delete.run
18. ReQL
19. Principles 1. ReQL embeds into your programming language. 2. All ReQL queries are chainable. 3. All queries execute on the server.
20. Embeds into your Language [1] pry(main)> require "rethinkdb" [2] pry(main)> include RethinkDB::Shortcuts [3] pry(main)> r.connect(host: 'localhost', database: 'marvel').repl() [1] pry(main)> r.table('characters').get(1).delete.run
21. Chainable Queries [1] pry(main)> r.table('characters').run [2] pry(main)> r.table('characters').pluck('last_name').distinct().run [3] pry(main)> r.table('characters').pluck('last_name').distinct().count().run
22. Server-Side Execution [1] pry(main)> query = r.table('characters').pluck('last_name').distinct [2] pry(main)> query.run
23. Examples
24. Filter + Contains [1] pry(main)> r.table('user').filter{|user| user['emails'].contains('user@email.com')}.run
25. Filter Dates [1] pry(main)> r.table("posts").filter{ |post| [2] pry(main)> post.during(r.time(2012, 1, 1, 'Z'), r.time(2013, 1, 1, 'Z')) [3] pry(main)> }.run
26. Filter + Pluck + Order + Limit [1] pry(main)> r.table('snippets'). [1] pry(main)* filter({lang: 'ruby'}). [1] pry(main)* pluck('id', 'title', 'created_at'). [1] pry(main)* order_by(r.desc('created_at')). [1] pry(main)* limit(10). [1] pry(main)* run()
27. Group + Merge [1] pry(main)> r.table('invoices').group( [1] pry(main)* [r.row['date'].year(), r.row['date'].month()] [1] pry(main)* ).ungroup().merge( [1] pry(main)* {invoices: r.row['reduction'], month: r.row['group']} [1] pry(main)* ).without('reduction', 'group').order_by('month').run
28. Cool Features
29. Geospatial [1] pry(main)> point1 = r.point(-122.423246,37.779388) [2] pry(main)> point2 = r.point(-117.220406,32.719464) [3] pry(main)> r.distance(point1, point2, {:unit => 'm'}).run [4] pry(main)> r.circle(point1, 2000).includes(point2).run
30. HTTP [1] pry(main)> r.table('comics').insert(r.http('http://foo.com/comics')).run
31. Changes [1] pry(main)> r.table('games').changes().run.each{|change| p change}