--- title: "No code, lots of rows, and Twitch plays CockroachDB" publication: "DB Weekly" issue: 310 published_at: "2020-06-26" canonical_url: "https://dbweekly.com/issues/310" --- Plus more database news, views, and links. #310 — June 26, 2020 [Read on the Web](https://dbweekly.com/issues/310) Database Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/n5qiefabl5wa2djjezb8.jpg)](https://aws.amazon.com/blogs/aws/introducing-amazon-honeycode-build-web-mobile-apps-without-writing-code/) [Amazon Honeycode: A New AWS Tool to Build Database Apps without Code](https://aws.amazon.com/blogs/aws/introducing-amazon-honeycode-build-web-mobile-apps-without-writing-code/) — Despite some reservations over the name, this feels a bit like Access meets Excel meets the cloud and will allow a wider range of users to build data-driven online apps without learning to code. Jeff Barr [Query 1.6 Billion Rows on QuestDB in Milliseconds, Live](http://try.questdb.io:9000/index.html) — An online demo of [QuestDB](https://questdb.io/), a high performance time-series database that promises millisecond latency on keyed aggregations that span over billions of rows. The creator [explained more here](https://news.ycombinator.com/item?id=23616896). QuestDB [![\](https://copm.s3.amazonaws.com/7a78690c.jpg)](https://www.cockroachlabs.com/blog/cockroachdb-sigmod-2020/?utm_campaign=cooperpress-2020-Q2&utm_source=dbweekly&utm_medium=newsletter&utm_content=dbweekly-primary-sigmod) [SIGMOD 2020 Publishes Research Paper on CockroachDB](https://www.cockroachlabs.com/blog/cockroachdb-sigmod-2020/?utm_campaign=cooperpress-2020-Q2&utm_source=dbweekly&utm_medium=newsletter&utm_content=dbweekly-primary-sigmod) — This research paper, published by SIGMOD, presents the design of CockroachDB and its novel transaction model that supports consistent geo-distributed transactions with a scalable SQL interface. Cockroach Labs sponsor [Splitgraph: A Code-Like Data Versioning and Management System](https://www.splitgraph.com/blog/introduction) — Inspired by Docker and Git and built, initially, for PostgreSQL, Splitgraph’s core idea is it lets you build Docker image-esque ‘data images’. Miles Richardson and Artjoms Iškovs **⚡️ Quick bytes:** - Maybe you already knew this, but I just discovered that since SQLite 3.25.0, you can rename columns with [`ALTER TABLE`](https://www.sqlite.org/lang_altertable.html) - If you've seen Twitch livestreams where groups of people control a game via chat, [there's now a similar thing for CockroachDB!](https://www.twitch.tv/twitchrunscockroachdb) - Oracle has released an [open 'community edition' of Coherence](https://blogs.oracle.com/oraclecoherence/announcing-coherence-community-edition), a system for building in-memory data grids. [Repo here.](https://github.com/oracle/coherence) Written in Java, naturally :-) - PingCAP has [announced TiDB Cloud](https://pingcap.com/blog/announcing-tidb-as-a-service-fully-managed-tidb-offering), offering the TiDB real-time hybrid HTAP database 'as a service' on both AWS and GCP. 💻 Jobs [Database Engineer (Remote)](https://apply.workable.com/harvest/j/366721E76A/) — Got experience designing cloud database infrastructure? Join an independent software company and work with our Senior Database Engineer, helping us design new production systems in Google Cloud. HARVEST [DevOps Engineer at X-Team (Remote)](https://x-team.com/remote-devops-engineer-jobs/?utm_source=cooperpress&utm_medium=email-ad&utm_campaign=db) — Join X-Team and work on projects for companies like Riot Games, FOX, Coinbase, and more. Work from anywhere. X-Team 📄 Articles [Jepsen Analysis of Redis-Raft, Raft Consensus for Redis](https://jepsen.io/analyses/redis-raft-1b3fbf6) — It’s been a busy time for Jepsen having analyzed [Postgres](http://jepsen.io/analyses/postgresql-12.3) and [MongoDB](http://jepsen.io/analyses/mongodb-4.2.6) recently (and finding bugs in both!) – this time they take on [RedisRaft](https://redislabs.com/blog/redisraft-new-strong-consistency-deployment-option/), a mechanism for bringing Raft consensus to a [Redis](https://redis.io/) cluster. Kyle Kingsbury [A Surprising Way to Do Data Science with Node.js](https://opensource.com/article/20/6/server-side-data-science-nodejs) — This is really aimed at data scientists who _don’t_ use Node right now in order to see how Node can be used to do some data analysis and use D3.js to produce an SVG chart. Cristiano L. Fontana [We Help Customers Speed Up Postgres Queries By 1000x. Learn How](https://pganalyze.com/ebooks/optimizing-postgres-query-performance?utm_source=DBWeeklySecondary06262020) — With pganalyze, companies like Atlassian are able to speed up their queries by orders of magnitude. See our best practices for optimizing PG performance in this free eBook. pganalyze sponsor ▶[ClickHouse: The Fastest Data Warehouse You've Never Heard Of](https://www.youtube.com/watch?v=fGG9dApIhDU) — We’ve _heard_ of it, but this hour long talk does a good job of giving us a feel for what it can do and how it works. Robert Hodges (Altinity Engineering) [Spark 3.0 Brings Big SQL Speed-Up, Better Python Hooks](https://www.datanami.com/2020/06/25/spark-3-0-brings-big-sql-speed-up-better-python-hooks/) — Further reflections on last week’s release. Datanami 🔨 Tools and Code [DB Browser for SQLite (DB4S)](https://sqlitebrowser.org/) — A high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. [v3.12.0](https://sqlitebrowser.org/blog/version-3-12-0-released/) came out last week with improved table editing and conditional formatting when browsing data (a bit like a spreadsheet might). Martin Kleusberg et al. [Irmin: A Distributed Database Built On The Same Principles as Git](https://irmin.org/) — An OCaml library for building mergeable, branchable distributed data stores. MirageOS [Announcing the 1.0 Release of the Official MongoDB Swift Driver](https://www.mongodb.com/blog/post/announcing-release-official-swift-driver) MongoDB 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