DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
Issue 87 — January 15, 2016
Featured
Designing Schemaless, Uber Engineering’s Scalable Datastore — Uber has developed its own MySQL-based schemaless storage system. This article explains why and how it came together.
Uber Engineering
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
Real-time Postgres monitoring — Visualize Postgres system resources, connections, locks, transactions, and indexes, and instantly correlate with metrics from anywhere in your stack.
Datadog    sponsored   
Using CTEs and Unions to Compute Running Totals — A look at combining CTEs with unions to give not just grouped results, but also side by side aggregates.
periscopedata.​com
How Developers Use Databases Today: A JetBrains Report — Insights based on responses from 2000 developers. One factoid: Postgres is the database most would like to migrate to, while MySQL is the one they most want to leave behind.
JetBrains    news   
Elasticsearch Replaces Solr As The Most Popular Search Engine — While they’re commonly used for their search functionality only, Solr and Elasticsearch are also document database engines of sorts. Elasticsearch has now pulled ahead of Solr in DB Engines’ rankings.
DB Engines    news   
Querying Amazon Kinesis Streams Directly with SQL and Spark Streaming — What if you could use your SQL knowledge to discover patterns directly from an incoming stream of data? Streaming analytics is a very popular topic of conversation around big data use cases.
Amazon    tutorial   
PipelineDB Releases First Enterprise Version Of Its Streaming SQL Database — PipelineDB is built on a new way of looking at SQL databases, thinking about streams of data rather than data at rest in big silos.
TechCrunch    news   
Hadoop's 10th Birthday — A look back at how Hadoop has gone from an unknown to the king of distributed data set processing systems.
Cloudera
Creating a Data Model For Carpooling — It’s always good to see how a database designer approaches modelling a situation. In this case, it’s a ride-sharing app.
Shantanu Kher
In brief
Does your company need Big Data? LambdaNow can help! — LambdaNow solves the complexity of Big Data by providing easy Big Data processing pipelines. Try it for FREE Now.
LambdaNow    tools    sponsored   
SQLite 3.10.1 Released — ‘Fixed a 16-month-old bug in the query planner that could generate incorrect results’
SQLite    news   
Picking the Right SQL-on-Hadoop Tool for the Job
Datanami    news   
Preview The Newest ODBC SQL Server Driver for Windows and Linux
SQL Server Team Blog    news    tools   
Survey: Big Data Goes Mainstream — “Financial services firms remain the biggest users of big data technologies”
Datanami    news   
JSON Support in SQL Server 2016
CodingSight    news   
Top 6 Database Performance Metrics to Monitor in Enterprise Applications
Omed Habib    tutorial   
What's New in Cassandra 3.0 - Part 1
SmartCat    tutorial   
Using the Ltree Datatype in Postgres
Leapfrog Online    tutorial   
Natural Language Processing with Spark on Reddit Comments
Data Reflexions    tutorial   
Graph Databases for Beginners: ACID vs. BASE Explained
Neo4j    tutorial   
As Data Science Evolves, It's Taking Statistics with It
Datanami    opinion   
PostgreSQL 9.6 Wish List
Neil McGuigan    opinion   
Medis: An Open Sourced Redis GUI Tool for OS X — Lets you view and edit keys, supports SSH tunnelling, config viewing/editing. It’s built using Node, Electron and React.
Zihua Li    tools   
MarsDB: A Promise Based Lightweight Database with MongoDB Query Syntax, Written On ES6
Artem Artemyev    code   
« Prev
Next »