[HN Gopher] Lightweight SQLite Editor for Windows ___________________________________________________________________ Lightweight SQLite Editor for Windows Author : bbkane Score : 120 points Date : 2023-04-18 19:06 UTC (3 hours ago) (HTM) web link (github.com) (TXT) w3m dump (github.com) | gnoffa wrote: | Personally I really love SQLiteStudio which I use pretty much | daily: https://sqlitestudio.pl/ | account-5 wrote: | Oh this looks good. I've been using: https://sqlitebrowser.org/ | | This seems to offer way more. | jdthedisciple wrote: | Been using the same, and I've been very content with it too. | | Curious about this one. | MPlus88 wrote: | [dead] | chasil wrote: | I've never tried this, but it appears to be possible to use | Oracle SQL Developer to browse SQLite tables. | | https://github.com/Trivadis/sqldev-jdbc-proxy | | Oracle SQL Developer is a Java clone of Toad from Quest | software: | | https://www.oracle.com/database/sqldeveloper/ | | Toad also bears a resemblance to the Windows app in the post. | precompute wrote: | >sqlitebrowser | | Been using this for years. Fantastic tool. | akisej wrote: | Looks very cool! We use logicloop.com to connect across | databases, use ChatGPT to write, fix and explain SQL queries too | psychphysic wrote: | Was just looking for this! There is a decent viewer on the store | (aka can install in a pinch while in S mode). | | But you couldn't even copy paste! | TehShrike wrote: | This 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. | pbowyer wrote: | 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. | TehShrike wrote: | 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. | justsomehnguy wrote: | 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. | haunter wrote: | >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. | rr808 wrote: | Wish there was a great free open source GUI which works for for | Sybase or even jdbc. | pkage wrote: | I strongly recommend TablePlus for sqlite/postgres/other | databases, it's made my life significantly easier. | | https://tableplus.com/ | solarkraft wrote: | Windows-only seems to me like the most rapidly shrinking market. | roywashere wrote: | 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 | adamrezich wrote: | which is a shame because I miss old-school highly-functional | win32 apps like this--bursting with soul and a flagrant | disregard for modern app design/development principles. | mrguyorama wrote: | You know, a tool, made by a tool maker, in the relevant | trade, making a tool meant to be used by tool makers. | | As opposed to the stuff nowadays that seem to be marketed | first, made by whoever has the least power to ignore the job, | and using some abysmal javascript GUI framework that can't | even keep up with desktop framerate. | | I also miss the days when the tools I used to do my job | didn't HIDE shit from me, like error messages. Sure, I might | not know what "ExtremelyExplicitNullException in doFrobThrob" | means, but when I paste that error message in the support | email, the engineer on the other side knows the exact line of | code that error was generated on, and which variable was | broken, and 9/10 times that's enough to actually find the | root cause and fix it. No telemetry required. I'm so tired of | vague, numbered error messages that nobody knows what line of | code it corresponds to and nobody cares anyway because it's | just going into a giant pile in the telemetry system that | nobody except one mediocre PM is allowed to pull bugs from. | 2h wrote: | 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. | roywashere wrote: | 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? | Brian_K_White wrote: | It was neither selfish nor a demand. It was an observation. | ezconnect wrote: | Don't worry the PC market is shrinking. | cozzyd wrote: | haven't tried, but it almost certainly works fine in wine... | | edit: tested it, and yes it works (though sometimes you have to | resize window to get updates for some reason...) | anditherobot wrote: | I love that it's just 12 files, straight to the point, no | unnecessary boilerplates | whizzter wrote: | 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...) | petepete wrote: | 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 | without skipping a beat and had a nice explain visualisation | built in. If there was a modern rewrite that supported | PostgreSQL, I'd buy it in an instant. | | There are screenshots in these articles if anyone's interested: | | http://etutorials.org/SQL/microsoft+sql+server+2000/Part+II+... | | https://www.sqlservercentral.com/articles/using-query-analyz... | smackeyacky wrote: | If you want an abomination, the Azure data studio makes SSMS | look like query analyzer. | chrismeller wrote: | I don't think it has the explain visualization, but otherwise | these screenshots look a lot like DBeaver to me. Perhaps worth | a try if you haven't stumbled upon it yet. | vetinari wrote: | 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. | leke wrote: | 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. | cellularmitosis wrote: | 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. | bena wrote: | 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... | jansommer wrote: | 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). | dataflow wrote: | 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? | zerr wrote: | Exactly my experience. In general, for the sane person, it is | impossible to write more than a few lines of Win32 API code | without copy/paste... ChatGPT came quite handy here. | waselighis wrote: | 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 | hansoolo wrote: | Oh! I gonna dive into this pretty soon. Thank you! | hochmartinez wrote: | Linux version, please! | trelane wrote: | If it were written for Linux first, it would even be available | for Windows simultaneously. | whizzter wrote: | 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. | leke wrote: | dbeaver is cross-platform and is a great general db client. I | highly recommend it. | themodelplumber wrote: | 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. | ijidak wrote: | This is awesome! I've been looking for a good SQL Lite GUI! | | A lot of times, I just want a tool to do ad-hoc CSV work, and | don't want to fiddle with a terminal. | guavaNinja wrote: | At my last job, I built a SQLite editor as an internal tool with | C++ and ImGUI. It had custom features/views for our custom needs. | | It was super fun and the code was super easy to read and edit. | Immediate mode made our job much easier. ___________________________________________________________________ (page generated 2023-04-18 23:00 UTC)