Hacker News new | past | comments | ask | show | jobs | submit | tanelpoder's comments login

Context: With eBPF, you can have "wait events" even for database engines that do not have such instrumentation built in.

Showing examples of the "extended thread activity sampling" approach on DuckDB, MySQL, Postgres and Oracle.


My favorite (and also surprising) old Unix document is an USENIX paper from 1984, describing the /proc filesystem:

https://news.ycombinator.com/item?id=26298564


Unsinkable ship, with design flaws…


And “packet” loss!


Are there any good 3rd-party native frontend apps for Claude (on MacOS)? I mean something like ChatGPTs app, not an editor. I guess one option would be to just run Claude iPad app on MacOS.


Jan [0] is MacOS native, open source, similar feel to the ChatGPT frontend, very polished, and offers Anthropic integration (all Claude models).

It also features one-click installation, OpenAI integration, a hub for downloading and running local models, a spec-compatible API server, global "quick answer" shortcut, and more. Really can't recommend it enough!

[0] https://github.com/janhq/jan


You can use https://recurse.chat/ if you have an Apple silicon Mac.


Msty [0] is a really good app - you can use both local or online models and has web search, attachments, RAG, split chats, etc., built-in.

[0] https://msty.app


If you're willing to settle for a client-side only web frontend (i.e. talks directly with APIs of the models you use), TypingMind would work. It's paid, but it's good (see [0]), and I guess you could always go for the self-hosted version and wrap it in an Electron app - it's what most "native" apps are these days anyway (and LLM frontends in particular).

--

[0] - https://news.ycombinator.com/item?id=41988306


I like msty.app. Parallel prompting across multiple commercial and local models plus branching dialogs. Doesn’t do artifacts, etc, though.


It's not native, but I've been pretty happy with big-AGI. It's just an `npm run` away. I don't use it for coding tasks, though.

Its most unique feature is its "beam" facility, which allows you to send a query to multiple APIs simultaneously (if you want to cross-check) and even combine the answer.


Open-WebUI doesn't support Claude natively (only through a series of hacks) but it is absolutely "THE" go-to for a ChatGPT Pro like experience (it is slightly better).

https://github.com/open-webui/open-webui


An example of this tool in action (on Linux kernel source code) is here: https://sbexr.rabexc.org/


I once wrote a top-like tool in Oracle's sqlplus client, that is not designed for building self-refreshing terminal UI display apps. Just to see if I could do it, had to get creative too. Used pipelined PL/SQL functions with never-ending output stream and a sleep function within it and had to carefully match the sqlplus "fetch array size" with number of rows returned in a batch from the pipelined function. Called it MOATS - the Mother of All Tuning Scripts - and then someone took the idea further and built v2.0 with added colors and charts, etc:

The v2.0 UI GIF is here: https://github.com/dbsid/moats_rac


Haha, off-by-one pixel error!

I still see MacOS as the best choice for my desktop/laptop uses (browser and SSH), but I also have a documents folder that I’ve accumulated over decades. I still use various .txt files in the docs folder as my low tech note taking apps.

I use the Spotlight or Alfred keyboard shortcuts (that also use spotlight index?) for quickly opening the files when needed - and annoyingly my most important file - notes.txt - regularly disappears from the Spotlight index and suggestions. It’s been like that for at least 5 years, probably closer to 10. I’m not even trying anymore, will just open the file from command line with vi as the fallback step.


> I still see MacOS as the best choice for my desktop/laptop uses (browser and SSH)

If it' just "this", Linux is perfectly capable and IMO even superior.


I use linux on the desktop, but I still run a MacBook for my laptop.

Nobody else offers the same combination of battery life to performance/weight, build quality, keyboard, trackpad, and screen. Of course it's not perfect for everbody and you might have different priorities but I think the MacBook gets most of them right for most people.

Some come close on a few of those points but if you want official linux support your choice is very limited. Perhaps that doesn't matter to you but I don't want to even think about if updating my daily driver is going to result in a broken webcam or flaky wifi or bad power management.

I'm holding out hope for the new snapdragon based laptops. They seem pretty close!


>> Nobody else offers the same combination of battery life to performance/weight, build quality, keyboard, trackpad, and screen.

Exactly this. And also a decent sound. I would definitely want to have a linux laptop again as OSX s*cks in many ways but Macbooks with M chips are still far superior so I keep monitoring the situation and waiting...

It is not a problem to find a laptop with high specs but then battery su*ks, it's made of creaking plastic, has a plastic clickpad hard to click, bad key travel and response or audio sounds like a 5y old cheap smartphone. This is something I am not willing to spend money on and torture myself at the same time.


Even when expanding scope to include laptops that run Linux well despite not officially supporting it, the selection available still have major issues, whether they be with build quality, screen panel quality, battery life, standby time, sleep/wake, overall lack of fit and finish (e.g. unthoughtfully placed ports) or some combination thereof.

It seems like a near impossibility for other manufacturers to not phone some of those things in. There’s always a catch.


The x1 carbons running Linux are better than the Mac in every aspect except performance for the battery life, but personally I don't want to use my laptop for that long at once anyway, so w/e.


Yep I should have written "mostly browser/SSH". But then occasionally I have to print something or run a (customer-provided) VPN client or open some corporate Excel file, etc. And there's the convenience factor of keeping my current setup. But should the MacOS thing become untenable for some reason, yep next step would be a Lenovo/System76 laptop known to work with Linux (including audio/bluetooth/wifi after resuming from sleep!) or even a Chromebook...

P.S. I've ran Linux/X (plus VMWare VMs with Windows) on my desktop machine with few complaints since the '90s and it was always the laptops that had issues, causing me to switch back to Windows after a couple of weeks of trial & frustration in the 2000s. I got Windows pretty performant & usable though, even attended Mark Russinovich'es Windows Internals class in London back in 2006 or so :-)


Laptop issues have dropped markedly in the last 3~4 years; especially battery life on AMDs in the last 6~12 months, the kernel perf / scheduling changes have been pretty good.


Just a cheap Chromebook would probably be even better IME - nothing to worry about, it is really very much just a keyboard and screen and gets out of the way.

Less can be said about your typical Linux experience in in the 2020s where you will still inexplicably find yourself having to mess around trying to get Bluetooth/audio/webcam/sleep working reliabily.


Does anyone remember NDISwrapper? You took Windows drivers for your laptop WiFi device or whatnot and the wrapper allowed to load them into Linux kernel (still didn’t work for me reliably though, not surprised). Even when I was young and had lots of free time, it seemed insane to have to deal with this.


Which Linux laptop do you recommend?


If you're looking for an occasional laptop, I bought a Lenovo V14 ADA for the few times I travel; got it brand new for less than $275. 1080p screen, 8GB RAM, 4 threads, good Mesa support. Perfect for travel / now and again usage. It can even play some games on low graphics.

EDIT: I should note, this is the AMD variant of the V14


I just checked Lenovo's more recent offerings in the US; the IdeaPad 1 15" AMD Abyss Blue.

Not sure if the build quality is as good as the EU SMB market laptops (which are generally really good value with good build quality, for me a perfect compromise between price and build quality, steel internal framework with solid plastic case, not sexy but definitely robust).

This IdeaPad1 looks like it has the same specs as the EU model (V14 G4 AMN). Just check if the build is solid enough. The IdeaPad1 can be bought at Best Buy.


Try a Lenovo (thinkpad or ideapad), or a System76, or Tuxedo. Those are generally the most Linux friendly devices.


It should be noted that the build quality of the ThinkPad are much higher than the IdeaPad. I have both and the IdeaPad is more or less on par with other cheap consumer laptops.


>It should be noted that the build quality of the ThinkPad are much higher than the IdeaPad.

And still, they've fallen so low in recent years I don't see it being drastically better nowadays. Had a T495 for a while. Worst laptop I've had in a decade.


For sure, but they are also much cheaper


Thinkpad P14s series with AMD, they make sure it is fully supported on Linux. I would take the just arrived gen 5 AMD because of the new Zen5 cores. Same perf than with Zen4, but much lower power consumption.


I have a P14s Gen4 AMD that works like a dream with Linux


I have an oldish Lenovo Thinkpad T470 which is bulker but it's very good nonetheless and a Dell XPS (4 years old, and the battery sadly is the weak point since I used it 95% of the time connected to an outlet and never cared for battery health)


Huawei mate book 14 (2024) the grey one (800 bucks) or the green (1200). The mate book pro is superb too but to expensive.

You'll love the OLED screen and it's ratio 3:2! What a beautiful thing.


For the described usage pretty much any laptop would work, even a Chromebook.


Dell XPS are quite nice on the high end developer category of laptops


Funnily enough a simple fgrep is super fast on SSDs and actually reliable. Even across TBs of data.

With Spotlight you can never be sure. And to be fair, the Windows equivalent sucks just as much.


Yeah I sometimes use ripgrep for this. It’s suspiciously fast!


> I still see MacOS as the best choice for my desktop/laptop uses (browser and SSH), [...]

Almost anything will do for those?


Recently windows has become much better for things a linux or macOS user takes for granted, like using ssh (a quick google search tells you how to install it using powershell), but is missing a lot of features. Two recent examples for me are taking 5 minutes to figure out how to install and use rsync, and taking 10 minutes finding a program to add/delete pages from a pdf file that's not a trial or demo of some kind.


SSH clients have been easy on Windows for at least 20 years: just use Putty. And there's also at least on Chrome extension that works as an SSH client. But you are right, that Windows doesn't come (or didn't come?) with one out-of-the-box.

In any case, I can see that those addition things like rsync or PDF manipulation might differ between the different operating systems. I was really just talking about browser plus ssh (client).


That’s pretty quick?


I did mention it’s become a lot better. These are just minor annoyances.


Both of those features have been built in to macOS for 2 decades, so in comparison, it’s quite slow.


Speaking of bad vision for a moment I thought I read “I still see MsDOS as the best choice” and almost yelled out what patrician taste!


Well, you can run multitasking in TSRs & keyboard interrupt handlers (the original event loop)… implementing a window manager and TCP stack is left as an exercise to the reader…


> implementing a window manager and TCP stack is left as an exercise to the reader…

I'm pretty sure both of those have implementations available for DOS already.


I recalled something from distant past - MSDOS multitasking with DESQView (apparently the same vendor who built QEMM):

https://en.m.wikipedia.org/wiki/DESQview


Yep, the "STONITH" technique [1]. But programmatically resetting one node over a network/RPC call might not work, if internode-network comms are down for that node, but it can still access shared storage via other networks... The Oracle's HA fencing doc mentions other methods too, like IPMI LAN fencing and SCSI persistent reservations [2].

[1] https://en.wikipedia.org/wiki/STONITH

[2] https://docs.oracle.com/en/operating-systems/oracle-linux/8/...


They had access to the ILOM and had some much more durable way to STONITH. Of course every link can "technically" fail but it brought it to some unreasonable amount of 9s that it felt unwarranted to consider.


Yep and ILOM access probably happens over the management network and can hardware-reset the machine, so the dataplane internode network issues and any OS level brownouts won't get in the way.


This reminds me of the Linux/Unix disk busy "%util" metric in tools like sar and iostat. People sometimes interpret the 100%util as a physical ceiling for the disk IO capacity, just like with CPUs ("we need more disks to get disk I/O utilization down!").

It is a correct metric when your block device has a single physical spinning disk that can only accept one request at a time (dispatch queue depth=1). But the moment you deal with SSDs (capable of highly concurrent NAND IO), SAN storage block devices striped over many physical disks or even a single spinning disk that can internally queue and reorder IOs for more efficient seeking, just hitting 100%util at the host block device level doesn't mean that you've hit some IOPS ceiling.

So, looks like the GPU "SM efficiency" analysis is somewhat like logging in to the storage array itself and checking how busy each physical disk (or at least each disk controller) inside that storage array is.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: