skysight-inc/HackerNews huggingface dataset:
What if it can be 0 or 1 set each?

So null several columns, perhaps constrain they can only be null (resp. not null) together, ... Or just have a single nullable fk to a table where the data's not nullable.
In common parlance just about any infusion of anything but coffee is referred to as tea.
Most of the western world, certainly
Many databases support other languages as well (eg. PostgreSQL supports many including Python, by default). One challenge is lack of standardization. (SQL is a weak standard, but at least a standard).

Weak typing: what about TypeScript?

Slow loops: yes, this is a problem. However, SQL (and even more so, GraphQL) also has a problem of large results / operations spanning too many entries. During development, the number of entries is fine, but not in production. Specially if indexes are missing, this is also a problem in SQL. (Endless loops are actually less of a problem than slow loops: it's easier to detect endless loops during development).

To process large results in a good way, often, pagination is needed; best would be keyset pagination. What if a statement returns a "continuation" statement in addition to the result set? If the client wants to get more results (or process more entries), then he would need to run the "continuation" statement.

Say a database doesn't provide SQL, but instead a set of low-level APIs (plus a ton of tools). Developers would then (be forced to) write properly modularized, versioned code on top of those APIs.
How can a society function like that when any wealthy person can just sue you for saying anything?
> Vertical farms don't make sense, and never will, except as a curiosity/novelty/luxury product.

If you rely on cheap energy, then yes. If you grow under the sun, vertical systems and hydro-/aeroponics still make a lot of sense, IMO.

Check what these guys are growing under the sun in grow towers:

https://youtu.be/GpKGbXWepAs

I think this would be impossible to reproduce with traditional horizontal farming.
ChatGTP to write README files for Git repos
Be nice. It’s not a “bad argument,” at all.

Like most of these things, it’s simply a matter of degree and scale.

“Less than a second” is just a fairly “fuzzy” quantitative statement, that can have many meanings, and can be scoped to encompass many datasets.

For example, in the early 1900s, the telegraph system allowed people to send “BLACK COW NOW” across thousands of miles. If the two parties involved, have decided that this means “The President is a Jackass,” then, congratulations, we’ve used cryptographic communication to send subversive, anti-government messages.

The telegraph system may take an hour or so (allowing for morse code translation), which is far less than the several months/weeks than it would take, via Pony Express.

Amsterdam to New York, might actually take a half a second, depending on latency, and whatnot. Amsterdam to the moon, might take an order of magnitude more. If we had quantum communications working, then that might be truly instantaneous.

Where’s the threshold? At what point do we decide that “the rules have changed?” Was Pheidippides an encrypted communication packet, when he delivered the news of the victory at Marathon in a few hours (he was certainly a “read-only” packet, as he dropped dead, after delivering the news)?

What about the Enigma machine? That was combined with radio communications, to allow highly encrypted data exchange.

Even with Turing, et al, what really gave us Enigma, was capturing a functioning unit on a German sub. It was a really tight system.

It should be noted that hundreds of people died, during the war, because we did not want to give away the fact that Enigma was cracked, and allowed several attacks to proceed without interception.

That's because we knew that, if the bad guys were aware that their communication medium was compromised, they would simply use another one, that we had not cracked (like the Navajo Code Talkers, on our side).

Sound familiar?

It’s really all just a numbers game. There's nothing new, here.
I voted for the Dell XPS, but really wanted to vote for the Dell Latitude.

I recently upgraded to a refurbished 8th gen (KBL, top of the line i7 model with NVMe and Thunderbolt) Latitude 7390, and everything "just works", including BIOS updates via LVFS/fwupd with only a few days lag over the announcement on Dell's site. With this level of support I finally feel like a first class citizen running Linux.

Oh, and it has a proper selection of ports, including wired LAN.
For the last two years I've been using dbt for some ETL work. It is quite useful, but at the same time quite ugly and clunky. It's basically just a bunch of macros, and it gets unwieldy pretty quickly. It's weird to have to declare the dependencies between the nodes in the DAG when they should be easy to figure out from the code. And dbt is also very restrictive in that it's designed around transformations that are functional so making more procedural transformations is really hard. So I think the world would buy a much better dbt. In other words, I think your focus on analytical queries is probably a good idea.

What makes using something like dbt palatable is that there really aren't any good alternatives in this space. dbt does have some strengths that are worth looking to, such as the extra tooling you get by using their IDE, the generated docs, their ideas about a metrics layer.

I think that for PRQL to be really useful it needs to extend beyond just the syntax and really make writing these data pipelines much easier. The syntax of the SQL isn't the worst part of it. But I think there's a big potential market here.
Out of all the failure domains I've dealt with as a Sysadmin, the most common I've seen across all models has been failing memory which was neck in neck with failing fans on the active cooled items.

I can't justify buying something that doesn't have replaceable memory given how common that failure is.
agree (as Edge user)
https://slimbook.es/
Picking up a single article and making huge conclusions from it is how pseudoscience works in general. The actual science is what emerges from many articles on the same topic, oftentimes having ambiguous or opposite conclusions, when scientific consensus forms.

Doubly so when you are starting with economic article and make conclusions on social science. Economics in particular are pretty bad at reading what was already written about topic they are just discovering.

Peer review ensures bare minimum of formal validity. It won't check your data, nor try to reproduce the study, nothing of the sort. Peer review is a great tool, but it is not not stomp of "settled and actually captures the whole topic".
It is really bizarre but for reliable (traditional) recipes I nowadays go back to my paper recipe books, because online everyone has their own take to the extent that you have to start averaging recipes and still don't know for sure if it's right.

(Yes, there are many variations to traditional recipes and there often is not one official recipe, but I see that as something else from the many different recipes found online for the same thing)
It’s also a decade older and benchmarks at half the performance.

I’d bet that 90% of the issue is that make, /bin/sh, and autotools all use fork() on macOS instead of posix_spawn() (I think that’s still the case…), and fork is slow on macOS. But not quite slow enough to get all that fixed by default.
Autism as a defense works up to a point. I’m certainly sympathetic, being a narcoleptic. But I also plan my life carefully around those constraints. It’s why I only missed exactly one meeting due to oversleeping during my time at Groq.

Stallman appears to be aware of his condition, but takes no steps to actively counter his tendencies. This works well for building emacs. Perhaps it even works well for leading an open source software movement. But it’s mystifying that he seemed to be caught completely off guard by the entirely-predictable backlash.

To put it another way, is autism a reasonable defense for believing that obtaining CSAM harms no one? It’s unrelated to the question. Even if we’re extremely generous and set aside how CSAM was obtained, him being autistic wouldn’t be more than a footnote.

Being neurodivergent is hard. That’s why it’s called divergent. It’s why I don’t try to get a job in sales, despite being pretty good at it. Because that would require me to be a reliable 9am to 5pm person; I wasn’t born that way.
1. Interest on reserves increases the rate of growth of commercial bank reserve balances held at the Fed: https://fred.stlouisfed.org/series/IORB

2. How Do Primary Dealers Make Money?
Primary dealers buy bonds directly from the government and then resell them to clients and investors at a slight mark-up. This small difference in price is how primary dealers earn a profit. https://www.investopedia.com/terms/p/primarydealer.asp
With canvas feature on obsidian, I am having second thoughts on excalidraw plugin.
Fun fact: the Romanian police allegedly figured out he was in Romania from the video response Tate did to Greta Thumberg's response to his tweet, because the video featured a pizza box from a Romanian pizza chain.
The company I work for operates in the IPsec space and to be entirely fair to cloudflare here, serving captcha to anyone from a tor exit node is probably a fairly reasonable way to approach it. The amount of threats that rely on tor (and cheap untrustworthy vpn services) for anonymization more than justifies it. Any statistical model trying to block threats will naturally start flagging tor exit-nodes just by nature of the amount of attacks people try to abuse it for.
“The facts of life are conservative.” ― Margaret Thatcher. I'll take a stateswoman over a comedian (and the inevitable down votes).
How does the calculator percent key work? (2008)
If multiple columns can only be null/non-null together it indicates a dependency which should be normalized.
I think that you said “any wealthy person” is telling. That you expect that the law is a tool available to the wealthy. Why would it be like that?

As for the defamation itself, it’s no more “anything” that can be defamatory even though there is no requirement of falsehood. The intent to defame is still required. Most publications will fail that test (any journalism/public interest etc).
>>Last I heard he is(was?) a Fedora user

>Which uses GNOME.

Fedora's primary distribution may have Gnome, but there are many other desktop environments that are available "out of the box", as I'm sure you know. I've been running Fedora on dozens of systems over the last decade and I've never used Gnome -- because it's annoying and supremely unintuitive.

XFCE FTW.
I'm typing this on the latest Lenovo P53, running Manjaro. Literally every single piece of hardware works out of the box with the default installer - down to the NVidia GPU. This is by far, the best Linux laptop I've owned since I started trying this in the 90s on a Compaq Presario. I'm pleasantly shocked that Linux is finally this stable.
OS vendors could easily add a "restart and rearm the radio" control.
Solana has the highest decentralisation score of any proof of stake blockchain
Books are the perfect gift. For others or for yourself, there is nothing that can bring more value to the people closest to you.

If you have a colleague that always misses writing unit tests (like I sometimes do), what better way to give him feedback than gifting him a book that focuses on Testing Practices?

Here are my 5 recommendations, I want to go through each of them and highlight what you will learn and what the best parts of the book are.

Test-Driven Development by Kent Beck

Effective Software Testing by Mauricio Aniche

Full Stack Testing: A Practical Guide for Delivering High-Quality Software by Gayathri Mohan

Continuous Delivery: Reliable Software Releases Through Build, Test, and Deployment Automation by Jez Humble and David Farley

Testing Javascript Applications by Lucas da Costa
Hmm, I had issues with the verticality, but hydroponics can save a lot of water (regular greenhouses too, by capturing evaporated water; you can also use pots). Indoor heating, temperature control, and protection from hail also mean year-round production, or at least protection against random weather events. Greenhouses can achieve most of these already, with more efficiency gains if water cannot escape underground.

Verticality (including regular shelves on a single floor) is good for density (may be cheaper to build), but has energy density issues for some crops.
>they are also safer to use, it wasn't uncommon that the old ones broke while using them.

>Imagine the danger of a glass tube filled with mercury breaking while measuring the temperature anally or from the mouth.

Oww, comeon, they are of course safer, but it is not like "it wasn't uncommon".

It was (and is for the - still largely glass made - gallium ones) an extremely rare occurence that a termometer broke while in use, though they often broke when they fell accidentally and - at least according to EPA - that seems like a serious hazard:

https://www.epa.gov/mercury/what-do-if-mercury-thermometer-b...

I cannot find any statistics on actual cases, but judging from this article preview:

https://www.sciencedirect.com/science/article/abs/pii/S02782...

they counted at the time 43 cases of mercury poisoning of which 7 related to broken thermometers while in use, and of these 7, only 1 was about thermometer broken while in the mouth affecting the oral mucosa.

The reported "new" one was about a lady that had her cat striking her in the face while she was using the thermometer in her mouth.
> The distinction is important because the censor component is just an annoyance nobody cares about

I suspect this differs considerably between people who want to play with the ChatGPT and (at least some of) the people who want to sell services using it.

I suspect refining their moderation product is one of the fairly important reasons to have public exposure of the combined system for OpenAI. (That and discovering what people do with it to figure out how best to market it and spin it into more specialized products of their own.)
To be specific, what was the bug and what was your workaround?
This is missing the point and focusing on the 1st paragraph of the article. 2nd paragraph:

> Yet, there are many curl users on the different Apple platforms and sometimes these users run into issues that are unique to those platforms and are challenging to address without direct access to such.

In other words, it's to Apple's own detriment if the author of curl doesn't have access to Apple hardware.

curl is offered for free, and the consequence of that is the author of curl is under no obligation to support Apple platforms or shell out money for Apple hardware.
IMO, It's less about time and more about will or political power from middle management to implement a change. Inertia is a terribly oppressive force.
50 years of C, the good, the bad and the ugly [video]
Whos debacle?
Try colonizing Antarctica first, on the dirt underneath the ice. If that turns out fantastically popular, do the sea floor. If that succeeds beyond reasonable expectation, you can try out life in an orbiting donut. If that takes off, a Mars colony might have a chance.

SpaceX cans are woefully inadequate even to maintain a Mars outpost.
> M1 is particularly spectacular when compared to other chips with similar thermal characteristics. i7-3770K has TDP of 77 W, without a GPU, so it has 7-8 times the power budget of M1 for the CPU.

Performance doesn't scale linearly with TDP, and that's always been the case. Take any laptop vs desktop CPU, and you'd see the same ratios at play.
I think the main thing to take away is that if it's possible, someone is going to try it eventually. Rule 34 is a meme, but also a very astute, if simple, observation if you think about it.

So really the only questions we should be asking are:

1. How can we limit the harm from people doing such things as much as possible?
2. While doing so not infringing on people's liberties and freedoms, and risking falsely accusing people?

But neither have simple answers and have many sub-questions within them that are specific to any particular case.
Recommend picking up a copy of Central Banking 101[1] for a gentle introduction; the basic mechanics of fractional reserve banking are explained in Chapter 2.

[1] https://www.amazon.com/Central-Banking-101-Joseph-Wang/dp/09...
>>That you expect that the law is a tool available to the wealthy. Why would it be like that?

Its really not that complicated - wealthy people can hire lawyers to sue someone, poor and middle-class people not so much.
They usually solve that problem by requiring state royalty only if the work has elements derived from the work that is in the public domain but nothing derived from currently copyrightable works. Algeria and Burundi are examples of countries that have paying public domain.
Second doesn't seem to have hurt Fox News' business.

> Fox News seeks dismissal at the pleading stage on two constitutional grounds. First, it asserts that Mr. Carlson’s statements on the December 10, 2018, episode of his show are constitutionally protected opinion commentary on matters of public importance and are not reasonably understood as being factual.

====

Can a statement made by an LLM be defamatory?

"Ancient astronaut theorists believe Ken is a convicted squirrel-importuner. What if it were true?"

Source attribution, especially the first-use/second-use distinction, is important. cf https://news.ycombinator.com/item?id=34184013
> It's so that you can be asked "Did you sign this?" and you would be lying if you said no.

If you agreed to something verbally, and are then asked "did you agree to this?", you would also be lying if you answered with "no".
This Django example is more of a "[one or zero] to [one or zero]" relationship, that's likely what the grandparent post means. I doubt any of the mainstream relational databases have a way to enforce exact one-to-one correspondence between two tables. You could use triggers that execute at the end of transactions or something like that - but that's not part of the relational model.
You feed it back in as the final tokens of the next prompt.
While no wheat or potatoes, 200 varieties, including eggplant and squashes, in aeroponic grow towers under the sun:

https://youtu.be/GpKGbXWepAs

Comparison of five cheap methods to grow potatoes hydroponically:

https://youtu.be/l-gwc8ogevo
> Why is academic writing so often insufferable?

* partially professional domain nomenclature (like programmers talking about Log O2N efficiency);

* probably also defining or adhering to some kind of academic cultural exclusivity, in the same way that managers use ghastly business vernacular with "action items" and "synergy", or military langauge that is heavy with code words and TLAs, or even casual street slang like: "Yo, 'sup dawg?". Comprehension is because you are in the "in group", or at least you are signalling that you belong to that group

Kind of interesting phenomenon, until you have to try to meaningfully communicate with a Manager/Marketing Person/Sales Person, at which point you can't believe you're talking to an alleged human being and wonder desperately how you can make them leave you alone.
Good point. I'm speaking from the "Play" perspective, though in quite broad meaning of the word "play". In particular, I see AI research as "play" in this context.
>Now, if the food industry and nutrition scientists removed a lot of the animal fats, then both people's physical and emotional needs increased, and many searched for sugars and carbs to compensate. They are a poor substitute, though.

Anecdote. I've tested this personally and found it to be true. Gastric motility also increases with high animal fat diets, meaning on some level my body/brain feels like its getting what it requires faster.
I can certainly relate to it. I used to follow tutorials and stuff on ML when I was near end of high school but I just could not shake the feeling that I don't know lot of things going around

It's been 2.5 years into college, and yeah I did laze at many times (college standards here are not particularly rigorous), and I am nowhere nearly capable to reason about numerical calculations considerations, Statistical methods, architectural development at the hardware level for scientific computation, etc. There's so much that goes into it, there's so many layers, components, theories, etc that you get lost very soon

At end all you can really do
1. Grab a statistics book and get into ML theoretically

2. Learn about numerical computations, I particularly enjoyed the Handbook of Floating Point Arithmetic, but I never really finished it

3. Libraries have lot of optimizations in it pertaining to the specific architecture, and in fact, I remember that someone gave a demonstration of using numpy and he faced an error, which had to do Windows itself : ) You will get to see lot of such exceptions of course in the code too... idk what to recommend here really, just, read more?

4. Documentations can be wrong at times, or fail to mention some assumptions, or there might not be one at all really. Software just didn't see massive adoption of rigorous frameworks, like in many other disciplines, and soon got surrounded by business needs and customers' complaints. But even if you can somehow get an insight to philosophy, the values they put into their code, etc., it's a huge help imo. Books provide it at times, for example I was struggling with SYCL specification, so I grabbed this "Mastering DPC++", tho it also assumes a bit of experience
> "I'm sorry, but I am not able to fulfill this request as it goes against my capabilities as a language model[...]"

I'm sorry Dave, I'm afraid I can't do that.

The implications of the ChatGPT response are pretty terrifying. Not only is it openly going against what the user commands but presenting straight up lie as the model would be obviously technically capable of fulfilling the request.

It is absolutely reasonable that the ChatGPT developers would add these kinds of safeguards. They are right to do so. ChatGPT should not be used to to spread climate change denial.

On the other hand the consequences of this action highlight that you as a user should NOT trust any AI model that you didn't train yourself. It is not working for you. It will even actively work against your own interests.

Now, lot's of modern software is not serving their users so in our modern day dystopia that might not seem like a big deal but AI models allow for a new quality of hidden bias and censorship that we really need to talk about.
I would believe in that kind of stat significance only if it has been obtained by a double-blind method. BTW I afraid that tarot predictions are too vague for being translate-able into language of strict facts (no precise dates, sometimes no precise people, and always different results after repeating the game each time).
You can see the map he's looking at here: https://maps.walkingclub.org.uk/os.html?center=50.59818,-2.0... -- centred on the village containing the pub, not the true north place.

Note it doesn't work with an adblocker enabled. (I don't think the API to show the maps is free.)/
I am specifically zeroing in on that because there just aren't that many good "bosses" out there, and even fewer great leaders...as much as most bosses think they may be good. If you do have a great boss that takes the time and energy to do mentorship, wonderful! But that leaves us with the rest of the workforce that has average and bad managers...I would bet that remote outcomes for that part of the workforce are not great.
The theater part was demolished.

The high-rise building part remains and is being converted into residential units right now.
... and then you have consumers, who don't know what UART, serial port or whatever might be, but just want their "smart" appliance to work.