Lightweight SQLite Editor for Windows • Hacker News Board

Re: Lightweight SQLite Editor for Windows

#11

Post by jdthedisciple » Tue, Apr 18, 2023, 7:47 PM UTC

account-5 wrote: post #2

Oh this looks good. I've been using: https://sqlitebrowser.org/ This seems to offer way more.

Been using the same, and I've been very content with it too.

Curious about this one.

Re: Lightweight SQLite Editor for Windows

#12

Post by TehShrike » Tue, Apr 18, 2023, 7:51 PM UTC

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.

Re: Lightweight SQLite Editor for Windows

#13

Post by justsomehnguy » Tue, Apr 18, 2023, 7:52 PM UTC

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.

Re: Lightweight SQLite Editor for Windows

#14

Post by adamrezich » Tue, Apr 18, 2023, 7:54 PM UTC

solarkraft wrote: post #4

Windows-only seems to me like the most rapidly shrinking market.

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.

Re: Lightweight SQLite Editor for Windows

#15

Post by Brian_K_White » Tue, Apr 18, 2023, 7:56 PM UTC

2h wrote: post #6

solarkraft wrote: post #4

Windows-only seems to me like the most rapidly shrinking market.

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.

It was neither selfish nor a demand. It was an observation.

Re: Lightweight SQLite Editor for Windows

#16

Post by pkage » Tue, Apr 18, 2023, 7:57 PM UTC

I strongly recommend TablePlus for sqlite/postgres/other databases, it's made my life significantly easier.

https://tableplus.com/

Re: Lightweight SQLite Editor for Windows

#17

Post by petepete » Tue, Apr 18, 2023, 7:59 PM UTC

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

Re: Lightweight SQLite Editor for Windows

#18

Post by MPlus88 » Tue, Apr 18, 2023, 8:01 PM UTC

jdthedisciple wrote: post #11

account-5 wrote: post #2

Oh this looks good. I've been using: https://sqlitebrowser.org/ This seems to offer way more.

Been using the same, and I've been very content with it too. Curious about this one.

[dead]

Re: Lightweight SQLite Editor for Windows

#19

Post by hochmartinez » Tue, Apr 18, 2023, 8:03 PM UTC

Linux version, please!

Re: Lightweight SQLite Editor for Windows

#20

Post by chrismeller » Tue, Apr 18, 2023, 8:04 PM UTC

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…

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.