redis-jdbc icon indicating copy to clipboard operation
redis-jdbc copied to clipboard

DBeaver integration with extra rendering on some commands

Open michaelpro1 opened this issue 2 years ago • 1 comments

Few enhancements to support the querying using DBeaver. Try it out in IntelliJ as that might need more tweaking.

  1. Render timestamp in separate column called TIMESTAMP (TTL & PTTL)

Before:

RESULTS 1

After

RESULTS | TIMESTAMP 1 | 2022-11-01....

  1. Render hash get operations

RESULTS key val

After

KEY | VALUE key | val

  1. Allow set/get of the schema via sql

USE ?

SET syntax conflicts with redis commands

SELECT DB_NAME()

  1. Basic input support with spaces (single/double quotes) + command case-insensitiveness

SET 'my key' "my value"

PG syntax is too complicated with search_path

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

michaelpro1 avatar Feb 04 '23 13:02 michaelpro1

@eacdy let me know if you're interested in merging, otherwise i will keep it as fork

michaelpro1 avatar Feb 15 '23 12:02 michaelpro1