Giter Club home page Giter Club logo

gluesql-discord's Introduction

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

gluesql-discord's People

Contributors

ever0de avatar

Stargazers

avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar

Watchers

avatar avatar

gluesql-discord's Issues

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

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.