Issue 127 — October 21, 2016
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.”
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.
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.
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
for a $20 credit and get started.
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.
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.
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.)
— Mongo’s fuzz tester is now their most prolific bug finding tool. Here’s a look at how it works.
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.
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.
SQL Server 2016 Express Edition in Windows Containers Now Available
SQLite 3.15.0 Released
— A key addition is support for
Announcing Automated Daily Backups for the Firebase Database
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.
Building SQL Queries with Temporary Tables vs WHERE IN
Declarative Data Fetching with GraphQL
— Nilan Marktanner creates an Instagram clone highlighting some of the benefits that GraphQL brings to the table.
PandaSQL: Make Python Speak SQL
Creating A Mongo Cluster in AWS with Ansible
How to Quickly Rename all Primary Keys in Oracle
Datanet: A New CRDT Database That Let's You Do Bad Bad Things to Distributed Data
Survey: The Hidden Costs of Data Operations
— VividCortex are seeking opinions on how your organization handles its database systems.
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.
Cassandra 3.7 LTS: A 3.x Edition with Backported Bugfixes
RXHash: Missing Redis Commands for the Hash Type
migrate-mongo: A Database Migration Tool for MongoDB in Node
Sebastian Van Sande