#297 — March 27, 2020 |
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 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.. |