DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
Issue 190 — February 9, 2018
RavenDB 4.0 Released: A Transactional NoSQL Database — A fully transactional all-in-one document database. 4.0 is 10x faster than 3.0 and it now runs on Windows, Linux, Mac and in Docker.
Ayende Rahien   news  
An Advanced SQL Window Function Quiz — “A lot has changed since SQL-92,” they say, so why not test out your knowledge. You’ll need to be familiar with SUM and HAVING to just pass Q1, by the way..
Andy Boot   tools  
Use SQL in MongoDB? But of Course You Can. We'll Show You How — And there's so much more to discover. Like SQL Import & Export. Or our innovative Query Code that lets you instantly generate code from our Query Builder in Node.js, Python, or C#.
Studio 3T   sponsored  
Standard SQL Features Where PostgreSQL Beats Competitors — Code-heavy slides from a talk given at FOSDEM PgDay that cover filters, BOOLEAN tests, XMLTABLE, and inverse distribution functions.
Markus Winand
Find the Longest Continuous Number of Days a Stock Went Up — We all love a good, thorough SQL tutorial, right? This is a great walkthrough of bringing together several SQL features in a relatively advanced way.
Dimitri Fontaine   tutorial  
Calculating Tupper’s Self-Referential Formula With SQL — This is very geeky but very cool.
JooQ   tutorial  
Why 2018 Will Be The Year of the Data Engineer — Every indicator I’ve seen in recent years shows no possibility of work slowing down for good data engineers and data from Glassdoor and Indeed seems to confirm it.
Datanami   opinion  
How Erasure Coding Changes Hadoop Storage Economics — “The introduction of erasure coding with Hadoop 3.0 will allow users to cram up to 50% more data into the same cluster.”
Datanami   story  
Your Database Should Work Like a CDN (Says CockroachDB) — Could distributed database performance (both in terms of latency and uptime) be dramatically improved with CDN-like multi-region deployments?
Sean Loiselle   opinion  
Big Data Driving Hyperscale Datacenter Surge — A surge in data analytics work is good news for companies supplying datacenters.
Datanami   news  
PostgreSQL 10.2, 9.6.7, 9.5.11, 9.4.16, and 9.3.21 Released — Fixes security, data corruption, and parallel query issues.
postgresql.​org   news  
Elasticsearch To Soon Gain Built-In SQL Support
This Week in Elasticsearch   news  
Amazon Aurora Now Compatible with MySQL 5.7
Amazon Web Services   news  
Proper Indexing Is Key to Database Performance, Let Percona Show You How
Percona   sponsored  
Configuring sql.DB for Better Performance
Alex Edwards   tutorial  
Powering PHP with JanusGraph
Don Omondi   tutorial  
Creating Fast, Lightweight Testing Databases in Docker
Kevin Barresi   tutorial  
How to Find Unused Indexes in MongoDB
Dharshan Rangegowda   tutorial  
How to Pivot Data with SQL
Markus Winand   tutorial  
Solving a 'Reindeer Ordering' Logic Puzzle with SQL
Damir Sudarevic   tutorial  
Running a 400+ Node Elasticsearch Cluster
Anton Hägerstrand   story  
How Apache Kafka Inspired Salesforce's Platform Events Architecture
Alexey Syomichev   story  
Making 30x Performance Improvements on Yelp’s MySQLStreamer
Abrar Sheikh   story  
3 Essential DBA Career Priorities For 2018 — Could ‘self-driving’ databases change the game for DBAs in 2018?
Jeff Erickson (Oracle)   opinion  
What Is Time Series Data and Why Should You Care?
InfluxData   sponsored  
Oracle NoSQL Database Now Downloadable in an Easier VM Format — If you want to get started quickly with Oracle’s NoSQL database in VirtualBox or VMWare Workstation, say.
Michael Schulman   tools  
MongoDB Tools: A Directory of MongoDB Tools — And issue 2 of our new MongoDB newsletter just went up too.
Ian Whalen   tools  
« Prev
Next »