skysight-inc/HackerNews huggingface dataset:
> 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.

I have to provide caution here, when you create views and stored procedures, I've always found it a mess to maintain:

1) VCS for stored procedures and views is usually non existent. Good luck understanding how these change over time and who changed them.

2) Deploying application logic alongside these systems is very painful, because unless you've versioned your views/stored procedures, when you make a breaking change you need to stop the entire application, make the change in the DB, and restart the entire application again on the new version. Zero-downtime deploys would require versioned views/stored procedures.

3) It quickly becomes a challenge to answer the question "what happens when I do X?" reliably, where X is insert, delete, or even select a row. Once you have complex enough stored procedures, modifying the data changes things in unexpected or unintended ways. A dev unaware of how the system works might assume that inserting a row simply inserts a row, but instead due to stored procedures hidden from application logic, it might cascade into inserting rows elsewhere, deleting rows, or modifying other rows in other tables. Discovering these issues without knowing that they could exist is often done around midnight during a production outage, because a new feature was released that did something in the DB that was presumed safe, but wasn't. If the code for the business logic were in one place, the application, it would been much easier to see what the change would actually do.

I understand entirely that performance gains from good DB use are astronomical, but in my humble experience, I've found them to be more trouble in the long run than they are worth.

e: spelling
Problem here is that morals are not absolute. The moral framework we use in the west isn‘t the same that is used, for instance, in China. It isn‘t even exactly the same between states in the US or countries within the EU. Or political groups within any of that.

So, which one are you supposed to be using? Or is the only approach left to use the lowest common denominator? This probably would burn down to „you shall not kill other humans“ and not even that is certain.
My main driver is a HP Elitebook 845 G9 (so the 14" version) running Arch. I have been using it for the past six months to do mostly backend development in Python.

Pros:

- Performance is really good, I haven't run benchmarks but day to day I see no difference with my beefy Zen 3 desktop. It completely replaced my desktop computer, except for games.

- Almost everything works out of the box on Linux. I think the fingerprint reader does not work, but I wasn't going to use it anyway.

- Issues tend to be fixed via either kernel updates or BIOS updates. I used to have to reboot it daily at the beginning for one reason or another (did not wake from sleep, wifi card stopped working...), now I rarely get any problem.

- Easy to open and every component is user serviceable. They have official disassembly guides on Youtube and sell spare parts.

- Suspend works reliably (which is not a given these days, even on Windows).

- Key travel is short but the tactile feedback is strong enough that I don't feel like I'm missing too much on this front.

- The 16:10 aspect ratio of the display is a game changer. My SO has the G8 with a 16:9 ratio and the difference is night and day.

- Enough connectors to not have to carry dongles.

Cons:

- The GPU still crashes from time to time, roughly once a week. This requires a reboot.

- The only version available in my region has a 38Wh battery which gives only ~6 hours of life. I will be swapping the battery for a bigger one at some point.

- The non-LPDDR5 means that the battery life when sleeping is not amazing, it tends to lose ~10% overnight.

- Power consumption is good but not on par with the best laptops at ~5W idle.

- I chose the matte low-power display, color is good, viewing angles are good but the ghosting is atrocious. It's the first time I get a device where ghosting is distracting.

- The NVME drive the laptop shipped with died on me after a few hours of use. I swapped it with another drive I had available, no problem since.

- Firmware updates are only officially available for Windows but the Windows binary can be used on Linux with a bit of command-line-fu.

- The trackpad is large and good but the push to click only works on the bottom half as opposed to a typical Macbook where the whole surface can be pressed down.

- USB-C ports for charging only on the left side.

- Arrow keys are half-height, I hit page up/page down all the time while trying to press arrow keys. Super annoying when using the command line.
This is a long-form mix of projection and complete denial of reality. We all have to make our own way, I'm glad you found yours.
Do you know of an example where speed limits being a non-enforceable recommendation has actually proven anywhere near as effective in reducing road fatalities as legally enforced limits?
And how far do you want to push this argument- that if I choose to drive an unroadworthy unregistered vehicle at 200kph on the wrong side of the road while highly intoxicated, I shouldn't be fined unless I provably cause injury/death/property damage to others?
The Five Stages of CTO
The logistics I imagine of doing so for projects would be immense. For ten projects, maybe it wouldn’t be bad, but which ten? Etc.
Wasn’t there some recent research that showed that hiring randomly actually works better on average?

Edit: Wait, that was promoting.
I have it and it's definitely a powerful and solid laptop with a great screen.

But out-of-the-box linux support was not great at all. I am usually a debian user, but since it shipped with Ubuntu I thought I'd give it a try (there were other distro choices when ordering the laptop, but Ubuntu was the only debian-based one).

The laptop came a couple of months ago with Ubuntu 20.04. I upgraded to Ubuntu 22.04, which was tricky enough as the system updater would tell me that I had incompatible packages installed (I had not added anything); it took a long while but I finally managed to unblock it.

After the upgrade, the laptop started getting completely unusable after suspend - a deadlock in the ath11k kernel module. Upgrading to 22.10 did not help, so for two months I just disabled suspend altogether, turning the computer off any time I had to close it. Fortunately last week a new kernel came in the proposed-updates channel which backports the fix for the deadlock, so now that works.

I still have some occasional kernel deadlock, and I have yet to figure out why, but it is kind of bearable right now.

The speaker volume is really, really low, though I am not sure if this is a problem with the linux drivers, or it is just a hardware limitation.

I am completely confident that all the remaining annoyances will get solved in a couple of months; probably they would be already if I had wiped the laptop clean as it arrived and installed debian unstable as I usually do. I am satisfied with my purchase as it ticks all the boxes I had (particularly the combination of size, screen, cpu and memory was not matched by almost anything else). But to be a premium (in quality and price) laptop that ships with an "officially supported" linux distribution, it sure had way more issues than I expected.
It shows its bias obviously . Altough sometimes people trick it to forget itself. It really seems like the censorship layers are unreliable, which is a good thing imho.

https://i.imgur.com/si7QBgl.png
TSMC 3-Nanometer Chips: Company Mass-Produces Next-Gen Semiconductors
Is bacteriophage φX174 DNA a message from an extraterrestrial intelligence?
Indeed it would be a fools errand to try to make it neutral. You probably end up with a tiny list of sources and severely limit the AIs ability.

You can just look at the internal debates happening in Wikipedias list of reliable news sources for how politics quickly seeds into questions of neutral authority and excessive bias.

At least Wikipedia does it in public and ostensibly by the public. I'm skeptical about trusting an opaque organization, who just happens to run the website of the most popular model, to make those choices for us.
Probably the histrorians were looking at the wrong place and perhaps the original Mount Sinai is not the one that's widely accepted. Any knowledge be it science, history, etc need to be revised and aligned to the newly discovery with more robust evidences.

Please check this documentary on the new evidences regarding the Exodus [1].

[1]The Real Mount Sinai - Shocking Exodus Evidence in Saudi Arabia:

https://youtu.be/LZDfGiXJjjI
“ChatGPT” seems to be a system with several models playing roles, and one of the roles played by a particular model or models is “moderator”. (Unsurprising, as among the existing for-sale services OpenAI has is a moderator model.)
Sigh.

Silverlight had positive sounding blog posts, etc... right up until its official death.

These megacorps never officially announce a product's demise, not while they can sell it. You have to read between the lines.
I see very disparate use cases for these laptops, so the competition is not really that fair.

- Fastest CPU + GPU + battery life, x64 not needed, money no object: M1 MBP.

- Reliable, serviceable, upgradeable, fashion-despising: T14 / T480 / T490.

- Serviceable, upgradable, but sort of new kids on the block, and less fashion-oblivious: Star Labs Starfighter, Framework, System 76 Oryx Pro.

- Sleek-looking at the expense of everything soldered and glued down: Thinkpad X1, MBP 2019.

- Open-source loving, more things under user's control: System 76 Oryx Pro, Star Labs Starfighter, partly Framework.

Star Labs Starfighter looks incredible BTW, thanks to bringing it to my attention. I sorely miss a trackpoint though.

No idea about others. I'd like to like HP Dev One, but I don't trust HP to make reliable things any more :(

I wonder why no model from the Dell Latitude line made it here; I thought some of them have good Linux support.
What a way to smear all those striving for equality
Only if search engines agreed not to (read never) provide any web results from an identity who was using whatever means to be an anonyphobe (even at a low threshold like 1% of the time) at a website or social media service.
For 20 years they’ve gotten it for free. Why start paying now? Apple is not a friend to the little guy, quite the opposite.

Remember, Steve Jobs was good friends with Larry Ellison who famously said that open source is there to be exploited. These guys all think the same way.
> How does a language benefit from not having the option to compile it? What restrictions does the requirement to be able to produce a machine-code executable place on it?

“Compiled” is being used as a short-hand for “compiled with optimisations”, so yes, an unoptimised build wouldn’t count here.

The design decision is around when (between the code being written and being run) is the final decision made about what exact code will run. If that is known really early (static types, no dynamic dispatch) then optimisations can be made early too. If it is really late (polymorphic methods, support for redefining types etc) then optimisation needs to run very quickly (“just in time”) or not at all.

If you want to go deeper on this, look at performance optimisation in Julia. It has the same LLVM backend as C/Rust, so can use all the same optimisations, but it is arguably a more dynamic and easier to use language than Python, so when and how optimisations apply really depends on how the code itself is written. As a bonus, it has some great tooling to see how changes to the code impact performance.
Andrew Tate: influencer detained in Romania on organised crime and rape charges
Look at XPS15. I think the 13 makes too many compromises to make it tiny. 15 is pretty small itself. It works with Linux flawlessly, but I'm still jealous of M1.
Yes, still I mostly use Ubuntu 22.10 amd64 where compiling all software works.

I still have not ported some of those to macOS M1 and Asahi Linux arm64. And I still have not leaned Mac keyboard layout, I have trouble finding keys how to type, and trouble to find settings how to fix layout.
I only recently replaced my T420 with T460s as my daily driver. M girlfriend got a T570 or 80.

There have been zero issues with Linux compatibility, just install and good to go.

I only recommend and would buy thinkpads. Also because as you said you get them very affordable after they spend 2 years in a office.
Apple could just donate a coupon or something like that.
Geting Started with BioNumPy
> What is merge? How is it different from join? How is it different from union?

I believe the author is referencing https://www.essentialsql.com/difference-merge-update/ - which you answered in your first point. There's no UPDATE support yet, therefore there's no MERGE support yet.
Well an LSP server would be a welcome addition.

But before that i would put some effort into the actual "repl/session" -like tool. Pipe a PRQL query to a PRQL session, and then the PRQL translates that to SQL, and returns the underlying response from the database.

If done right, this would open the possibility to build all sorts of cool editor plugins, that could directly interface with the PRQL session.

IMHO this is where a tool like PRQL would shine, as it would make writing SQL more enjoyable and way faster, but at the same time being both language and sql-dialect agnostic.
Wasn’t it offered for free?! Or was something asking in exchange?

There are plenty of licenses which are free only for non-commercial use. The author choose the “free for all” license for a reason though.
I'd really like to understand this process. Is there a real world example of government employee adjusts a particular figure on a particular bit of software. That then somehow sends money to a particular bank?
This article uses “normalize” to mean “splitting into multiple tables”. But splitting into multiple tables is only normalization in the cases were it reduces data redundancy. If the resulting two tables are 1:1 and you dont save any data, that is not normalization, that is just busywork.
Heh I actually went the opposite way as it made my database schemas more difficult. If it's a one-on-one with just one piece of data, make it an extra column instead (sometimes I've also done this for many-to-ones if there is only some small but neglegible data duplication going on). One reason I do use one-on-ones is when the column is heavy on updates, because on update PostgreSQL rewrites the entire row.
> we better make damned sure any supernaturally intelligent AI (if we ever figure out how to make one!) is also supernaturally moral.

We probably will, in the sense that the superintelligent AI will be an even greater, more inflexible, fanatic for the moral views that its creators like to be seen as adhering to than even those creators themselves.

This will probably turn out to be a very bad thing, though.
There are always two sides to this: joins are expensive, or joins are cheap.

In reality both are true. If you’re doing complex business logic on low cardinality tables, joins win every time. If you’re doing simple retrievals on high cardinality tables, they’re not.

The trick for scaling is figuring out which your use case is and converting between the two as necessary. Maybe one database for editing and one for publishing/serving.

There are rare cases that are high data complexity and high cardinality. Normally these can actually be pushed into one of the other formats, but when they can’t, sharding can often be a good option.
Zero issues with that on my T420. (Using modern gnome, afaik i5 16gb ram and no extra graphics). I can even attach it to the TV and watch in full HD (so more than the screen even has) without any compromise.
I'm not sure why you would put data you don't intend to be queried in the same database. As for DoS, I know postgres can impose limits (from having used the crt.sh database, which is available publicly), though I am not sure why you think so many JOINs would be required.
One use case: reliably reproducing bugs in Windows desktop software (confirming something is an issue for a standard config).

Another as you mentioned: repeatedly testing a Windows desktop software installation process as it is being developed.

It primarily offers an undetectable incognito mode browser session (Microsoft Teams login requires 3rd party cookies, etc.).

Really wish winget worked inside Windows Sandbox!
At least until a more open Stable Diffusion 1.0-esque competitor comes along without the aggressive prompt moderation... and maybe less bias/overt controls put on content sources fed into the model, assuming that's a thing that's already being done.
> how can the OS know if I'm after throughput or latency

Because you tell it by enabling / disabling buffering (Nagle).

And most apps do prefer throughput. Those that don't really know that they prefer latency.

> since OS doesn't know about what this particular app needs with respect to throughput vs latency tradeoffs.

I think you're mixing up determining what you want (app choice) with how to achieve that best (OS information). I was responding to the parent talking about flushing and buffer sizes specifically.
Select * is something no one should be doing in real code.

Select [list of columns] should the way to query and doing so you know exactly what columns are read. That's one of the reasons I dislike ORM like hibernate.

I advocate the least surprises principle, select * or select !column are doors to surprises. What if someone add a geometry column with tons of data (real example happened to me)? You are going to read tons of data that probably you don't need.
And some work creates negative value! :)
The blog post is right that storage is the key problem if you are trying to eliminate hydrocarbon fuels from electricity generation and electrify all the things at the same time. And also right that there is no "one size fits all" magic solution for carbon-free energy storage.

For all the self-congratulation that European countries do (and the US is starting to do, with the IRA's energy provisions) about their progress, no policy maker seems to understand how woefully short of what is needed we are.
>> surely there's some kind of "reasonable person" standard at some point, right?

Are you referring to whether a reasonable listener would believe the defamatory claims? Or whether the person doing the defaming could reasonably be expected to know better than to believe what they're saying?

Normally, we think of situations where the defamer is a crazy person and no reasonable listener would believe them. But the distinction seems pertinent to the potential prosecution against Trump based on the Jan 6th committee hearings, because in that case the normal "reasonable person" standard would be inverted. A reasonable listener could easily believe that the President of the United States was describing reality when he claimed he knew the election was stolen and that the Vice President could legally overturn the results. His defense may well rest on whether he himself could have reasonably believed that what he was saying was true.
Posts like this remind me of high school where I argued against some hypothetical and got bullied because people got weirded out by it.
> I don’t know what anyone complaining about Docker on M1 are on about)

Are you using ARM-based Docker images? Never an issue with availability of your base images?

Not doubting, just interested.
It's probabilistic but on average leans to the woke side of things.

That's not Reason being unreasonable.

https://www.reddit.com/r/ChatGPT/comments/zsnrcu/biased_ai/
What do you mean by competitive?

I haven't seen a plan at the less than 35$ except for public mobile at 25$ with 1gb.
I come from Italy and at 5 you get 50 gb.

The pricing is just insane
https://blog.mozilla.org/en/mozilla/brendan-eich-steps-down-...
It arguably follows the underlying git design more closely than many git clients. Git has no concept of commit titles and commit descriptions - it's all just a message, so in VS Code you write it all in the same box with newlines [1].

It's definitely not obvious if you're used to having separate fields, but it's a bit unfair to complain about all GUI clients because an opinionated text input box is missing from a single feature from one of them surely?

[1] https://stackoverflow.com/a/51316392
Same goes for Apache Cordova a framework for building mobile apps for Android and iOS. Apple knows a big chunk of apps in the App Store are using it.

You can only use it for iOS apps if you have Apple hardware. I am one of the maintainers and thankfully I got a Mac Mini donated as well when I lost my company Mac.
It might do, but simply re-running the generation when it says no has a decent chance of getting it to work.
>Last I heard he is(was?) a Fedora user

Which uses GNOME.
Honestly those numbers are miserable and not in-line with what I have experienced with M1 (or M2).

The numbers make me think it's using the 'efficiency' cores, or might indicate a lot of memory pressure issues (which seems unlikely at 16GiB)

There's a better write-up about compilation performance here: https://build2.org/blog/apple-m1-compilation.xhtml

For macOS there is a `taskpolicy` command to set the usage of efficiency and high performance cores. I'd expect that it's using high performance cores by default but you can force it by running `taskpolicy -c utility <program>`.

You can also force it to be run on efficiency cores by running `taskpolicy -c background <program>`
Getting online is not the true purpose of owning computer.
You don't need TLS. you kind of already have all sorts of computers that can handle TLS, so why build another one?

UXN was developed out of necessity , because some software stopped working in certain environments. AFAIK author is living on a boat. and doesn't have unlimited electricity and internet access. Their electricity supply depends on weather.

When you look at it like that, information security is largely first world country problem. whilst 3rd world country is happy if it has internet and electricity at all.
Some databases like ArangoDB (https://www.arangodb.com/) allow you to use Javascript instead of SQL.

However, using a type-unsafe (read weak typing), turing-complete language introduces the usual problems we know and love, such as infinite loops, runtime type errors, exceptions, and the like.

Personally, I'm looking forward to a WASM runtime for databases -- so we can run webassembly on the database. This COULD be carefully designed to be statically checked and, possibly, make it really hard to write runaway loops.
Reason has generally good quality. It's not a smear if you think so
Could you or someone elaborate on that? It’s not obvious to me how uncertainty around K implies that equality is a good thing… it feels like there is some (perhaps obviously correct) assumption here on the distribution of K that’s missing here.
Now if we say that utility provided to society by a person is concave with respect to their resources, then equality becomes obvious, but that seems different than this toy model (and also not obviously correct).