skysight-inc/HackerNews huggingface dataset:
Ask HN: What are the open source tools for database subsetting?
I have a very huge Postgres database that I need to clone locally (like 0.01 if its data) and do some tests. I have tried to use Jailer [0] (complicated to use. Like after installing it with the dpkg command, how do we launch it?) or Condenser [1] (intuitive but producing errors). Is there any other open source program to produce a small subset of the data available in a PostgreSQL? Like I like the fact that in Condenser you only tell the config file that you want 1% of the initial data and it does.

[0]: https://github.com/Wisser/Jailer
[1]: https://github.com/TonicAI/condenser
I skipped most of high school. I didn't have a condition. High school was bullshit and pointless. Some people expect me to be repentant for this now that I'm on the wrong side of 25, but I'm not. I was right. It was a waste of my time and I minimized my exposure to idiots who thought they had power over my future.

Maybe instead of asking what's wrong with these kids that they don't want to go to school, ask what's wrong with the schools that kids don't want to go.
Oh definitely, don’t send a large change as a first PR. We are in agreement there.
Tether Says It Will Buy Bitcoin for Stablecoin Reserves Using Realized Profits
The silliness aside, the answer is in the link:

> For the denominator, we use changes in the reported wealth of the Forbes 400 to estimate the income of the 400 wealthiest families.
> When you instruct a human in natural language you can rely on them to do disambiguating and nonsense filtering, which means you don’t need to take the time to phrase things precisely.

This relies on a feature of human communication that the LLMs do not have an approach for: empathy. I am able to discern meaning from ambiguity because I can put myself in your shoes and decide what you probably meant.

Computers can probabalistically guess what was meant in natural language, but it will be missing out on enormous context of who the speaker is and what they're attempting to achieve (granted, you could provide this context in text form to the LLM, but then you are no longer taking advantage of the human ability to disambiguate, instead relying on verbosity and redundancy to constrain the LLM to catching your drift)
Happens to me too. And surely a bunch of others as well, who just don’t voice it.

Defending Firefox and adblock as a fringe case worthy of dismissal is a sad reflection of the current state of the internet.
Sure man: https://en.wikipedia.org/wiki/Roy_Moore#Sexual_misconduct_al...

Totally legal:

> https://www.statista.com/chart/11848/americas-youngest-child...

As our infographic shows, the youngest to marry since 2000 were three ten year olds. According to Frontline, the three girls married men aged 24, 25 and 31 in Tennessee in 2001.

https://www.washingtonpost.com/posteverything/wp/2017/02/10/...

> We learned that in 38 states, more than 167,000 children — almost all of them girls, some as young 12 — were married during that period, mostly to men 18 or older.

> Minors such as Siddiqui can easily be forced into marriage or forced to stay in a marriage. Adults being pressured in this way have options, including access to domestic-violence shelters. But a child who leaves home is considered a runaway; the police try to return her to her family and could even charge our organization criminally if we were to get involved. Most domestic-violence shelters do not accept minors, and youth shelters typically notify parents that their children are there. Child-protective services are usually not a solution, either: Caseworkers point out that preventing legal marriages is not in their mandate.

> Women who marry at 18 or younger face a 23 percent higher risk of heart attack, diabetes, cancer and stroke than do women who marry between ages 19 and 25, partly because early marriage can lead to added stress and forfeited education. Women who wed before 18 also are at increased risk of developing various psychiatric disorders, even when controlling for socio-demographic factors.

> Sherry Johnson of Florida, who said she was raped repeatedly as a child and was pregnant by 11, at which time her mother forced her to marry her 20-year-old rapist under Florida’s pregnancy exception in the 1970s.

Such a church lady of me.
The article mentions a cool hack to make Edge browsers TTS work with your own custom text.
I also made a small extension that automatically reads out prompt answers for Bing chat like this.
https://microsoftedge.microsoft.com/addons/detail/your-perso...
Bundling and minimizing can very significantly reduce code size, by eliminating unused code.

This is beyond the stripping comments, whitespace, renaming all symbols to short identifiers, replacing idiomatic constructs with shorter equivalents, etc. that people expect minifiers to be doing.

Bundling with tree shaking can get rid of a lot of code that would otherwise need to be downloaded. This is especially the case when using only a subset of functionality from a larger library.

Otherwise, for most libraries, if you pull in a single function, every single module from that library will also get loaded. This applies both the pre-bundled libraries (i.e. where there is only one large module, so obviously everything gets downloaded), and non-bundled libraries, because most libraries have you import from an "index.(m)js" module, that exports all the various public API of the library. Which means a browser with import maps will need to download all those files, and all files they import, which will be basically every module in the library.

Minimizers themselves often also have some sophisticated dead code elimination. Indeed, one potential (but inefficient) way to implement tree shaking is simply to bundler without shaking, while using module concatenation, and then simply passing it to a minifier with good dead code elimination capabilities. This would be able to eliminate basically anything tree shaking could, and more. The more comes from both from any eliminable code the bundler would not know how to eliminate, but also being able to eliminate anything that was only imported by said dead code.

This is one of reasons why uncompressed minified code can sometimes beat out the compressed original code, and is still at least somewhat compressible itself. Of course I have not even touched on having fewer files to download (which still has meaningful overhead), nor the smaller resulting codebase being faster to parse than the.

Lastly, but not least, many people want to use typescript or jsx when writing their code, which means the code needs to be pre-processed before a JavaScript engine will read it. If you already have a compile step, then adding bundling and minimizing on top of that can be relatively simple and make good sense for the above reasons. (Note can be simple. It depends a lot on what tools you use. Webpack for example can get really complicated, but it also offers some really powerful features.)
Right ISO 8601... in SQL Server it's the unambiguous format
This implies some sort of malicious intent on the part of the Go maintainers, which doesn't really seem fair given the way the original proposal was written and how feedback was incorporated.
As I understand it from reading the article, they can take all of your coins.
I would agree with him to a point. Productivity on full remote workers can be difficult to track and is likely not higher than in office. When I worked from home full time, it was more difficult to maintain productivity as much as while in office. Also, the psychological benefits of in office work definitely come into play here. I believe a hybrid approach is the best and has many benefits (which I won't go into for brevity)
wow, you really like dismissing pretty obvious evidence that zinc plays a role in Alzheimer's.

It is not complex, it is simple. I believe it is a metabolic disease caused by metabolic disease and genetic risk. That will be unique for everyone, but for most people I feel the answer will be poor zinc handling.

And Niacin is all you can come up with? Did you know we make niacin if we have enough B6 and B2?
> AI can’t do hiring because it lacks the data

Challenge accepted.
This is my personal opinion and not legal advice. IANA trademark practitioner.

Before the EUTM [0], the EU trade mark office, they're currently in opposition proceedings with no oppositions registered.

AFAIK the term GPT is entirely descriptive (so not distinctive) and so is unsuitable for use as a trademark. It should be refused, but I wouldn't expect trademark examiners to have heard of generative-pretraining, nor that this can be applied to transformers to make a gpt. Unless someone tells them then I expect the application by OpenAI would be allowed.

That said, OpenAI can use the term "trademark" if they're using that term as a mark of origin for goods or services, it doesn't need to be registered first (at which point it becomes an RTM and can use the (R) symbol). Indeed you can register a mark as having acquired distinctiveness through your prior use as a trademark ("acquired distinctiveness").

[0] https://euipo.europa.eu/eSearch/#details/trademarks/01883665...
End user operations will be 100% Windows based and I won't be involved in the operation long term. Also, whoever is, probably won't know Linux at all, let alone at a sys admin level.

But I like the idea of having one machine to maintain. What's the best mechanic for that on Windows?
Yeah have thought about it, we have a fairly large community on discord that could help out too.
I didn't want people clipping their signal too hard with the EQ, hence the current limit. I'd probably need to think about adding a limiter for the sake of people's speakers.

You can instead turn ethe other frequencies down and then your volume up, same effect ;)
There is a sizeable group of people - of whom I am one - who accept that software telemetry is incredibly valuable for making decisions about the future of a project. They simply want the use of it to be their choice.

Continuing to hold this opinion does not imply that their opinions have somehow been manipulated or changed.

As for the Overton Window - telemetry has been a part of software since the internet was a thing. And it will continue to be a thing long into the future. I just fight to keep it as a choice for the user.
This is demonstrably wrong. It can clearly generate unique text not from it's training corpus and can successfully answer logic based questions that were also not in it's training corpus.

Another paper not from Msft showing emergent task capabilities across a variety of LLMs as scale increases.

https://arxiv.org/pdf/2206.07682.pdf

You can hem and haw all you want but the reality is these models have internal representations of the world that can be probed via prompts. They are not stochastic parrots no matter how much you shout in the wind that they are.
I can certainly understand that maybe the salaries should not be claimed back, for for sure the bonuses must be given under some condition that if the bank/company fails within X years of receiving it, the bonuses should be returned in full, otherwise there is simply no responsibility for carelessness.
Models are worthless without reproducible training anyway. What good is a point in time model if you can't update it going forward.
What the hell are they doing to pupils at schools in the US?! I mean, literally, how are the US schools differ from the other countries ones?

Please share something, as it's not clear at all for those non-US citizens.
OpenAI Disrupting the Meaning of “Open”
OpenAI pulling the ladder up behind them
Most people with kids do not own their home and live paycheck to paycheck for what it's worth.
The planes used for long flights typically have power outlets, in my experience. Trains too but my experience is more limited there.
> The point of serialization is precisely to make stolen parts unviable economically, so you’ve painted yourself into a bit of a corner there.

Assuming this kind of lock is unbreakable and all the parts in the phone are locked, you mean, which is a big assumption in the long run. A side effect is that you can't reuse parts from a bricked phone in another, which increases waste without actually addressing the problem which is access to spare parts.

> I believe genuine parts cost more because they are better, not due to artificial scarcity

Price is not the only restriction, but also the number of parts you can order, having to send back the damaged one (which prevents stocking on spare parts for the future) and the exclusion of third party repair shops. In any case I acknowledged that what apple did is indeed a good step, but the repair system can be improved.
Did you learn anything about going to bat for racists?
this is fantastic. only the other day i was wondering how i would replace my mx master mouse battery when the time comes.

it may not be perfect but this is a big step in the right direction. well done logitech.
School shootings are still insanely rare. When you account for high crime areas the likelihood of an average kid experiencing a school shooting is so low it should make you question anyone trying to make it seem otherwise.
They must be trying to sell a premium support subscription or something
> Demsky sought help from educators, doctors and counselors, trying to understand what was stopping her son from going to school for nearly a year. Finally, a psychiatrist told Demsky about a condition that affects a growing number of students with severe anxiety: school avoidance.

>“It was almost like a revelation,” she told USA TODAY.

The psychiatrist basically repeated back the description of the son's behavior and called it a diagnosis (and charged money).
Probably help some of them:

https://www.nature.com/articles/s41598-021-94124-5

B6 increases dopamine so that might play a role as well.
Interesting to see hp hit the front page twice in one week, once for "hp is the most vile business and their executives should be in jail" and then moments later "ooh, pretty laptop!"

Seems like HP should be pretty universally reviled around here. Surprised to see an ad for them pop up.
Looks expensive, but very nice. I paid about $300 for a Lenovo Chromebook, that even though is much less powerful hardware, still seems like way more for the money. I like it when I travel because with the Linux container support I can program, is small and cheap (don’t worry about losing it) and works for consuming content.
National Videogame Museum in Frisco, TX https://nvmusa.org/
Too many startups doing developer tools? And HN is the best place to each to the developers? GitHub could become a good developer focused social network, until then HN is the best:)
Maybe the USPS? No way I'd trust them
Large Language Models from scratch (2022)
For my part: it didn't used to be called that, and feels like software folks trying to feel fancier than they are (and/or whitewashing bad practices by pushing new-to-the-industry terminology that makes spying sound scientific)

Though at this point it's been widespread long enough that I suppose it's just a normal term that's "always been used", to some developers, not a new, alien-feeling part of the software lexicon.
> Your "Whys" quickly end with "because so-and-so said so", and will change tomorrow.

The "5 whys" always seemed to stop just short of formally identifying the root cause of conflicting management techniques, inexperienced decision makers, poor planning and people not understanding the technology they were making decisions and deadlines around.

I saw this first hand a couple years back, except... we always seemed to stop one step short of the "so and so said so" because... "we don't want to blame people". So often it would stop at me, instead of going one more level up beyond me to the people who gave me impossible/contradictory things to do.

So, to get past the "no blame" thing, I got "we're not 'blaming' you, but perhaps you need more training on X" and that sort of thing. I've been doing this professionally longer than most of the rest of the team have been adults (or in some cases, alive)... no, I don't need more training on X. The system didn't fail because I hit a problem with X. The system failed because 3 people set too many deadlines concurrently, and when it was pointed out to everyone (individually, then in a group setting), no one would budge and I get told "just make it happen". Laws of physics, etc.

But... let's make sure we don't "blame" people! Just... it's OK if we blame you, we just won't call it 'blame'. We're just "identifying".
I love Retro from the UK. As a German, it much better reflects my childhood in the 80s with CPCs, Sinclairs, Archimedes' and Atari STs - computers that to me feel forgotten by US Retroism.
Brb trying this with Wizard
I agree for me personally. However I truly believe some people do better work 100% remote or fully in office. I don’t understand why it needs to be the same for everybody.
If you truly skipped most of high school and succeeded, then you're the exception. Most people that take that route end up in a dead-end job, prison, drug addiction, homelessness, or endless other problems.

Sure, school isn't perfect and has its issues, but kids skipping school is a big problem.
I was in the same boat. I subconsciously reached for ways to distract my mind whenever it didn't have something to occupy itself with.

- When I was doing the dishes, I would immediately put a podcast on

- When I was waiting for my kid's music lesson, I would immediately grab a book to read

- When I was eating, I would always turn the TV on

- When I was sitting on the couch, to supposedly rest, I would put a music record on and I would also reach for my mobile phone to "catch up" or text a friend

- When I lie to bed, I immediately would grab my phone to browse HN

I realized that these were harmful habits that I subconsciously formed as a way to distract my mind from other thoughts that were causing stress and anxiety.

These days I'm more mindful about this and I try to just sit there by myself and just be. Kinda like meditation.
Captain Kirk would be proud.
Chromebooks come with an option to run a linux subsystem. It is fairly nice I can use the chromebook as intended and also hack on other things in linux.

Not the same but the option is there.
We should all stop using GPT and use LLM instead , it's easy. Right here, right now, just dont use GPT, if all competitors use LLM instead , it will become even more widely recognizable than GPT
That's nice to hear, but 16" is awfully big. I know, I'm hard to satisfy... So I'll probably just continue to buy old Thinkpads, as they are my "Frameworks" as they are also incredibly serviceable. But well, they are starting to get pretty slow...
Wow, that's something you don't see everyday!

(an use case for SPAs I mean)
Letting the police mediate mental health issues seems like a flawless plan.
Langton's ant is really cool, especially considering the extremely simple rules.

- At a white square, turn 90 degrees clockwise, flip the color of the square, move forward one unit.

- At a black square, turn 90 degrees counter-clockwise, flip the color of the square, move forward one unit.

If you look at the images and animations, you might think that it becomes repetitive quickly, and nothing interesting happens. But that is only if you have an infinite grid.

If you have a grid that wraps to the opposite side on the edges, it interacts with its own path a lot more. This produces very chaotic and "random" results. In fact, I've made a toy PRNG based on Langton's ant, and it does quite well on PractRand. It's not a performance king, far from it, but still really cool that two simple rules can do that.

It would be a fun project to make a (probably very slow) cipher based on Langton's ant.
I hate that settings like this are not given a UI.
On the contrary, increasing mortgage mobility should lower prices.

In most cases the mortgager is selling their old house and buying another, keeping the same supply/demand balance. But in some cases the mortgager is selling one house and building a new one, increasing supply and lowering prices.
As it stands now, modern recruiting is roughly the same as an AI recruiter.

Scrape 10,000 emails/basic biographics and email blast everyone with an exciting opportunity at an {X} company doing {Y} thing that raised {Z} money. Insert unlimited leave, work life balance, and some other thing no one cares about but the company.
The funny part about this is that PandasAI was apparently able to figure out what he intended to type in making that simple histogram. There must be some autocorrection buried in the pile of algorithms at work there.

His request was for PandasAI to -

"Plot the histogram of countries showing for each the gpd,..."

The histogram was constructed correctly according to what he thought he typed. Scary mind-reading stuff here with that AI stepping in and correcting our defective requests without even asking - " Did you mean to request GDP?"

This AI could serve as the annoying know-it-all at all of your parties, correcting everyone's anecdotes and misconceptions in real time. It only needs a high-pitched nasal voice with a simulated west Texas drawl playing from your Alexa or on-screen as a Poindexter-in-a-Stetson avatar.
I thought this was a pretty smart take on the whole “got fentanyl on my skin” issue, by a retired law enforcement officer:

https://thelawdogfiles.com/2023/05/fentanyl-and-you.html
> you’re not artificially restricted by the mental model encoded in the API

Most of the time I want a restricted mental model because I have so many API's to deal with that if they are not restricted my "mental model" breaks down. Suppose I am using a sockets library. I want to use that like a black box. I don't want that code arbitrarily mixed in with my code. I want to be able to debug my code separately because I assume that 99% of the time the bug is in my code and not the sockets lib etc. etc.

Even when most of the code is my own I will still split it into modules and try to make those as black box as possible in order to manage complexity.
The author claims that people's offering of help is not true help since it's for selfish reasons. I would like to argue that this is natural and necessary to some extent. People are motivated by what benefits them personally.

All your relationships, pretty much everything you do, has a selfish aspect to it. You're not in a relationship with someone because you're being kind towards them, you're in a relationship because it benefits you, and hopefully it's mutually beneficial.

So, you need to let people be just a little bit selfish, because you need them to be motivated. Without people working for the sake of personal motivation, open source wouldn't work.
I hate this take because I hear it all the time and it's simply incorrect, at least in relation to Holmes' case.

In a court of law you need to prove your case, with evidence, beyond a reasonable doubt. The evidence that Holmes lied to investors for the purposes of getting money, and that she knew she was lying and did it purposefully, was undeniable - there were too many smoking guns. The evidence that she knew she was defrauding patients was always less clear cut.

Besides, the prosecutors did try mightily to convict her of crimes against patients. Are you saying the 12 randomly selected jurors who found her not guilty of these crimes are in cahoots with "the current state of the justice system"?
Houses are useless as money because their value keeps changing and they're worth too much indivisibly. But we don't even try to use houses to buy a pizza, so that's okay.

Digital money should be small enough to carry on your person, be divisible into small chunks, and its value should not wildly fluctuate from day to day. Bitcoin meets the first two of those criteria, but it violates the third. That makes it impossible to use Bitcoin to buy a pizza. (Although it did work for pizza for a brief time in the early days before its volatility became outrageous.)
It's called "spyware" when you don't trust the collector to be acting in good faith.