janproch

If you want to try it without downloading desktop app, use online demo - https://demo.dbgate.org/, connect to any preconfigured database, click big PLUS IN CIRCLE in top right corner and choose "Database chat"

DbGate is cross-platform database manager, for desktop and for web platforms. New version 6.3.0 brings also support of native database backup & restore for MySQL and PostgreSQL

You could try it on online demo: https://demo.dbgate.org/ , create query and toggle AI Assistant

This releasae brings many UX improvements, keyboard navigation, tab preview mode like in VS code, handling stored procedure parameters, improved compare DB model feature and much more

DbGate, open-source client for various databases, recently added support for ClickHouse database. There is quite wide support of this engine, including ClickHouse weird features like sorting keys and not-unique primary keys.

I play piano, but I am not good in reading notes. So I wanted to record my reportoir, which I have hard time to learn from note sheets, or created from youtube piano tutorials (I use these tutorials as inspiration, not as exact source). I tried several tools for this purpose, but I wasn't satisfied with them. So I created PianoHub.

PianoHub is created with SvelteKit and hosted on Vercel. I use it mor my very amateur piano recordings, I hope that it could be useful also for someone else.

DbGate was been already introduced on HN - https://news.ycombinator.com/item?id=26899100

New version comes with creating ER diagrams, with automatic layout, ability to change styles and export functionality.

There are also notable improvements from recent versions, such as big optimalization of electron app (now no embeded HTTP server in electron app is used). Also table schema editor and database structure compare tool was implemented.

This will depend on underlying nodejs driver, which is better-sqlite3. I have no information about how it works in this configuration, but if you would try it, feedback is welcome (but in case that if will not work, I could only create ticket in better-sqlite and wait for solving it)

DbGate was introduced on HN 2 months ago - https://news.ycombinator.com/item?id=26899100

DbGate is electron+svelte driven cross-platform database manager.

Now it comes with SQLite support, as it was the most requested feature. Implementation uses better-sqlite3 package.

Thanks, that's obviously the problem

Creating diagrams is now not supported, I have plan to add it, but not with biggest priority

I am also looking forward to SQLite

Yes, this will be added soon. Thanks for feedback

very good tip, thanks

Thanks for feedback. It looks like electron problem.

This issue was already created on github, https://github.com/dbgate/dbgate/issues/86 . Output from console could be helpful.

Next step would be testing dbgate upgrade, probably upgrade of electron would be neccessary

As you said, DbGate has no activity tracking or monitoring. Tracking is only on site dbgate.org. I will never add any tracking to dbgate app. I believe that it doesn't have great sense in open-source project.

If you mean search database by name in CONNECTIONS widget, yes, I want to do it. Could you please create an issue on github?

Honestly, not at 100% today. But I am very focused to make it keyboard-friendly, many operations could be done only with keyboard. Keyboard support is improved continually, eg. recently I have added configuration of keyboard shortcuts and command palette like in VS code (after F1), if you don't like context menu.

Thanks. Yes, support of diagramming is also planned. About documentation, I am not sure, whether support it directly. Maybe this could be better achieved with some plugin, as there could be lot of options... Probably I will create some simple plugin making basic HTML doc, someone could than improve or fork and customize it

Thanks! Table editor will be surely implemented. I am now deciding, what big feature will be the next, table structure editor is hot candidate. Next candidate is SQLite support

I am also using Electron. But I didn't come across problems with scrolling. Surely the reason is not Electron, Beekeeper Studio is created with Vue.js, maybe that is origin of this problem. DbGate uses Svelte, which should be much much effective, because of omiting virtual DOM. Formerly DbGate was written in React (which has also virtual DOM as vue), rewriting to Svelte boosted the performance markedly.

You can execute dbgate from console, all available info is printed to console. Message "An internal error has occurred" seems to be from the underlying db driver. You could also create issue github, if more investigation is needed

Azure cloud should be not problem, what version of MariaDB are you using?

Well, looks great...

Yes, I am planning to support it for long time. In fact, I deal with programming SQL clients over 10 years (in past, I have created DatAdmin and DbMouse clients), I would like to use this know-how to create widely used open-source SQL client. Of course, it depends also on feedback from users and community.

Now I have reserved 1 man-day per week for my non-profit or very-low-profit projects, dbgate takes 90% of this time. (+of course some evenings and weekends). I am planning to use github sponsors or something like this in future, maybe it would allow me to extend this reserved time.

Author's point of view... dbgate have much simpler user interface. dbeaver is powerful, but it has traditional design like other applications made by Java. dbeaver looks like Eclipse, whereas dbgate looks like VS Code. Another point - powering by javascript allows lot of "hacking" - plugins as NPM packages, data export/copy jobs exported as js files, which can be run with nodejs. This cannot be accomplished with Java.

I have tried Azure Data Studio, before I have decided to create DbGate as linux tool. From my point of view, ADS uses technology from VS Code heavily, which is great in VS Code, but not in database access tool. About features, what I miss in ADS most are data browsing (filtering, sorting, master-details) features, it is neccessary to write queries manually. I think I am quite good in writing SQL queries, but it is annoying and slow to write very similar queries again and again.

What you mean exactly with lack of MS telemetry?

Thanks. My plan is at first to have reasonable big set of active users, who will report problems, ideally also some contributors from community. Buy-me-cofee or donate buttons is next step

That should be no problem, I will add it in next version

Hi all,

this is my passion project. I was unable to find nice SQL client for Linux, so I created it on myself. I have created proprietary SQL client for Windows in past, so this app is influenced by experiences from this work. Recently I have added support also for noSQL, MongoDB.

It's built on Electron using Svelte. Although Electron apps tends to be clumsy, partly thanks to Svelte framework is the app fast enough.

It's open source (MIT), cross-platform (Linux, Mac, Windows), or can be run as web-based application in browser. Hope it could be useful also for others.