SQLPro for SQLite

I recently released v3 of Base, my SQLite editor for macOS. The goal of this app is to provide a comfortable native GUI for SQLite, without it turning into a massive IDE-style app. The coolest features are - That it can handle full altering of tables, which is quite finicky to do manually with SQLite. - It has a more detailed display of column constraints than most editors. Each constraint is shown as an icon if active, with full details available on clicking the icon. This update also adds support for attaching databases, which is a bit fiddly with macOS sandboxing. I'd love to hear any…

Database management for macOS

Hi HN, Over the past few months I've been building DB Pro with my co-founder. DB Pro is a modern desktop database GUI client designed to make working with Postgres, MySQL, SQLite, libSQL and other engines feel fast, visual, and enjoyable. Our focus has been on the dev-experience. We wanted to absolutely nail the UX and look and feel as we believe most db clients aren't friendly to work with. Some features: Visual change review – See pending inserts/updates/deletes before committing them. Inline data editing – Edit table rows directly without clunky modal dialogs. Raw SQL editor – A…

https://github.com/ncruces/go-sqlite3 was doing poorly on this benchmark that was posted yesterday to HackerNews [1]. With the help of some pprof, I was able to trace it to a serious performance regression introduced two weeks ago, and come up with the fix (happy to field questions, if you're interested in the nitty gritty). It's not the fastest driver around, but it's no longer the slowest: comfortably middle of the pack. It's based on a WASM build of SQLite, and thanks to https://wazero.io doesn't need CGO. [1]:…

Run SQL on your phone

Native database client, free and open source