Straight from the horse’s mouth: FoundationDB is a distributed datastore, designed from the ground up to be deployed on clusters of commodity hardware. And: The key-value store supports fully global, cross-row ACID transactions. That’s the highest level of data consistency possible. What does this mean for you? Strong consistency makes your application code simpler, your data models more efficient, and your failure modes less surprising. They say it’s “actively developed and has years of production use”. I wish they’d say exactly how it’s being used in production. (Maybe they do and I haven’t found it yet?) Also, if you’re getting hung up on “key-value store”, the vision is much bigger than that.

read more

Matt Jaffey joined the show and talked with us about Pilosa, building distributed index with Go, and other interesting projects and news.

read more

Philipp Krenn joined the show to talk with us about Elasticsearch, the problem it solves, where it came from, and where it’s at today. We discussed the query language, what it can be compared to, whether or not it’s a database replacement or a database complement, Elasticsearch vs Elastic the company. We also talked about the details behind Elastic’s plan of “doubling down on open” to open up X-Pack, which is open code paid add-on features to Elasticsearch. We discussed the implications of this on their business model, and what changes will take place at the code and license level on GitHub.

read more

Dimitri Fontaine shares 3 classic data-modeling anti-patterns. The UUID section lacks strong argumentation, but the real gem in this article is his advice at the end. A snippet: My advice is to always normalize your database model first, and then only fix the problems you have with that when you actually have them. Well except in those 3% of cases where really, really, it should be done in the design phase of the project. It’s quite hard to recognize those 3% though, and that ability is hard gained with experience. Experience is the ultimate teacher.

read more

This is plugin is by Tim Pope (the unofficial pope of Vim plugins), so the chances of it being high quality are… high. It supports the typical RDBMSes (Pg, MySQL, Sqlite) as well as a few NoSQL flavors (Mongo, Redis).

read more

If this is a repeat for you, then pay no attention. I was recently introduced to this tool by @jerodsanto who logged this awhile back when he found it. 💫 If you’re on macOS you don’t want to open up Numbers to fiddle with a .csv file — that’s why Jakob Egger, the creator of Egger Apps, created it. Download it on the Mac App Store.

read more

What do you use when your app needs to provide speed and availability to a global audience? You need a distributed database that… Deploys anywhere Reduces latency by performing reads and writes close to users (while still enforcing consistency, even across a distributed deployment) Maintains uptime by tolerating faults Offers granular control over geographical placement of your data for GDPR compliance Sounds like a CDN.

read more

Craig Kerstiens put out a tweet the other day, asking: Whats your favorite hidden gem of Postgres that you wish more people knew about? The list of resulting hidden gems is… long. Thankfully, he aggregated them in a nice, readable, off-Twitter format. Give it a scan, you’re sure to learn something new.

read more

Randall Degges examines the good and bad uses of Local Storage. tldr, don’t use it to store sensitive data. Almost every day I stumble across a new website storing sensitive user information in local storage and it bothers me to know that so many developers are opening themselves up to catastrophic security issues by doing so. Let’s have a heart-to-heart and talk about local storage and why you should stop using it to store session data.

read more

If so, then this Twitter thread should be a great read for you. If you’re avoiding services like DynamoDB/Datastore/Spanner/SQS/PubSub out of fear of lock in, remember that managing Cassandra, Kafka, ZooKeeper, etc yourself is also lock in. 💣.

read more

This framework is very much in the proof of concept stage. There’s still a lot to do. The framework provides a seamless GraphQL interface for Rust servers. It is type-safe, ergonomic, very low boilerplate, and customizable. It has potential to be very fast. I believe that it can be one of the best experiences for GraphQL development in any language, as well as one of the fastest implementations (in part, because it seems to me that Rust and GraphQL are a great fit). Also, check out ~> 2018: The year we learn Rust 1.0 and Rust in 2018

read more

We went back into the archives to conversations we had around blockchains and databases at OSCON 2017. We talked with Monty Widenius (creator of MariaDB), Brian Behlendorf (Executive Director of Hyperledger), and Tague Griffith (Head of Developer Advocacy at Redis Labs). Business Source License (BSL) is there to be a bridge between closed source and open source. - Monty Widenius

read more

Another gem by typicode a small local JSON database powered by Lodash (supports Node, Electron and the browser)

read more

Mike Glukhovsky joined the show to talk about the future of RethinkDB. Mike was a co-founder of RethinkDB along-side Slava Akhmechet. RethinkDB shutdown a year ago officially on October 5, 2016 — and today we’re talking through all the details with Mike. The shutdown, getting purchased by the CNCF, relicensing, buying back their IP and source code, community and governance, and some specific features that Mike and the rest of the community are excited about.

read more

Mark Nadal joined the show to talk about his hacker story and his venture backed open source datastore project called GunDB — a realtime, decentralized, offline-first, graph database engine. We talked about the details behind this database, how Mark secured funding, why yet another datastore, who’s using the database, how Mark plans to sustain this project through products and services, his thoughts on the RethinkDB postmortem and more.

read more

This week we talked with Richard Hipp, the creator of SQLite, about its history, where it came from, why it succeeded as a database, how it’s development is sustainably funded, and how it’s the most widely deployed database engine in the world.

read more

MacLane Wilkison and Michael Egorov, the creators of ZeroDB, joined the show to talk about ZeroDB — an end-to-end encrypted database (protocol), why it’s open source, how it’s different than other encryption techniques, performance for running encrypted queries, and an interesting topic called Proxy re-encryption.

read more

Sameer Al-Sakran and Tom Robinson from Metabase joined the show to discuss Metabase - their open source tool that’s laying the foundation of their goals for open source business intelligence.

read more

Slava Akhmechet joined the show again to catch us up on RethinkDB and the awesome progress they’ve made to power the realtime web. We talked about innovation in databases, compared and contrasted to pub/sub, Pusher, NoSQL, and even The Next Big Thing™ in databases.

read more

Ilya Grigorik joined the show to talk about GitHub Archive, logging and archiving GitHub’s public event data, and how he uses Google BigQuery to make querying that data accessible to everyone.

read more

Wynn sat down with Andy Gross and Mark Phillips of Basho and John Nunemaker of Ordered List to talk about Riak, Riak Search, and moving an open source community to GitHub.

read more

It’s never been easier to do file uploads with MongoMapper and GridFS. Joint, from MongoMapper creator John Nunemaker, is a MM plugin that adds some nice convenience methods to your models: class Foo include MongoMapper::Document plugin Joint attachment :image attachment :pdf end By declaring these two attachments, you automagically get accessors for image and pdf. The setter methods take any IO (File, Tempfile, etc) and the getter methods return a GridIO type from the Ruby driver. John even throws in some nifty proxy goodness: doc.image.id doc.image.size doc.image.type doc.image.name

read more

John Nunemaker joined the show to talk about open source, improving your craft, building a business, and how MongoDB has changed his life.

read more