Live data from Hacker News

Lightweight SQLite Editor for Windows

github.com

101–110 of 114 posts

Re: Lightweight SQLite Editor for Windows

#101

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.

This also brought back memories for me of writing Win32 apps. If you're looking for a good book, checkout Programming Windows by Charles Petzold. It really demystified a lot of things for me and I bet it's still relevant if you want to write stuff like this.

Re: Lightweight SQLite Editor for Windows

#102

Earlier quoted context omitted.

I didn't assume you'd give a helpful answer, but I didn't expect you to give that kind of an answer, either. You're always welcome not to respond if this is taking too much of your time. I figured maybe at least one of us would learn something about high DPI issues, hence why I engaged. And I did just try what you said and the combo box fine to me: https://imgur.com/a/Mb83tPj

That is not the default Win32 combobox. I don't know what you're using, but it's not the plain c api.

dataflow: That is indeed a nice looking combobox in your new screenshot. I'm not getting that result on win10 when using the Win32 c api, and if you're not using something like WinForms, MFC or another abstraction, it's hard to say why it works for you. I'm on a 4k resolution with 200% scaling and the button is way too thin.

Re: Lightweight SQLite Editor for Windows

#103
post #61

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.

How is that lighter weight than a simple win32 app?

If you don't have Windows it would probably qualify as lighter weight.

Re: Lightweight SQLite Editor for Windows

#104

Earlier quoted context omitted.

That is not the default Win32 combobox. I don't know what you're using, but it's not the plain c api.

dataflow: That is indeed a nice looking combobox in your new screenshot. I'm not getting that result on win10 when using the Win32 c api, and if you're not using something like WinForms, MFC or another abstraction, it's hard to say why it works for you. I'm on a 4k resolution with 200% scaling and the button is way too thin.

I'm not sure if this makes a difference but do you see that problem with dialogs (resources + DialogBox) rather than basic windows?

If I remember & get a chance later I can try to make a minimal example.

Edit: Based on this comment [1] I'm guessing you're on something like Windows 8.1 rather than a recent version of Windows 10 or later.

[1] https://www.reddit.com/r/programming/comments/d77mf7/comment...

Re: Lightweight SQLite Editor for Windows

#105
Dumb question for those of you familiar with coding Win API these days -- can you easily build 64-bit Windows applications using Win32 API? I did a little Win32 C coding many years ago, but that was long before 64-bit Windows hit the scene. Is there a Win64 API now?

Re: Lightweight SQLite Editor for Windows

#106

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.

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!).

Agreed! Sadly, lean GUI apps are mostly a thing of the past now.

Re: Lightweight SQLite Editor for Windows

#107

Earlier quoted context omitted.

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.

I'm not considering Wine emulation in isolation, I'm considering a scenario where someone would use this as a UI to inspect a SQLite database powering for example a Linux based NodeJS or PHP application. Would the semantics of the Linux based application (with SQLite compiled for Linux) correspond to the UI (with SQLite compiled for Windows) running through an API emulation layer (Wine) that potentially translates se…

Ah, mixed Linux and Windows. Fair enough. Yeah, I’d assume that to be equivalent to a network share and accessing the database from multiple machines.

Re: Lightweight SQLite Editor for Windows

#108

Earlier quoted context omitted.

dataflow: That is indeed a nice looking combobox in your new screenshot. I'm not getting that result on win10 when using the Win32 c api, and if you're not using something like WinForms, MFC or another abstraction, it's hard to say why it works for you. I'm on a 4k resolution with 200% scaling and the button is way too thin.

I'm not sure if this makes a difference but do you see that problem with dialogs (resources + DialogBox) rather than basic windows? If I remember & get a chance later I can try to make a minimal example. Edit: Based on this comment [1] I'm guessing you're on something like Windows 8.1 rather than a recent version of Windows 10 or later. [1] https://www.reddit.com/r/programming/comments/d77mf7/comment...

No, win10

Re: Lightweight SQLite Editor for Windows

#109
post #98

But 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?

Great question. What arcane libraries do all those Mac-specific text editors, IDEs, etc that Mac users rave about use, that they can't be cross-compiled for all three operating systems?

I have the same question. Any time someone releases an OS-specific piece of software, that's a question they should already have an answer to (especially given how much open source exists to smooth out the differences)

Re: Lightweight SQLite Editor for Windows

#110

Earlier 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...

When you load a dialog from resource, windows scales it proportionally to specified font size (DS_FONT style).
Post reply on HN