Live data from Hacker News

Lightweight SQLite Editor for Windows

github.com

31–40 of 114 posts

Re: Lightweight SQLite Editor for Windows

#31

I love that it's just 12 files, straight to the point, no unnecessary boilerplates

You didn't happen to look at those files? main.cpp is 8900 lines, dialogs.cpp something almost as long. It's probably super performant but I wouldn't volounteer to maintain that codebase unless getting paid (And the commit history only shows the author...)

Re: Lightweight SQLite Editor for Windows

#32

I've been wanting to dip my toes into old-school Win32 development for a while now, this codebase looks like a great example to pore over.

Use ChatGPT! It's night and day for Win32 dev in my experience, and the code it produces is really good. One thing to note before going into Win32: You're going to have a pixelated, upscaled ui if you don't take care of high dpi support yourself, and that involves patching system controls. So prepare yourself for lots of dpi-work if that's a concern. (One thing I've been experimenting with is superclassing the system…

Exactly my experience. In general, for the sane person, it is impossible to write more than a few lines of Win32 API code without copy/paste... ChatGPT came quite handy here.

Re: Lightweight SQLite Editor for Windows

#33

Oh this looks good. I've been using: https://sqlitebrowser.org/ This seems to offer way more.

I've never tried this, but it appears to be possible to use Oracle SQL Developer to browse SQLite tables.

https://github.com/Trivadis/sqldev-jdbc-proxy

Oracle SQL Developer is a Java clone of Toad from Quest software:

https://www.oracle.com/database/sqldeveloper/

Toad also bears a resemblance to the Windows app in the post.

Re: Lightweight SQLite Editor for Windows

#34

Linux version, please!

This codebase is very much tied to the win32 API, maybe with the winelib wrapper but otherwise I wouldn't bother.

Sibling post here mentioned using under wine but I'm not sure if that's the best idea since wine might not translate locking semantics in the same way and those might be plenty important to avoid corruption with SQLite databases.

Re: Lightweight SQLite Editor for Windows

#35

Windows-only seems to me like the most rapidly shrinking market.

which is a shame because I miss old-school highly-functional win32 apps like this—bursting with soul and a flagrant disregard for modern app design/development principles.

You know, a tool, made by a tool maker, in the relevant trade, making a tool meant to be used by tool makers.

As opposed to the stuff nowadays that seem to be marketed first, made by whoever has the least power to ignore the job, and using some abysmal javascript GUI framework that can't even keep up with desktop framerate.

I also miss the days when the tools I used to do my job didn't HIDE shit from me, like error messages. Sure, I might not know what "ExtremelyExplicitNullException in doFrobThrob" means, but when I paste that error message in the support email, the engineer on the other side knows the exact line of code that error was generated on, and which variable was broken, and 9/10 times that's enough to actually find the root cause and fix it. No telemetry required. I'm so tired of vague, numbered error messages that nobody knows what line of code it corresponds to and nobody cares anyway because it's just going into a giant pile in the telemetry system that nobody except one mediocre PM is allowed to pull bugs from.

Re: Lightweight SQLite Editor for Windows

#38

I love that this looks very much like Query Analyzer, the lightweight querying tool that came with SQL Server 2000. Back then, server management, querying and profiling were handled by separate utilities that did one thing well. They were all replaced with SSMS, which was a slow abomination. Query Analyzer is my favourite SQL editing environment to this day. It was incredibly snappy, could render thousands of rows wi…

I don’t think it has the explain visualization, but otherwise these screenshots look a lot like DBeaver to me. Perhaps worth a try if you haven’t stumbled upon it yet.

Dbeaver is many things, but I would not call it lightweight. It is written in Java, after all.

It is great, but Query Analyzer-alike it is not.

Re: Lightweight SQLite Editor for Windows

#39

Earlier quoted context omitted.

I don’t think it has the explain visualization, but otherwise these screenshots look a lot like DBeaver to me. Perhaps worth a try if you haven’t stumbled upon it yet.

Dbeaver is many things, but I would not call it lightweight. It is written in Java, after all. It is great, but Query Analyzer-alike it is not.

dBeaver is written in Java, but it feels very lightweight. I'm running it on a Linux desktop I've been using since 2014. It's also cross platform so I run it at work on a Windows laptop.
Post reply on HN