20 ms·
Lightweight SQLite Editor for Windows
- account-5 4y agoOh this looks good. I've been using: https://sqlitebrowser.org/ https://sqlitebrowser.org/ This seems to offer way more.
- justinclift 4y agoAs a thought - unlike the current stable build - our nightly builds can open multiple "Browse Data" tabs at the same time. Aka: view multiple tables simultaneously. https://nightlies.sqlitebrowser.org/latest/ https://nightlies.sqlitebrowser.org/latest/ We're really overdue for making a new official release, but the nightly builds are pretty stable in the meantime. :)
- jdthedisciple 4y agoBeen using the same, and I've been very content with it too. Curious about this one.
- MPlus88 4y ago[dead]
- chasil 4y agoI'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 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/ https://www.oracle.com/database/sqldeveloper/ Toad also bears a resemblance to the Windows app in the post.
- precompute 4y ago>sqlitebrowser Been using this for years. Fantastic tool.
- EMM_386 4y agoI love DB Browser. It's fast, does what I need it to, is open source ... great little tool.
- scary-size 4y agoIt's a blessing. I loath the slow feedback cycles your get in the BigQuery Web UI. Even for "small" tables, that would fit on your machine. When I expect a longer data exploration or debugging phase, I dump the BQ tables to SQLite. Opening that with SQLite browser lets me iterate very fast.
- Jgrubb 4y agoInteresting idea, thanks. I never, ever use the BQ UI for querying unless I absolutely have to. We use Metabase for BI, which we plug into all of our development datasets and do the exploration and iterating there which still requires network round trips and I could see how your approach would be faster.
- kyrra 4y agoGoogler opinions are my own. I know little about BQ. My understanding of Big query is that at least some of the tech it's based on allows for handling very large datasets. I'm talking being able to search BI that is petabytes in size. I don't think it's really designed for small datasets. If you can stick the data in SQLite, I think you're using the wrong tool. Searching around, it looks like BI Engine may help in cases like this. See: https://cloud.google.com/blog/topics/developers-practitioners/speeding-small-queries-bigquery-bi-engine https://cloud.google.com/blog/topics/developers-practitioner...
- scary-size 4y agoThat's true. Most of our production data is in the "petabyte" category. But often we start out with a small amount of data, for example for a new feature or product. That's when a lot of the exploration and query building happens. Once that's done, we leverage BigQuery to scale this up, serving a few hundred million users. There's a platform/standardisation component to this as well. We want our devs to use a single tool for all of their OLAP uses cases.
- kyrra 4y agoTotally makes sense, I guess I do the same thing internally (using partitioned tables, so the queries are a lot smaller, or making sure to only select the minimum columns to prove my query is correct). I also have no clue if my internal queries end up using something like BI Engine where it'll cache data in memory (much of this is opaque to me), but turn around is at least a few seconds per request. Your point is valid here, thanks for raising it.
- psychphysic 4y agoWas 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!
- solarkraft 4y agoWindows-only seems to me like the most rapidly shrinking market.
- 2h 4y agoWhat 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.
- Brian_K_White 4y agoIt was neither selfish nor a demand. It was an observation.
- roywashere 4y agoAdding 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?
- ezconnect 4y agoDon't worry the PC market is shrinking.
- cozzyd 4y agohaven'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...)
- adamrezich 4y agowhich 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 4y agoYou 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.
- cellularmitosis 4y agoI'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.
- waselighis 4y agoDave'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=JlZe2JwrJqM https://www.youtube.com/watch?v=CyJw2MumgTQ https://www.youtube.com/watch?v=CyJw2MumgTQ
- hansoolo 4y agoOh! I gonna dive into this pretty soon. Thank you!
- bena 4y agoIt 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-Developer-Reference/dp/157231995X https://www.amazon.com/Programming-Windows%C2%AE-Fifth-Devel...
- shortrounddev 4y agoYes, 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.
- jansommer 4y ago
- guavaNinja 4y agoAt 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.
- ijidak 4y agoThis 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.
- TehShrike 4y agoThis 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 4y agoSame. 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 4y agoTablePlus 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 4y agoKudos 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 4y ago>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.
- TheRealPomax 4y agoThat'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.
- edp 4y agoCan't you just put the image as a file inside your repo and reference it from the README.md file ?
- TheRealPomax 4y agoNot if your readme also has to work on "not Github" like npm or pypi, or anything that repackages your release while using your readme.md as page content. Those images are going to have to be fully qualified URLs.
- justsomehnguy 4y agohttps://github.com/little-brother/sqlite-gui/blob/master/resources/demo.webp https://github.com/little-brother/sqlite-gui/blob/master/res...
- pkage 4y agoI strongly recommend TablePlus for sqlite/postgres/other databases, it's made my life significantly easier. https://tableplus.com/ https://tableplus.com/
- Aeolun 4y agoHmm, looks like they’ve improved. I should try this again. Only negative is it doesn’t have any linux support.
- aha_throwaway 4y agoThey have linux app, just not as good as in Windows, Mac. https://tableplus.com/linux https://tableplus.com/linux
- piaste 4y agoHave you tried DBeaver? If so, how would you compare TablePlus to it?
- petepete 4y agoI 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+SQL+Server+Tools+and+Utilities/Chapter+6.+SQL+Server+Query+Analyzer+and+SQL+Debugger/Query+Analyzer/ http://etutorials.org/SQL/microsoft+sql+server+2000/Part+II+... https://www.sqlservercentral.com/articles/using-query-analyzer-templates https://www.sqlservercentral.com/articles/using-query-analyz...
- chrismeller 4y agoI 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 4y agoDbeaver 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 4y agodBeaver 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.
- Aeolun 4y agoYou 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.
- hochmartinez 4y agoLinux version, please!
- trelane 4y agoIf it were written for Linux first, it would even be available for Windows simultaneously.
- Circuitstorm513 4y agoIt would also be much more bloated (and not feel native) on Windows. Qt is what now? 30 or 50 MB? GTK probably much better these days. For that size you can almost go to Electron and get better look and feel (at the cost of RAM) ;-)
- themodelplumber 4y agoThis 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.
- whizzter 4y agoThis 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.
- chrismorgan 4y agoSQLite 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.
- 4y ago
- anditherobot 4y agoI love that it's just 12 files, straight to the point, no unnecessary boilerplates
- whizzter 4y agoYou 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...)
- RedShift1 4y agoA good IDE makes it very easy to navigate through files like that. You navigate to functions, structures, variables, etc... instead of files.
- whizzter 4y agoThat's nice until it breaks down, besides doesn't help much if you have 2400 lines long functions ( cbMainWindow ) that mixes Win32 API drudgery with indentation logic and SQLite fiddling. Sure it's an cute and to-the-point codebase, but even if I have experience with using these API's I'd never volunteer to work on this codebase because it's obviously also one that's a creation of the authors memorized experience.
- akisej 4y agoLooks very cool! We use logicloop.com to connect across databases, use ChatGPT to write, fix and explain SQL queries too
- gnoffa 4y agoPersonally I really love SQLiteStudio which I use pretty much daily: https://sqlitestudio.pl/ https://sqlitestudio.pl/
- rr808 4y agoWish there was a great free open source GUI which works for for Sybase or even jdbc.
- deleted 4y ago[deleted]
- xony 4y ago[dead]
- tenken 4y agoNo mention of https://sqlitestudio.pl/ https://sqlitestudio.pl/ in the comments which is cross platform ...
- jodrellblank 4y agoDon't miss the "Powerful" link goes to a six minute YouTube video[1] showing it to be packed with nice touches / demonstrating the features. [1] https://youtu.be/lctkqWD7HTk https://youtu.be/lctkqWD7HTk
- TheRealPomax 4y agoBut 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?
- anta40 4y agoPerhaps the author only use Windows? It doesn't use any cross-platform library like Qt, wxWidgets, etc. Just good old Windows API.
- rlv-dan 4y ago> What arcane library does it rely on Win32 > can't just cross-compile Suppose that you only use a specific operating system. Even if you could cross compile, how would you verify that it actually works? How would you know the specifics of each operating system and adapt you application to work well in such situation so that user don't flame you? It's just not that easy. And don't get me started on making GUI applications. Side note: As a Windows user, In this case I really appreciate the look and feel of the native GUI. It feels like a "real" Windows application. You would not get that if you cross compiled.
- spapas82 4y agowin32 apps should run flawlessly on linux using wine. Haven't tested this one but I'm using notepad++ and heidisql on linux since I'm used to these tools. I even run word 2000 on wine when I need to open doc files!
- oblio 4y agoGreat 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?
- TheRealPomax 4y agoI 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)
- qwtel 4y agoIf you can do with an even leighter-weight client, you can try my very own https://sqliteviewer.app https://sqliteviewer.app. It's all browser/wasm-based and works offline, but has some important shortcomings.
- dusted 4y agoThat looks absolutely beautiful (the classic windows ui style helps, of course)
- gorgoiler 4y agoIt’s funny but I only just had this thought: in the dark ages of text editing we would use ed to write commands that edited line by line, and then another command to show the changes. What a chore! Enter vi where you can see a window into large parts of the file while editing it at the same time. It was a quantum leap in productivity for sure especially because I could work form a terminal (as opposed to jumping to a different system more geared towards word processing etc.) But for SQLite databases I am somehow still fooled into thinking I am content, when in a terminal, to issue INSERT/UPDATE commands to make changes and SELECT commands to see those changes is adequate. If this is the equivalent of ed… > sqlite3 my.db UPDATE table … SELECT … …and if this post is linking to a GUI equivalent of Microsoft Word 6.0, then is there instead a vi equivalent for editing database tables, and what is it?
- betimsl 4y agoI believe I speak for everybody when I say that win2k was the best UI. So...is that demo gif running on win2k?
- mkup 4y agoNot necessarily Windows 2000. It might be Windows 7 or Windows XP with classic theme as well (or Windows Server 2003-2008, either R2 or non-R2).
- poo-yie 4y agoDumb 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?
- philkrylov 4y agoSome typedefs were promoted to 64-bit but it's the same Win32 API, even the name has not changed