DB Weekly
Issue 60 — May 29, 2015
Hacker News
It’s not easy, but some people fight MySQL’s corner pretty well.
William Lyon
A look at how to use a graph database to implement a feature that recommends articles to users based on other articles they’ve shared on Twitter.
Yan Cui
A look at some of the concepts behind modelling the economy within a game using a graph database.
BrightTALK
Sponsored
Check out this webcast recording which covers a range of database technologies from MySQL/Percona to Hadoop, Mongo, and Redis. You’ll learn how you can fit all of these technologies together to make your data flow seamlessly between them and optimize your database performance. View Now.
Couchbase
"Couchbase Server was able to sustain 1.1 million writes per second. The data set size was 3 billion items with a value size of 200 bytes."
Mark Dumphy
And got a 70% cost savings. Why and how?
2nd Quadrant
Sometimes complex orderings then calculations over data can be a bit complicated in SQL. Postgres 9.4 quietly brought a few new functions that make it more powerful and easier to iterate over groups of data for things like percentiles and more.
Channel 9
Temporal in SQL Server is designed to simply the handling of time-varying data. It provides the ability to look at data trends, types of data changes, and the overall data evolution within your database.
Jobs
-
Database Administrator (Blacksburg, VA) Rackspace is seeking a Senior Database Administrator in our Blacksburg, VA office. The Senior DBA will be responsible for maintaining the company’s database systems (currently MS SQL Server) including back-up, performance tuning, capacity planning, monitoring critical events and documentation. Learn More.
Rackspace
In brief
-
Microsoft's Study into NoSQL Usage for .NET Applications news
If you can help Microsoft’s Data Platform Team, check out this survey.
Microsoft Data Platform Team -
PostgreSQL 9.4.2, 9.3.7, 9.2.11, 9.1.16, and 9.0.20 Released news
postgresql.org -
Postgres Pushes Past MySQL in Developers' Hearts news
TechRepublic -
MySQL 5.7's Key Features news
Muhammad Irfan -
SQL Server to add JSON Support news
InfoQ -
Collaborative Filtering Recommender System Use Case Scenario in OrientDB tutorial
A way of using a graph database like OrientDB for building a recommendation system.
wildgraph -
Preventing SQL Injection in PHP Applications - the Easy and Definitive Guide tutorial
Paragon Initiative Enterprises -
Typechecking SQL in Slick and doobie (in Scala) tutorial
Richard Dallaway -
SQL Server Radio: An SQL Server Podcast
Madeira SQL Server Services -
3 Must-Read Books About Database Performance
Database Friends -
A Review of Kent Graziano’s 'A Check List for Doing Data Model Design Reviews' opinion
Grzegorz Kaczor -
Simple Scheduled Backups for MongoDB tools
Afshin Mehrabani -
Awesome MySQL: A Curated List of MySQL Resources and Tools tools
Shlomi Noach -
elasticsearch-sql: Use SQL to Query Elasticsearch code
Query elasticsearch using familiar SQL syntax. You can also use ES functions in SQL.
NLPChina -
mgfs: Mount A MongoDB Database As A Filesystem code
Amin -
Reqlite: RethinkDB in JavaScript code
An implementation of a ReQL server in JavaScript.