HackerTrans
TopNewTrendsCommentsPastAskShowJobs

janproch

no profile record

Submissions

[untitled]

1 points·by janproch·vor 5 Monaten·0 comments

[untitled]

1 points·by janproch·vor 6 Monaten·0 comments

[untitled]

1 points·by janproch·vor 7 Monaten·0 comments

[untitled]

1 points·by janproch·vor 9 Monaten·0 comments

[untitled]

1 points·by janproch·vor 11 Monaten·0 comments

[untitled]

1 points·by janproch·vor 12 Monaten·0 comments

DbGate In-Depth Review on Research.com

research.com
1 points·by janproch·letztes Jahr·0 comments

[untitled]

1 points·by janproch·letztes Jahr·0 comments

DbGate supports libSQL/Turso database

dbgate.io
3 points·by janproch·letztes Jahr·1 comments

[untitled]

1 points·by janproch·letztes Jahr·0 comments

[untitled]

1 points·by janproch·letztes Jahr·0 comments

[untitled]

1 points·by janproch·vor 2 Jahren·0 comments

New GUI client for ClickHouse database

dbgate.org
2 points·by janproch·vor 2 Jahren·1 comments

Show HN: Online MIDI piano – learn, record, edit and share piano songs

pianohub.cloud
2 points·by janproch·vor 3 Jahren·1 comments

[untitled]

1 points·by janproch·vor 4 Jahren·0 comments

[untitled]

1 points·by janproch·vor 4 Jahren·0 comments

[untitled]

1 points·by janproch·vor 4 Jahren·0 comments

DbGate – open-source (no)SQL database client – now can create ER diagrams

dbgate.org
1 points·by janproch·vor 4 Jahren·1 comments

DbGate – open-source database client – now supports SQLite

github.com
10 points·by janproch·vor 5 Jahren·3 comments

Show HN: DbGate – open-source, cross-platform SQL+noSQL database client

dbgate.org
198 points·by janproch·vor 5 Jahren·76 comments

comments

janproch
·vor 12 Monaten·discuss
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"
janproch
·letztes Jahr·discuss
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
janproch
·letztes Jahr·discuss
You could try it on online demo: https://demo.dbgate.org/ , create query and toggle AI Assistant
janproch
·vor 2 Jahren·discuss
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
janproch
·vor 2 Jahren·discuss
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.
janproch
·vor 3 Jahren·discuss
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.
janproch
·vor 4 Jahren·discuss
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.
janproch
·vor 5 Jahren·discuss
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)
janproch
·vor 5 Jahren·discuss
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.
janproch
·vor 5 Jahren·discuss
Thanks, that's obviously the problem
janproch
·vor 5 Jahren·discuss
Creating diagrams is now not supported, I have plan to add it, but not with biggest priority

I am also looking forward to SQLite
janproch
·vor 5 Jahren·discuss
Yes, this will be added soon. Thanks for feedback
janproch
·vor 5 Jahren·discuss
very good tip, thanks
janproch
·vor 5 Jahren·discuss
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
janproch
·vor 5 Jahren·discuss
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.
janproch
·vor 5 Jahren·discuss
If you mean search database by name in CONNECTIONS widget, yes, I want to do it. Could you please create an issue on github?
janproch
·vor 5 Jahren·discuss
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.
janproch
·vor 5 Jahren·discuss
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
janproch
·vor 5 Jahren·discuss
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
janproch
·vor 5 Jahren·discuss
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.