AvionDB: A MongoDB-like Distributed Database
vasa
Posted on May 9, 2020
In the past few months we have been getting this question a lot:
What do I use for managing dynamic data for my Decentralized App?
We have the InterPlanetary File System for storing static data, but what about the data that keeps changing?
There are a number of existing distributed databases like GUN, OrbitDB, Scuttlebutt, Textile Threads, etc.
Although these existing databases are great, we wanted a distributed database that will feel familiar when you are coming from Web 2.0 & still has all the features that you would expect from a distributed database.
Something like a distributed MongoDB.
Enter AvionDB
AvionDB is a distributed database built on top of OrbitDB & IPFS.
When we started our work on AvionDB, we had a few design goals in our mind.
Design Goals
- Familiar developer interface: MongoDB/Mongoose like interface.
- Local-first: Your app can work locally without the internet. For example, you can take notes on your notepad without (or even sync with other devices) connecting to the Internet.
- Privacy-first: All the data, whether it is on your device or on out in the network, it should be encrypted by default.
- Cross-platform: The database can be used natively on Mobile, Web & Desktop platforms.
How does it work?
AvionDB uses OrbitDB stores to model MongoDB-like Databases.
- Each AvionDB instance can have several Databases.
- Each Database can have several Collections.
- Each Collection can have several Documents.
The Javascript implementation works both in Browsers and Node.js with support for Linux, OS X, and Windows. The minimum required version of Node.js is now 8.6.0 due to the usage of ... spread syntax. LTS versions (even-numbered versions 8, 10, etc) are preferred.
Using AvionDB with NodeJS
Install
// Using npm
npm install --save aviondb
// Using Github
npm install git+https://github.com/dappkit/aviondb.git
Usage
// Import modules
const AvionDB = require("aviondb");
const IPFS = require("ipfs");
const ipfs = new IPFS();
const runExample = async () => {
await ipfs.ready;
// Creates a db named "DatabaseName"
const aviondb = await AvionDB.init("DatabaseName", ipfs);
// Returns the List of database names
await AvionDB.listDatabases()
// prints ['DatabaseName']
// Creates a Collection named "employees"
const collection = await aviondb.initCollection("employees");
// Returns the List of collection names
await aviondb.listCollections()
// prints ['employees']
// Adding an employee document
await collection.insertOne({
hourly_pay: "$15",
name: "Elon",
ssn: "562-48-5384",
weekly_hours: 100,
});
// We also support multi-insert using collection.insert()
// See https://github.com/dappkit/aviondb/blob/master/API.md
// Search by a single field Or many!
var employee = await collection.findOne({
ssn: "562-48-5384",
});
// We also support find(), findById()
// See https://github.com/dappkit/aviondb/blob/master/API.md
// Returns the matching document
console.log(employee);
// Prints the above added JSON document
// Update a document
var updatedEmployee = await collection.update(
{ ssn: "562-48-5384" },
{ $set: { hourly_pay: '$100' } }
);
// We also support updateMany(), findOneAndUpdate()
// See https://github.com/dappkit/aviondb/blob/master/API.md
// Returns the updated document
console.log(updatedEmployee);
// Prints the updated JSON document
await collection.close(); // Collection will be closed.
await aviondb.drop(); // Drops the database
await aviondb.close(); // Closes all collections and binding database.
await ipfs.stop();
};
runExample();
Using AvionDB with Browser
through Browserify
Same as in Node.js, you just have to browserify to bundle the code before serving it.
Note: The code uses
es6, so you have to use babel to convert the code intoes5before usingbrowserify.
through webpack
Same as in Node.js, you just have to webpack to bundle the the code before serving it.
Note: The code uses
es6, so you have to use babel to convert the code intoes5before usingwebpack.
from CDN
Instead of a local installation (and browserification) you may request a remote copy of AvionDB from unpkg CDN.
To always request the latest version, use the following:
<!-- loading the minified version -->
<script src="https://unpkg.com/aviondb/dist/aviondb.min.js"></script>
CDN-based AvionDB provides the AvionDB constructor as a method of the global window object. Example:
// create an AvionDB instance
const aviondb = await AvionDB.create("DatabaseName", ipfs)
Usage
<html>
<head>
<title>AvionDB Example</title>
<script src="https://cdn.jsdelivr.net/npm/ipfs/dist/index.min.js"></script>
<script src="https://unpkg.com/aviondb/dist/aviondb.min.js"></script>
</head>
<body>
Open your console logs to see AvionDB in action!
</body>
<script type="text/javascript">
const runExample = async () => {
const ipfs = await window.Ipfs.create();
await ipfs.ready;
// Creates a db named "DatabaseName"
const aviondb = await AvionDB.init("DatabaseName", ipfs);
// Returns the List of database names
await AvionDB.listDatabases()
// prints ['DatabaseName']
// Creates a Collection named "employees"
const collection = await aviondb.initCollection("employees");
// Returns the List of collection names
await aviondb.listCollections()
// prints ['employees']
// Adding an employee document
await collection.insertOne({
hourly_pay: "$15",
name: "Elon",
ssn: "562-48-5384",
weekly_hours: 100,
});
// We also support multi-insert using collection.insert()
// See https://github.com/dappkit/aviondb/blob/master/API.md
// Search by a single field Or many!
var employee = await collection.findOne({
ssn: "562-48-5384",
});
// We also support find(), findById()
// See https://github.com/dappkit/aviondb/blob/master/API.md
// Returns the matching document
console.log(employee);
// Prints the above added JSON document
// Update a document
var updatedEmployee = await collection.update(
{ ssn: "562-48-5384" },
{ $set: { hourly_pay: '$100' } }
);
// We also support updateMany(), findOneAndUpdate()
// See https://github.com/dappkit/aviondb/blob/master/API.md
// Returns the updated document
console.log(updatedEmployee);
// Prints the updated JSON document
await collection.close(); // Collection will be closed.
await aviondb.drop(); // Drops the database
await aviondb.close(); // Closes all collections and binding database.
await ipfs.stop();
};
runExample();
</script>
</html>
Demo Example of Firebase Authentication with AvionDB
Frequently Asked Questions
Are there implementations in other languages?
We are working to implement AvionDB for following languages:
- NodeJS & Browser JS
- Typescript
- Golang
- Python
The best place to find out what is out there and what is being actively worked on is likely by asking in the Discord.
If you want or are planning to create an implementation in a language that is not listed here, then feel free to reach us out and discuss about it in the Discord.
Where can I see your Roadmap?
You can find our Roadmap here. The features in the Roadmap are taken from 2 separate issues(#7, #8) which individually maintain a list of feature proposals related to OrbitDB-specific improvements & AvionDB-specific improvements respectively.
The Roadmap is an open discussion, feel free to add your suggestions, comments.
What mongodb features does aviondb support?
You can find all the supported MongoDB-like features in our API docs.
Other Questions?
If you didn't find the answer to your question(s), feel free to reach us out on Discord.
Contributing
Take a look at our organization-wide Contributing Guide.
As far as code goes, we would be happy to accept PRs! If you want to work on something, it'd be good to talk beforehand to make sure nobody else is working on it. You can reach us on Discord, or in the issues section.
If you want to code but don't know where to start, check out the issues labeled "help wanted", "discussion".
Please note that we have a Code of Conduct, and that all activity in the @dappkit organization falls under it. Read it when you get the chance, as being part of this community means that you agree to abide by it. Thanks.
Contact Us
Feel free to reach us out on Discord.
Posted on May 9, 2020
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.
Related