#187: SQL Keys in Depth

This week's database news - Read this on the Web

Database Weekly Issue 187 — January 19, 2018

Datasette Publish: A Webapp for Publishing CSV Files as an Online Database — A tool that turns one or more CSV files into an online database with a JSON API, powered by SQLite and the Zeit Now deployment platform. Simon Willison   tools   Bistro: A Lightweight Column-Oriented Data Processing Engine — Written in Java, Bistro is an interesting new light-weight column-oriented data processing engine based on a novel column-oriented logical data model. Alexandr Savinov   code   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   SQL Keys in Depth — An attempt at boiling down the various arguments, pros and cons of different types of keys, whether they’re auto-incrementing integers, UUIDs, or other things. Joe Nelson   tutorial   Fueled by Kafka, Stream Processing Poised for Growth — Once a niche technique used only by large organizations, stream processing has emerged as a popular way to deal with massive amounts of freshly generated data. Datanami   news   How Alibaba Created a Stream System with Millions of Feeds — A first hand look at how Chinese ecommerce company Alibaba scales using its own custom extensions to PostgreSQL. Alibaba Tech   story   Using Redis as a True Distributed, Fault-Tolerant Database — The ‘trick’ here is that you’re not using Redis per se, but Yugabyte, a database that supports the Redis protocol and can be used in-place of it. Karthik Ranganathan   tutorial   Go Deep into Today’s Modern Data Tier to See the Root of the Problem Fast SelectStar   sponsored   How We Sped Up Eventually-Consistent Database Global Syncs with Caching — They reduced an already solid time of 1 second for global consistency to 0.25 seconds by adding a volatile cache. Chaitanya Patchava   story   Don't Throw Out Your Algorithms Book Just Yet: Classical Data Structures That Can Outperform Learned Indexes — An interesting response to this paper we linked to last year about machine learning based indexing systems. Bailis, Sheng Tai, Thaker, and Zaharia   story   Graphile: Instant GraphQL APIs for Postgres Databases — Auto-discovers tables, columns, relations, procedures and more, then runs a high-performance secure GraphQL API server that adheres to best practices. Benjie Gillam   tools   What's The Effect of 'Meltdown' on Postgres's Performance? — How have the fixes for the recent Spectre and Meltdown CPU vulnerabilities affected Postgres performance? This first look suggests about a 7% hit. 2ndQuadrant   news   How to Migrate an Azure SQL Database to Amazon Aurora Steve Abraham   tutorial   Using SymmetricDS to Replicate Your Database Structure — An open source database replication tool that can be used to keep heterogeneous databases in sync. Chris Henson   tutorial   Analyzing Cassandra Performance with Flame Graphs Jon Haddad   tutorial   Linux Cloud Hosting Starting at 1GB of RAM for $5/mo Linode Cloud Hosting   sponsored   Scaling YugaByte DB to Millions of Reads and Writes — An open source database that supports Cassandra and Redis APIs. Bharat Baddepudi   story   PL/Swift: Write Custom PostgreSQL Functions in Swift The Always Right Institute   tools   Database Weekly is curated by Peter Cooper Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK