HackerTrans
トップ新着トレンドコメント過去質問紹介求人

janproch

no profile record

投稿

[untitled]

1 ポイント·投稿者 janproch·5 か月前·0 コメント

[untitled]

1 ポイント·投稿者 janproch·6 か月前·0 コメント

[untitled]

1 ポイント·投稿者 janproch·7 か月前·0 コメント

[untitled]

1 ポイント·投稿者 janproch·9 か月前·0 コメント

[untitled]

1 ポイント·投稿者 janproch·11 か月前·0 コメント

[untitled]

1 ポイント·投稿者 janproch·12 か月前·0 コメント

DbGate In-Depth Review on Research.com

research.com
1 ポイント·投稿者 janproch·昨年·0 コメント

[untitled]

1 ポイント·投稿者 janproch·昨年·0 コメント

DbGate supports libSQL/Turso database

dbgate.io
3 ポイント·投稿者 janproch·昨年·1 コメント

[untitled]

1 ポイント·投稿者 janproch·昨年·0 コメント

[untitled]

1 ポイント·投稿者 janproch·昨年·0 コメント

[untitled]

1 ポイント·投稿者 janproch·2 年前·0 コメント

New GUI client for ClickHouse database

dbgate.org
2 ポイント·投稿者 janproch·2 年前·1 コメント

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

pianohub.cloud
2 ポイント·投稿者 janproch·3 年前·1 コメント

[untitled]

1 ポイント·投稿者 janproch·4 年前·0 コメント

[untitled]

1 ポイント·投稿者 janproch·4 年前·0 コメント

[untitled]

1 ポイント·投稿者 janproch·4 年前·0 コメント

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

dbgate.org
1 ポイント·投稿者 janproch·4 年前·1 コメント

DbGate – open-source database client – now supports SQLite

github.com
10 ポイント·投稿者 janproch·5 年前·3 コメント

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

dbgate.org
198 ポイント·投稿者 janproch·5 年前·76 コメント

コメント

janproch
·12 か月前·議論
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
·昨年·議論
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
·昨年·議論
You could try it on online demo: https://demo.dbgate.org/ , create query and toggle AI Assistant
janproch
·2 年前·議論
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
·2 年前·議論
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
·3 年前·議論
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
·4 年前·議論
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
·5 年前·議論
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
·5 年前·議論
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
·5 年前·議論
Thanks, that's obviously the problem
janproch
·5 年前·議論
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
·5 年前·議論
Yes, this will be added soon. Thanks for feedback
janproch
·5 年前·議論
very good tip, thanks
janproch
·5 年前·議論
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
·5 年前·議論
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
·5 年前·議論
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
·5 年前·議論
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
·5 年前·議論
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
·5 年前·議論
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
·5 年前·議論
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.