skysight-inc/HackerNews huggingface dataset:
I don't think this makes much sense. Meta sells ads. Apple and Google don't walled garden ads on apps do they? Meta doesn't use the Google and Apple ad APIs. They have their own ad marketplace, etc.

I really do think it's as simple as them seeing a future where people use a different form factor from a phone to do what they do much of what they do with their phones. I think that will be something closer to Google Glass but modern day
I understand the desire to reorder clauses in a way that makes sense to the user, but they seem to discount the value in the formality of enforcing a particular order to the clauses: you're assured that if the query contains, say an ORDER BY clause, it will always appear at the end, no need to hunt for it.

Also, why the need to match semantic evaluation order when there are far more important things happening under the hood that affect the execution plan (indexes, etc.)?

> Side-effects at a distance...The same columns are cross-referenced in SELECT, GROUP BY and ORDER BY, and corresponding edits are often required in three places

Can't this be avoided by using aliases?
Menga Dolmen: Engineering behind Neolithic monument revealed
Looks like from Elixir. If old SQL syntax will be supported then why not - but this one will introduce a lot less readable queries when multiple JOINs, subqueries and aggs are involved - it is very easy in plain SQL and here they will probably look bad.
I use two things:

* A password manager (PasswordStore [0]), in which I may make entries without passwords but where I indicate my ID on a given account.

* A personal wiki in which I may indicate for something that I have an account connected to e.g. Google or whatever.

When I come to some service that I vaguely remember having used before, I will find the necessary info either in my personal notes or in my password manager.

[0]: www.passwordstore.org
I don't get your point. You are describing a world I do not take part in, I think for myself. And make adjustments appropriate to me. Your points are mostly circular and decidedly lacking in irony. I repeat, if what you say is so true, how do you learn? It sounds as if the barest of truth is out of reach, no matter what. How do I thus gauge the content of your words?
Also OpenSearch PPL.
Is it really a problem with the people who built the client database?

Maybe the administrators of the organization should have removed Jane from the system?

It looks an awful lot like someone couldn't see a way to delete a member from a family account, and couldn't be bothered to figure it out. So they just edited her name from "Jane" to "Jane (Deceased)".
Gobot: The binary package manager for Node
Most microwaves are terrible too, good microwaves are much more expensive so nobody buys them, but they can cook much more intelligently with higher quality parts.
You may enjoy the https://pocorgtfo.hacke.rs/ zine where every release is a polyglot file. Some of the PDFs are bootable systems, some are NES cartridges, etc.
Two knobs will do. The timer knob can be used to stop the microwave and it starts once the timer is set and the door is closed.
Yeah, but that's because it's Apple. If the same hardware was made by pretty much anyone else, I'd probably be interested. It's like the iPad Pro. It could probably replace my laptop if it could run real Linux.

If the community had free reign to do whatever with the hardware, it would be much more than a toy. Someone would port SimulaVR (or a different window manager) and it would feel like a real computing device.

I can imagine a world where I travel with one of those headsets and a wireless keyboard. Then I can setup shop anywhere and do development work in a cloud environment. The headset just being a dumb terminal to render the terminal or whatever.

It really feels like we are only a few years away from that being reality. I really want the apple headset to succeed, so that other companies invest in open/hackable hardware.
What is the recommended system settings for this?
Melbourne has just banned electric scooter rentals from its streets
My final straw for unity was when they locked my org due to fraud. I appealed the case thinking it was a false positive by some automated system and they would correct the error.

It took them 3 months to finally unlock, but by that point I just moved on to Unreal and never looked back.
If you have an online way for people to cancel membership or subscription, and if you ask the reasons for cancelling, at least have an "Other" option.
There are drugs in use today that lower seizure threshold, e.g. some antidepressants. So I guess it's be a question of how much it decreases the seizure threshold and whether it's a worthwhile tradeoff.

When the alternative is an unstoppable decline ending in death, I think pretty severe side-effects could be considered acceptable.
I'm glad to see pipe syntax moving forward! In my time at Google, I wrote a lot of SQL queries that required a long sequence of intermixed filtering, grouping, aggregation, and analytic window operations. But the ordering of those operations rarely matched SQL's inside-out syntax, so I commonly had to chop up my logic and glue it into multiple chained CTEs. This busywork made my code's logic harder to follow and was frustrating, especially since I was familiar with alternative coding models, such as R's dplyr, that would have allowed me to express my logic as a simple linear pipeline.

I hope SQL pipes become commonplace so that I can use them anywhere I have to write SQL queries.
The problem with Lemmy is that subreddits ("communities") are tied to a specific instance. So basically every instance has its own separate c/linux, c/funny, c/technology, c/anime, etc. This makes it really hard to use.
Suspected burglar caught after sitting down with book
It would make competitive chess even more draw-ish. It is much easier to see when you accidentally get into a losing position than when you miss a winning idea. So the take back would be used defensively.
The average content of gold and silver and of platinum-group metals is very similar in the whole Earth and in the rest of the bodies of the Solar System.

Nevertheless, in the crust that covers the surface of the Earth, the abundances of gold and silver and of platinum-group metals are many orders of magnitude lower than their average abundances in the Solar System.

For instance most of the silver has remained in deep parts of the mantle when the crust has formed, so silver is 11 times less abundant at the surface of the Earth than in the Solar System.

Gold and the platinum-group metals have gone to even higher depths, in the iron kernel. So at the surface gold is almost 300 times less abundant than in the Solar System, rhenium almost 600 times and nickel more than 900 times less abundant than in the Solar System, palladium around 3000 times, platinum and ruthenium around 5500 times and osmium and iridium around 50000 times less abundant than in the Solar System.

Similar numbers apply to all of the 8 planets that are big or medium-sized and also for some of the small planets and big satellites, because all these have been melted at some point in their history, when all the metals with high affinity to iron or sulfur have gone to inaccessible depths below the surface of those planets.

In the outer parts of the Solar System, the bodies are covered by thick layers of ice, but for the 4 inner planets the silicate crust that we see covering their surface is similar to the slag that forms at the surface of the iron smelted in an iron furnace and it is similarly depleted in the metals with low electropositivity.
https://spectrum.ieee.org/amp/bionic-eye-obsolete-2656624624

https://www.pelobuddy.com/quartz-tablet-support/

Perhaps the author might fund a more useful question to be: why iot shills expect anyone to trust their devices?
'Never expected it': San Francisco swept up in California home insurance crisis
What happens with the time that was spent on the undid move? Is it lost time, or added back to the clock? If the latter, how would you avoid abusing the undo to gain time? (E.g. think 5 minutes on a move, undo it, and then do it again, but this time in 2 seconds)
Calling that pong is a stretch. It's 2x3 pixels wide pong if you insist.
I think this contextualizes how hard they tried to make their site unusable on web browsers. "Front page of the internet." Thanks glowies.
Pretty sure the Meta glasses routinely sell out and the Spectacles had a hard time selling. Maybe they both sell them at a loss, who knows
Counter argument: most of these commands are great if you want to do shell scripting (including one-offs that you never save to a file), where you chain commands to do work for you. But I've never needed anything except for `ls` and (rarely) `chmod` for my actual day job, especially since everything I write needs to work cross-platform. Shell script has been the bane of "and folks on Windows should also be able to contribute" open source developers. I consider these great commands to know for personal automation, or when doing Unix(like)-only dev work, but they're the complete opposite of essential for cross-platform development. Not intimately knowing them means you literally can't be tempted to integrate them into a team-wide/project-wide workflow.

Maybe if Windows had grown up with the same Unix tools from day one, the story would be different, but as it stands if I want to do cross-platform development, I'd much rather use the tools I know that Windows devs on my team (and community contributors) can also use, so that we're all using the same tooling and everyone can help everyone else when that tooling falls short.

A lot of things in this article are (for better or for worse) "just do X in VS Code" these days, with support for a "project-recommended extensions" file that you check into version control so that folks forking/cloning automatically get told which extensions they will want to get up to speed with the rest of the team. Because if there's a "common" unix command chain, good chance there's an equivalent cross-platform extension for VS Code for it. If it's not already built in of course.

The essential part is knowing how to do get the result you need for yourself, and how to automate the tasks of getting those results using tools that everyone will be able to use if you're doing dev work (paid or as volunteered) for someone else.
Thanks for the offer. I’m legally bound from talking about this.
Pointing out that there are ways to reduce risk of something bad happening does not excuse the fault of a perpetrator. Neither is it victim blaming. This is particularly true when having a bad thing happen to you could occur without any individual acting intentionally, such as is the case with food poisoning.
One cent sounds low but it’s not zero, which has a special place in pricing.

Check out this paper:

https://people.duke.edu/~dandan/webfiles/PapersPI/Zero%20as%...
> The article says the JPEG would be a third the size they are now. OK. That’s nice.

That's also significant $$$ when you're serving petabytes of image traffic every month. Even if it's limited to iOS.
I'd think that companies use commercial grade internet, and normal people use residential internet. If so, then it would be easy to imagine that the ISP blocks some features for the residential subscriptions.
Can’t answer for legal reasons.
The proposal here adds pipe syntax to SQL.

So it would be reasonable to call it SQL, if it gets traction. You want to see some of the big dogs adopting it.

That should at least be possible since it looks like it could be added to an existing implementation without significant disruption/extra complexity.
Organizations often lack sensitivity in handling such matters
cool project! i've been looking for something like this to help me visualize my financials.

Would love to know more about the underlying math
Sure but it absolutely matters heavily if not just as much prereqs.

I met a girl who struggled with trig and another guy who basically trivially studied the subject and aced it. IQ matters a lot.

We are talking in circles. Both matter but I’m saying with my example above that even at basic math, both still matter. It’s not some thing where iq only matters for phd level math
Longtime Moom user, I’ve tried many others but this is the best IMO. The config plist is part of my dotfiles repo and I’ve been able to effortlessly port the settings between multiple new machines. Everything I need is available with just key chords.

I am excited about a resizable settings window though!
You wouldn't get any time back.
In theory they could, in practice they don't because almost nobody writing those elements pays attention to that level of detail or use them solely for a visual styling effect that has no bearing on understanding the meaning of the content.
China Is Putin's Lifeline
My Tovala oven does this (you scan before you put in), though it uses steam and broiler not microwaves.
The real truth: if you aren't good, there is nothing wrong with that and there are more than enough developers in the world and people who are good with math. What we need is more people creating real and interesting jobs for these skills.

Also most people aren't great with spatial reasoning. Chess requires zero prerequisites yet the average level of chess on chess.com is constant one turn blunders. It took only a year of playing on and off to get to 98th percentile and up to maybe 70th percentile most of it is capitalising on basic mistakes. We need to stop deluding people with feels good content, that's how you get memes like imposter syndrome.
I don’t want to live in a world where every 6 months I need to add an extra hop to find an album on Spotify, where Google abruptly retires applications I came to rely on, where Microsoft places ads in my taskbar, where Apple keeps me from running the software I want and Amazon acquires companies to let their products, which I use, rot to death.

This also brings up another point which I think is sometimes missed - open vs closed DATA formats. Obsidian is a good example. The software is entirely proprietary but the files it uses are standard markdown, so if the software "rots" it is not nearly as much of an issue.

Contrast this with some inscrutable binary format (cough PSD cough) where its significantly more difficult to ingest the files without reverse engineering the format.

My acceptable criteria are either:

- Open source and open format

- Closed source and open format
Holding the door open for someone is considered being an asshole to some minority.
Show HN: I Improved My Problem Website Based on Your Feedback
Hi everyone! Last week, I introduced the Problem Platform—a place for people to post and discuss their problems. I received some great feedback, especially concerns about requiring Google sign-in and not being able to view problems without an account. I've made some changes based on your suggestions. Thanks for helping me improve the platform!
The most insightful comment I have seen in this thread.

It assumes a single investment context, the global (read: western) financial system, right?

Is the latter more firmly wedded to the idea of growth than the rest of the world, or is that an illusion? Consider the (unsuccessful but suggestive) attempts to establish a commodities-backed currency by BRICS. Is this an attempt to sustain growth by alternative means, or to preempt and manage its end?

My impression is a system in which the national interest takes a backseat to investor interests can't contemplate reform in which the number might cease to go up, because growth is a load-bearing feature of governance (read: those in and with a hotline to government want growth for their own benefit, and need it to secure the support of a population which has also come to expect it). Some nations, while heavily dependent on the global financial system, have maintained at least the semblance of sovereignty, on the other hand, and may be able to consider the situation in (slightly) more realistic terms.

Of course, decline is nearly as ripe for exploitation as growth, while perhaps requiring more expenditure in narrative construction, so I hazard no guess on which system prefaces a more humane future.

Is this a reasonable interpretation?
I've seen it happen even when source is available. I've also seen a lot of really terrible math mistakes in ML because people don't understand the underlying assumptions of the metrics they use.

The rot is everywhere because people forgot the goal. We all get caught up in the metrics that are used to judge us that we forgot what we were proxying in the first place.
Wow, this is awesome! Is your fork public? I'd love to try adding some stuff like touch controls and save file syncing like I've done for Cave Story https://thelongestyard.link/cave-story/
Anyone that has actually utilized the scientific method truthfully to solve a problem or to verify truth ought to be able to identify several limitations or even identify it's more obvious flaws.

It is merely a formula - a method to determine, what is to be determined, why and to what end ALL is Science - the method alone is nothing, method cannot be without data and a hypothesis cannot be without someone to make it and the knowledge required to make a hypothesis. Without logic and reason the method, data, hypothesis and results would be nothing. Without society to allow for and direct progress there would be nothing to hypothesize.

Science is the sum of all of that. The method is a tool - not even the most effective necessarily. The method with make a light bulb - if allowed 200+ tries. Other tools allow for more direct results.

Tesla who transformed Edison's power delivery system into something infinitely more useable and that was only the beginning of his demonstrating mastery of a whole new thing - much of his inventions couldn't come of the scientific method. The method could be used to verify his brilliance but wasn't the source of it.

Tbh, it's literally just predefined, recorded, trial and error - that's it. Just guess, try and repeat - according to the rules so it can be replicated by anyone, super simple really.

It's like a brute force password hack - not the sharpest tool in the shed, but an effective one.
Show HN: A Python-based, in-memory NoSQL database
Over the last two weeks, I have been learning more about how NoSQL databases work. I decided to make a database, with the intent to use it on my personal website.

JameSQL supports several query types, including and/or, range, span, and wildcard. It also has a text-based query language with support for operators that is transpiled back into a JSON query to be executed.

You can try it out at:

https://jamesg.blog/search-pages/?q=category_lower:%27indiew...

Under the hood, I use a reverse index for text and boolean searches, a b-tree for range queries (using the btrees Python package), and a trie for string prefix queries (using the pygtrie package). Most queries are executed in < 0.01s.
About a year ago our cat went up the tree in our backyard and left his snap-off collar with an Airtag in a branch somewhere up there. We could ping it and hear it, but couldn't see it. So it got left up there for a year, rain, shine and hail. A couple of days ago I noticed it on the ground. Still working fine.
Why? It would only search the people I am connected to, not the whole planet.
Great changes. I didn't sign up and closed the site without seeing any problems last time. This time I'm much more likely to sign up.
I didn't say anything was wrong with it, I was just curious how it works?

But also I guess I assumed a "fam" is more than just a spouse. Sure if it's only one other person you live with, then you're probably not needed any time. Idk I'd still rather watch a movie together, but that's just me
> adults who want to learn proof-based math

What is their usual motivation for this? Do they find they are running into regular work or life situations that require it?

I think about all the math I took in high school and undergrad, and in my adult life I have not used anything more advanced than basic middle school algebra and occasionally some simple trigonometry. I don't even remember most of what I learned, other than very high-level concepts.
It really depends on what your application is and how much critical functionality relies on hard to replace proprietary services.

If you store a lot of data, transfering it is a big deal too, of course.

But really, computers are computers. It's easy to move software between them. It just takes motivation, effort, and time.
Western countries lack the talented and hardworking manufacturing workforce necessary to stay competitive.
For many company's use cases (make EC2s a few times a year, otherwise leave them running) I would imagine they would really feel better if there was an option that said "if charges incurred is over (configurable threshold you set to 10k higher than your normal monthly spend), then robocall the customer, and if they do not reply after 3 automated calls then block all additional AWS API calls that would incur more than 10% of my monthly spend if left running for 24h."

This would still allow all production services to run, but would stop someone from spinning up 200 crypto miners. I'm sure AWS is capable of implementing this, and I don't want to say it's "easy" but I would be shocked if they lacked the technical expertise to do this.
>… People had to use `char(1)` columns with CHECK constraints to store '0'/'1' - or worse: 'T'/'F' or 'Y'/'N'

If you are truly blessed you get to see all of these in a single database. Also “Yes”/“No” with that specific casing.
I wrote

> I still like Delaware for C-Corps

I’m thinking the readership of this thread doesn’t realize that using Delaware for capital means using a C-Corp

I’ve seen lots of lazy/broke/small entrepreneurs go with LLCs anywhere, but LLC anywhere isn’t using Delaware for what Delaware offers
JavaScript dates are about to be fixed
I emailed him.
best for who still stands, and my entire post covered the aspect of its court and case law. there is an objective way to look at it
nice work on chartdb, guys!

can you elaborate on how the ai part works? im a bit confused how that fits in because there are many SQL diagram tools without AI as well
> Our browsers could have been exploiting things behind NAT this entire time. Smart TVs, Smart watches, phones, anything pingable on your LAN.

Maybe if they’re running an HTTP server (which isn’t too uncommon for IoT devices) while allowing the attacker website via CORS (less likely). An IoT device listening for WebSocket or WebRTC connections won’t benefit from CORS, but those are relatively rare and ought to have other mitigations in place.

All your links show is the ability to scan ports, not even read the responses to the fetch() requests made to local IP addresses. That could be useful to an attacker, but a far cry from exploiting any smart device or having the ability to send “outgoing crafted packets” from the browser. You cannot even open arbitrary sockets or craft arbitrary HTTP requests.
I remember following the openbsd stable branch about 20 years ago and it was indeed very slow to simply check out and update. Svn felt much better even though it wasn't a revolutionary improvement.

I guess that's why the errata page has source patches. It's also great that they have syspatch now for fast binary patches
It was a pair of scuba tanks in a custom bag which was too small for the tanks, so there was no really secure inside.

But, it was attached to the handles with one of these: https://www.amazon.com/dp/B0B34Y5YZS

There are people who dive down and find lost stuff on the bottom of lakes, and people who go magnet fishing, they still might find your keys!
Not sure what you are arguing, you didn't seem to read my post? I never said we shouldn't try to make more people succeed, or that everyone who fails are stupid.
Amazing. I am fun of cellular automata and Conway game of life. This looks like a nice game.
Laerte, a Brazilian artist known for his comic strips, once did a strip explaining the difference between artwork and framework, which is that framework has to be good.