I love that it's just 12 files, straight to the point, no unnecessary boilerplates
Lightweight SQLite Editor for Windows
31–40 of 114 posts
Re: Lightweight SQLite Editor for Windows
#32I'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…
Re: Lightweight SQLite Editor for Windows
#33Oh this looks good. I've been using: https://sqlitebrowser.org/ This seems to offer way more.
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
#34Linux version, please!
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
#35Windows-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.
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
#36Oh this looks good. I've been using: https://sqlitebrowser.org/ This seems to offer way more.
Been using this for years. Fantastic tool.
Re: Lightweight SQLite Editor for Windows
#37Re: Lightweight SQLite Editor for Windows
#38I 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.
It is great, but Query Analyzer-alike it is not.
Re: Lightweight SQLite Editor for Windows
#39Earlier 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.
Re: Lightweight SQLite Editor for Windows
#40Linux version, please!