Databases Icon

Databases

Databases, structured data, data stores, etc.
27 Stories
All Topics

Rust github.com

sled – an embedded database for Rust

Careful now, 'sled' is in its alpha stage. Heck, its name is a recursive acronym that means "sled likes eating data", so that should give you an indication of its state (I hope they come up with a new one once the software is stable). The project's goals are on point: don't make the user think. the interface should be obvious. don't surprise users with performance traps. don't wake up operators. bring reliability techniques from academia into real-world practice. don't use so much electricity. our data structures should play to modern hardware's strengths.

read more...

Dimitri Fontaine tapoueh.org

PostgreSQL data types – series recap

Dimitri Fontaine, a PostgreSQL major contributor, has written an awesome blog series on PostgreSQL data types to show how to benefit from the PostgreSQL concept of a data type. The PostgreSQL concept of a data type is more than input validation, a PostgreSQL data type also implements expected behaviors and processing functions. This allows an application developer to rely on PostgreSQL for more complex queries, having the processing happen where the data is — for instance when implementing advanced JOIN operations, then retrieving only the data set that is interesting for the application. The posts in this series were extracted from his book Mastering PostgreSQL in Application Development — which teaches SQL to developers so they can replace thousands of lines of code with very simple queries.

read more...

Matt Jaffee YouTube

The index as a first class citizen

Matt Jaffe was on a recent episode of Go Time and also gave this talk at OSCON recently on indexes as a first class citizen. In this video Matt talks about a piece of software that's purely an index, not a database, not a datastore, just the index — and optimizing that single piece of software to be very fast! Here's a quick breakdown of an index as a first class citizen: Standalone application, not just a data structure Horizontally scalable, distributed FAST, indexes should make things faster Flexible, integrates with other datastores and data types Also, learn more about Pilosa to see Matt's work in action.

read more...

Databases foundationdb.org

FoundationDB – Apple's open source distributed database

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

Philipp Krenn Avatar The Changelog #292

Elasticsearch and doubling down on "open"

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

Database modeling anti-patterns 🙅‍♀️

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

CockroachDB cockroachlabs.com

Your database should work like a CDN

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

Security rdegges.com

Please stop using Local Storage

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

Rust ncameron.org

A Proof-Of-Concept GraphQL Server Framework for Rust

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

Tague Griffith Avatar Brian Behlendorf Avatar Monty Widenius Avatar The Changelog #278

Blockchains and Databases at OSCON

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

Mike Glukhovsky Avatar The Changelog #266

The Future of RethinkDB with Mike Glukhovsky

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 Avatar The Changelog #236

GunDB, Venture Backed and Decentralized with Mark Nadal

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...
0:00 / 0:00