SQL database to read and write "discord"

Overview

GlueSQL Discord Storage

After discussing how CI testing will be managed, we plan to move it upstream.

Precautions for use

You may not mine or scrape any data, content, or information available on or through Discord services (as defined in our Terms of Service).

  • This project does not mine or scrape information from Discord. (This project stores all data on Discord.) However, if you retrieve data using this project and save it separately or perform other actions, the above may cause problems.

Result Images

  • Example of reading discord messages into sql discord-message

insert select

You might also like...
RisingWave is a cloud-native streaming database that uses SQL as the interface language.

RisingWave is a cloud-native streaming database that uses SQL as the interface language. It is designed to reduce the complexity and cost of building real-time applications. RisingWave consumes streaming data, performs continuous queries, and updates results dynamically. As a database system, RisingWave maintains results inside its own storage and allows users to access data efficiently.

An embedded, in-memory, immutable, copy-on-write, key-value database engine

An embedded, in-memory, immutable, copy-on-write, key-value database engine. Features In-memory database Multi-version concurrency control Rich transa

Query LDAP and AD with SQL

SQLDAP Ever wanted to query AD or LDAP with SQL like queries ? I'm going to answer this question myself: yes ! Why ? Because I never could remember al

Rust library to parse, deparse and normalize SQL queries using the PostgreSQL query parser

This Rust library uses the actual PostgreSQL server source to parse SQL queries and return the internal PostgreSQL parse tree.

PRQL is a modern language for transforming data — a simpler and more powerful SQL

PRQL Pipelined Relational Query Language, pronounced "Prequel". PRQL is a modern language for transforming data — a simpler and more powerful SQL. Lik

ReadySet is a lightweight SQL caching engine written in Rust that helps developers enhance the performance and scalability of existing applications.
ReadySet is a lightweight SQL caching engine written in Rust that helps developers enhance the performance and scalability of existing applications.

ReadySet is a SQL caching engine designed to help developers enhance the performance and scalability of their existing database-backed applications. W

Execute SQL now and get the results later.

pg_later Execute SQL now and get the results later. A postgres extension to execute queries asynchronously. Installation Add pg_later to shared_preloa

Rust client for Timeplus Proton, a fast and lightweight streaming SQL engine

Rust Client for Timeplus Proton Rust client for Timeplus Proton. Proton is a streaming SQL engine, a fast and lightweight alternative to Apache Flink,

Very rudimentary library shim to read the Swinsian db in Rust.

Swinsian Rust Library Shim My favorite OSX music player is by far Swinsian. The API however ranges from non-existant to absolute trash (AppleScript).

Comments
  • Apply cache layer

    Apply cache layer

    • storage constructor
    2023-02-11T05:32:21.914777Z DEBUG gluesql_discord_storage::discord: get_guild_info: 273ms
    
    • create table
    2023-02-11T05:32:21.914840Z  INFO gluesql_discord_storage: CREATE TABLE
    2023-02-11T05:32:22.228804Z DEBUG gluesql_discord_storage::discord: get_channels: 312ms
    2023-02-11T05:32:22.228888Z DEBUG gluesql_discord_storage::storage: fetch_schema: 312ms
    
    2023-02-11T05:32:22.495230Z DEBUG gluesql_discord_storage::discord: get_channels: 266ms
    2023-02-11T05:32:22.495275Z DEBUG gluesql_discord_storage::storage: fetch_schema: 266ms
    
    2023-02-11T05:32:22.836212Z DEBUG gluesql_discord_storage::discord: get_channels: 340ms
    2023-02-11T05:32:22.836255Z DEBUG gluesql_discord_storage::discord: get_channel_id: 340ms
    2023-02-11T05:32:23.562402Z DEBUG gluesql_discord_storage::discord: create_channel: 726ms
    2023-02-11T05:32:23.840179Z DEBUG gluesql_discord_storage::discord: get_pins: 277ms
    2023-02-11T05:32:24.172674Z DEBUG gluesql_discord_storage::discord: send_message: 332ms
    2023-02-11T05:32:29.392575Z DEBUG gluesql_discord_storage::discord: set_pin: 5219ms
    2023-02-11T05:32:29.392714Z DEBUG gluesql_discord_storage::storage: insert_schema: 6897ms
    
    • insert into
    2023-02-11T05:32:29.392842Z  INFO gluesql_discord_storage: INSERT INTO
    2023-02-11T05:32:29.839777Z DEBUG gluesql_discord_storage::discord: get_channels: 446ms
    2023-02-11T05:32:30.368222Z DEBUG gluesql_discord_storage::discord: get_pins: 528ms
    2023-02-11T05:32:30.368702Z DEBUG gluesql_discord_storage::storage: fetch_schema: 975ms
    
    2023-02-11T05:32:30.615157Z DEBUG gluesql_discord_storage::discord: get_channels: 246ms
    2023-02-11T05:32:35.678620Z DEBUG gluesql_discord_storage::discord: get_pins: 5063ms
    2023-02-11T05:32:35.678706Z DEBUG gluesql_discord_storage::storage: fetch_schema: 5309ms
    
    2023-02-11T05:32:35.938118Z DEBUG gluesql_discord_storage::discord: get_channels: 258ms
    2023-02-11T05:32:35.938196Z DEBUG gluesql_discord_storage::discord: get_channel_id: 259ms
    2023-02-11T05:32:36.274321Z DEBUG gluesql_discord_storage::discord: send_message: 336ms
    2023-02-11T05:32:36.274425Z DEBUG gluesql_discord_storage::storage: append_data: 595ms
    
    • select
    2023-02-11T05:32:36.274476Z  INFO gluesql_discord_storage: SELECT
    2023-02-11T05:32:36.661037Z DEBUG gluesql_discord_storage::discord: get_channels: 386ms
    2023-02-11T05:32:40.999060Z DEBUG gluesql_discord_storage::discord: get_pins: 4338ms
    2023-02-11T05:32:40.999255Z DEBUG gluesql_discord_storage::storage: fetch_schema: 4724ms
    
    2023-02-11T05:32:41.379221Z DEBUG gluesql_discord_storage::discord: get_channels: 379ms
    2023-02-11T05:32:46.254187Z DEBUG gluesql_discord_storage::discord: get_pins: 4874ms
    2023-02-11T05:32:46.254317Z DEBUG gluesql_discord_storage::storage: fetch_schema: 5254ms
    
    2023-02-11T05:32:46.620747Z DEBUG gluesql_discord_storage::discord: get_channels: 366ms
    2023-02-11T05:32:46.620781Z DEBUG gluesql_discord_storage::discord: get_channel_id: 366ms
    2023-02-11T05:32:47.155178Z DEBUG gluesql_discord_storage::storage: scan_data: 900ms
    
    2023-02-11T05:32:47.442835Z DEBUG gluesql_discord_storage::discord: get_channels: 287ms
    2023-02-11T05:32:51.612562Z DEBUG gluesql_discord_storage::discord: get_pins: 4169ms
    2023-02-11T05:32:51.612750Z DEBUG gluesql_discord_storage::storage: fetch_schema: 4457ms
    Select { labels: ["id", "name"], rows: [[I64(1), Str("glue")]] }
    
    • drop table
    2023-02-11T05:32:51.613360Z  INFO gluesql_discord_storage: DROP TABLE
    2023-02-11T05:33:22.433095Z DEBUG gluesql_discord_storage::discord: get_channels: 30820ms
    2023-02-11T05:33:22.742421Z DEBUG gluesql_discord_storage::discord: get_pins: 309ms
    2023-02-11T05:33:22.742549Z DEBUG gluesql_discord_storage::storage: fetch_schema: 31129ms
    
    2023-02-11T05:33:23.012213Z DEBUG gluesql_discord_storage::discord: get_channels: 269ms
    2023-02-11T05:33:28.170419Z DEBUG gluesql_discord_storage::discord: get_pins: 5158ms
    2023-02-11T05:33:28.170584Z DEBUG gluesql_discord_storage::storage: fetch_schema: 5428ms
    
    2023-02-11T05:33:28.428624Z DEBUG gluesql_discord_storage::discord: get_channels: 257ms
    2023-02-11T05:33:28.428700Z DEBUG gluesql_discord_storage::discord: get_channel_id: 258ms
    2023-02-11T05:33:28.782449Z DEBUG gluesql_discord_storage::discord: delete_channel: 353ms
    2023-02-11T05:33:28.782481Z DEBUG gluesql_discord_storage::storage: delete_schema: 611ms
    
    • select schemaless
    2023-02-11T05:35:04.627465Z  INFO gluesql_discord_storage: SELECT SCHEMALESS
    2023-02-11T05:35:04.927010Z DEBUG gluesql_discord_storage::discord: get_channels: 297ms
    2023-02-11T05:35:05.350431Z DEBUG gluesql_discord_storage::discord: get_pins: 423ms
    2023-02-11T05:35:05.350680Z DEBUG gluesql_discord_storage::storage: fetch_schema: 721ms
    
    2023-02-11T05:35:05.651179Z DEBUG gluesql_discord_storage::discord: get_channels: 299ms
    2023-02-11T05:35:10.623701Z DEBUG gluesql_discord_storage::discord: get_pins: 4972ms
    2023-02-11T05:35:10.623788Z DEBUG gluesql_discord_storage::storage: fetch_schema: 5272ms
    
    2023-02-11T05:35:10.872306Z DEBUG gluesql_discord_storage::discord: get_channels: 248ms
    2023-02-11T05:35:10.872342Z DEBUG gluesql_discord_storage::discord: get_channel_id: 248ms
    2023-02-11T05:35:11.589856Z DEBUG gluesql_discord_storage::storage: scan_data: 965ms
    
    2023-02-11T05:35:11.897603Z DEBUG gluesql_discord_storage::discord: get_channels: 307ms
    2023-02-11T05:35:15.994256Z DEBUG gluesql_discord_storage::discord: get_pins: 4096ms
    2023-02-11T05:35:15.994293Z DEBUG gluesql_discord_storage::storage: fetch_schema: 4404ms
    
    enhancement 
    opened by ever0de 3
Owner
Jiseok CHOI
Jiseok CHOI
🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, SQLite, and MSSQL.

SQLx ?? The Rust SQL Toolkit Install | Usage | Docs Built with ❤️ by The LaunchBadge team SQLx is an async, pure Rust† SQL crate featuring compile-tim

launchbadge 7.6k Dec 31, 2022
A Rust SQL query builder with a pleasant fluent API closely imitating actual SQL

Scooby An SQL query builder with a pleasant fluent API closely imitating actual SQL. Meant to comfortably build dynamic queries with a little bit of s

Aleksei Voronov 100 Nov 11, 2022
Gh-sql - Query GitHub Projects (beta) with SQL

gh-sql: Query GitHub Projects (beta) with SQL Installation gh extension install KOBA789/gh-sql Features SELECT items DELETE items UPDATE item fields

Hidekazu Kobayashi 108 Dec 7, 2022
SQL validator tool for BigQuery standard SQL.

bqvalid What bqvalid does bqvalid is the SQL validator tool for BigQuery standard SQL. bqvalid fails with error message if there's the expression that

null 10 Dec 25, 2022
ReefDB is a minimalistic, in-memory and on-disk database management system written in Rust, implementing basic SQL query capabilities and full-text search.

ReefDB ReefDB is a minimalistic, in-memory and on-disk database management system written in Rust, implementing basic SQL query capabilities and full-

Sacha Arbonel 75 Jun 12, 2023
Grsql is a great tool to allow you set up your remote sqlite database as service and CRUD(create/read/update/delete) it using gRPC.

Grsql is a great tool to allow you set up your remote sqlite database as service and CRUD (create/ read/ update/ delete) it using gRPC. Why Create Thi

Bruce Yuan 33 Dec 16, 2022
FeOphant - A SQL database server written in Rust and inspired by PostreSQL.

A PostgreSQL inspired SQL database written in Rust.

Christopher Hotchkiss 27 Dec 7, 2022
Distributed, version controlled, SQL database with cryptographically verifiable storage, queries and results. Think git for postgres.

SDB - SignatureDB Distributed, version controlled, SQL database with cryptographically verifiable storage, queries and results. Think git for postgres

Fremantle Industries 5 Apr 26, 2022
GlueSQL is a SQL database library written in Rust

GlueSQL is a SQL database library written in Rust. It provides a parser (sqlparser-rs), execution layer, and optional storage (sled) packaged into a single library.

GlueSQL 2.1k Jan 8, 2023
Distributed SQL database in Rust, written as a learning project

toyDB Distributed SQL database in Rust, written as a learning project. Most components are built from scratch, including: Raft-based distributed conse

Erik Grinaker 4.6k Jan 8, 2023