No mention of https://sqlitestudio.pl/ in the comments which is cross platform ...
Lightweight SQLite Editor for Windows
51–60 of 114 posts
Re: Lightweight SQLite Editor for Windows
#52I 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.
It's not feature complete, but Data Studio felt like a breath of fresh air compared to SSMS being all the slowness of Visual Studio coupled with about 1500 places where configuration might be.
(Of course, what do I know. I use DataGrip for my databasing these days. It's fine.)
Re: Lightweight SQLite Editor for Windows
#53I'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 actio…
Yes, it's unfortunate that Programming Windows after 5ed became about XAML and C#. Those are good tools, but it's sad that they stopped updating the Win32/C++ resources as well.
Re: Lightweight SQLite Editor for Windows
#54Earlier 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?
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.
I guess I was hoping for something little clunky than that, but thanks for the suggestion.
Re: Lightweight SQLite Editor for Windows
#55Don't miss the "Powerful" link goes to a six minute YouTube video[1] showing it to be packed with nice touches / demonstrating the features.
Re: Lightweight SQLite Editor for Windows
#56Earlier quoted context omitted.
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.
dBeaver is written in Java, but it feels very lightweight. I'm running it on a Linux desktop I've been using since 2014. It's also cross platform so I run it at work on a Windows laptop.
You think? Just looking at the interface and all the buttons/options screams ‘exhaustive/heavy’ to me.
It’s pretty fast for a Java tool, but I wouldn’t call it snappy.
Re: Lightweight SQLite Editor for Windows
#57I strongly recommend TablePlus for sqlite/postgres/other databases, it's made my life significantly easier. https://tableplus.com/
Hmm, looks like they’ve improved. I should try this again. Only negative is it doesn’t have any linux support.
Re: Lightweight SQLite Editor for Windows
#58But 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?
Re: Lightweight SQLite Editor for Windows
#59Kudos 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.
That's because adding a screenshot is surprisingly hard if you've never discovered that you can create an issue, paste an image into it, and then copy the URL that gives you into your readme without ever actually submitting the issue.
Re: Lightweight SQLite Editor for Windows
#60I strongly recommend TablePlus for sqlite/postgres/other databases, it's made my life significantly easier. https://tableplus.com/
Hmm, looks like they’ve improved. I should try this again. Only negative is it doesn’t have any linux support.
They have linux app, just not as good as in Windows, Mac.