--- title: "Bringing SQL to DynamoDB, Percona to Postgres, and NoSQL to the 'edge'" publication: "DB Weekly" issue: 268 published_at: "2019-08-23" canonical_url: "https://dbweekly.com/issues/268" --- This week's database news #268 — August 23, 2019 [Read on the Web](https://dbweekly.com/issues/268) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/v1566560254/m4vbujuwwetgzf6mm7me.png)](https://pingcap.com/success-stories/lesson-learned-from-queries-over-1.3-trillion-rows-of-data-within-milliseconds-of-response-time-at-zhihu/) [Lesson Learned from Queries over 1.3 Trillion Rows of Data Within Milliseconds](https://pingcap.com/success-stories/lesson-learned-from-queries-over-1.3-trillion-rows-of-data-within-milliseconds-of-response-time-at-zhihu/) — No big releases, so we’re leading with a detailed, technical case study this week 😄 _Zhihu_ is China’s largest question and answer site (think Quora) with over 220 million users. This post digs into how they use TiDB to keep things running at a low latency at scale. Xiaoguang Sun [DigitalOcean Introduces Managed MySQL and Redis Services](https://blog.digitalocean.com/take-the-worry-out-of-managing-your-mysql-redis-databases/) — Earlier this year we wrote about DigitalOcean’s steps into offering a managed PostgreSQL service, now they’ve introduced MySQL and Redis to the family too. André Bearfield [![\](https://copm.s3.amazonaws.com/fef0470e.png)](https://info.enterprisedb.com/WhitepaperMovingOracleWorkloadstotheCloud.html) [5 Decisions to Make When Moving Oracle Workloads to the Cloud](https://info.enterprisedb.com/WhitepaperMovingOracleWorkloadstotheCloud.html) — This tech guide covers five key decisions you’ll need to make to navigate your choices and enable your success. [Download now](https://info.enterprisedb.com/WhitepaperMovingOracleWorkloadstotheCloud.html). EnterpriseDB sponsor [Startup Rockset Adds SQL to DynamoDB](https://www.datanami.com/2019/08/21/startup-rockset-adds-sql-to-dynamodb/) — Rockset, the serverless search and analytics startup, has unveiled a SQL platform targeting AWS’s typically NoSQL_DynamoDB_. Datanami [Percona Distribution for PostgreSQL 11 (Beta) Now Available](https://www.percona.com/blog/2019/08/19/percona-distribution-for-postgresql-11-beta-is-now-available/) — Percona, perhaps more historically known for its MySQL performance expertise, is now in the Postgres world too. This Percona-flavored distribution of Postgres 11 includes a variety of tools and extensions to make Postgres more powerful and scaleable. Borys Belinsky (Percona) [Couchbase Mobile: NoSQL, but 'On The Edge'](https://hackernoon.com/couchbase-mobile-the-power-of-nosql-on-the-edge-dkdhx30jl) — Couchbase is a distributed NoSQL database which originally brought together ideas from [both](https://www.couchbase.com/couchbase-vs-couchdb) CouchDB and `memcached`. Couchbase _Mobile_ takes things a step further by enabling Couchbase to run directly on end users’ devices and sync against the master database in the cloud as and when appropriate. Rob Hedgpeth **Quick bytes:** - Amazon DynamoDB [served up to 45.5 million requests _per second_](https://aws.amazon.com/blogs/aws/amazon-prime-day-2019-powered-by-aws/) during Amazon's 2019 "Prime Day" with 7.11 trillion calls overall. - An AI-focused [chip with 1.2 _trillion_ transistors](https://venturebeat.com/2019/08/19/cerebras-systems-unveils-a-record-1-2-trillion-transistor-chip-for-ai/) has been created. A huge jump from the ~10bn a typical modern Intel CPU has. - Thousands of unencrypted _MoviePass_ customer card numbers and other data [were reportedly exposed for months](https://techcrunch.com/2019/08/20/moviepass-thousands-data-exposed-leak/) due to a critical server not being password protected. 💻 Jobs [Lead Security Engineer](https://grnh.se/59299dec1) — Make an impact as our first Security Engineer, focusing on driving innovation & best practices around our cloud security efforts. Cockroach Labs [DB developers are in demand on Vettery](https://www.vettery.com/tech?utm_source=newsletter&utm_medium=cooper-dbweekly&utm_term=tech&utm_content=grouped&utm_campaign=ad-88878) — Make a free profile, name your salary, and connect with hiring managers from top employers. Vettery 📒 Everything else [Understanding Apache Arrow Flight](https://www.dremio.com/understanding-apache-arrow-flight/) — Arrow Flight is a high-performance wire protocol for large-volume data transfer for analytics built for modern data transfer requirements (including security, parallelism and platform independence). It uses gRPC and HTTP/2 under the hood. Lucio Daza [How to Add IF-ELSE Logic to SQL Queries](https://dev.to/helenanders26/sql-201-how-to-add-if-else-logic-to-sql-queries-41j) — An introduction to `CASE`. Helen Anderson [Pagination with Relative Cursors](https://engineering.shopify.com/blogs/engineering/pagination-relative-cursors) — Using SQL’s `OFFSET` for ‘paging’ through a large set of replies can become inefficient at scale. One solution is relative cursor pagination because it remembers where you were and continues from that point onwards instead. Shopify Engineering [Test Drive GoCD’s CI/CD Pipelines in Minutes](https://www.gocd.org/test-drive-gocd.html?utm_campaign=gocd_test_drive&utm_medium=email&utm_source=cooperpress_serverless&utm_content=go_website&utm_term=) — Use our new test drive to quickly see how GoCD helps solve your CI/CD challenges with our first class pipelines, visualizations, and more. ThoughtWorks - GoCD sponsor [MySQL Load Balancing with ProxySQL on AWS Aurora](https://severalnines.com/database-blog/database-load-balancing-proxysql-aws-aurora) — An introduction to using [ProxySQL](https://proxysql.com/), an open source MySQL proxy, to balance the load of an Aurora database. Krzysztof Ksiazek [Data Engineering at Badoo: Handling 20 Billion Events Per Day](https://www.infoq.com/news/2019/08/badoo-20-billion-events-per-day/) — Badoo is an online dating network who are using Protobuf, Exasol, Spark, and CubeDB across their stack. There’s also [a 20 minute talk](https://skillsmatter.com/skillscasts/13983-data-engineering-in-badoo-handling-20-billion-events-per-day#video) you can watch. InfoQ [SuperSQLite: A 'Supercharged' SQLite Library for Python](https://github.com/plasticityai/supersqlite) — Offers unique features like remote streaming over HTTP and bundling of extensions like JSON, R-Trees (geospatial indexing), and Full Text Search Plasticity [kvrocks: A RocksDB-Based, Redis-Compatible Key-Value Database](https://github.com/meitu/kvrocks) — A new open source data store written in C++ that supports namespacing, MySQL-esque replication, but aims to use SSD disks as the backend storage to increase capacity (versus Redis’s memory-oriented approach). meitu [pgcmd: A Non-Interactive PostgreSQL Querying CLI Tool](https://github.com/soheilpro/pgcmd) — Essentially it lets you connect to a Postgres database, issue a query, and get the result back in JSON-format. Soheil Rashidi A **[Cooperpress](https://cooperpress.com/)** publication. [Change your email address](https://dbweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://dbweekly.com/leave/*|UID|*) © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom