SQL database to read and write "discord"

Related tags

Database rust sql storage discord gluesql
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.

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

pganalyze 37 Dec 18, 2022
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

PRQL 6.5k Jan 5, 2023
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

ReadySet 1.7k Jan 8, 2023
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

Tembo 12 Jul 25, 2023
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,

Timeplus 4 Feb 27, 2024
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).

coral 1 Sep 30, 2022
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

Prisma 189 Dec 25, 2022
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
GitHub
🧰 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