DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
Issue 114 — July 22, 2016
Featured
Is Logical Data Modeling Obsolete? — When databases were sized in megabytes rather than petabytes, their design was a well-defined discipline of data analysis and implementation, but how have things changed in the modern era?
Andrew Wolfe    opinion   
3 NoSQL Databases You’ve Never Heard Of — A quick look at MUMPS (a 51 year old database designed for healthcare use), c-treeACE, and FinchDB.
Datanami    story   
How SmartNews Built a Content Recommendation Engine on AWS — Not solely about databases, but ultimately SmartNews is a heavily data-driven organization and its use of numerous tools and services is striking.
Amazon    story   
SQL Dashboards in a Flash. — Periscope Data lets you run analyses over billions of rows in seconds.
Periscope Data    sponsored   
Charting Neo4j 3.0 — “I want to show you how easy it got with Neo4j 3.0 to pull data from the graph into your JavaScript code and, for instance, create pretty charts from it.”
Michael Hunger    tutorial   
Using SQL to Monitor a PostgreSQL Database — PostgreSQL provides an activity-tracking module called the statistics collector, which tracks table access and other internal events. If your database is experiencing long wait times, you may be able to use this tool and some simple SQL to find and fix the problem.
Maria Alcaraz    tutorial   
Our Journey From Graph Databases to PostgreSQL — Graph databases have their time and place but just because you can do something in a graph database doesn’t mean it’s ideal. Here, follow a journey taken from Mongo to Neo4j to Postgres.
Engineering at Hipo    story   
BuntDB: Embeddable, In-Memory Key/Value Database in Go — A low-level, in-memory (but persists to disk), key/value store in pure Go, with geospatial support. Inspired by BoltDB.
Josh Baker    code   
Writing More Legible SQL — Writing SQL is one thing, but when it comes to reading other’s SQL, things can get tricky. These few tips will help to make your SQL much more understandable by others.
Craig Kerstiens    tutorial   
Redis Labs Raises $14M for Its In-Memory NoSQL Database Services — Redis Labs, the company behind the open source Redis data structure store, today announced that it has raised a $14 million Series C round led by Bain Capital.
Frederic Lardinois    news   
Jobs
Operations Engineer — We are looking for an experienced Operations Engineer to join our remote team to work on things like AWS deployment, Ansible, MySQL, nginx, unicorn & Sensu. Pacific, Alaska, & Hawaii–Aleutian Time Zones are preferred but this is not a requirement.
Harvest
Stop wasting time - know what you'll earn before the interview — On Hired, sign up in 10 minutes and get offers from top companies like GitHub, Uber, & Stripe. Engineers get an average of 5 offers on the platform in 1 week
Hired.​com
In brief
9 Ways Retailers Are Using Big Data and Hadoop
Datanami    news   
Building a Better Pokédex with SQL
Periscope    tutorial   
How to Know if a Given Index Can be Dropped on an Oracle Database
jOOQ    tutorial   
Inheritance: One More Reason to Love PostgreSQL — A brief look at table inheritance in Postgres, if you’re not already familiar with it.
Hans-Juergen Schoenig    tutorial   
Tuning MySQL: my.cnf, Avoid This Common Pitfall
Hayden James    tutorial   
Anatomy of an Elasticsearch Cluster: Part II
Ronak Nathani    tutorial   
Distributed Deep Learning on Spark — An overview of tools and frameworks that have been proposed for performing deep learning on Spark.
Alexander Ulanov    video   
Supercharging Apache Spark with Flash and NoSQL
datanami    story   
OhgodnoSQL: How Not To Do 'NoSQL on SQL'
The Daily WTF    story   
Migrating Adbrain’s Apache Spark Jobs From HDFS to Amazon S3: How We Did It
Zoltan Arvai    story   
Optimizing DISTINCT Performance in Postgres
Explain Extended
How Cassandra’s Inner Workings Relate to Performance
Manuel Kiessling
Getting Started with MongoDB: How to Turn a Calculated Risk into a Big Success
Robert Fehrmann    opinion   
Battle of Open Source Analytics: Spark vs Drill vs Quasar
John De Goes    opinion   
Where's the bottleneck? Find out with Datadog — Monitor DB performance alongside CPU, memory, disk, and network metrics to spot resource issues immediately.
Datadog    tools    sponsored   
PowerUpSQL: A PowerShell Toolkit for Attacking SQL Server — Tools to audit for weak configurations.
Scott Sutherland    tools   
JCQL: Java Code Linting with SQL — An interesting idea - querying source code with SQL.
Mahmoud Ben Hassine    code   
« Prev
Next »