#297 — March 27, 2020

Read on the Web

Database Weekly

9 Offbeat Databases Worth A Look — Popular, well tested databases have a huge benefit in sense of community, documentation, and proven performance, but keeping an eye on newer or less common databases can prove educational (or, in the best case, perfectly suited to your unusual use cases!)

Serdar Yegulalp

MeiliSearch: Fast, Open Source Full Text Search Database — Think of this as a zero-config alternative to Elasticsearch. It’s built in Rust and supports things like tolerating typos in queries, filters, synonym checks, and is well suited for fast ‘as you type’ searches.

MeiliSearch

Announcing DataPub: New Virtual Meetup for Open Data Enthusiasts 🎉 — Love open datasets, hearing about community members’ projects, and learning how to build your own? Join us on Mar 31st for DataPub (100% virtual) to learn ways to use public data to monitor situations (including COVID-19), rework inefficient queries, and more.

Timescale sponsor

NASA to Launch 247 Petabytes of Data Into AWS, But.. — …they possibly forgot about the potential egress costs. (If my wrangling with the Amazon S3 calculator is right, that’d be over $12m just to download the entire dataset once?)

Simon Sharwood (The Register)

AWS Adds Role-Based Access Control to Amazon DocumentDB — DocumentDB is AWS’s ‘MongoDB compatible’ document database service and now you can grant users roles (e.g. read, readWrite or dbOwner).

Amazon Web Services

MongoDB Helping Developers Tackle COVID-19 — MongoDB, Inc. is giving out free MongoDB Atlas (their database-as-a-service platform) credits for those detecting, understanding and stopping the spread of COVID-19.

MongoDB, Inc.

If You're Running memcached 1.6.0 or 1.6.1 Update ASAP — A nasty buffer overflow vulnerability was shared publicly in a GitHub issue complete with a POC so you want to upgrade 1.6.0 or 1.6.1 installs to 1.6.2 as soon as possible.

memcached community

A Look at Embedded SQL in C for Postgres with ecpg — A quick look at what is generously called a ‘vintage technology’ (i.e. old fashioned) where you write SQL directly inline within, say, a C program and compile it to handle all the database work behind the scenes. I’d never seen this style of programming before, so it’s interesting even if I’ll never use it.

Laurenz Albe

Getting Fast Subsets of Large Datasets with Pandas and SQLite

Itamar Turner-Trauring

Ask HN: How Do You Update Multiple Disparate Databases?

Hacker News

🔨 Code and Tools

SymmetricDS: An Open Source Database Replication System — A Java-powered system supporting one-way or multi-master replication, including transformations, across many databases including Oracle, MySQL/MariaDB, Postgres, SQL Server, SQLite, MongoDB, and more.

JumpMind Inc.

Tile38: An In-Memory Geolocation Data Store and Spatial Index — Built in Go, Tile38 is an in-memory geolocation data store that supports a variety of object types including lat/lon points, bounding boxes, XYZ tiles, Geohash, and GeoJSON.

Josh Baker

The Perfect Partner to MongoDB Atlas. Try It for Free, for 30 Days — Studio 3T is the toolkit you need to unlock the power of MongoDB Atlas. Export easily, translate code instantly.

Studio 3T sponsor

SQLiteFlow: An SQLite Data Editor for Mac and iOS — Costs money but has a trial.

HyperObjc

csvs-to-sqlite: Convert CSV Files Into a SQLite Database — A tool written in Python.

Simon Willison

node-sqlite 4.0 Beta: An SQLite Client Library for Node.js Apps — A wrapper library for Node apps with zero dependencies. With the new v4 still in beta, the maintainer is keen for you to try it out and report any issues.

Kriasoft

🐦 And if you have $3 million to burn on a database..