DB Weekly
Issue 62 — June 19, 2015
Pat Shaughnessy
Here’s a continued very deep dive into what happens under the covers of Postgres when you run a select statement. If you’ve ever been curious about the internals of Postgres this is a great primer.
JavaWorld
Pinot is a realtime distributed OLAP datastore used at LinkedIn to deliver scalable real time analytics with low latency. It’s designed to scale horizontally and is open source.
Microsoft Virtual Academy
A professionally filmed 29 minute ‘getting started with databases’ video.
ObjectRocket
Sponsored
Redis has come a long way from being a small personal project from Antirez, to being an industry standard for in memory data storage. With that comes a set of best practices that most people can agree upon for using Redis properly. Check out 10 quick tips on using Redis correctly.
Barry Jones
If you want to use Postgres, but not run and maintain it yourself, Heroku or AWS are two compelling options. This is a thorough rundown of what you can expect from each.
Periscope
"If you’re choosing a database for analysis purposes and you stumble across this post, read on and learn why MySQL is the wrong choice."
William Lyon
How we can use the Neo4j graph database to help model a text corpus as a graph and implement a simple paradigmatic relation mining algorithm.
Pat Shaughnessy
"Don’t let your data out of the database until you need to... until you have just the values your application really needs." Pat Shaughnessy looks at the benefits of letting your database take the strain instead of your programming language.
Zalando
Zalando’s Head of Data Engineering, Valentine Gogichashvili, shares their experiences with PostgreSQL and how it fared scaling up to 100 million visitors per month.
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
-
SQL Server 2016: Always Encrypted news
SQL Server 2016 seeks to make encryption easier via its new ‘Always Encrypted’ feature.
InfoQ -
Cloudera Hub Adds VoltDB as 'Fast Data' Front End news
Datanami -
ERPScan Claims SAP Hana Riddled with SQL Injection Vulnerabilities news
SAP Hana is SAP’s in-memory database.
Computing -
A First Look at System-Versioned Temporal Tables in SQL Server 2016 news
SQL Server Pro -
MongoDB 3.0.4 Released news
MongoDB Blog -
Understanding Your App and Its Users with The Power of Neo4j tutorial
Ognjen Bubalo -
How to Install, Configure and Secure MySQL/MariaDB on Linux tutorial
LinuxVeda -
Querying Your Database from Millions of Fibers (Rather than Thousands of Threads) tutorial
jOOQ is a great way to do SQL in Java and Quasar fibers bring much improved concurrency.
Java, SQL and jOOQ -
Painless Microsoft SQL Server with Node.js and seriate tutorial
David Neal -
On Selecting a Shard Key for MongoDB tutorial
Bryan Reinero -
Using RethinkDB with ExpressJS tutorial
Craig Walsh -
Best Practices for Upgrading to MongoDB 3.0 video
Richard Kreuter -
Ask HN: What Are The Best Tools for Analyzing Large Bodies of Text? opinion
Hacker News -
Why XML-in-RDBMS != MongoDB opinion
Why the XML-as-column approach comes with a large set of gotchas.
MongoDB -
Connecting Neo4j to Any SQL Tool with the Power of Postgresql tools
A Python and Multicorn-based foreign data wrapper that brings together Neo4j and Postgres.
Benoît Simard -
SheetDB: Connect Remote SQL Databases with a Google Sheet code tools
Allows you to connect to a remote SQL server and load data into Google Sheet directly.
Xuefeng Zhu