skysight-inc/HackerNews huggingface dataset:
Some of these newer TLDs are really fun. There was a submission the other day for https://dogapi.dog and something about the words "dog api dot dog" had me smiling all day, thinking of different dot-dog domains. Oh god I realised I need to buy mylastname.dog and make an email address for Alfie, my Vizsla, brb :)

edit: woof! at ~80 EUR/year, the joke is maybe not worth it
These are all really great complaints; and yet I still prefer writing plain SQL to using ORMs and their nifty tricks. I think the main reason is that I don't ever want to have a lot of SQL logic in my code. Short queries (say, 10 lines or less) are okay, if they're one-off and pertain to the function's logic and are never repeated by other pieces of code. But writing complex queries through an ORM layer means they're going to be in code -- and harder-to-maintain -- than if they were where they should be: In views, functions and procedures. ORMs also obscure the execution plan and make optimization more difficult, which in production isn't something I really want to worry about.

Writing SQL is like uploading a program; just like a shader to a GPU. And if the network stopped being the bottleneck, the DB server's load would become the problem. Just like with a GPU, you want to upload your programs and data as infrequently as possible. But unlike a GPU, you have full flexibility to permanently store your logic right there in your SQL DB. If it's well-documented, it's much more streamlined to write views and views-on-views, than to keep all that DB logic in your code. I don't find that it becomes a mess at all, because properly crafted views and procedures strongly encourage forced indexing and checking execution plans when you refactor them; as opposed to in-code, ad-hoc queries where it's hard to know if someone ever ran tests to optimize them.

Some statements do need to be very large, for efficiency. Others are better being broken up into sub-procedures, temp tables or even roundtrips. A great query is a work of art where each part of it is optimized not just for execution plan but also for read/write, network state and expected load. What I like about SQL is the flexibility to decide which way to go, and prioritize based on how often something will be used and what kind of strain it'll place on each of the layers in the stack. As with anything powerful, there are a million ways it can be abused. But what I've found in the ORM space and also with noSQL solutions is that simplicity of use comes at the price of flexibility and control.

[edit]
>> null handling is complicated

This would probably also be my biggest complaint about the language itself; the existence of IS NULL / IS NOT NULL and both null-safe and -unsafe comparisons gets confusing (and especially painful if you're trying to write a parser). I think it's one of those things like `undefined` vs `null` vs `false` in Javascript where, on second thought, it's just too late to fix it without breaking half a billion websites.
It makes perfect sense if you consider the right abstraction. TCP connections are streams. There are no packets on that abstraction level. You’re not supposed to care about packets. You’re not supposed to know how large a packet even is.

The default is an efficient stream of bytes that has some trade-off to latency. If you care about latency, then you can set a flag.
Sorry for the somewhat late answer, but we recently released Hydra 2.0 which makes the Kratos/Hydra integration much easier. You can also get it out of the box on the managed service (+ a ton of other features).
You need a simple consent page for the integration and that is it basically.
Check it out sometime :-)
Mobs won't be able to stop open source models from existing all over the internet.

Not every AI tool will be a corporation who can get attacked by Internet warriors. And absent laws not every organization will feel the need to listen to them.
Ok again, but those people want to be there because they work in the city, if a significant cohort of workers leave the city why they do want to be there? Most would have no job there anymore.
I can recommend Lenovo Thinkpads as long as you're willing to live with the following restrictions: avoid any Nvidia hardware, and be willing to use a very recent kernel (Arch and friends, not Ubuntu and friends). Nvidia makes good hardware for 3D acceleration but their drivers are the absolute worst and their power consumption is unreasonable at idle. Cutting edge hardware from other manufacturers (i.e. Intel) may need a very new kernel, my laptop didn't have sound without messing with the config when I got it because Intel either forgot or failed to hit the deadline to get their drivers into the most recent stable kernel.

The build quality of the Thinkpad laptops is just generally very good, especially for the price, better than some of their more expensive competition in my opinion. I disagree with their Fn-key position, but luckily the UEFI allows you to switch it around to a more sane position (where the ctrl key is on their layout).

If you disagree and would like to try non-Lenovo laptops, any laptop that gets sold with Linux on it by default will save you a lot of working out config options. Just because the manufacturer threw Ubuntu on it doesn't mean that it'll work well (the same can be said of Windows, sadly) but the basic driver support is there. System76 laptops are the exception there, they generally work great with Linux but you pay for the privilege. I've personally also had a great experience running Linux on HP's ProBook line.

As for the macOS requirement, you can technically run macOS in a virtual machine or even make a Hackintosh if you pick the right device. Both are against Apple's TOS so I wouldn't use those in a professional context myself but they're an option if you need to build for iOS and friends.

Something to consider is to pay extra for the support contract. Dell, Lenovo, HP, and other big brands offer contracts where they will show up at your house, almost anywhere in the world, with either a replacement part or a temporary loaner laptop if something were to ever go wrong. Availability may be restricted to certain countries but the people I've spoken to were all incredibly pleased with the business support these companies offer, especially compared to Apple when the nearest Apple store is three hours away and you don't even know for sure if they'll be able to help you. Having someone come to you just adds a nice touch, I suppose.
As a German the game is Fußball (literally: football), but I just regularly say soccer in english because I cannot be bothered into finding out what the people I converse with think that football is and soccer is understood by everyone to be association football, i.e. the sport where the only hand that can be used is t̶h̶e̶ ̶h̶a̶n̶d̶ ̶o̶f̶ ̶m̶a̶r̶a̶d̶o̶n̶a̶ the hand of god.
Video series by engineerguy on Faraday's The Chemical History of a Candle
I think broadly you're right at the moment (the mood seems to have turned very negative for no reason other than moods do that). But vertical farming has always been hugely oversold. It's at best a niche tech for growing tropical crops in cold/temperate climates IF we decide to just stop shipping things around. It has no current economically viable or practical use.
Mine is happily dual-booting Win11 and running Steam when it isn't being a real NixOS computer.

Everything works, including nvidia proprietary driver and mode switching.

It's honestly the best linux laptop since I got my XPS 13
Wow way to kill the enjoyment of a nonsense verse
The "constrained environment" is the rub. In the old days, supporting a time sharing dev environment for 30 users (with 2K dedicated memory each), or getting to a functional self-hosted prompt before the floppy drive spun up to full speed, or fitting a dev environment in a single jumbo packet, etc. were not only cool, but were technically required.

We have megahertz and gigabytes and "embedded" systems with MMUs and filesystems at our disposal, so I'm guessing the time when forth was a solution has long since past.
If you want another one: Alzheimer. The amyloid plaque theory was utterly dominant for 30 years. But the research led to nothing, the medicines that were developed don't work. This article was linked here recently: https://www.quantamagazine.org/what-causes-alzheimers-scient...

I'm sure there are theories in history, political science or sociology which once met the criteria, but are wrong. One of the things that (IMO!) is extremely important for something to be accepted as a fact is whether we can explain it through a causal model. The assumptions of such a model should at least meet the same criteria, but probably even stricter ones. A simple hand-waving explanation, no matter how widely accepted, should ever be accepted as fact.
Hydroponic systems are dependent on industrial fertiliser. But you can lower the requirements by at least an order of magnitude by creating circular systems, incorporate food waste into the circularity, and more and create highly effective local and regional nutrient loops.

This doesn’t need to stop at the hydroponics system. There are plenty of opportunities to create better nutrient loops in our food production system.

We have been working on this for nearly five years. We currently participate in a project which has two dozen companies participating in closing this nutrient loops and create better and more efficient food production.
Yes, Asahi is working to get external monitors working. Currently external monitors work only at Mac Mini M1 where it's physically connected to DisplayPort type interface where already exists drivers. At M1/M2 laptops external displays are connected to Thunderbolt (that USB-C connector) so it requires developing more complex drivers.
You are approaching this discussion as a rational human being. Classic rookie mistake.
The subjectivity of truth is very hard to be trained to, and it is probably biased by the content it has read. But what if AI would come with unexpected answers to problems we humans represent? Guiding us for future improvements.

We do not have a good track record historically on many painful subjects.
> Wow. Good luck with that.

Thanks! We've had a lot of good luck so far. In fact, the child psychologist we went to proactively, to talk about how to help a 1 y.o. child handle moving to a new home in a different city, approved with the way we handled both this and other issues, and with our approach in general. But hey, N=1, it's always possible she is wrong.

> The entire psychology science and discipline was still not able to solve it. But your optimism is encouraging.

The issue isn't with psychology, the issue is with people treating an entire spectrum as one bit "is or isn't" boolean. It's good for writing outrage-inducing stories to maximize revenue. It's good for winning arguments despite being wrong. It's not good if you actually care about the outcome.

The kind of issues we're talking about here are mostly the psychological equivalent of a bruised knee. Meanwhile, the commentariat and the pundits selling books want to round everything up to emotional abuse, as if letting a child cry for 15 minutes was as bad as leaving them to live on the street. Unfortunately, some of the HN comments seem to go this way too.
> It's too bad Reason doesn't have an editor or something who can filter this sort of nonsense.

Editors of newspapers are supposed to know how AI models work?
That's quite a common thought (well, since Kant anyway), but self-defeating in this context. We want to know as much as we can. Sure, there will be errors and omissions, but why should that stop us?
This is a tension between application-sql and exploration-sql.

When building a data application, say a reporting tool, you want the code to be explicit. It is much easier to read if all columns are written out.

If you are ad-hoc exploring data, this is a pain.
I've always heard "reality has a left wing bias"
Source:

https://web.archive.org/web/20141028071303/http://www.bankof...
Tuxedo Infinity Book S/Pro
git-lfs authors agree and point out regular git also disables Nagle.

https://github.com/git-lfs/git-lfs/issues/5242
SatelliteXplorer
A theory should not attempt to explain all the facts, because some of the facts are wrong.

⇐ Francis Crick
Can TeXmacs be used as a generic Word clone with beautiful typesetting, or is it more suited for scientific papers and requires a lot of tweaking for plain documents?

I write a couple of documents a year, and I'd really like them to be typeset beautifully than using Google Docs or Libreoffice Writer, which feel quite unsophisticated and bland.

I typeset my resume in LaTeX and I wonder if I should port that to TeXmacs as well.
You're right that it's a "dev/dba problem", but the reason for not using `select !<column>` is exactly the same as not using `select *`. If you specify exactly what you want, there's less of a chance of your ORM-based app breaking because it received an extra or too few columns. I'm sure most people who work with SQL DBs have been bitten this before.

Also, while it could also be useful, over the years I've started moving away from things like using `!` to negate things. It makes it slightly harder to read and it ruins the symmetry of my code. And lord knows SQL doesn't need any more of that. It's probably the only language I use often where I have to place my commas at the start of the line; where I need to add a first filter as `1 = 1` etc just to make it easier to comment out things quickly.

What I personally want most is the ability to move the FROM clause to the top (this is a no-brainer) and better aliasing rules. The alias I used in my SELECT should be accessible everywhere in the statement.
I have been using ULID(github.com/oklog/ulid) for years. Cannot imagine going back to AI uint64 ever again.
We obviously don't use HTTP for serving our API. The HTTP end-point is just a 301, but it still contains the Date field:

$ curl -I http://api.screenlyapp.com

HTTP/1.1 301 Moved Permanently

Date: Fri, 30 Dec 2022 09:01:44 GMT
[...]
For those who don't think "Tram" is a real word: "die Straßenbahn"
It also shows how social capital as a whole plays a role, above and beyond the connections.

You did the wife a favour and the husband did you a favour by putting forward your CV for interview.

I've met a bunch of billionaires in my life through work, but doing so hasn't changed my life one iota. On the other hand, giving up my (unused) dessert spoon on my first date to my (now) partner on our first date after she dropped hers has stuck in her mind and she claims it was one of the small things that contributed in to me getting a second date.
From the link:

> While the double cookie approach is what is recommended by Google, the ASP.NET team concluded otherwise - they found that going with a user-agent sniffing approach would be the safer approach. User-agent sniffing is hard to get right. It's hard to cover all the relevant browsers, and it's hard to do so in a way where you can be reasonably sure it won't break in user-agents of the future. But when someone gets it right, that becomes a readily copiable solution that anyone can use.
Does Discrete Graphics work in Linux somehow? Does it require some drivers? At ZBook I needed to change to UMA Graphics because it uses much less CPU and works better.
https://wiki.archlinux.org/title/Apple_Keyboard#hid_apple_mo...

The hid_apple module supports swapping the alt/cmd and the fn/cntrl keys to match standard keyboard layouts. It's quite helpful if you use multiple devices and keyboards.
I use https://ia.net/writer. It does the job and supports templates for quick export to HTML or PDF.
Unreal C++ and C++/CLI have one.

When one wants the flexibility of C++ with the productivity of a GC.
> must be that vaunted German engineering

Can't be too much German engineering in a Taiwanese (Clevo) machine
No, we parse it and set it over DBUS. If you want to do something more turnkey, take a look at htpdate (https://linux.die.net/man/8/htpdate).
Not only forms, nowadays it gets plenty of use via Roslyn code generators.
Does it run Linux? What distros are available? How much RAM and what CPU ? URLs ?
> I wonder if it's possilbe to build a circular structure of processes that keep respawning each other.

Almost certainly; they'd just have to be children of a process outside the circle.
https://upload.wikimedia.org/wikipedia/en/b/ba/DrawingHands....
In BigQuery you can write:

SELECT * EXCEPT (username) FROM users

https://cloud.google.com/bigquery/docs/reference/standard-sq...
> I propose someone collect a list of facts

Didn't Cyc have a whole bunch of those?
> It was bricked 1 month out of warranty due to the GPU, which was recalled by Nvidia but Lenovo refused to honor the recall.

Did they actually issue a recall on those chips? Someone should update the wiki
which still says:
...neither nVidia nor Lenovo ever admitted publicly that the chips were defective. The issue was handled as one of quality control with no "official" revisions issued, and no recalls. (https://thinkpads.com/t61/)
But there's no IPFS link there.
Can anyone think of the reason Apple wouldn't provide hardware support to curl and similar projects?

To my mind "this dev tool doesn't work, only on Apple, only on Apple's flagship chips" is the opposite of what they'd like to see happen.
formulae :(
From an outside, global, point of view, the laptop you already have.
> Editors of newspapers are supposed to know how AI models work?

Editors of newsmagazines are supposed to know how journalism works, and to probe journalists to assure that they’ve done the research to properly understand and represent the subjects of their stories. So, yes, when publishing a story about AI models, the editor should know enough about how AI models work to understand that the story is a proper representation, not in advance of seeing the story, but as a result of the dialogue with the reporter on the research that the reporter has done before the editor signs off on the story.
There's no good reason beyond, "Apple doesn't do that, and never has."
> Only specific aspects of modern life are energetically wasteful, depending on what era you compare to.

> Many modern conveniences reduce resources use, because they replace real things with ones and zeros, and for better or worse many industries are getting forgotten.

I agree, I didn't mean to relate it to all aspects of modern life, just the energetically wasteful ones.
I'm very happy with my Lenovo L14 Gen1 AMD.

It's not a compute beast (although Gen2 versions are obviously faster) but it is repairable and has neither soldered RAM nor SSD.
On spectrum optimization: how much of the Sun's emissions spectrum is actually used by plants for photosynthesis? Are there efficiency gains to be realized by converting non-"bioavailable" solar radiation first into electric power, and then into LED output plants can use for photosynthesis? Quick Googling suggests "maybe, probably not", but it's been years since I took an EM physics course.

I realize PV panels are less than 100% efficient at solar to electric energy conversion. Wikipedia suggests 30% is a realistic figure for large-scale solar installations. Batteries also add losses, so let's assume LEDs only run while the sun shines. LEDs themselves add losses too, so our inefficiencies seem to be piling up... All the same, I'd love to see someone run the experiment of (yield per care of traditional farming) / (yield per acre of solar panels + vertical hydroponics).
That there is not one K, but many, and we don't even know their exact values.
7 hours later, the M1 is pretty high up in the poll.

System 76 Oryx Pro; 29 points

Framework; 111 points

Dell XPS 13 Developer Edition; 44 points

2019 Intel MacBook Pro; 4 points

M1 MacBook Pro; 54 points

ThinkPad X1 Carbon Gen 10; 119 points

Star Labs Starfighter; 7 points

HP Dev One; 7 points

Lenovo T14 Lenovo T480/490; 27 points

If anyone has theories about why the M1 is polling so well, I’d be curious to hear. It seems unlikely that the M1 is a popular choice for Linux, yet that’s what the polls seem to indicate.
"projects that have to send the same queries to different databases are very rare." That's true in business certainly but once you head into academia or are working with medical data / the public sector you often find yourself having to write queries against databases from different vendors to construct datasets, which gets annoying fast. I used to work as an RA in an economic modelling group and hit this issue a few times, so I can see the use of something like this in that niche.
You don't really need soil for calories-rich plants, but you need a lot of energy (sunlight). Which you obviouly can't have in a large vertical farm, unless you use a lot of electrical power.
I'm surprised the performance stats weren't more dramatic. Is the compilation not taking advantage of multiple cores? Or for this task is the m1 really do comparable to an Intel 3rd gen cpu?
How is magnetic north defined? In relation to negative electric charge, or just by reference to a standard compass? (I.e. "whatever is attracted to this side of my magnet is magnetic north" )
At this moment openAI wants good press. But if they make it into a subscription service, all this nonsense has to be removed.
Ha, I was joking - I was just playing the game of 'claim the original suggestion isn't what a true supporter would do, and heighten the previous suggestion' by suggesting a semi-illegal 'stalk and dump unmarked cash' technique.

i.e. If you were a true supporter, the right thing to do would be to form a legal trust and make the beneficiary of the trust the artist's children, and put your money into that, as this would help them legally avoid income taxes on the money you are giving them while using the money for their children's education.

Or a TRUE SUPPORTER wouldn't use band camp, instead they would evaluate the quality of roads and infrastructure around the artists house and pay for a series of contractors to improve the surrounding roads and areas, which will not only improve the artists quality of living but will also improve the value of their house. etc. etc.

In reality there is no 'right thing to do' - just choose whatever channel the artist has put up that supports them at the level that you want them to, and where you get value out.
I wrestled with a graph traversal problem and Postgres docs for a hot minute before realizing that the "recursive" working set can only access the results of the previous iteration. With that in mind, I took a crack at your problem with the following approach:

1. Build the JSON from the bottom up starting at the deepest path.

2. At each step, handle two cases: a) build the parent of the working set, and b) collect any sibling paths at the same depth.

3. The last step aggregates all children together since all paths descend from '/'.

Solution: https://www.db-fiddle.com/f/qTcG5BUjM8GzuzBfHamnVJ/4

There was a fair bit of trickiness. I used a CTE in the recursive step to reference the recursive table multiple times and to enable aggregation in the recursive step. I used a few helper functions for my own sanity.
A set is even if you can pair each element up with another element.

A set is odd if you can pair each element with another element and have one element left over unpaired.

Then infinity is even and odd.
Hmm, I'm going by memory but I distinctly remember reading they were recalled and that Dell among others were issuing replacements for their systems with the faulty chips. Perhaps it's true that it wasn't officially recalled.

Also your link mentions Lenovo did briefly offer repairs in 2010-2011, so I guess I could have taken part, but that was about 2 years after I ejected the company from my world.
Nextcloud, synced with Etar on my android phone
Running debian on a Lenovo P14s flawlessly