base on Skytable is a modern scalable NoSQL database with BlueQL, designed for performance, scalability and flexibility. Skytable gives you spaces, models, data types, complex collections and more to build powerful experiences # Skytable <img align="right" src="assets/logo.jpg" height="128" width="128" alt="Skytable Logo"/> A modern NoSQL database, powered by BlueQL.<br/> <p> <a href="https://github.com/skytable/skytable/releases"><img src="https://img.shields.io/github/v/release/skytable/skytable?style=flat" alt="GitHub release (with filter)"></a> <a href="https://github.com/skytable/skytable/actions"><img src="https://img.shields.io/github/actions/workflow/status/skytable/skytable/test-push.yml?style=flat" alt="GitHub Workflow Status (with event)"></a> <a href="https://discord.gg/QptWFdx"><img src="https://img.shields.io/discord/729378001023926282?logo=discord&style=flat" alt="Discord"></a> <a href="https://docs.skytable.io"><img src="https://img.shields.io/badge/read%20the%20docs-here-blue?style=flat" alt="Docs"></a> <a href="https://github.com/skytable/skytable/discussions?style=flat"><img src="https://img.shields.io/badge/discuss-here-8A3324?style=flat&logo=github&labelColor=C34723" alt="Static Badge"></a> </p> ## What is Skytable? Skytable is a **NoSQL database** implemented using modern design paradigms, that focuses on **performance, flexibility, and scalability**. Skytable is primarily in-memory, uses multithreaded asynchronous I/O and a custom AOF-based storage engine with advanced delayed durability transactions for efficient disk I/O. Skytable's data model is based on a column-oriented structure with support for additional data models^(WIP). Querying is done using BlueQL, a SQL-based query language hardened against injection attacks, written specifically for Skytable. Skytable is best-suited for applications that need to store large-scale data, need high-performance and low latencies. > **You can read more about Skytable's architecture, including information on the clustering and HA implementation that we're currently working on, and limitations [on this page](https://docs.skytable.io/architecture).** ## Features - **Spaces, models and more**: For flexible data definition - **Powerful querying with BlueQL**: A modern query language based on SQL - **Rich data modeling**: Use `model`s to define data with complex types, collections and more - **Performant**: Optimized multithreaded network I/O, write batching and several other optimizations - **Secure**: Injection deterrence using BlueQL and other memory safety measures - **Enforces best practices**: If you're building with Skytable today, the practices you'll get used to here will let you easily take on the job of building performant systems, even outside Skytable > Learn more about [Skytable's features here](https://docs.skytable.io). ## Getting started 1. **Set up Skytable on your machine**: You'll need to download a bundled release file [from the releases page](https://github.com/skytable/skytable/releases). Unzip the files and you're ready to go. 2. Start the database server: `./skyd --auth-root-password <password>` with your choice of a password for the `root` account. The `root` account is just like a `root` account on Unix based systems that has control over everything. 3. Start the interactive client REPL: `./skysh` and then enter your password. 4. Your setup is now complete. > **For a more detailed guide on installation and deployment, [follow the guide here.](https://docs.skytable.io/installation)** ## Using Skytable Skytable has `SPACE`s instead of `DATABASE`s due to signficant operational differences (and because `SPACE`s store a lot more than tabular data). **With the REPL started, follow this guide**: 1. Create a `space` and switch to it: ```sql CREATE SPACE myspace USE myspace ``` 2. Create a `model`: ```sql CREATE MODEL myspace.mymodel(username: string, password: string, notes: list { type: string }) ``` The rough representation for this in Rust would be: ```rust pub struct MyModel { username: String, password: String, notes: Vec<String>, } ``` 3. `INSERT` some data: ```sql INSERT INTO mymodel('sayan', 'pass123', []) ``` 4. `UPDATE` some data: ```sql UPDATE mymodel SET notes += "my first note" WHERE username = 'sayan' ``` 5. `SELECT` some data ```sql SELECT * FROM mymodel WHERE username = 'sayan' ``` 6. Modify and run your own queries to understand how things work. **And then make sure you [read the documentation learn BlueQL](https://docs.skytable.io/blueql/overview).** > **For a complete guide on Skytable, it's architecture, BlueQL, queries and more we strongly recommend you to [read the documentation here.](https://docs.skytable.io)** > > While you're seeing strings and other values being used here, this is so because the REPL client smartly parameterizes queries behind the scenes. **BlueQL has mandatory parameterization**. (See below to see how the Rust client handles this) ## Find a client driver You need a client driver to use Skytable in your programs. Officially, we maintain a regularly updated [Rust client driver](https://github.com/skytable/client-rust) which is liberally license under the Apache-2.0 license so that you can use it anywhere. Using the Rust client driver, it's very straightforward to run queries thanks to Rust's powerful type system and macros: ```rust use skytable::{Config, query}; fn main() { let mut db = Config::new_default("username", "password").connect().unwrap(); let query = query!("select username, password from myspace.mymodel where username = ?", "sayan"); let (username, password): (String, Vec<u8>) = db.query_parse(&query).unwrap(); // do something with it } ``` > **You can find more information on client drivers on [this page](https://docs.skytable.io/libraries). If you want to help write a client driver for your language of choice, *we're here to support your work*. Please reach out to: <[email protected]> or leave a message on our Discord server.** ## Getting help We exclusively use [Discord](https://discord.gg/QptWFdx) for most real-time communications — you can chat with developers, maintainers, and our amazing users. Outside that, we recommend that you use our [GitHub Discussions page](https://github.com/skytable/skytable/discussions) for any questions or open a new issue if you think you've found a bug. ## Contributing Please read the [contributing guide here](./CONTRIBUTING.md). ## Acknowledgements Please read the [acknowledgements](./ACKNOWLEDGEMENTS.txt) document. ## License Skytable is distributed under the [AGPL-3.0 License](./LICENSE). **You may not use Skytable's logo for other projects.** ", Assign "at most 3 tags" to the expected json: {"id":"5719","tags":[]} "only from the tags list I provide: [{"id":77,"name":"3d"},{"id":89,"name":"agent"},{"id":17,"name":"ai"},{"id":54,"name":"algorithm"},{"id":24,"name":"api"},{"id":44,"name":"authentication"},{"id":3,"name":"aws"},{"id":27,"name":"backend"},{"id":60,"name":"benchmark"},{"id":72,"name":"best-practices"},{"id":39,"name":"bitcoin"},{"id":37,"name":"blockchain"},{"id":1,"name":"blog"},{"id":45,"name":"bundler"},{"id":58,"name":"cache"},{"id":21,"name":"chat"},{"id":49,"name":"cicd"},{"id":4,"name":"cli"},{"id":64,"name":"cloud-native"},{"id":48,"name":"cms"},{"id":61,"name":"compiler"},{"id":68,"name":"containerization"},{"id":92,"name":"crm"},{"id":34,"name":"data"},{"id":47,"name":"database"},{"id":8,"name":"declarative-gui "},{"id":9,"name":"deploy-tool"},{"id":53,"name":"desktop-app"},{"id":6,"name":"dev-exp-lib"},{"id":59,"name":"dev-tool"},{"id":13,"name":"ecommerce"},{"id":26,"name":"editor"},{"id":66,"name":"emulator"},{"id":62,"name":"filesystem"},{"id":80,"name":"finance"},{"id":15,"name":"firmware"},{"id":73,"name":"for-fun"},{"id":2,"name":"framework"},{"id":11,"name":"frontend"},{"id":22,"name":"game"},{"id":81,"name":"game-engine "},{"id":23,"name":"graphql"},{"id":84,"name":"gui"},{"id":91,"name":"http"},{"id":5,"name":"http-client"},{"id":51,"name":"iac"},{"id":30,"name":"ide"},{"id":78,"name":"iot"},{"id":40,"name":"json"},{"id":83,"name":"julian"},{"id":38,"name":"k8s"},{"id":31,"name":"language"},{"id":10,"name":"learning-resource"},{"id":33,"name":"lib"},{"id":41,"name":"linter"},{"id":28,"name":"lms"},{"id":16,"name":"logging"},{"id":76,"name":"low-code"},{"id":90,"name":"message-queue"},{"id":42,"name":"mobile-app"},{"id":18,"name":"monitoring"},{"id":36,"name":"networking"},{"id":7,"name":"node-version"},{"id":55,"name":"nosql"},{"id":57,"name":"observability"},{"id":46,"name":"orm"},{"id":52,"name":"os"},{"id":14,"name":"parser"},{"id":74,"name":"react"},{"id":82,"name":"real-time"},{"id":56,"name":"robot"},{"id":65,"name":"runtime"},{"id":32,"name":"sdk"},{"id":71,"name":"search"},{"id":63,"name":"secrets"},{"id":25,"name":"security"},{"id":85,"name":"server"},{"id":86,"name":"serverless"},{"id":70,"name":"storage"},{"id":75,"name":"system-design"},{"id":79,"name":"terminal"},{"id":29,"name":"testing"},{"id":12,"name":"ui"},{"id":50,"name":"ux"},{"id":88,"name":"video"},{"id":20,"name":"web-app"},{"id":35,"name":"web-server"},{"id":43,"name":"webassembly"},{"id":69,"name":"workflow"},{"id":87,"name":"yaml"}]" returns me the "expected json"