#326 — October 16, 2020

Read on the Web

Database Weekly

VisiData 2.0: A Terminal Spreadsheet Multitool for Discovering and Arranging Data — Here’s an introductory tutorial to what you can use this tool (which has been described as 'vi for data' before) for or maybe you'd prefer a 4-minute lightning talk/demo by its creator (even if you don't like videos, it's worth seeing the tool in action).

Saul Pwanson

Oracle Launches High-Performance Cloud Database ServiceOracle Exadata Cloud Service X8M is designed to provide existing Oracle customers with a way to tackle larger (or ‘most challenging’) data problems without any underlying app changes.

Mike Wheatley

Crunchy Bridge: More Postgres Power, Less Administration — A better option for your Postgres hosting. With a rich set of extensions like PL/Python + SciPy/NumPy/Pandas and more on demand, Crunchy Bridge is made for modern apps. Built by Postgres experts and the team who brought you Heroku Postgres.

Crunchy Data sponsor

Making 2 Million Ancient Usenet Posts Available with Postgres and PythonUsenet was a fascinating distributed discussion system whose heyday was in the 80s and 90s and there are various archives of posts made to it (such as someone asking what Postgres is in 1989!).

Jozef Jarosciak

Machine Learning Straight Through SQL with MariaDB — You can now train and run ML models straight from MariaDB using SQL thanks to MindsDB and the CONNECT storage engine.

Vicențiu Ciorbaru

Aggregate All The Things: New Aggregations in Elasticsearch 7 — The popular search-oriented document database has added some new aggregations like rare_terms, top_metrics, and auto_date_histogram.

Alexander Reelsen (Elastic)

Alphora-Style Database Diagramming — Thoughts on database diagramming and one approach to referencing between tables.

McKay Salisbury

Security Best Practices for PostgreSQL — Here's a framework and a series of recommendations to secure and protect a PostgreSQL database. Download white paper.

EDB sponsor

⚙️ Code and Tools

Couchbase Shell: A Modern Shell for Couchbase Server and Cloud — Provides an appealing terminal-based way to work with Couchbase. Written in Rust and works on Windows, Mac and Linux.

Couchbase

A List of Useful SQL Server Tools — Taryn is a database administrator at Stack Overflow and this is what she uses day to day to work with SQL Server when she’s doing cool stuff like migrating 40TB databases.

Taryn Pratt

An Introduction to Jedlik: Nicer DynamoDB for Node Developers — An object-document mapper (ODM) for Node, written in TypeScript, designed to make DynamoDB (Amazon’s hugely scalable document database service) easier to work with.

Michael Harrison

Cayley: An Open-Source Graph Database Built for Linked Data — Cayley supports several backends including LevelDB, PostgreSQL, Mongo, and more.

Cayley

Couchbase Lite 2.8 and Sync Gateway 2.8 Now GA

What is Flexible Server in Azure Database for MySQL?

🔗 From the queue..

We have a special system for managing our links, leads, and submissions, but we don't ever get to use all of the great links we have because we don't want to overwhelm you each week.

Nonetheless, there are still lots of great things in our 'queue' and it's a shame not to share them, so in occasional issues we'll be including this special section (which you can skip by all means!) to share some love to items that didn't make it into issues at the time for whatever reason.

Enjoy!

___

What Was the Worst Database Decision You Ever Made?

▶  Things Every Developer Needs to Know About Database Indexing

How to Achieve High Availability with a DBaaS Provider

MySQL Storage Engine Optimization: Configuring InnoDB Optimization For High Performance

Evaluating MongoDB Under Python TPCC 1000W Workload

Fast Loading Data Into Azure SQL: A Lesson Learned