DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
Issue 141 — February 10, 2017
Featured
mongoaudit: A MongoDB Auditing and Pentesting Tool — Secure your Mongo installation with this security testing tool that looks for misconfigurations, known vulnerabilities, etc.
Stampery Inc.​    tools   
The Liberation of RethinkDB — Back in October we sadly reported the company behind RethinkDB was closing. The project, however, lives on, as explained here.
Bryan Cantrill    news   
Superset: How Airbnb Scales Data Access and Visual Insights — Now open sourced (GitHub repo), Superset is a powerful data exploration platform. The animated GIFs on its README show off the potential well.
Airbnb Engineering    tools   
[Free Tool] Square Root Staffing Law Workbook — This free Excel workbook uses the square root staffing law to estimate the amount of capacity users need to provision to provide uniform quality of service at a higher load than their systems currently handle.
VividCortex    sponsored   
Here's How Evernote Moved 3 Petabytes of Data to Google's Cloud — Last year Evernote decided that it wanted to move away from running its own data centers and start using the public cloud to operate its popular note taking service.
PCWorld    story   
Building A Serverless App with A Serverless Database — FaunaDB claims to be ‘the first truly serverless database.’ An odd claim, but this will help you see how it works.
Fauna
Joining A Billion Rows 20x Faster Than Apache Spark — SnappyData is an open source in-memory platform built on top of Spark. Here it’s claimed it can benchmark 20x faster than Spark at joining two columns over a billion rows.
Sumedh Wale    story   
PostgreSQL 9.6.2, 9.5.6, 9.4.11, 9.3.16 and 9.2.20 Released — This group release includes fixes that prevent data corruption issues in index builds and in write-ahead-log replay situations, and patches over 75 other reported bugs.
PostgreSQL    news   
In brief
Wanted (Badly): Big Data Engineers — A report ‘confirms surging demand for data scientists, engineers and analysts’.
Datanami    news   
Put your DB into overdrive on Linode’s SSD servers. — Whatever your preferred DB, get better performance by loading it on Linode. Use promo code DB20 for $20 credit.
linode    sponsored   
How to Enforce Uniqueness of A Compound Primary Key Made Up of Two Foreign Keys
DBA Stack Exchange    tutorial   
Everything You Need to Know About MySQL Partitions
Vertabelo    tutorial   
Building a Performant API using Go and Cassandra — A walkthrough of building a RESTful Web API that uses the Cassandra NoSQL database.
Ian Douglas    tutorial   
How SendGrid Backs Up Riak and Solr Data
Brad Culberson    tutorial   
Beautiful SQL: Lateral Unnesting of Array Columns
JavaOOQ    tutorial   
Graphing Intent: Inside a Consumer Tracking Database
Datanami    story   
Indexing in an Actor-Oriented Database [PDF] — An academic paper.
Bernstein, Dashti, Kiefer and Maier    story   
Exactly Once: Why It's Such a Big Deal for Apache Kafka — “exactly once guaranteed delivery of messages” is coming to Kafka soon.
Datanami    story   
Postgres-XL: MPP and Horizontally Scalable PostgreSQL

 — Flexible enough to handle OLAP & OLTP workloads. Horizontally Scalable with all the features of PostgreSQL.
2ndQuadrant PostgreSQL Products    tools    sponsored   
RavenDB Embedded at Massive Scales — An open source .NET NoSQL database.
YouTube    video   
Go Data Science with Daniel Whitenack [podcast] — Daniel Whitenack explains the workflow of a data scientist and discusses why Go is suited to it.
Software Engineering Daily
Advanced SQL Recipes — A (growing) compendium of advanced SQL tricks you can adopt to jump-start your next analysis.
Silota
« Prev
Next »