search

turt2live / matrix-bot-sdk

TypeScript/JavaScript SDK for Matrix bots
MIT License
194 stars 68 forks source link

Postgres storage provider should support creation of custom tables and raw SQL #360

Closed samip5 closed 6 months ago

samip5 commented 6 months ago

Is your feature request related to a problem? Please describe. I'm annoyed when I cannot create custom tables with the storage provider, nor execute raw SQL for queries with it.

Describe the solution you'd like The provider should be extended with support for custom tables and potentially raw SQL.

Describe alternatives you've considered Use sqlite db for the part of my bot that requires custom tables.

Additional context I'm building a bot that has a store links that were requested previously, and it doesn't work with the kv store as it should be db row instead.

turt2live commented 6 months ago

Custom storage providers are possible. The included one is deliberately feature-less.