If you can do with an even leighter-weight client, you can try my very own https://sqliteviewer.app. It's all browser/wasm-based and works offline, but has some important shortcomings.
Lightweight SQLite Editor for Windows
61–70 of 114 posts
Re: Lightweight SQLite Editor for Windows
#62I 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...)
A good IDE makes it very easy to navigate through files like that. You navigate to functions, structures, variables, etc... instead of files.
Re: Lightweight SQLite Editor for Windows
#63I'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.
I love that this has been built with the old-school API! I've done a bit over the years and find it kind of pleasurable (maybe I enjoy torture!).
Re: Lightweight SQLite Editor for Windows
#64But why is it Windows only? Even as a Windows user, my professional day is spent on a Mac even if my Windows machine is running at the same time. What arcane library does it rely on that it can't just cross-compile for all three operating systems?
Perhaps the author only use Windows?
It doesn't use any cross-platform library like Qt, wxWidgets, etc. Just good old Windows API.
Re: Lightweight SQLite Editor for Windows
#65But why is it Windows only? Even as a Windows user, my professional day is spent on a Mac even if my Windows machine is running at the same time. What arcane library does it rely on that it can't just cross-compile for all three operating systems?
> What arcane library does it rely on
Win32
> can't just cross-compile
Suppose that you only use a specific operating system. Even if you could cross compile, how would you verify that it actually works? How would you know the specifics of each operating system and adapt you application to work well in such situation so that user don't flame you? It's just not that easy. And don't get me started on making GUI applications.
Side note: As a Windows user, In this case I really appreciate the look and feel of the native GUI. It feels like a "real" Windows application. You would not get that if you cross compiled.
Re: Lightweight SQLite Editor for Windows
#66Linux 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.
SQLite is so very extremely popular that I don’t think you have to worry about corruption under Wine—if it was broken, a lot of software would be broken.
Re: Lightweight SQLite Editor for Windows
#67Earlier quoted context omitted.
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…
I'm confused. Are you sure high DPI needs patching system controls to avoid pixelation? Doesn't dpiAwareness avoid the pixelation? I certainly haven't needed to patch anything for this in the past. If you have an example you could point to, that would be great, since I don't know if I'm missing something here. Also, question: do you know of a good way to test for high-DPI mode on a low-DPI screen?
Nope, you get the pleasure of implementing dpi support yourself.
https://building.enlyze.com/posts/writing-win32-apps-like-it...
Re: Lightweight SQLite Editor for Windows
#68Earlier quoted context omitted.
I'm confused. Are you sure high DPI needs patching system controls to avoid pixelation? Doesn't dpiAwareness avoid the pixelation? I certainly haven't needed to patch anything for this in the past. If you have an example you could point to, that would be great, since I don't know if I'm missing something here. Also, question: do you know of a good way to test for high-DPI mode on a low-DPI screen?
Nope, you get the pleasure of implementing dpi support yourself. https://building.enlyze.com/posts/writing-win32-apps-like-it...
Thanks for the link. Glancing at it, I still don't see where there's a need to patch system controls for high DPI support, though. The closest thing I see there is for changing their fonts, but that seems different from patching them (no superclassing that I can see, etc.). Moreover, it's for dynamic DPI support (i.e. supporting DPI changes), not high DPI support. Is that what you were referring to?
Re: Lightweight SQLite Editor for Windows
#69Oh this looks good. I've been using: https://sqlitebrowser.org/ This seems to offer way more.
It's a blessing. I loath the slow feedback cycles your get in the BigQuery Web UI. Even for "small" tables, that would fit on your machine. When I expect a longer data exploration or debugging phase, I dump the BQ tables to SQLite. Opening that with SQLite browser lets me iterate very fast.
Re: Lightweight SQLite Editor for Windows
#70I strongly recommend TablePlus for sqlite/postgres/other databases, it's made my life significantly easier. https://tableplus.com/
Have you tried DBeaver? If so, how would you compare TablePlus to it?