Episode 34: Databases

Download

News

• What makes us feel good about our work
• http://www.ted.com/talks/dan_ariely_what_makes_us_feel_good_about_our_work
• RethinkDB announces version 1.13
• http://rethinkdb.com/blog/1.13-release/
• dhcp.io offers free dynamic DNS
• http://dhcp.io/
• Folding a fractal
• http://acko.net/blog/how-to-fold-a-julia-fractal/
• Wavepot music scripting
• http://wavepot.com/

Book of the Show

• Jason:  Negotiating For Dummies http://amzn.to/1jS9Yem
• Patrick: Steelheart http://amzn.to/1lsRxBv

Tool of the Show

• Jason: nvAlt / nvPy ( http://brettterpstra.com/projects/nvalt/ https://github.com/cpbotha/nvpy )
• Patrick: Arduino ( http://www.arduino.cc/ )

Databases

• Flat Files vs. Databases
• Motivation (Why use a database)
• Reverse-Indexing
• Caching
• Redundancy
• Scalability
• Segmentation
• Analysis
• Validation
• Consistency
• ACID
• Eventually Consistent
• Types
• Relational Databases
• SQL (Structured Query Language)
• NoSQL Databases
• Key/Value Store
• Column-Family (Key / MultiValue)
• Document Store
• Implementations
• Embedded
• SQLite (Relational)
• BerkeleyDB / MapDB (Key/Value)
• In-Memory Server Database
• memcached (Key/Value)
• Redis (Key/Value)
• Disk-Based Server Database
• MySQL / Postgres (Structured)
• HBase / Cassandra  (Column-Family)
• MongoDB / RethinkDB (Document)