4 ms·
Looks nice, but like others here we need something that can be self hosted or even better – run offline. Somewhat related: does anyone know of any good compone
by mstade 7y ago
Looks nice, but like others here we need something that can be self hosted or even better – run offline.
Somewhat related: does anyone know of any good components/libraries that can be embedded in a web page to let users interactively build SQL queries of reasonable complexity? By that I mean something that not only lets you pick columns and filter and maybe group things, but also do joins on other tables as well.
Edit: just to clarify, it doesn't have to be be visual only. In fact, something that lets you edit a query interactively either by visual components or actual SQL code is perfect, especially if it's bidirectional so that edits in the code also show in the UI and vice versa.
- danpelota 7y agoI don't know about embedding, but I've been happy with the Metabase UI for building these kinds of queries: https://www.metabase.com/docs/latest/users-guide/custom-questions.html https://www.metabase.com/docs/latest/users-guide/custom-ques...
- hermitcrab 7y agoIf you want an offline, no code, visual data transformation tool, please check out our new product: https://www.easydatatransform.com/ https://www.easydatatransform.com/
- mstade 7y agoThank you, I'll take a look! Just want to clarify – it doesn't have to be no code. In fact, a bidirectional workflow where you can edit the query either by writing SQL or clicking buttons is ideal.
- texodus 7y agohttps://perspective.finos.org/ https://perspective.finos.org/ supports simple SQL-like operations, group by, filters and sort e.g.
- nojvek 7y agoThanks for this comment. I am working on something very close to this vision at https://boomadmin.com https://boomadmin.com The idea is to have an open source (but commercial use paid license) that people can self host and totally have it offline or have it hosted on cloud with a single click. I quit my job last month to work on it fulltime to work on an MVP. If you’re interested please add your email for an early beta. I would love your feedback.
- mmsimanga 7y agoFor offline I would recommend SQLeo[0]. It has been around for a long time but I have yet to find something more powerful when exploring a new database or visually constructing queries. You can also visualise queries not created using SQLeo. Don't be put off by the dated look and feel, you can change the look and feel using some startup parameters. [0]https://sourceforge.net/projects/sqleo/ https://sourceforge.net/projects/sqleo/