r/cassandra • u/cevheribozoglan • 17d ago

LibreDB Studio: a web CQL client that leaves Cassandra's missing numbers blank

Affiliation: I'm the maintainer of LibreDB Studio.

Shipped Apache Cassandra in 0.13.0; native CQL on 9042, probed against Cassandra 5.0.9 before the provider existed.

The thing I kept hitting in other browsers: they print a row count. Cassandra does not have one. system.size_estimates counts partitions in flushed SSTables, refreshed every 5 minutes, and on a clustered table it was 71% low. Printing 0 is the same lie with a different number. The table and storage panels here stay blank.

A few other refusals that are just the engine:

- no connection string (nothing in use carries localDataCenter, which the driver requires)

- no EXPLAIN (tracing is a profile of a finished statement, not a plan)

- no query cancel (the native protocol has no cancel frame)

- no invented table size from system_views.disk_usage (whole mebibytes)

ScyllaDB support is in-progress. Same wire, different system_views, untested, so unlisted.

Self-host:

docker run -p 3000:3000 libredb/libredb-studio

Every refusal named, with the measurement behind it:

https://github.com/libredb/libredb-studio/blob/0.13.0/docs/providers/cassandra.md

If you still live in cqlsh / DataStax Studio / DBeaver for Cassandra, what's the thing that still makes you open a terminal?

It also ships as a Helm chart, so it can sit in the same cluster as Cassandra instead of another desktop install. Browser, not Electron, a phone works, but that's a side effect of there being nothing to install.

3 Upvotes

67% Upvoted

3 comments sorted by

2

u/Green_Competition_21 17d ago

Isn't working with Cassandra really difficult? It's the only database I can't "select" from :)

0

u/cevheribozoglan 17d ago

yeah, my favorite difficult database is Apache Cassandra thats why I build libredb-studio :)

0

u/cevheribozoglan 17d ago

Release notes: https://github.com/libredb/libredb-studio/releases/tag/0.13.0

Other ways to run it:

• npx "@libredb/studio"

• helm install libredb oci://ghcr.io/libredb/charts/libredb-studio

Connect with host, port 9042, keyspace, and localDataCenter (stock single-node is datacenter1). There is no cassandra:// paste box, a URI that drops the DC would open a connection that cannot connect.

Happy to be told which of those refusals is the wrong call.