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

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

TDS 7.2+ (mssql / Microsoft SQL Server) async driver for rust

Tiberius A native Microsoft SQL Server (TDS) client for Rust. Supported SQL Server versions Version Support level Notes 2019 Tested on CI 2017 Tested

An object-relational in-memory cache, supports queries with an SQL-like query language.

qlcache An object-relational in-memory cache, supports queries with an SQL-like query language. Warning This is a rather low-level library, and only p

Run SQL queries on CSV files

zsql run SQL queries on csv files A terminal utility to easily run SQL queries on CSV files. zsql is shipped as a small single binary powered by rust

Running SQL-like queries on files.

filesql Running SQL-like queries on files. Features Supported: REPL Basic SQL expressions. INSERT clause. (which inserts data into another file) WHERE

Tool to automate the visualisation of UML dependencies from a SQL file
Tool to automate the visualisation of UML dependencies from a SQL file

Doteur A simple tool to draw your mysql relations from exports. Help us If you use the tool, and like it, don't forget to add a star to the project on

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

Singularity Data 3.7k Jan 2, 2023
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

null 9 Nov 15, 2022