Issue 127 — October 21, 2016
Featured
Picking A Cloud Database for Analytics: The SQL Options — "Amazon Redshift and Google BigQuery provide particularly compelling answers for running analytics queries on event data."
Andrew Montalenti opinion
Your Database is Your Prison - Here's How Expensify Broke Free — A business oriented look at the relationship between a startup, the database it uses, and how database choices affect security and more.
First Round story
How We Build TiDB, a NewSQL Database — The story of how and why a team is building TiDB, a new distributed SQL database inspired by Google’s F1 and including the best of both traditional RDBMS and NoSQL.
Max Liu story
Linode is the SPEEDIEST SSD host for your DB - simple, reliable & powerful. — MySQL? MariaDB? PostgreSQL? Whatever DB you use, run it on a Linode, the most scalable, reliable and fastest servers in the cloud. Use promo code
DB20 for a 20ドル credit and get started. linode sponsored
SQLite Archiver: A Tool for Packaging Assets in an SQLite Database — Takes a file or a list of files and and creates a SQLite database with the files as stored as BLOBs. You can also mount this archive as a FUSE filesystem.
Jamie Little tools
MySQL Cluster 7.5 Released — With support for 128TB+ data set sizes per data node you can both better scale up and out with this release. It’s compatible with MySQL 5.7 under the hood.
Oracle tools
Interactive Analytics: Redshift vs Snowflake vs BigQuery — Periscope thoroughly analyzes the use of Redshift, Snowflake and BigQuery for data warehouse-based analytics work. (Spoiler: Redshift won for them.)
Periscope story
MongoDB's JavaScript Fuzzer: Creating Chaos — Mongo’s fuzz tester is now their most prolific bug finding tool. Here’s a look at how it works.
Robert Guo story
Jobs
Data Integration Engineer (Kafka/ElasticSearch/Postgres/Python) — Want to help make sense of the data behind the 1ドル trillion real estate market? Hundreds of data feeds to normalize. Millions of photos to classify. Millions of user events to analyze. You name it, we got it.
REALSCOUT
Shouldn't Companies Apply to You? - Try Hired — You're on the cutting edge of technology, why job hunt like it's the 90s? Try Hired today and have 4,000+ top companies apply for the chance to interview you.
Hired
In brief
SQLite 3.15.0 Released — A key addition is support for row values.
SQLite news
MySQL on Compose - hosted on AWS, GCP or SoftLayer — Get the most from your favorite RDBMS with 3 Node HA, Daily Backup and Auto-scaling. See how easy it is to connect your Database, hassle-free.
Compose sponsored
Steven Yue tutorial
Declarative Data Fetching with GraphQL — Nilan Marktanner creates an Instagram clone highlighting some of the benefits that GraphQL brings to the table.
CSS Tricks tutorial
Yhat tutorial
Jeremy Duvall tutorial
jOOQ tutorial
Survey: The Hidden Costs of Data Operations — VividCortex are seeking opinions on how your organization handles its database systems.
Baron Schwartz opinion
SQL Source Control: track each change to your SQL Server database — Get a full history in your source control system. See who made changes, what they did & why. See how.
Red Gate sponsored
Capacitor Set code
Instaclustr code
github.com code
Sebastian Van Sande code