Login

u/debba_

▲ 18 r/Backend+1 crossposts

I am building SQL notebooks into an open source database client built with Tauri and React

Hi guys!

I've been working on Tabularis (open source cross-platform db client) and I'm working on a notebooks feature that i think people here might find interesting.

The core idea: SQL cells + markdown cells in a single document, running against your live database connection. no separate kernel, no python, just SQL.

The feature I keep coming back to is cell variable references, you write {{cell_3}} in your SQL and it takes the result set from cell 3 and injects it as a CTE. means you can chain analyses without building giant nested queries. for ad-hoc exploration this is a huge workflow improvement.

You also get:

  • inline charts: bar, line, pie. select label column + value columns, switch between types. nothing fancy but enough for quick visual checks
  • notebook parameters: define params once, use in all cells. good for parameterized reports
  • run all with stop on error: shows a summary of what succeeded/failed/skipped with links to the failing cells
  • parallel execution: mark independent cells with a lightning bolt, they run concurrently during run all
  • execution history: every cell tracks its last 10 runs, you can restore any previous query + result
  • csv/json export per cell, or export the whole notebook as self-contained HTML
  • drag & drop reordering, collapsible sections, resizable result panels

It supports all of databases supported by Tabularis.

The notebook file format is json-based (.tabularis-notebook).

There's a demo database + sample notebook in the repo under /demo.

Github: https://github.com/debba/tabularis
WIP Branch: https://github.com/debba/tabularis/tree/feat/notebooks

Feedback welcome, especially around the cell reference syntax and what else would make this useful for your workflow.

u/debba_ — 1 day ago
Query Redis with SQL using plugins
▲ 2 r/redis+1 crossposts

Query Redis with SQL using plugins

Hi r/redis 👋

I’ve been working on Tabularis, a lightweight open-source database tool built with Rust + Tauri.

One of the ideas behind the project is something I’ve been experimenting with recently:

Query anything with SQL using plugins.

Instead of baking every database driver into the core app, Tabularis runs drivers as external plugins communicating over JSON-RPC, which means they can be written in any language and installed independently. 

That opens the door to some interesting possibilities.

The goal isn’t to replace Redis commands, but to make exploration and debugging easier, especially when dealing with large keyspaces or when you want to query Redis data alongside other sources.

One thing that surprised me is that two different developers independently built Redis plugins for Tabularis, which shows how flexible the plugin system can be.

I’m curious what the Redis community thinks about this effect : would querying Redis with SQL be useful for your workflows?

github.com
u/debba_ — 29 days ago