skysight-inc/HackerNews huggingface dataset:
Imagine a programming language without functions...This would be tiresome. But that’s what SQL is

SQL limitations encourage creative solutions. I once implemented a simple "functional" framework as a virtual module in SQLite.

Some background. SQLite's virtual tables were always "functional". To make a virtual table function you basically require that particular constraint from where clause is present otherwise you will report a failure. Having this, you may create for example a table of all primes but with two columns, the prime value (obviously) and the count, but the column count will be mandatory (so the query for showing first 10 primes will be 'select value from primes where count=10'). Later SQLite added table-valued syntax and hidden column which allows the use of the syntax 'Select value from primes(10)'. But finally what made me implement a functional framework were eponymous virtual tables. Usually any virtual table should be present in schema, but eponymous tables don't require this and exist just by virtue of the corresponding module being registered.

So the framework uses all this machinery and a simple table is used for storing "functions". The table has two columns, query name and query body. The body may contain numbered SQLite parameters (?1, ?2, ?3). So this single row will automatically create a virtual table with the name from the query name column while all numbered parameters in the body will be converted into "input" parameters of this table (No need to manually parse, SQLite will take care of this thanks to its API). Sure, the bodies can use other queries from this library, SQLite handles this nicely.
I often found myself double-checking Linux file permissions, so I built chmod.one, a simple online tool to convert between symbolic and numeric (octal) chmod formats.

Instantly see how chmod permissions translate
Toggle checkboxes for owner, group, and others
No need to memorize complex permission codes

It's free, lightweight, and meant to make working with file permissions easier. Would love to hear feedback from the community!
> > we were sending USD $50 million to Gaza for condoms.

> This is a patently obvious and gross mischaracterization.

Looks like it hasn't been confirmed yet, but let's not pretend like there aren't really odd and weird and arguably wasteful items in the US spending bills that serve no immediate purpose for US citizens.

Rand Paul releases a yearly report of some of the most prominent ones that he uncovers. I assume they're all hidden in thousand-page spending bills that make it through. These are the results of people that are really un-serious and I wouldn't trust them with our money, they're just drunk on the numbers. To them, a million here a million there is peanuts and essentially bargaining chips in the little games they play in senate/congress.

https://www.hsgac.senate.gov/media/reps/dr-paul-releases-202...

I'm busy reading the report now, but the summary notes:

"$4.8 million on Ukrainian influencers, $32,596 on breakdancing, $2.1 million for Paraguayan Border Security, $3 Million for ‘Girl-Centered Climate Action’ in Brazil, and much more!"
Frankly yes, though I still prefer text editing in Sublime Text.
Surprised they didn't rename it to "Golf Of Peace And Freedom And Cuba".
I feel like we’re living in strange times where your comment appears to be AI generated as well. You complain about the surprise at the end and then offer up a similar structural surprise in your reply.
Threat of cyber-attacks on Whitehall 'is severe and advancing quickly', NAO says
FictionalNameGenerator.com has become an invaluable resource for writers, game developers, and content creators who need consistent character names for Western or European profiles.

I've found it especially helpful when writing test data for applications or creating placeholder personas for UX research.
TFA describes a perfect example of unwarranted implicit trust. Any
tunnel-in should terminate in an environment not unlike being outside
a regular perimeter, with internal per-host access control (perhaps by
RADIUS or some coordinated ACL - which would also have fixed the
parallel account problem )... especially to an unsecured Internet mail
server. I wish the misnomer "Zero Trust" were better crafted and
understood as a broad philosophy. I think it's psychologically
difficult to do the role-play and imagine "what if I couldn't trust
myself?"
We will push it to our repo very soon :)
I downloaded both the 6.3 and 6.4 RISC-V binaries and ran them on my 1.6 GHz Lichee Pi 3A, which has the SpacemiT K1 SoC.

6.3: 71 single core, 327 multi core
6.4: 133 single core, 545 multi core

The 6.3 results are in line with preexisting results from 1.6 GHz BPI-F3 and Milk-V Jupiter, which have the same SoC. For whatever reason no one has ever submitted a Lichee Pi 3A result before.

I don't know how optimal the RVV code added is, but that's certainly a worthwhile improvement.

https://browser.geekbench.com/v6/cpu/10179195

https://browser.geekbench.com/v6/cpu/10177252
No I'm not talking about mixed projects (although the ability to do that is very important).

I'm saying that using it for separate C++ and Go projects is extremely convenient and ergonomic.
Irrelevant. Noone said "cancel the F35 program", and noone said it can be totally replaced. The F35 program is running over-budget, so it's entirely reasonable to look at some cost reductions on the $2 trillion. (The current admin said they were looking for trillion-dollar cost savings by this April, and laying off the entire federal workforce wouldn't going to do that.) The choice is not a binary "100% of all the F35s currently budgeted, or no F35 program at all".

You can get thousands of suicide drones for the equivalent price of one F-35A ($80m). Both Ukraine and Russia are using these daily. (Obviously they don't have a fraction of the capabilities of an F35.)

The Houthis interdicted the Red Sea to commercial shipping in 2024. This is asymmetric: the US Navy couldn't afford to keep shooting down cheap Houthi drones with $2m missiles ("cost exchange ratio"). This is costing billions in economic damage. [0][1]

Another obstacle to where the F35 can't be deployed is the US blocks deploying leading-edge technology to some allies, for multiple reasons (espionage, lack of training, geopolitical), so such conflicts will determine which mix of drones or missile systems or F16s (yes, generations older) are more cost-effective.

[0]: https://www.politico.com/news/2024/08/07/houthi-yemen-defens...

[1]: https://www.reuters.com/business/autos-transportation/dp-wor...
SNR is not a function of antenna size. The size is dictated by the wavelength, not how desperate you are to receive a signal.

Directionality does make an antenna larger as it usually involves reflectors and directors, the size and placement of which is also a fraction of the wavelength, but if they are actually able to do direct to phone with decent reception and arbitrary coverage, then that beats having to set up base stations to cover a small circle even if you get 10-15 dB better SNR.

This might give you LTE in, say, all of the Australian outback, all of Alaska, along the Andes mountain range, etc.
Understood, but when we look at all the databases and source-control products, we're standing on the customer side. We get to experience stuff that just works, because the people on the development side opted for write-AHEAD-log and/or copy-on-write, as opposed to write-afterward-log or write-but-store-backups-in-case-something-goes-wrong.

When we're on the developer side of things, we get to choose whether to CRUD or to go eventy. If we want to build systems as good as those DBs, we should do what they did (events) rather than what they say (insert/update/delete). It's unfortunate that there's not much upstream tech to help us with this (it's pretty much just kafka) and that people who choose to use kafka get accused of 'resume-driven-development', etc.

>> Querying current state, which was 99% of the usecases, was cumbersome and extremely slow.

It's an easy fix if the events are there. Just cache the current state. It sounds glib but it's one of the first-principles of event-sourcing that makes me choose it over CRUD. If your events are immutable, they can be shared. If they can be shared, they can be folded into a fast-current-state-view. If they are instead mutable (or non-existent)), you can't share them unless you also have a plan on how to sync them (which no-one gets around to and probably overlaps on some classical impossibility result like two-generals.)
It hasn't been confirmed.
I'm in SF. I agree it's a wedge issue. My concern is that those of us on the left are losing. This entire thread started by being about my belief that we aren't falling into a fascist hole, even if we did elect a fascist again. We have real economic issues we are dealing with, neither party is actually dealing with them, and so the traditional parties are shifting in coalitions.

My hope is that we can find some middle way that gets us to a better place. I think the trans athlete issue is a distraction, but one I think it might want to reconsider, as it's mostly symbolic. I want trans folks to be treated with dignity and respect, and every day gender discrimination issues I see as non-negotiable.
Long Covid (probably a form of ME/CFS triggered by Covid) is one of the worse diseases one can get. It invalidates you as a person physically and mentally and there are no solutions around. At the same time you are gaslighted by doctors and people because there is no clear diagnosis.

My wife is already on her 3rd year and I just could witness first hand how shallow is the knowledge of most doctors, how they have zero curiosity or enthusiasm to help and especially in Europe, how are they extremely averse to try anything with the "do not harm" in mind.

They think that doing nothing is better than trying a non-approved treatment and I'll put an example. My wife had a respiratory tract infection back in October which probably got while going to the GP by the way. With Long Covid her immune system seems very compromised, she never leaves home if it's not imperative because even with a wheelchair is too much effort. I don't attend almost any social event and I take a lot of precautions. Anyway, with the infection she was coughing blood for 3 days and then she was unable to breath properly, having drops of oxygen saturation down to 86% and waking up breathless in the middle of the night.

She documented her symptoms very well including her saturation measurements. The GP just told her to wait for a few weeks for full recovery and everything will be back to normal and he literally said he had no time to read her notes. She asked please to get an oxygen concentrator or at least be sent to a pulmonologist. This request was denied and of course the only option she had was to buy the concentrator on her own which helped a ton. Probably if she got it the 1st year she would be much better by now.

She is taking like 10 supplements and medications, she is using infrared light, oxygen concentrator, wheelchair, special pillows, asthma inhaler, etc... All this helps her to have a bearable existence but guess what, not a single thing was proposed and prescribed by the doctors. Almost everything she takes is based on small studies from internet and experiences from patients. Mostly from the USA where doctors are much more open minded and willing to take risks which is necessary when your default baseline is almost like being a tetraplegic with dementia and chronic pain.

She has to get pretty harmless drugs like Sulodexide (a blood thinner) from other countries in a shady way because the Doctors in the Netherlands won't even prescribe this.

There is some progress in diagnosis or biomarkers detection and some promising studies for cures like monoclonal antibodies, antivirals and others. But meanwhile it's a pure nightmare to live with Long Covid.
How do these differ from SQL functions in PostgreSQL? They look like the same thing.
Indeed. I work on the Firefox media stack and we have been grabbing wake locks when video playback is happening for a long time. Occasionally e.g. on some linux desktop variant this has malfunctioned and we're alerted in no time and fix it.

The Wake Lock API is for other use cases, such as recipe websites, or other document for which you don't want the screen to go away / dim, the kind where you happen to need to look at the screen for long period of time without touching it/interacting w/ mouse and keyboard.

Prior to this API being introduced, websites used to play an inaudible/almost invisible looping media file to keep the screen awake. This has power usage implication, a small single digit number of watts (1 to 3.5 depending on os, hardware, mobile or not) is required to keep audio running (because of high priority threads, frequent wakeups, and simply because the audio hardware itself needs power).

One of those libraries source, for illustration: https://github.com/richtr/NoSleep.js/blob/master/src/index.j...
No I don't think national parks should be sacred, but I don't think they or public libraries should "be butchered for 'floor space'". I think options should always be measured and considered.
As do I. TextMate is still unbeatable, especially after I added Copilot and LSP to it!
>opinion writer at the New York Times

Why should I keep reading past this point? Why would anyone?
Where is one time purchase available? The only option I see is $99 for three years.
The Magic: The Gathering colour wheel (and humanity)
> People connecting through our VPN have access to an internal-only SMTP gateway machine that doesn't require SMTP authentication.

Time to clean that up while you're at it.
Acoustic Engineer Fixes NYC Subway, Parks and Buildings to Limit Noise [video]
it is Apple Silicon native
MartyPC Web Edition 0.3.0
Rust vs. C++ (2023)
Technically, the majority of Americans voted for something other than what we got.
That's so cool. I wonder what the battery life is like when doing that. It's amazing that a human can do all that on a mouthful of potato!

The safety aspects of such powerful and heavy limb moving so fast near humans is going to be an interesting one, and society is going to have to get used to it one way or the other. A single mistake like the robot spinning an arm 360 degrees due to a bad kinematic solution could be a very serious injury. Presumably normally a robot has static "no entry" zones to protect things that shouldn't be hit, but that's a lot harder in an uncontrolled space.

I have seen robot arms bolted to benches at trade shows where they could physically reach out and strike a passerby and wondered if they had soft limits on movements, and if they didn't, or they were wrong, how could I know not to approach
> Down that road lies "let's put every event in a fast message bus with higher insert volume and availability than the database, and feed that into the DB asynchronously", hence Kafka and friends.

Yes, this is the way. Which is why it's not

>> Isn't this essentially how a modern transactional database works anyway

and needed a comment.
In circa 2022 I got covid and lost smell. First I couldn't smell the spices in the kitchen, but I thought nothing of it. But some days later, I couldn't smell WD-40. That's when I noticed I can't smell anything at all. My sense of smell never really recovered. After about a year, I could faintly smell menthol. Now I have to really try hard if I want to get some faint sense of smell, but a lot of time I just don't smell anything.
So what? They probably paid for api access just like everyone else. So it's a TOS violation at worst. Go ahead, open a civil suit in the US against an entity the US courts do not have jurisdiction over and quit whining...
Phone -> Starlink Sat for the initial connection. That then pings to a starlink groundstation, then it gets routed over their fiber to T-Mobile over the internet (its all just data going over fiber anyway).

> fiber
Boxer
If DeepSeek were petty they would use quotes from OpenAI as their justification.
In all seriousness, have you considered adding an outdoor access point? They reach quite far as you usually have Line of Sight. Trying to get a centrally placed indoor AP to penetrate inner and outer walls is guaranteed to give reception issues.

Look at he stuff from Ubiquiti.
Something about the way Microsoft writes just rubs me the wrong way.

Not: "Please wait for ... an update"
But: "Please be patient and wait for ... an update"

It's not just their staff here, it's all over the docs and UI too. They can't write two sentences without saying something condescending and rude.

Like in Word, if you look for how to turn off grammar checking, they'll tell you, but they just have to add "Remember to run spell check. Spelling and grammar errors can seriously undermine what you're trying to say, especially when your boss, your teacher, or that person in HR sees them." [1]

They can't help themselves.

[1] https://support.microsoft.com/en-gb/office/turn-spell-check-...
DO sucks anyways. Hetzner is better.
This is her news outlet: https://www.thefp.com/. 99% of the articles are expositions of right wing talking points; and the same goes for her personal columns.

I'm not saying that's wrong or bad. I'm pointing out there's a group of people masquerading as "free thinkers" despite their overwhelmingly right wing views, and Weiss is in this group (Batya Ungar-Sargon is another).
>statement from Apple just PR

remember the iphone 6 battery and butterfly keyboard gate we both "small number of users" according to Apple.
"Can you make me a picture of a palestinian moonbase?"

Worked for me.
That private enforcing company has zero motivation to make the rule clear and easy to understand. Their letter soliciting license fees or a declaration of not needing a license is very obnoxious and threatening. Part of the strategy is that "you won't know whether you need a license, but if we caught you violating this arbitrary opaque rule, you're screwed. So you better pay that money."
Which is the reason alongside telemetry I tend to favor using websites over apps.

Having said that there are apps that are considered mainstream and not malicious by the general population but can become a convenient backdoor for, say, a state actor.
Give it a try and try to come back with your sanity intact. I dare you :)

It's mess.
Kubernetes is great. Legacy bash and cron is hip and cool again just because you can wrap stuff in a k8s cronjob.
I see! We wanted an overview of KV caching internally and quickly understand the latest methods without much fluff, I think it did a great job at that
How do you prettify it in Sublime?
Sublime Text team, thank you so much for creating the best tool out there! I truly appreciate the stability and simplicity of your product.

My main request is to add a tool similar to Cursor Composer and Chat. Thank you again!
Amazing they don't have 2FA on VPN, even if you don't go for yubikey/phone app you could at least require a cert.
It's a classic. I haven't played around with Samba in a long time, but if I remember correctly, you can either:

- configure SMB with a shorter timeout at boot

- configure your Samba share to mount with automount. (See [1] for inspiration)

[1] https://forum.manjaro.org/t/root-tip-how-to-systemd-mount-un...
How to Set WebGL Shader Colors with CSS and JavaScript
Thank you for your reply. In your other comment, you mention that you know Ruby relatively well. Would you recommend learning Ruby along side with Rails (i.e., learning Ruby in/with Rails), if I have some experience with other languages, such as Java, Python, C/C++, Lisp, and so on?

Also are there any Ruby AI libraries that you would recommend? Thanks!
Nocebos, the opposite of placebos, are extremely interesting. [1] The thing most people don't appreciate about placebos (and nocebos) is that the effect isn't just 'in your head.' It actually physically manifests - people can e.g. recover from illnesses measurably more quickly with placebos.

And the opposite is true of nocebos. So for instance one of the most common examples of nocebos is somebody will be given a terminal cancer diagnosis but then die long before the cancer could have been the cause of their death. They're so convinced that they're dying imminently that it becomes a self fulfilling prophecy. I expect a similar phenomena is why elderly couples tend to follow each other into the grave in short order. Dying of heart break or loneliness is not necessarily just rhetorical.

Basically, the mind is extremely powerful.

[1] - https://en.wikipedia.org/wiki/Nocebo
Emptying the Dishwasher with Systems Theory
Every dead body on Mt. Everest was a motivated, hard working person.
I think you failed to convey what you meant to with your comment.

If you want your contribution to the discussion to be meaningful, you may want to give it another go.
You're taking your opinion to extreme because I don't think anyone is talking about replacing all engineers with a single AI computer doing the work for a one-person mega-corporation.

The actual question, which is much more realistic, is if an average company of, let'say, 50 engineers will still have a need to hire those 50 engineers if AI turns out to be such an efficiency multiplier?

In that case, you will no longer need 10 people to complete 10 tasks in given time-unit but perhaps only 1 engineer + AI compute to do the same. Not all businesses can continue scaling forever, so it's pretty expected that those 9 engineers will become redundant.
If it's any consolation, if indeed the extra productivity happens, and kills the number of SWE jobs I don't see why this dynamic shouldn't happen in almost all white collar job across the private sector (government sectors are pretty much protected no matter what happens). There'll be a decreasing demand for lawyers, accountants, analysts, secretaries, HR personnel, designers, marketers etc etc. Even doctors might start feeling this eventually.
It's shockingly common to have to explain to Americans like yourself, that a democratic world exists beyond your borders. We even have different democracies electing different leaders.

Crazy isn't it.
One of my dearest friends suffers from ME/CFS - she's been bed ridden for 3 years now. Any stimulation is just so painful her. Seeing Dianna actually able to get out of bed has brought a bit of hope back into my life
I'm a bit of a noob when it comes to DSD, but don't you need a DAC with DSD (as an alternative to PCM) support?

Correct me if I'm wrong, but the player would need exclusive access to the device, and bypass almost all of the audio processing stack, like software mixing. Can you play PCM audio (like system alerts) through the same DAC at the same time? Like, a hw analog mixer?
Have the C-suite hand back their compensation above minimum wage for the last 3 years. Fine the company, all profits, or a percentage of global revenue (and pay that back to customers).

If the outcome of ignoring data security is to not make any money then companies will actually do something about it.

Penalities should push the company to the point of failing.
Hi, OP here. My intention wasn't to "gotcha" anyone by mentioning that in the end, it was simply to be upfront. Many blog posts/content put out these days are obviously 100% AI-generated, yet it's never being mentioned. This one was probably 80%/20% (I still did many manual edits).

Glad you overall liked it!
OpenAI is laundering all published works and possible non-public as well, but they are "investigating whether data output from OpenAI’s technology was obtained in an unauthorised manner".

Investigate at home first:

https://sfstandard.com/2024/06/13/telemedicine-adderall-vyva...

https://www.dlnews.com/articles/regulation/buterin-warren-jo...
Relays at L4 and L5 (also described in the linked Wikipedia) would be useful. If both are built it's reasonable for relay stations or satellites stay in contact continuously, if over different paths at different times of the day. The second relay station would also be useful if other objects naturally collected within the regions of stability disrupt communication.
Does it do 3d?