Issue 297 - Offbeat databases and a new full text search system (16)

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.

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!)

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.

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.

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?)

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).

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.

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.

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...

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.

Try Studio 3T: The best way to get started with MongoDB — Code translation in a click? Easy SQL to MongoDB Migration? We’ve got it - and more. Get your 30-day trial today to see.

Tile38: A Geospatial Database, Spatial Index, and Realtime Geofence — 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, Geohashes, and GeoJSON.