skysight-inc/HackerNews huggingface dataset:
When I think of SQL, I think of relational databases where they were created and most commonly used. What queries return are not tables, but a relation that can be composed of data from one or more tables.

What this paper is then saying is "What if SQL returned something other than a relation?" That question is being answered by all non-relational DBs being made. An example of one might be a graphdb that could return a graph with nodes, edges and properties thereof.

If we want to stay within relational dbs, then we're saying that we want a single statement to return multiple relations. That sounds something like GraphQL query to me which is stitching of the relational parts.
Yes, but I'm answering what is commonly referred to as the "new meth" or "super meth." The higher purity involving P2P. For example: https://www.pharmchek.com/resources/blog/the-rise-of-super-m...
But, there's no ability on a per-message basis.
If they have their phone set up with iMessage, I cannot just send them an SMS if they lose their data connection.
> Who on earth has the ethical authority to claim the right to control my ability

Do you also complain about so many other things that "unethically curb your abilities"?

> Only what is done with those weights should be legislated, and extremely conservatively.

Ah yes, let's regulate this black box with no insight into what it does, and only guess at its possible outcome. Whatever can go wrong?

Oh, we know what can go wrong, because we've had multiple issues with algorithms going wrong.
Hardware Intrinsics in .NET 8
hell yea!
One could argue it's our constant complaining that leads to things such as proper minimum wage (that actually gets increased almost yearly), 1 month per year vacations that are defined as human rights that employers can't take away from us, sick days that employers can't take away from us, overtime that employers can't force on us, healthcare that's mostly the same for the poor as for the wealthy, and so on, and so on.
Silly pleb! You didn't think you owned that thing you paid for, did you?
For those of you who don't know, civil asset forfeiture is the practice of the government, or law enforcement agencies in the United States, confiscating your property if said property could be the proceeds of any illegal activities.[1]

Only a 'preponderance of evidence' is required, a much lower burden of proof than in criminal trials. This essentially means 'more likely than not.' [2]

Also, unlike you the individual, your property is not 'innocent until proven guilty' as it has no rights. You must prove that you deserve your property back.

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

[2] https://versustexas.com/blog/beyond-reasonable-doubt/
When you use systems like Prometheus, VictoriaMetrics, Mimir, Thanos, Datadog
What do you care for the most?
- Cost of storing data.
- Query Performance.
- Data bloat.
- Uptime and Reliability.
- Or something else?
They're social engineering your circle of contacts to pressure you to buy an iPhone
Cross-purposes?! Ha! I think I need a break from this site...
re: tilted code, you have more statements against it here than you have for it at the link, where there is just one afaict

neither is statistically significant

> I've also heard a lot off any record

Are these people already caddy users? Probably not the right people to ask, they are early adopters and typically positive of most things a project does outside of the part they use
I feel like if they were serious about seizing assets that are connected to a crime they'd start raiding Sotheby's art auctions. That'd be fun to watch play out in court.
> If the law instead is about regulating the release of model weights, I will understand this and it would of course disappoint me.

Of course it's not about that. It's pure unadulterated FUD. The law is about many things:

https://softwarecrisis.dev/letters/the-truth-about-the-eu-ac...
> Arrow keys are the bane of keyboard life. You constantly have to lift your hands off the touch-typing home keys to move around your software file

Or you can purchase a programmable keyboard with customizable chords such as an Ergodox keyboard.
Anything attempting to proxy public Internet traffic and buffer the entire body at all times is in big trouble.

Either it has to have a very low body buffer limit and reject anything more (making it impossible to download any files through the proxy, or do anything similar) or it's trivially vulnerable to DoS where any client or server involved can crash the whole caboodle.
I did some contract work for a company called Akiban, which was bought by FoundationDB, which was bought by Apple that took the whole product off the market at the time. What Akiban offered was SQL with an extra datatype called a "nested result set", the idea here seems similar if not more generalized; you didn't need a traditional join anymore and your ORM-like library could build up hierarchical models from a single SELECT statement that included nested queries. there is still logic in SQLAlchemy to accommodate this concept.
This isn't related to the ability to just send someone an SMS if they're using imessage.
Nice write-up! The nuances between browsers can be annoying yes, if I remember correctly the spellcheck behaviour for contenteditable div are also different between FF and Chromium-based.
UK, not EU but then the OP mentioned European Citizens, I'd argue I'm still European, that's geography.
In my experience, status pages are useless.
While this is true, there were a lot of programs that existed before M110, and part of the bill of goods that was sold with M110 was that it was going to make it easier for people to access existing resources without fear of law enforcement.

And again, literally written into M110 is the idea that treatment is supposed to be cheaper than incarceration. Perhaps it's due to really bad red tape, but the treatment programs are not looking terribly cheap or effective.
The thing is,the most profitable businesses are often the boring ones. Unlike online businesses, the competition they face is decreasing daily as everyone chases after some glamorous business where they can work from the beach.
I don't get who's for this. The Trumpian "don't tread on me" populists who mistrust government don't want it, do they? The left wing "everything is about race and gender" don't want it, do they? Like, honestly, is anyone other than LEOs themselves arguing for civil asset forfeiture?
Self-managed. It can cover both cloud and on-prem instances.

What that usually means is self-maintained, and I would rather outsource that to cloud/service vendors.
Not if switch to using boolean logic. It's at max capacity then.
I remember the two CDs of TA having different music and getting mad about that because the song I wanted to listen to wasn’t on the CD I had in
That's on the receiver party.
I'm the sender using an iOS device. I can't CHOOSE to send an SMS if they have iMessage on.
Come on, you can make arbitrary analogies until the end of time but it doesn’t change the facts:

1) you have a device

2) you have software

If you buy the software, it is paid.

If you do not buy the software, its free.

If the software is not available for your device that does make it not free; you just have an incompatible device.

Any other take on this is subscribing to some bias.

Paper clips, are not relevant.

There is a distinction, to be fair, between “free open source software” which is free and you can take it and port it to your device if you want.

…but no one is claiming iMessage is FOSS, and when someone says it is “free”, that is not what they mean.
The goal usually isn't for one party to take a C program and transform it into "safe" machine code. The goal is for a possible adversary to take a C program and produce an IR, and then for somebody else (maybe you) to validate that IR and produce safe machine code. Wasm is a vastly better interchange format between distrustful parties than C would be!

(There are probably even better interchange formats coming on the horizon; Zachary Yedidia has some cutting-edge work on "lightweight fault isolation" that will be presented at the upcoming ASPLOS. Earlier talk here: https://youtu.be/AM5fdd6ULF0 . But outside of the research world, it's hard to beat Wasm for this.)

Less important: I don't think going through Wasm has to be viewed as an "extra step" -- every compiler uses an IR, and if you want that IR to easily admit a "safe" lowering (especially one that enforces safety across independently compiled translation units), it will probably look at least a little like Wasm, which is quite minimal in its design. Remember that Wasm evolved from things like PNaCl which is basically LLVM IR, and RLBox/Firefox considered a bunch of other SFI techniques before wasm2c.
First the authors show that for certain use cases, a single query is not ideal. Either the result set will be larger than it needs to be, or it will have to use something like ARRAY_AGG which "discard[s] all schema and relational information on the way." So let's assume that we are in a situation where a single query is not desirable.

Then the authors show ways to use multiple queries (in section 3, "SQL-BASED REWRITE METHODS"). Each method has its drawbacks. If you've done enough SQL, these patterns will look familiar to you. Compare the syntax needed here vs the proposed "SELECT RESULTDB" syntax in Listing 3 and you should see that their proposal is easier to write. Then in section 4, the authors "present an algorithm that can be integrated into a DBMS to efficiently compute the result set of our SELECT RESULTDB queries." Presumably this would be more efficient than any of the alternatives from section 3.
It's not dead but this phrase will certainly prove useful for scaring off people from entering already oversaturated job market
I do, thank you! (But it will never be the case that conflicts are modelled in Git, unless one uses notes or something to build a more expressive database on top of it, whereupon I think it's not really reasonable to call the resulting system "Git".)
Android has a concept of a default SMS client, but not one of a default messaging app that isn't an SMS client. Signal, for example used to include an SMS client but no longer does.
Defending RIghts and Dissent has an form to contact Congress on FISA Section 702 renewal

https://secure.rightsanddissent.org/a/protect-liberty-act

It asks legislators to vote

NO on the Intelligence Community's fake reform bill, the FISA “Reform” and Reauthorization Act (which as the OP points out is actually an expansion of warrantless wiretapping)

YES on the Protect Liberty and End Warrantless Surveillance Act, which actually does include some significant reforms
Correct. Same with South America: everyone used MSN Messenger.
We shot a 802.11b 215m across houses and a park to save getting a second internet using WDS around 2003 to 2005.
That was a full 20 years ago - yikes!

We used Linksys WRT54G's started with for some reason I think it was .a, then .b then .g's. We started with Sveasoft's firmware, when that ended and started charging shifted onto DD-WRT.

We used a 24db gain directional dish grid antenna on one end a a slightly less powerful but plenty capable custom built wave-guide (we got from a guy that had access to expensive telco. calibration kit), think it was 10to15, maybe even 20?

We'd shoot our weekly DB backups across the park! I created batches using robocopy for network re-startable copies as it took a lot longer than onsite w/cable. It was better than what we had as but we couldn't lay our own cables down the street over the park and viaduct! An additional link at the other site w/ongoing of 100 p.m. would have drained us beyond our weekly burn.

So much easier to mount 2 antennas direct LOS, job done!

I do remember the orange tree with a net would drop the link entirely when it rained =) - damned neighborhood Faraday orange tree. Setup a fruit tree shaker for when it's in the rain people! Some, at least 2x, people in the 2000's were very slightly inconvenienced.
Is this an answer to my question? I’m allowed to add more load and increase your infrastructure costs just because you won’t take my money in the way I want you to?
Multiple resultsets is a common term. Where a resultset is a table basically.

SQL Server (since 2005) can actually even have multiple active resultsets on a single connection. Assume same is true for most other database servers.
You sound like a politician defending gambling after receiving a large donation from 888, or else an employee at a betting company.
Here it is on Amazon:
https://www.amazon.com/Deep-Learning-Foundations-Christopher...

Now that Amazon has competition they are not offering even $1 of discount. In the old days you'd get at least $20 off list price.
I'm not sure thats the exact reason. This guy is subbing out work to other companies; he's not making 53k/month by picking up litter. He's running a business with nominally 1 employee but contracts out the excess work to other companies who I doubt are all making 53k/month.

That said, having seen snow plow ads it does sound like good money. Not as good as fang.
I was curious about specifically Australian examples as the comment implied they had examples in mind such as losing the use of the bow and arrow or somesuch.

The story there is more complex and there's a faction in Austalia that would insist that Australian aboriginals were on the decline when Europeans arrived.
http://web.archive.org/web/20231211210126/https://www.nytime...
i like how macos does it with separating the ctrl key from most actions with command key. so we can use ctrl in gnu readline style freely on all text areas natively.

for example to find in document, you press cmd-f and you can use ctrl-f to move cursor forward in text (or ctrl-option-f to jump to the next word etc.)
Did you try taking it before or during a night trip by car? That's the only moment I realize its true effects.

As others in this thread have mentioned, the taste of coffee is just too good to give up for me. Instead, I limit myself to: 1) 2 cups of coffee a day before 12pm, 2) allow myself to drink decaf after 12pm

I also allow myself to become caffeinated if I have to drive in the dark for long periods at end (e.g. 2+ hours).
These moments are rare enough for me to make caffeine one hell of a drug ;-)
I’ll bet it’s really friendly around Christmas

I wonder how we would test it
> It's bad, but it could be a lot worse

Yes, and it's getting worse

> Remember I said "if this is as bad as it gets"

1. How isn't this already bad enough for you?

2. How are you blind to the fact that it is getting worse? With companies like Deloitte already pushing for things like predictive policing [1] among many, many examples of systems already in place, and already causing harm.

Yes, governments can go to war, but that's reductio ad absurdum. Whatever bad things happen you can always find worse things. Doesn't mean this somehow justifies or nullifies the existing situation.

https://www2.deloitte.com/fi/fi/pages/public-sector/articles...
Oh wow, thank you for mentioning the GDPR bit!
I'm surprised they didn't mention SQL Server's "FOR JSON", which doesn't solve the problem they're solving entirely (n:n cannot be deduplicated AFAIK) but it can get you 90% of the way

https://learn.microsoft.com/en-us/sql/relational-databases/j...

(I can't help but wonder if this whole thing would be a lot better if SQL had a more first-class concept of sum types...)
This letter is particularly concerning when you consider there are individuals represented by this org who also believe in the Constitutional Sheriff theory. They want to be lords of a fife, not law enforcement.
its very rare a person goes homeless because the prices in downtown Seattle are expensive. if housing goes up, you move to a place its more affordable - not to the street. The reason for this homelessness surge is drugs.

Many of these people its a lifestyle choice, one that works very well for what they want. They get to beg, do drugs, and sell stolen goods all in one spot, its very convenient. yes, if you have been paying attention, all those store robberies and car break ins is very much related. many of those instances, the hot goods are exchanged for cash at these tent areas - some even have xmas lights!

> "hopefully at the end of all that, a new shot at a normal life."

What makes you think they even want that? They want to do drugs, they want to not work. we should re-criminalize public drug use, followed by not allowing people to set up permanent residence anywhere they please.

All of a sudden, less people would want to choose that lifestyle.
what about taylor swift song 'shake it off'?
This. Outage started 30 minutes ago and the status page is still not updated. Either everyone is asleep at Netflix or the chain of command for this task is too long.
An external keyboard is about your only option.

I've tried touch typing on a tablet and I can do about three words before drifting out of position and typing gibberish. You could probably get decent results with a lot of practice, but why would you ever want to?
I live in the Seattle area, which is struggling with public drug use just like Portland.

Like Portland, we've lived for decades with very progressive politicians who have lead successful decriminalization efforts and spent huge sums of public funds on treatment and harm reduction programs.

After several decades and many, many millions of dollars spent, the problem is, by every measure, absolutely the worst it's ever been. https://kingcounty.gov/en/dept/dph/health-safety/safety-inju...
Bad Review? Sue the Critic. Whistler Did
As a person who consistently has to debug bad code written by ChatGPT, namely because it hallucinates API endpoints or parameters that don't exist, I'd say the answer to your question is a resounding no.
SSE and event streams are the same thing
Scientist Shamans
Thanks for the info @smt88

I've been using React for a couple of years and tend to stick with Next.js if I have a choice.

I came across Preact and it looked to me like a simplified React component library.

Have you used Preact in production?
The simulation only started at unix 0 so really it "happened" a 0 but was coded to appear in the past to help seed the universe and reduce agent confusion, a classic issue in the previous versions.
That's not the rub at all. No one is "giving secrets" to anyone. The debate is whether to further allow and expand the power of the government to prevent anyone else from keeping secrets of their own. We started from the premise that secrets are necessary sometimes, right? I fail to see the connection.
I agree with you. The problem is that we conflate SMS and iMessage usage in the Messages app. Most people do use Messages for SMS-like messages (meaning not for exclusive iMessage features). E.g. looking at my message list: at least 40% of messages I receive are alerts, payment confirmations, appointment reminders, etc. These are SMS messages in terms of their purpose, even if some have the blue bubble and whatnot. Messages is a popular app in the US, but what we need to look at is how popular it is for specifically iMessage-exclusive features, not as an SMS client.
Maybe if the client did the JOINs and other logic that were in the query, it would shed load from the upstream DB? That would be helpful for RDBMS which tend to be harder to scale when they are CPU bound.

I have seen a lot of services move to microservices and do client-side joins to help distribute load. Maybe there is a way for a DB built around this approach to run each table on a dedicated instance and have each stream the data back async? That would reduce cross-talk between the DBs serving the query and effectively create a client-side JOIN again, but be transparent to the client (if it were handled by the DB driver instead).

An interesting thought!
Why are people obsessed with “breaking into” Apple’s walled garden? There are already secure cross platform messaging services like Signal or WhatsApp that has feature parity with iMessage. This is a solved problem that doesn’t need another solution.
Abstractions are just technical terms for analogies, and they commonly break down as you go deeper down the stack ;).
Thanks! Macroexpanded:

Reasonable expectation of effectiveness for large dog lifespan extension - https://news.ycombinator.com/item?id=38447491 - Nov 2023 (186 comments)
it would be incredibly easy for apple to frame this as a security issue, because, even in my mind, it is. I pay for apple devices because I trust apple with my data. I do not trust most companies with my data. I trust my data to only flow through Apple's servers, and to get a clear indication when my data is _not_ flowing through apple's servers (e.g. green bubbles). A company bypassing this causing messages to show up blue when they are in fact traveling outside of Apple's control is a security risk (to me). Clearly if it's e2e encrypted that's not the case, but that's not what apple is going to argue. They're going to argue exactly what I just did. And I honestly agree with them. That doesn't mean Apple doesn't need to allow other companies onto the platform, just that BLUE BUBBLES mean something to apple customers and bypassing that is something that apple needs to block.

Apple really needs to get that RCS implementation rolled out though. Wonder if it's still going to be green bubbles or something else.
The Sam Bankmans of the world gamble away their stolen money on shitcoins but the Madoffs of the world buy real estate, yachts, and government bonds. His real estate purchases had decent appreciation over the years -- a hamptons house (bought in 1980 for $250,000, sold for $10 million), a NYC penthouse apartment (bought in 1984, sold for $8 million).

https://en.wikipedia.org/wiki/Recovery_of_funds_from_the_Mad...
This is the patent system working as intended. Protection for technology development.

You may say it limits innovation. But it also protects smaller players from investing in innovation, by de-risking that a big customer might copy them and destroy their business. Which is mostly this scenario.

I think the bigger problem with the patent system is the patent trolls. Please someone solve that problem.
Loving the downvote and the hyperbole to ignore the fact that even the current state of "artificial intelligence", as the general public understands it, is still extremely dangerous to society. This doesn't have to escalate into warfare to be a credible threat. Stop living under a rock.