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.
Dave's Garage on YouTube has a couple good videos that I can recall.
Lightweight SQLite Editor for Windows
21–30 of 114 posts
Re: Lightweight SQLite Editor for Windows
#22Windows-only seems to me like the most rapidly shrinking market.
But it is a huge market!!! And o so many people I work with in telcos and such work on their company provided windows laptops
Re: Lightweight SQLite Editor for Windows
#23Linux version, please!
If it were written for Linux first, it would even be available for Windows simultaneously.
Re: Lightweight SQLite Editor for Windows
#24Windows-only seems to me like the most rapidly shrinking market.
What a selfish comment. Shame on you. It's open source. You don't like it, you're welcome to add support for another OS, or use something else.
Adding support to a tool for a different is that is developed for winapi is really not a thing. If it was written for GTK or Qt or electron then it is possible. But I would guess you should just best write a new app instead?
Re: Lightweight SQLite Editor for Windows
#25I love that it's just 12 files, straight to the point, no unnecessary boilerplates
Re: Lightweight SQLite Editor for Windows
#26This looks inspired by the excellent SQLYog, which is one of the apps I missed most when I switched from Windows to macOS. I still haven't found a good macOS equivalent.
Same. I've tried DBeaver (its UI is an abomination) and TablePlus (some of the UI is better but e.g hiding the database search where they do - why?) and TablePlus is the one I'm sticking with, but I still miss SQLYog. Especially the permissions editor for database users.
Re: Lightweight SQLite Editor for Windows
#27I'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.
It looks like a pretty clean example from what I can recall.
WinMain builds the window and starts the message pump. The pump is implement starting at line 425. It's basically a while loop that reads the next message on the stack, translates it, then sends it to the object it belongs to.
It's the precursor to today's modern event-driven designs. Basically, this is now done for you by the runtime.
The bulk of the action happens in the created window's "wndproc", cbMainWindow (Line 455 - 2897).
There's a giant switch statement, with each handled message being a separate case. There's also a WM_COMMAND message, which is essentially a message holding another message inside.
This is probably the best book on Win32 API programming out there.
https://www.amazon.com/Programming-Windows%C2%AE-Fifth-Devel...
Re: Lightweight SQLite Editor for Windows
#28I'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 controls and "overwriting" the original by registering a superclass of eg. the edit control as simply "edit". This makes other system controls, like the combobox, use your dpi scaled/custom version).
Re: Lightweight SQLite Editor for Windows
#29Linux version, please!
This has the intuitive scent of a project that works directly in Wine without any problems. Haven't tried it myself though.
Kinda like OpenMPT...indicate the supported Wine version in the Downloads maybe, and then after seeing it running just fine, one could argue that there's not even much point to a Linux port.
Re: Lightweight SQLite Editor for Windows
#30This looks inspired by the excellent SQLYog, which is one of the apps I missed most when I switched from Windows to macOS. I still haven't found a good macOS equivalent.
Same. I've tried DBeaver (its UI is an abomination) and TablePlus (some of the UI is better but e.g hiding the database search where they do - why?) and TablePlus is the one I'm sticking with, but I still miss SQLYog. Especially the permissions editor for database users.
TablePlus is the best I've found so far too. I tried Sequel Pro for a couple years. Haven't found anything that competes with SQLYog for browsing the schema while writing a query.