Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Lightweight SQLite Editor for Windows

github.com

Post reply on HN
Print view View original

41–50 of 114 posts

Re: Lightweight SQLite Editor for Windows

#42

Post by smackeyacky »

petepete wrote: post #17

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…

If you want an abomination, the Azure data studio makes SSMS look like query analyzer.

Re: Lightweight SQLite Editor for Windows

#43

Post by hansoolo »

waselighis wrote: post #21
cellularmitosis wrote: post #5

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. https://www.youtube.com/watch?v=JlZe2JwrJqM https://www.youtube.com/watch?v=CyJw2MumgTQ

Oh! I gonna dive into this pretty soon. Thank you!

Re: Lightweight SQLite Editor for Windows

#45

Post by haunter »

justsomehnguy wrote: post #13

Kudos to the author for a meaningful screenshot right at the start. And with a basic Win32 GUI I can bet my pumpkin latte what it as fast as SQLite itself.

>Kudos to the author for a meaningful screenshot right at the start.

I was thinking about this recently that so many projects on Github missing screenshots. I was thinking to make PRs to at least show some basic functionality.

Re: Lightweight SQLite Editor for Windows

#46

Post by dataflow »

jansommer wrote: post #28
cellularmitosis wrote: post #5

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…

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?

Re: Lightweight SQLite Editor for Windows

#49

Post by masfuerte »

dataflow wrote: post #46
jansommer wrote: post #28

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

You just need to add a manifest to your app indicating that you support high DPI. To test your app just change the DPI in the display settings.
Post reply on HN