agdb

The graph database.

  Agnesoft Graph Database

Quickstart Db | Quickstart Client | QUERIES | DECISION TREE

Why not SQL?

The Agnesoft Graph Database (aka agdb) is persistent, optionally memory mapped graph database with native object 'no-text' queries. It can be used as a main persistent storage, data analytics platform as well as fast in-memory cache. Its typed schema-less data store allows for flexible and seamless data updates with no downtime or costly migrations. All queries are constructed via a builder pattern or directly as objects with no special language or text parsing.

• Key Features
• At a glance
• Crate Features
• Decision Tree
• Roadmap
• Reference

  Key Features

• Data plotted on a graph
• Typed key-value properties attached to graph elements (nodes & edges)
• Persistent platform agnostic file based storage (transferable between platforms)
• ACID compliant
• Object queries with builder pattern (no text, no query language)
• Memory mapped for fast querying
• Server mode
• OpenAPI clients in any programming language
• Cloud hosted SaaS database
• Db itself has no dependencies

  At a glance [Db]

cargo add agdb

Basic usage demonstrating creating a database, inserting graph elements with data and querying them back with select and search. The function using this code must handle agdb::DbError and agdb::QueryError error types for operator ? to work:

use agdb::{Db, DbId, QueryBuilder, UserValue, DbUserValue, Comparison::Equal};

let mut db = Db::new("db_file.agdb")?;

db.exec_mut(&QueryBuilder::insert().nodes().aliases("users").query())?;

#[derive(Debug, UserValue)]
struct User { db_id: Option<DbId>, name: String, }
let users = vec![User { db_id: None, name: "Alice".to_string(), },
                 User { db_id: None, name: "Bob".to_string(), },
                 User { db_id: None, name: "John".to_string(), }];

let users_ids = db.exec_mut(&QueryBuilder::insert().nodes().values(&users).query())?;

db.exec_mut(
    &QueryBuilder::insert()
        .edges()
        .from("users")
        .to(&users_ids)
        .query(),
)?;

This code creates a database called user_db.agdb with a simple graph of 4 nodes. The first node is aliased users and 3 user nodes for Alice, Bob and John are then connected with edges to the users node. The arbitrary name property is attached to the user nodes. Rather than inserting values directly with keys (which is also possible) we use our own type and derive from agdb::UserValue to allow it to be used with the database.

You can select the graph elements (both nodes & edges) with their ids to get them back with their associated data (key-value properties). Lets select our users and convert the result into the list (notice we select only values relevant to our User type with passing User::db_keys()):

let users: Vec<User> = db
    .exec(
        &QueryBuilder::select()
            .values(User::db_keys())
            .ids(&users_ids)
            .query(),
    )?
    .try_into()?;

println!("{:?}", users);
// [User { db_id: Some(DbId(2)), username: "Alice" },
//  User { db_id: Some(DbId(3)), username: "Bob" },
//  User { db_id: Some(DbId(4)), username: "John" }]

You can also search through the graph to get back only certain elements based on conditions. For example:

let user: User = db
    .exec(
        &QueryBuilder::select()
            .values(User::db_keys())
            .ids(
                QueryBuilder::search()
                    .from("users")
                    .where_()
                    .key("name")
                    .value(Equal("Bob".into()))
                    .query(),
            )
            .query(),
    )?
    .try_into()?;

println!("{:?}", user);
// User { db_id: Some(DbId(3)), username: "Bob" }

For database concepts and primitive data types see concepts. For comprehensive overview of all queries see the queries reference or continue with more in-depth efficient agdb.

  Crate Features

agdb

agdb_api

  Decision Tree

NOTE: Regular links are broken in mermaid, use CTRL+Click to navigate to the relevant docs.

flowchart TD;
    A[Embedded or server?] --> Embedded
    A --> B[Client or hosting?]
    Embedded --> Studio
    Embedded --> Queries
    B --> Client
    B --> Hosting
    Client --> API
    Client --> Studio
    Client --> Queries
    Hosting --> Server
    Hosting --> Cloud
    click Embedded "https://github.com/agnesoft/agdb/blob/main/docs/studio.md"
    click Queries "https://github.com/agnesoft/agdb/blob/main/docs/queries.md"
    click API "https://github.com/agnesoft/agdb/blob/main/docs/api.md"
    click Hosting "https://github.com/agnesoft/agdb/blob/main/docs/server.md"
    click Cloud "https://github.com/agnesoft/agdb/blob/main/docs/cloud.md"

  Roadmap

The following are planned features with target versions:

  Reference

• API

• But why?

• Cloud

• Concepts

• Efficient agdb

• Performance

• Queries

• Server

• Studio

• Troubleshooting