skysight-inc/HackerNews huggingface dataset:
Show HN: DaLMatian – Text2sql that works
Hey HN, we've built DaLMatian, a text2sql product that meets the needs of data analysts working with enterprise data. We built this app because as a data analyst at an enterprise I could not find a text2sql product that was (1) actually useful for my day-to-day and (2) easy to set up on my computer. Existing products either fall apart when tested on gnarly enterprise data/queries or require going through a sales/integration process that I wasn't in a position to push for - I just wanted something that I could quickly set up to help make my job easier. Our goal is to make this a reality for any data analyst that feels the same.

There are many constraints that make this reality difficult to achieve. The product needs to scale to databases with millions of columns and extract business logic from very complex queries. It also needs to be fast, at least faster than an analyst would take to write the query. On top of all this, an analyst needs to be allowed to use it from a security standpoint. Our app meets all the key requirements of an enterprise data analyst while also being lightweight enough to run locally on a typical laptop.

Here's how it works. To get started, you simply need to open a file of past queries in our IDE (try it here: https://www.dalmatian.ai/download) and add a file with your database schema (instructions here: https://www.dalmatian.ai/docs#configuration). There is also an option to connect a database to auto pull your schema (no actual data is seen by the LLM). We do not see anything you input since the app is local and the only external connection is with OpenAI. It's just like asking ChatGPT for help with queries, but in a streamlined way.

If you'd download our free IDE and try to break it, we'd love to hear what you come up with!
It's not. And you can't add any more.
This is pure craftsmanship. A heavy undertaking TBH, kind of reinventing browser flow on top of browser primitives.
Y'all have built something cool. I'm excited to see where it goes from here.

If there's anything the pgrx team can do to help, just let us know.
See here for details: https://developer.apple.com/documentation/security/keychain_...
But sideloading is viable for everything else... I think that's the core argument that makes what Apple does criminal
I’ve got an Intel Pro that would very slightly shock me when plugged in. It’d feel like the edge of the case had jabbed me a little, when it did it. I could imagine this being an electrical effect. User claims this has been while unplugged, though, so must be a different issue even if it is electrical.

Or maybe their laptop got exposed to some nasty levels of radiation.
You could also frame it as they sold you an NFC capable phone and not really providing NFC functionality, which doesn't seem fair or at least deceptive.
Ontario sued for halting basic income pilot
How about "Hackers Found a Way to Open Any of 3 Million Hotel Keycard Locks in Seconds" its only 75 characters. Nobody has to guess about abbreviations or whether it's really Latin or mm.
One thing I hope they mention: Apple put in proprietary extensions to give Apple-made Bluetooth headphones an advantage over all others, then removed the headphone jacks.
How does VitePress compare to Jekyll in terms of developer-friendliness and page build times? I still use Jekyll for small projects because it is well-documented and just works.
I'll never understand why people insist on making tools that depend on non-standard/illegal HTML when HTML is perfectly extensible. Authors are free to invent custom tag names (according to some rules) and free to create attributes (according to some rules) but this appears to break those rules and depends on people authoring invalid illegal HTML.

Why can't we extend standards-based languages using the built-in custom extensibility they already have?
It's always easy to show that something isn't perfect: just find a counterexample.

It's also easy to multiply that tactic by insinuating that this means that it isn't good, or isn't better than the competition. Which is what you're doing here.
Already considered in my comment.

> Imagine that there's a little computer inside each neuron that decides when it needs to do work

Yah, there's -bajillions- of floating point operation equivalents happening in a neuron deciding what to do. They're probably not all functional.

BUT, that's why I said the "useful parts" of the decision:

It may take more than the equivalent of one floating point operation to decide whether to fire. For instance, if you are weighting multiple inputs to the neuron differently to decide whether to fire now, that would require multiple multiplications of those inputs. If you consider whether you have fired recently, that's more work too.

Neurons do all of these things, and more, and these things are known to be functional-- not mere implementation details. A computer cannot make an equivalent choice in one floating point operation.

Of course, this doesn't mean that the brain is optimal-- perhaps you can do far less work. But if we're going to use it as a model to estimate scale, we have to consider what actual equivalent work is.
> And regarding your quote of the Christians: They don't live it either or never lived. The dark ages produced a lot of christian focused 'art' full of gold.

There have always been Christians who at least tried to live it. They're in the minority and they weren't and aren't the ones you hear much about (or from) but that's kind of the point.
My M2 pro tries to ground itself through my arm on occasion when using it while it is charging so I wouldn’t put it passed apple
I agree with you on your comments about his contributions, but that doesn't mean he deserves the title of Founder of Tesla (Nor does Aaron, RIP).

Neither of them FOUNDED the company, they joined in later on.
What you're missing is that up until relatively recently, folks were still holding out hope that Reddit could remain a place that was enjoyable to interact with regularly. It's only the last 5 years that it has completely degraded into an obnoxious hellscape that you occasionally have to pinch your nose and deal with to extract some information that is unfortunately buried there. Facebook, on the other hand, degraded into a hellscape a long, long time ago. The facebook wounds have healed, whereas the reddit wounds are fresh. Plus, people liked using Reddit a lot more than they ever liked Facebook at their respective peaks. You're seeing people coping with a deeper and more recent loss.
Depends on what, exactly, you mean by "trust", I think.

Personally, I can't think of anything that would make a cloud solution attractive. They provide too much downside for no upside to me.

However, I could imagine use cases (that I don't have) that would make using a cloud solution a reasonable thing.
> For the payment situation for example, Apple Pay (and Google Pay) use EMV Tokenization so that your actual credit card number is obfuscated

As does Samsung Pay. As could any number of tap to pay providers, if Apple would let them on iOS.
Nobody needs a games console, but a smartphone is increasingly an essential part of daily life - for things like accessing government services, transport, payments, identity, commerce etc.

If you are a company or other organisation that depends on making your service available through smartphones, then you may be affected by Apple's policies.
I would bet most people buying tracking devices know those tracking devices are tracking location.

The point is Apple as a platform provider made something (location without warning) on the platform available to themselves as a platform user (Airtags), that they didn't make available to other platform users who are their competitors (Tile).
Perhaps I'm missing something, but why can't we render HTML directly onto the canvas in the browser? The parser is there, the layout engine is already implemented, and the calculation of box layout is already done. It should be doable without going in circles. If only the browser had a flag indicating which "surface" to render on.

I was looking at Glide Grid the other day, and it renders so fast, even with 1 million rows; it's somehow responsive. There should be an easier way to render HTML to canvas without resorting to low-level primitives. Why is canvas faster than the "regular" DOM renderer?
Sure, but on my Android smartphone, my bank still has the ability to implement their own payment solution using NFC directly using their app, which is something they did and offer as an alternative next to Google Pay. It even has certain advantages, such as allowing one to unlock a banks doors outside regular hours to access the self-service area for things that are beyond regular ATMs, something that currently does not work with Google or Apple Pay.

On iOS, my bank does not get to offer that ability, and I do not get that choice. If I owned an iPhone and wanted to do something like deposit some cash, pickup or ship a package via the postal service (as our postal service has the same security measures) outside business hours without a physical credit or debit card, I'd be out of luck, because of Apple's restrictive nature.

Having talked to a few of my friends and family, a lot of Apple Pay users are surprised and/or unaware that this is even an option they could have, and I am certain that at some point, Apple will implement something similar, whereupon Google Pay will also enable such functionality, cause the industry does follow Apple to a large extent when it comes to what is considered the minimum of neceessary features one has to offer.

But until then, I see this as restricting innovation, similar to how AT&T prevented a lot of developments, and we got the internet in its current state in part thanks to antitrust action against them, which they promised, we'd regret in a similar manner to Apple today.
Representation Engineering and Control Vectors – Neuroscience for LLMs
I'm presenting this at a paper club in San Diego tonight; I wrote this article in preparation. The Representation Engineering paper is fascinating, and I had to write about it and get some experimental hands on time with it.
I'm with you. I think having an optimized production inference serving framework on the deployment side has the potential to make your project the best of all worlds, essentially.

Of course there are other really advanced use cases and alternative ways to go about this but that would go a very long way.

Also FWIW Nvidia Triton Inference server is even more performant than vLLM and supports dynamic batching, quantization, paging, KV cache, blah blah blah in addition to being able to load multiple models today whether they be LLMs, ONNX, whatever across all of the available backends.

Significantly more complex in terms of deployment but wanted to mention it in terms of being able to load multiple models concurrently in an efficient and performant manner.
Two executives combined my over $300 million or better than a third of the total operating revenue and they "can't" pay moderators.
There is no procedural method or recipe in which would lead to someone finding their purpose like that. This purpose isn't a purely objective and externalized thing. To do otherwise, it would be no different than partaking in one of those FB quizzes that would, based upon some input, spit out which Harry Potter House you belong to, or what kind of D&D class you have.

You have to take the time to allow yourself to be aware of what's going on within yourself, and what's going on in the community around you. This "awareness" isn't the same as collecting data, or constructing thoughts that interpret things. It's not an easy thing to convey, since many people will take what I'm saying here and turn it into yet another recipe. And if I then say, it's more like mindfulness meditation, then all sorts of ideas and interpretation gets added to that, making it far away from I'm saying here.

I'm not very articulate about this. But maybe Carol Sanford's _Regenerative Life_ would better able to convey just how to find your unique contribution to that which is greater than yourself.
In 2005, i compiled linux kernel in 15 minutes on AMD Duron 700. Is true that was a very optimized kernel for my architecture, but i think that the typical kernel with all modules could get 1 hour or something.
So will I. That does not diminish the point of my previous comment. I'd still like to be able to run a quality, open, OS on Apple's hardware though.
I don't know why, but for some reason why I see something like this, I can't help but imagine what it must be like for Tim Cook receiving this news when he is randomly going about his day. It's got to be a huge punch to the face and I wonder how such people deal with such news.
It is astronomical if you take it every day for 5 years.

It is not if you take it during winter months.
Just posted a comment saying the exact same myself lmao
here is an up to date list of steel framed bikes with eye watering pricetags

https://www.theproscloset.com/blogs/news/steel-is-real-12-st...
Good, but no one really cares of fast loading of pages. Either 0.1 or 1 sec, or even 2-3 sec. Most important is if the website contains useful information.
I really hope they have this realization about chat soon.
That's also ahistorical.

The green bubbles came first.

iMessage didn't even exist for the first few years of the iPhone's life. All messages were green. Green could not have been chosen to indicate it cost money, because there was nothing to distinguish it from.

Then, in 2011 (IIRC), iMessage was introduced, and the blue bubbles were to indicate both that it doesn't cost money, and that it supports several other capabilities (which have changed over the years—IIRC, it did not start out with end-to-end encryption, so the people boldly asserting that that's the primary reason for the distinction are also wrong).
In Vermont, 'Town Meeting' is democracy
There is a discussion related to naming on GitHub: https://github.com/vuejs/vitepress/discussions/548

Given that version 1 landed as "VitePress" they probably decided to keep the name.

> I initially gave VitePress a different name because I wanted to be able to explore a different architecture without worrying about backwards compat. After shipping the vuejs.org with VitePress, I believe VitePress is flexible enough to be a full replacement of current VuePress while offering better DX and better performance.

> ...

> I think we should ship VitePress stable as VuePress 3, but I am open to potential questions and concerns.

> Pros: Less confusion in the long run. There will be just one officially maintained SSG with better DX, better performance, and customization that fully aligns with standard Vite-based Vue apps.

> Cons: Potential confusion in the short run, since there are probably a lot of tutorials / integrations targeting VuePress 1. Still I think with the recent Vue 3 switch, users won't be surprised with a major upgrade for VuePress.
Regardless of the size, it does that make it okay to hamper competition like they do.

If this was such an insignificant niche, Apple Watch wouldn't even exist, would it?
"The tech giant prevented other companies from offering applications that compete with Apple products like its digital wallet, which could diminish the value of the iPhone, the government said."

They literally offer APIs for any company to integrate with their wallet. As a consumer, I wish more apps would do so instead of half-heartedly implementing their own thing.
Internet death threats are so common and boring that I only notice the amusingly new ones, like “I hope you can take advantage of Canadian healthcare.”
Or you can look at the cut off date of competitive sports players and athletes. If January 1st is the cut off for age there will be a disproportionate number of players born in December. If it's June 1st many of the players will have birthdates in May and April.
> Apple has an advantage that they can come pre-installed.

Not only that, apparently updates automatically push their apps on you as well, without even asking. Suddenly I had a "Journal" app added to my homescreen from nowhere, and I thought my device had been hacked before I realized what was going on.

Apple also have the advantage of not having to follow their own rules. Their apps can send notifications without asking for permission about it. "Journal" again is an example here where the app sent me a notification and after going to the app, then they asked me for permission to send notifications.
It's been about two years since I regularly interviewed people (and longer since I was interviewed), but imagine some of the following might still be helpful.

Presumably, you're interviewing people you want to work with on your team, which is not just about technical skill, but also trust, the ability to communicate, etc.

Repeatedly ask candidates to explain what they're doing and thinking. Rote reading off some text in another window or copy-pasting should be a dead giveaway you don't want to work with the person, particularly if you've asked them not to use AI tools.

Make your interview problem open-ended enough that you can calibrate for somewhat varying ability / nervousness / surprises. If your workplace allows use of AI tools (I imagine the list of those that don't is shrinking rapidly), consider allowing them during the interview but ask them to disclose their use, just as you would expect your colleagues to do while working with you. Someone using, say, Copilot should be able to explain why they are accepting or rejecting the tool's suggestions and show they can adapt the results to suit, on the fly.

If I were a candidate in your interview, asking for anything intrusive such as a phone camera pointed at the keyboard, etc. would likely be an instant deal-breaker for me. Remember that they are (or should be) interviewing you as well.

In my last few jobs we had interview segments which were purely hands-on coding, and other segments which were more design oriented and conversational. I imagine (and now I'm thinking more broadly than your company in particular) that as the tools get better, you'll see more places allowing AI tools for hands-on work, but an increased emphasis on communicating and problem solving. These design problems can be hard to come up with and facilitate, but they can also tell you a lot about how the candidate will communicate, and think on the fly.

Good luck!
Reading about a thing versus doing that thing
Reading about a thing is often easier than actually doing that thing, e.g., reading about how to build a business versus actually building a business.

The reading part can often feel easy, and you might have high motivation during that time. It feels like you're getting smarter, and you might envision yourself applying that knowledge in the future -- the thing you're reading about just seems to make sense.

But then, after the reading, when you have to start doing, you might not feel such high motivation anymore. It turns out that the thing was actually harder than what you thought, and suddenly you have to start using your problem-solving skills. You feel frustrated.

After a while, this can cycle can make you feel like reading is just a distraction from actually getting stuff done. You start thinking that you should always be doing the hard work, rather than the easy work (reading). The satisfaction and entertainment you get from the reading part, might make you feel like you're not working hard.

This is wrong, though. It shouldn't make you not read.

If you feel like reading about something might turn out useful, but you're being held off by the fact that it's going to be satisfying, *stop.* You should read about it. It's okay to feel highly motivated while reading about it, but then be on low motivation while actually doing it.

This is because reading will give you new ideas, expose you to different viewpoints, and enhance your understanding of topics. You are going to apply the stuff you read subconsciously when solving problems.
The problem here is that platform is not precise. You could say this means that Apple should just make the iPhone hardware, and software vendors should compete to create operating systems for it. There's no hard line.
You can lookup the number of the jail they are supposedly in.

There was a scam attempt against me that spoofed the caller-id to look like the county sheriff; scammer would not agree to me calling them back on that (or any other) number for the sheriff.
I guess Apple switched to those new plutonium batteries:

https://www.independent.co.uk/tech/nuclear-battery-betavolt-...
Raising capital in a new industry sucks, lol. A cushy job is still a job, and the human brain does a REALLY good job at building the same amount of attrition across roles in relativity - whether you're breaking your back in the mine or cold-calling 400 people a day from a Herman Miller chair.
Profile is 2k as it is a combination of both the 1k comment/post listings, iirc.
Not mine cause we leave those people out. It's not Apple's fault that SMS sucks, and RCS adoption was very slow even on Android. Even with all Android phones, a group chat is a disaster unless they use FB Messenger or WhatsApp, which is in fact what most people use. Market working as intended there.
Anyone shorting the stock?
It could already but doesn't have enough users
I generally agree with your sentiment, maybe more when it comes to people like Donald Trump or SBF...

But what do you want them to do? Build a shitty case in 1 year and get destroyed in court?

Remember, Apple has thousands of lawyers too, they aren't going to settle this case.
The real way they do it is by offering a nice job in IT to somebody with a passable written English (read Indian), then traffic them to Shan states in Myanmar and beat them into doing it. Apparently it scales better and is more predictable than LLM.
Damn, thats pretty fast. Maybe I was doing something wrong in the config step?
Are you sure JPL needs supercomputers to calculate flight plans? Please, if you know of more details, I'd like to see them. I was reading the NASA supercomputer complaint and it looks like trajectories can be calculated on extremely conventional small high performance computers now.
Speaking as a cryptography implementer, yes, these drive us up the wall.

However, crypto coprocessors would be a tremendously disruptive solution: we'd need to build mountains of scaffolding to allow switching to and off these cores, and to share memory with them, etc.

Even more critically, you can't just move the RSA multiplication to those cores and call it a day. The key is probably parsed from somewhere, right? Does the parser need to run on a crypto core? What if it comes over the network? And if you even manage to protect all the keys, what if a CPU side channel leaks the message you encrypted? Are you ok with it just because it's not a key? The only reason we don't see these attacks against non-crypto code is that finding targets is very application specific, while in crypto libraries everyone can agree leaking a key is bad.

No, processor designers "just" need to stop violating assumptions, or at least talk to us before doing it.
Because Apple makes sure that, in a messaging group, if a single user is not an iPhone, the whole group messaging is degraded.

Dark patterns that creates incentives for discrimination against non iPhone users.

See: https://news.ycombinator.com/item?id=39780085
The bubbles are green if you talk to someone with an Android, and they're blue if you talk to someone with an iPhone. People simplify this by saying "you have blue bubbles."
Yes how easy would it be to auto-detect unusual activity on their systems likely to be scammers?
How many people ring random numbers 24/7 in foreign countries for legitimate reasons for example?
It quite literally does not. Step one: walk into any store and buy an Android. Step two: have your phone service transferred to that Android. Step three: there is no step three.

People do this every day. Hundreds of them, at least. Every day.
Not sure about this. Many big tech companies are very productive an generate a lot of income.