redis-jdbc
redis-jdbc copied to clipboard
DBeaver integration with extra rendering on some commands
Few enhancements to support the querying using DBeaver. Try it out in IntelliJ as that might need more tweaking.
- Render timestamp in separate column called TIMESTAMP (TTL & PTTL)
Before:
RESULTS 1
After
RESULTS | TIMESTAMP 1 | 2022-11-01....
- Render hash get operations
RESULTS key val
After
KEY | VALUE key | val
- Allow set/get of the schema via sql
USE ?
SET syntax conflicts with redis commands
SELECT DB_NAME()
- Basic input support with spaces (single/double quotes) + command case-insensitiveness
SET 'my key' "my value"
PG syntax is too complicated with search_path
- DBeaver specific stuff
Requires PreparedStatement, otherwise fails changing schema. Now it detects the schema from connection. PreparedStatement impl is very bare to only support that use-case. Wish lombok had an annotation for this
@eacdy let me know if you're interested in merging, otherwise i will keep it as fork