skysight-inc/HackerNews huggingface dataset:
TL;DR: Sqlfluff rewritten in Rust, about 10x speed improvement and portable

At[Quary](https://www.quary.dev/), we're big fans of [SQLFluff](https://sqlfluff.com/)! It's the most comprehensive formatter/linter about! It outputs great-looking code and has great checks for writing high-quality SQL.

That said, it can often be slow, and in some CI pipelines, we've seen it be the slowest step. To help us and our customers, we decided to rewrite it in Rust to get faster performance and portability so that we could run it anywhere.

Sqruff currently supports the following dialects: ANSI, BigQuery, and Postgres, and we are working on the next Snowflake and Clickhouse.

In terms of performance, we tend to see about 10x speed improvement for a single file when run in the sqruff repo:

time sqruff lint crates/lib/test/fixtures/dialects/ansi/drop_index_if_exists.sql
0.01s user 0.01s system 42% cpu 0.041 total

time sqlfluff lint crates/lib/test/fixtures/dialects/ansi/drop_index_if_exists.sql
0.23s user 0.06s system 74% cpu 0.398 total

And for a whole list of files, we see about 9x improvement depending on what you measure:

time sqruff lint crates/lib/test/fixtures/dialects/ansi
4.23s user 1.53s system 735% cpu 0.784 total

time sqlfluff lint crates/lib/test/fixtures/dialects/ansi
5.44s user 0.43s system 93% cpu 6.312 total

Both tests were run on an M1 Mac.
I like the idea of your approach. Can you share anything about how well it's worked out for you?

My main concern is that with the allegedly rampant cheating on take-home assignments, the number of employers willing to use them may drop precipitously.
Some rural Californians can't sell their businesses because LA is their landlord
Be like your father except with knowledge of Category Theory

That's the best we can do.
Yes. I really believe the main thing is the density of cycling networks and their separation from traffic.

Bike trails in the US that are fully separate from traffic are very commonly used. Trails that do road sharing at some parts are not.
This is a recent change, thanks to the 2018 tax code changes (the implementation was delayed until this tax year).
Also there is script(1).
One-time-pads effectively save you here. The application knows zipcode 1234 == "AWER", but the database doesn't and there isn't any way to derive that without outside information. The technique is a pseudo-anonymization technique, not encryption.
When a Lifetime Subscription Isn't for Life
I feel the same way. Especially with a promo piece like this so short on details.

If you’ve watched a house, or any structure, go up, you know that building the basic structure happens remarkably quickly. This seems to replace framing, roofing and siding. Maybe drywall too?

But you still have all of the expensive/slow stuff like plumbing, electrical and finish carpentry that still has to be done.
So how do you find, in an interview setting, good software engineers? (And better than with LeetCode-style questions?)
Show HN: Worthify – turn stories and ideas into short-form video
Hi HN! I am super excited to share Worthify, a prompt-based tool that lets you take any idea or story you have and turn it into a short-form video that you can post on any social media platform.

With Worthify, you can be as descriptive or as simple as you want with your prompt to get a return. Our goal was to lower the barriers of entry for making personalized, short-form content so that people can build their brand on social media platforms. We're really focused on showing this to business owners, content creators, marketers, educators, or anyone that just wants to turn a story into a video.

We've been building for just a few months, but we've made significant progress. We were focused on developing everything from scratch (lots of weekends and after work hours put into this). We also host all the models for voice synthesis, image generation, video generation, and more in-house so that we can make custom models and plug them in when we need to for any future use cases. We're leveraging Ray to scale our infrastructure with a on-prem first mentality and then scale into the cloud as we need.

I'd love for you to try it out and share your thoughts, feedback on any part of the UX/UI or just the general experience, and any suggestions for future development!
I would like to See:

- More open keyboard firmware

- more vendors supporting it

- An Option for (programmable) key mapping within

- Support for at least 5 mapping profiles

But this is pretty unlikely to happen...
The beauty of it is that my question is still valid :-). Let me rephrase it:

Say you got the same salary working in a company that you found more ethical, would you go for the FAANG?

Everyone is different, but it's amazing how many excuses we can find to justify doubling/tripling our salary :-).
Well, clearly I don't need 99% of whatever the bank is doing to send a transaction between two accounts I own. Add to that all the things that many banks continuously fail to provide, like proper OpsSec, transparent fees, full programmability via APIs.

> despite being inferior technology

Could you clarify? Are you talking about a particular protocol, or an implementation component, or mean crypto in general?
Yes, kinda assumed that a bit, since illness do give out a certain smell,,was just wondering what else blossomed from that. Maybe the only superpower is having awareness,,
The billionaires rallying behind Trump after his conviction
Like the idea.

Let’s find those people and put their names into a non-permutable distributed blockchain database in the cloud with public access!
His camera costs $200 and takes 3MP photos with no video capability and poor low light performance.

A $50 trail cam will take at least 10MP photos, will have night vision and will be able to take videos. People have left trail cams out for over a year and they were still taking photos.

Battery life is cool, but if existing devices already have more life than anyone needs what's the point?
> for example, the printing functionality that was moved from libgnomeprint (or whatever it was called) into GTK3 is staying (which makes sense), but menu bars (which have been in GTK since the beginning) are going away because GNOME doesn't use them anymore.

You make it sound like menu bars are removed from GTK4. But I read the article multiple times to find where it says so. From what I understood, menu bars will stay in GTK4 but will not be represented in libadwaita because GNOME doesn't need them.
Makes me wonder what the oldest browser they support is?

Apples to oranges, but I've noticed the Plex PlayStation 4 app just refuses to play some files that work fine in the browser
>write Windows apps using the old user32 APIs and run them in Wine

Honestly, to me this is the actual choice. I've tried using graphics gale (a win32 app) and fire alpaca (a qt app) on linux. Fire alpaca didn't work. Neither the app image nor the windows version on Wine. But graphics gale worked flawlessly.

The future of crossplatform is just everyone writing Win32 API apps, just like every language communicates by a C api.
> Now imagine for a second, that the whole universe was a big cycle, and that you are going to be repeating this very same life in a “future” cycle, and maybe infinitely many times

I've heard this called 'Eternal recurrence of the same' in a past life (pun not intended). It fascinates and terrifies me at the same time.
That is the same problem as generating python that blows up, no? (assuming it is tested in a sandbox)
Off-topic but have we always called vaccines "jabs"? Or is it just a post-COVID thing? (I don't recall seeing it prior, and it almost feels like a dog-whistle to trigger/discourage the anti-vax types.)
Hedge on money printing... Ahem "monetary policy"

Otherwise I agree, although special purpose ones like helium I can see encoding interesting rewards.
Definitely true and a layered defense against data loss / theft has obvious advantages. But take for instance a small SaaS running on a cloud PaaS (e.g., AWS, GCP etc). What it the likelihood of improper disposal of a hard disk? And then what is the likelihood this improperly disposed of hard disk survives the process of removal / improper disposal to then be found by someone nefarious? And then, what is the likelihood that that particular drive was in a volume that contained anything sensitive.

Then what is the cost / overhead / complexity / other cons of adding encryption at rest? Cyber budgets often go crazy I see so many clients that are buying tech based on marketing hype or the security teams lusts for cool tech rather than what reduces the risk the most for the dollars available.
If there's an inference to be drawn here -- it's probably that fans of LeetCode-style interviewing tend to be not such great teammates for a variety of reasons; not persons from a certain countries.
I’d say the author is being so restrictive in the scope of threats that it isn’t very useful.

Regardless, even in their very restrictive scenario, it provides defense in depth as I said.
“The prod.keys allow users to bypass Nintendo’s Technological Measures for digital games; specifically, prod.keys allow users to decrypt and play Nintendo Switch games in unauthorized ways.”

We really can't be allowed to own the things we buy can we. I shouldn't need Nintendo's blessing to emulate their games if I rip them off a cartridge (or digital download) I purchased.
It definitely isn't? Doesn't sound like the nigerian prince scam whatsoever.

They do probably just want a Upwork/Fiverr account, will they do less than legal things with it and get you banned, yeah probably.
{{asking nicely}} do you credit this for something else that’s developed in your life? Just wondering if things like these help us do something else..{{not so serious}}
> is the same

No, it is not the same, but it is quite analogous. The commonality is that obviously you cannot give your job your all, when you have more than one job. It's not like I am defending over employment.

One point of clarification is that you mentioned "2," while Musk is currently the CEO of the following 5 companies: X Corp, Space X, Tesla, Neuralink, and The Boring Company.
> Are you saying that speaking to external beings while tripping is potentially a treatment for mental health?

"External" but really just products of your brain, and yes, I could see how this would be helpful. Taking such drugs seem like giving a whack to the brain to the point you enter a kind of "debug mode"; perhaps some issues that you can't normally untangle are accessible directly in that mode. At the very least, you get to poke at your internal state from angles normally not available to you, so some of your mental blocks could shake loose and fall back into place.

(I wouldn't know, I never took anything like it or had any similar experiences, but that's what I gather from reading countless stories and reports of those who did.)
Mexican mayor killed hours after first woman elected president
Social Security's Financial Outlook: The 2024 Update in Perspective
Always amazed by Terence Tao's clarity of thought.

Not only is he one of the greatest mathematical minds alive (if not the greatest), he is also one of the most eloquent writers on mathematics.

Nothing more beautiful than seeing great science being married with great writing.

Even if you don't understand the specifics, you can always get the big picture.

Thank you, Terence!
Have you taken a look at the build123d "algebra API" yet? It is intended to be near zero magic without any of the with blocks from the "builder API". There are algebra and builder API versions of all of the introductory examples on this page https://build123d.readthedocs.io/en/latest/introductory_exam...
Of course. Her own perspective is her own. But that wasn't that piece. That piece was her trying to tell a larger story. In doing so, she started from her own quite significant ignorance and tried to infer from that a larger story. There is little value in that progression.

In talking with other young folks I see echoes of her misunderstandings. A lot of this is the tool vs oracle discussion. I think there are significant risks where young folks see LLMs as oracles, where they really are better understood as tools. However, many young people don't have the experience to make that distinction.
As I've hit age defined in 3, some of it is also "Anything invented after you're thirty-five is mostly same stuff you had before but upgraded. You are confused why everyone is losing their minds over it."

It reminds me of current AI craze. We had a bit of this in 2016, it didn't go well: https://en.wikipedia.org/wiki/Tay_(chatbot)
I remember reading on a related reddit thread (more about container home costs) that structural costs account for only a small portion of the cost of home-building and that ground and electrical work, plumbing, finishes etc add a big portion
Zero-down mortgages are making a comeback
I don't think it's exactly a scaling issue, its that you can't turn the screws on your users and bill them monthly, siphon their data, and show them ads.
I used to (early 00s) be super big into GA and GP until a professor of mine at the time described the whole class of algorithms as "Marginally better than brute forcing". That really resonated with my experience, and was just too spot-on to ignore.
Sheds and small storage buildings seem like they could be a good use of the technology. Dwelling units and production spaces need utilities, which complicates things. Sheds need a solid base, good walls, a roof (which might be 3D printed in stairstep fashion), and a door. There's a big gap in the market between the metal/resin DIY kits from big box retailers and the prefab sheds delivered by flatbed truck.
The Uncanny Rise of the First AI Beauty Pageant
Volcano Disaster Assistance Program
Flatworm
Will anyone notice a difference?
Why NASA's Europa Clipper mission to Jupiter's icy moon is such a big deal
Do we need to be honest about Fridays?
UK broadcasters trade ad airtime for advertisers' shares
Great article, but unfortunately a determined threat actor would just go to the source and get a remote job as a Cox technician to gain access to millions of routers to add to their botnet. A real solution by the ISP would be to implement a software (or, preferably, hardware) setting that prevents remote access by default unless explicitly enabled by the customer. That approach would slow a social engineering campaign and limit the scope of a hack like this.
Trove of Whaling Logbooks Will Help Scientists Understand Changing Climate
Triggering the “it’s a shot, not a vaccine” gang is like shooting fish in a barrel.
Not entirely sure that Recall won't essentially sidestep most of the protections of the EU privacy laws by touting that the data is stored locally and so it is "yours". Never mind that this basically provides a huge incentive for bad actors to get "your" data however they can. Microsoft will have done all the work of gathering it for them in one easy target.
As you wrote in your own comment, dollars are imaginary. Maybe they get paid in salary, maybe it's equity. Or benefits in the form of healthcare. The important thing is the value of goods and services they can buy. Before, they could rent 3,000 sq foot house and buy 6 cars, now they can only rent a 500 sq ft apartment and buy one car.

Again, if we achieve a flat income distribution by reducing the value of what everyone can it with their income is that a good thing? Everyone's purchasing power is reduced: the 90% can only buy 1/6th as much as they could before, the top 10% 1/60th as much. But since the income distribution is now flat, this is somehow a good thing even according to you though everyone can buy only a fraction of what they could before.

This is what you're seemingly not able to comprehend: the total sum of value in the world isn't static. If I bulldoze a 2 story apartment building and build a 20 story apartment building I've just created a 10x increase in the residential floorspace on that block. If I develop cheap rocket motors I can put satellites into orbit for much less money, and thus enable things like high speed global internet. If I build a much more efficient factory for building cars and tractors, then foods gets much cheaper and farmers can replace draught animals with machinery. And shipping companies can haul much more cargo with trucks. The total value of goods and services in the world can, and is, increased. And it has more than doubled in the span of a typical lifetime for the last century. It doesn't take ages, it happens fast.

Most people who get enormously wealthy do so by founding or investing in companies that do something novel to increase the sum of value. Let's flip the previous analogy on its head: a genie gives you the ability to increase the real purchasing power of 90% of people by 6x, and the top 10% of people by 60x. Is that a bad thing, because the income distribution is now more unequal even though everyone is left strictly better off?
I stopped doing email address obfuscation about 15 years ago, opting instead to add a honeypot email address. Anybody who sends an email to the honeypot is automatically added to a list of senders whose emails get dropped when they're sent to the real address.
In my area, the definitions of prefab or "manufactured" housing used to keep out poverty-associated dwellings have been extended to apply to anything not constructed locally on site.

We're also famous for our "Sears homes", which ironically would be illegal under the modern interpretation of the codes to construct.

Given that I don't think the prejudice is against the materials themselves, bringing the manufacturing on site to fabricate a home is more likely to get new laws written against the process than to fix housing in areas that don't feel they have a particular deficiency of 3D printed homes.
Seems like it could be useful for e2e testing of command line applications
Tesla has already concentrated it's shareholders into an extract that consists entirely of people who crave fantastical promises and don't care much for the reality on the ground.
a shot you may do a few times per year and still get the disease
Without the accelerator addon the Pi5 could do smaller models at passable speed, so I wonder if an accelerator can make this faster and allow larger models.

https://robleshermoso.com/posts/ejecutando-llm-raspberry-pi-...
Hello HN,

We’re excited to unveil Datafinc, an advanced AI business management tool designed to revolutionize data handling and strategic planning for businesses of all sizes.

Why Datafinc?

1.Seamless Data Acquisition: Automatically gather and integrate data from multiple sources without complex APIs or manual entry. Simplify data collection.

2.Robust Data Storage: Secure, well-organized data management that ensures compliance with GDPR and CCPA. Unlimited storage capacity.

3.Efficient Data Transformation: Clean, combine, and aggregate datasets effortlessly. Reduce reliance on costly data specialists.

4.AI-Powered Insights: Predictive analytics and real-time prescriptive insights to optimize operations. Stay ahead of trends.

5.Interactive AI Consultant: Real-time data insights and analysis through an intuitive chat interface. Accessible expertise 24/7.

Why It Matters

Datafinc democratizes access to cutting-edge data management tools, enabling startups and established enterprises to leverage their data more effectively. Gain a competitive edge with advanced AI capabilities.

Join the Waitlist

Get early access and help shape the future of Datafinc.

https://www.datafinc.com/waitlist

Best,
The Datafinc Team
For better.
> No, I mean only sound, not semantic.

But that's my point regarding the paper mentioned above: I have the impression that this viewpoint doesn't match with the way old beards used the language:

> In other words in each of these quotations, the author uses the graphic structure of a character to represent a key notion in the discursive reasoning to support or confirm a reality or a fact. The meaning of the character can be systematically related to the meaning of the graphic components

> [...]

> According to these texts, characters are analysed into pure semantic components: “west” and “rice” for “grain”; “cereal,” “entering” “rice” for “broomcorn millet”; “eight” and “ten” for “tree,” and the choice of the components is essentially explained in terms of the Yin/Yang and Five Elements theories.

Of course, I am well aware of the modern viewpoint, which disregards such systematic semantic interpretations, but I am wondering whether I understand the paper correctly: « were really characters components always understood semantically in the past? »

And I am cautiously wondering about it, precisely because all Chinese speakers I've talked to shrugs the idea off (« am I missing something? »).

> You're making a very unfair comparaison

Alright, but we were talking about ancient scholars, it seems fair to compare them to modern scholars. Let me try to rephrase myself. My point was multiple:

(1) ancient scholars were trained to do science, just not the way we do

(2) not being "trained to do science" in the modern sense isn't sufficient to disregard their viewpoint;

(2') the converse is also true: being "trained to do science" in the modern sense isn't sufficient to validate a viewpoint. Example: many trained scientists or engineers will hold democracy in high-esteem despite the previous "research" & history.

That's to say, I believe it's well worth studying their viewpoints, despite the fact that they "weren't trained to do science," as commonly understood today.
> I’d say the author is being so restrictive in the scope of threats that it isn’t very useful.

Loss of control of the hard disks may have many different ways it can manifest in the real world, but from a cryptography and software development perspective, is congruent to other flavors of the same underlying problem.

That's not being "restrictive", it's recognizing the common denominator.
Computer Architectures, AI and the Alchemy of Scale Transformation
Some positive uses from the other day: https://news.ycombinator.com/item?id=40535636

(Funnily enough the post those comments are on used a Hailo accelerator and Pi cameras, but not actually a Raspberry Pi - it was before this kit was announced.)
Not all investors are only interested in making money. That's why so many investment vehicles take into account ESG scores. Or why people refuse to invest in cigarette companies.
Reminds me a bit of the Shed-to-House projects or shipping container house projects that end up costing nearly as much as a site built home once all of the non-shell costs are added in.
See for yourself:

https://news.berkeley.edu/2023/07/27/james-webb-space-telesc...
This magnanimity is also something prized in Earth-medieval kingship, too. Many a revolt against a king ended with the king pardoning the vassals that rose up -- only a king very secure in his throne could depose or even execute rebellious vassals. Of course, it's important that it be a common member of the nobility for this to work consistently. Against commoners, brutality was far less politically costly. And heretics (read: Kathars), who risk the Wrath of God coming over the whole community, are even less worthy of protection.
Show HN: I created a VSCode duck Extension that makes DevExp more playful
Hey HN,

A few weeks ago when working at my (kinda boring, let's face it) dayjob I started wondering, how could I make all of this more interesting.

So I created QuackTrack a VSCode Extension that adds a cute duck next to the cursor and displays different animations depending of the developer's actions.

This is my first VSCode Extension, so ChatGPT was used heavily on this one.

Thank you for checking it out, I hope you like it!
I saw it a lot in The Economist so I assumed it was some sort of British-ism?
My first thought was using it as a compatibility layer for VT100-style CLI programs. Hypothetically, if we wanted to finally replace VT100 emulation and move to some new legacy-free protocol for terminals, we would need some sort of shim for running legacy VT100 programs and displaying them in our shiny new VT-next terminal. Similar to the `vt` program from plan 9.