skysight-inc/HackerNews huggingface dataset:
This is false. In fact, I filed the first BBB complaint.
| How well do foreign data wrappers work with Postgres's query planner?

You can provide table size estimation to Postgres's query planner in wrappers using `get_rel_size()` function, here is doc:

https://docs.rs/supabase-wrappers/latest/supabase_wrappers/i...

| Also, is the Firebase connector for Realtime Database or Firestore?

It is for Firestore, Realtime Database is not supported yet.
To the artists it didn't really matter whether they were bitten by the cats (the record labels) or by the dogs (the pirates), they ended up losing out anyway. This is because artists are less motivated than either pirates (who have nothing better to do) or record label executives and their cronies (who are protecting their income stream). Artists are a rule are happy to be making enough money to be able to continue to make art. And that makes them the vulnerable party in these transactions. Witness the countless accounts of abuse by record companies of bands and individual artists, including bookkeeping tricks, contractual abuse and so on.
I think elonjet also has a sub on reddit. Will reddit links be banned from twitter soon? Any website that mentions elonjet? lol
What was the dbt replacement?
> closed the deal because he believed he could "flip" Twitter, if not for a profit, for less than a settlement would have cost

I think he closed it because he and his billionaire buddies didn't want to go through court depositions. Who knows what shenanigans might have been exposed from that.
It's worth noting that OpenAI mixed it up and is not using the GPT-2 tokenizer this time.

It's unclear what tokenizer they are using and the documentation is being coy about it. It could be a more efficient or a less efficient tokenizer.
Did anyone claim a linear (let alone 1:1) gain?

This was the relevant part of what you replied to:

> It doesn't certainly doesn't mean anything as broad as "a company cannot do more things by increasing its employee count."
What guarantees can you give me that your database won’t eat my data? Query speed is important, but I’m conservative with my choice of data store for a reason: its the worst possible thing to find a bug in.
To each their own. Personally, if I'm hacking on a hobby project, the last thing I want to do is read government standards documents and set up meetings with law enforcement IT people. If I were forced to do so, I would just start model railroading instead.
Applications that care about length extension attacks: https://en.wikipedia.org/wiki/Length_extension_attack (though most applications shouldn't care about it, and not all functions in the SHA-2 family are vulnerable to it, as tptacek notes. See https://en.wikipedia.org/wiki/SHA-2#Comparison_of_SHA_functi...).
> The problem is the massive leaps of logic being made by people who have (quite wrongly, based on available evidence) become convinced that the vaccines are a greater threat to healthy people than the virus is.

That may be true overall (and it may not btw, only time will tell), but it's certainly not true on a by-indvidual basis. Someone who's, say, 18 with no major health disorders is going to experience a lot more risk of adverse outcome from any of the vaccines than from SARS-CoV-2. That's partially a function of the incredible SARS-CoV-2 outcomes in the "not old" age range but also because vaccination is also a fundamentally different intervention than exposure to the entire SARS-CoV-2 virus. If we're talking about the mRNA vaccines (Pfizer/moderna/etc), those are basically spike protein mRNA suspended in lipid nanoparticles. It makes your cells express the spike protein, not the whole SARS-CoV-2 virus. So metaphorically speaking you're getting pure spike protein antigen, and different peoples' genetic predispositions/etc are going to play out differently in that scenario as opposed to contact with the normal virus.

...Like those of the people in the case report we're looking at.
I may have missed it in skimming over the post, website, and github repos, but will this eventually be open source?

I would love to use such a product, but I only use open source wherever I have the option, and especially with subscription based services.

Either way, congrats on releasing a seemingly excellent product!
Software Freedom Conservancy: Governance and Federation Are the Future (2018)
So, I feel ya. I'm inventing a new thing, and competing in the data space is hard. Can you focus on a user/b2b product to drive your DB?
For multi-modal check out OpenAI CLIP: https://www.pinecone.io/learn/clip/
just petty.
> A question for vaccine skeptics:

I don't think it's the correct question to ask.

I've got two Pfizer shots but I know many vaccine skeptics who refused to take the shots and they aren't skeptics because of the risk/reward ratio of the vaccine vs covid. They're skeptics because the politicians and the media have repeated a great many different lies during this entire fiasco.

For a start if people were allowed to discuss the lab leak hypothesis without being called moon-landing deniers then maybe there'd have been way less skeptics.

It's the attitude of the politicians and the mainstream media that created the skeptics.

To me what the mainstream media were publishing about the Covid-19 during the outbreak and the first lockdown was approximately as correct as what they were publishing about SBF/FTX before his ponzi was exposed: a narrative they were fed.
The key feature here is the cost: compared to the same model size from the previous iteration (ada), it's 1/10th the cost, and I'm curious how they achieved that.

It's low enough for quick experimentation and real-time usage, and I have a few fun tests I can do with it...
Reader is awesome. I’m not a Readwise customer but the app experience is effortless. I’m going to subscribe to your service. Great job!
Because it does matter: to a large extent it's a zero-sum game.
Our tools evolve, and without popularity they and your skills will stagnate and you'll be less productive over time.

IT is changing fast and a stream of fresh converts is required to implement & update new libraries and features and protocols.
It sounds like the problem is games don’t reliably switch resolution/aspect ratio in the middle of running. This is something you rarely do on a PC and you’d accept having to restart games after plugging in a new monitor.
McMaster has >700,000 products available on its website so I wouldn’t really call that relatively small.

It is more segmented than what Amazon offers.
Next in the trilogy: Things I want from SRE/DevOps as a SysAdmin.

- What specs of a VM do you require?

I'll assume that 16mb of RAM and 512mb of drive space running Slackware is suitable operating from 1.44mb floopy.

- What do I do if it doesn't compile?

It works in DevLand I assume I'll work anywhere. No, you cant growl at me, you asked for Linux and I gave you Linux. Documentation please.
The far future where we can ask an AI something like make me money, or improve humanity seems pretty far off still. Not for sure. Change can accelerate, but probably under 2% over my lifetime (which is still way higher than I would have put it a few years ago). Until we get there the question will be how humans can better leverage the tools. We won't be in quite as dire problems because the limiting factor will probably still be humans minds to do the increasingly small set of things the AI is bad at
Yeah that was my impression too. So why the urge to move on to SHA3 (and now the discussion around SHA4)?
ELT approach means you copy raw data from transactional sources, events, external APIs and dump it in the first “layer” of your data warehouse.

Then you progressively clean it and model it into some format that is easily usable for dashboards or self service analytics.

To do that you build a DAG of SQL scripts and dbt makes that easy through templating, macros and automatically generated docs.

You still have to execute the DAG somehow and here you either use their OSS version and schedule it with anything from Github Actions to Airflow, OR you buy their Cloud offering
I never make promises.

I also never use tech that doesn't share "how it works".

Clear?
Google vs. ChatGPT: What happened when I swapped services for a day
It also drastically reduces the cost to produce whatever's automated and also creates new opportunities.
2022 Looped – Annual Calendar Round-Up
Was a bit skeptical about how good this was gonna be, but I'm definitely impressed.

The improvements are a lot more apparent on desktop. I love the fact that I can do pretty much anything using the command palette and keyboard shortcuts. Feels like this is the kind of browsing experience that I'm most contend with. The GPT-3 "ghostreader" feature was also great; most of the summary / text generations fulfilled my expectations.

If I have to pick on something: the mobile app browsing experience isn't that much better from Pocket or Instapaper. The scrolling and animation feels a bit laggy in my iPhone. The "ghostreader" feature in the app feels very limited and awkward to enable here as well.
My existence hasn't been a burden on anyone. I worked hard to make sure that I put as little stress on my parents and grandparents that I could through everything and took out loans to pay for everything and paid the loans off. I've had surgeries but I'm not disabled. I work and pay taxes and have friends and a husband and participate in a large social circle. Forcing me to live as a gay man with gender dysphoria would have limited the possibilities in my life with no discernible benefit to society.

The only joy I found in life before I transitioned fully was in doing drugs and hooking up with guys. I could have maybe started a career and settled down with a man while living as a gay man but I doubt it. My misery was all consuming. My goodness, when I was 5 or 6 I remember bargaining with God to make me a girl and vowing to hold my breath until he would. I passed out many nights doing that in bed when I was alone with my thoughts and my sadness about not being a girl hit the hardest.

As a teenager I could barely function and nearly died from an eating disorder. I hated every masculine thing about my body and with testosterone pumping through me the only thing I could do to feel less masculine was starve myself, to try to be smaller.... In short I wasn't functional and I was physically withering away to the point where pneumonia nearly killed me because my body was so weak.

After I transitioned I stopped living in survival mode and started building an actual life.... I also gained a few pounds and got fit instead of being a shambling skeleton. I doubt my story is unique among gender dysphorics.

So whatever. You can debate the ethics of whether or not society was better off with me being a starving depressed twink versus a trans woman I guess but if you think it's bad for society that I was able to look how I want and start a family and feel happy I think you've got weird ideas about how the world works.
Exactly what I'm looking for, thank you.

EDIT: I am immediately struck that I need vastly more data and compute than I can afford for my experiment.
> Back then those Unix machines were all desktops. So was linux for the most part, although it was certainly possible to setup a Linux laptop by then.

Not quite all Unix machines were desktops. Tadpole made the SPARCbook line of laptops which ran SunOS/Solaris. In conjunction with IBM they made a PowerPC RS6000 laptop for IBM which ran AIX.

They also made the ALPHAbook 1 laptop which initially shipped with OpenVMS. I'm not sure if it lasted long enough to get the planned port of DEC UNIX. At the time I tried to convince my employer to purchase a ALPHAbook for me, but before that decision was made I left never to touch an OpenVMS system again.
Personally I prefer the interactive development style of SBCL. Thus I would easily prefer SBCL and GNU Emacs over VS Code, especially given that VS Code uses telemetry to spy on its users.
There are several demo videos on the youtube channel (https://www.youtube.com/@didgetsdemos) that should give you a good feel for what it can do without having to install it.
Note that these are bugs in pypy and not in "Python" i.e not in the dominant python implementation.
How will you meet your basic needs and who/what will provide the resources for you to do these pointless things you enjoy?
Nope. There is a shortage of super yachts unfortunately.
I guess the idea would be something along the lines of a 'strict' tag, to identify a shift to modern syntax with stricter rules around parsing, that ensures an infinite lookahead wouldn't be required for e.g. pseudos vs properties.

I put together a regex last time this was discussed [1] (which obviously completely alleviates all concerns): https://regex101.com/r/aOc2Pz/1

But seriously, syntax evolutions happen. If there's an issue with parsing garbage CSS why not just let that garbage run slowly, and re-optimise for the rest, prioritising for form and function.

[1] https://news.ycombinator.com/item?id=32248837
this seems more like a systems problem with a reinforcing and a balancing feedback loop: you're hiring for the future based on current demand, but there's a delay between the syncs of supplying capacity (hiring) and demand.
Except... Half of us have no recourse, and governments get carte blanche to violate this type of tracking anyway. Sweeney should just take it to Mastodon.
ChatGPT: Smart, but Not Smart Enough
And that's perfectly fine. Humans have exactly the same problem. They will get this wrong, and you will reply "no, I'm talking about the android version". Language is ambiguous so we cannot expect machines to get it right all the time.
Awesome, thanks. The loop design looks simple, which is encouraging. It's true that the most annoying parts are usually the secondary tasks that can't be ignored either way.

The joists sure help. In my case the floor is either tiles or wood panels laying on top of poured concrete.
Yeah it's definitely not new, Marx called the process proletarianization.
Mina POWER!!!!
Yeah, I agree completely.

It also is difficult position for health agencies to be in, because they want to make clear guidelines to prevent confusion, but there are gray areas. For example, it's completely possible that:

(a) The benefits outweigh the risks of a 4th shot for any age group

or

(b) The risks outweigh the benefits of a 4th shot for some or all age groups [not because the risk are high, but the benefits so low]

AFAIK, there aren't any super high quality studies anywhere in the world that have robust data on the 4th shot in particular for all age groups. So one health agency might guess one way, another health agency might guess another way. Reasonable people can disagree. The CDC got a little bit ahead of the science when they were initially recommending the 3rd shot, but in the long run it was proven to be a good gamble that no doubt saved thousands of lives. But now maybe that same logic is a mistake for the 4th shot.

But regardless of the CDC's recommendations, most people seem to have figured out the cost/benefit for themselves: The vast majority of people in the US have 2 shots, a little under half have the booster, and very few have the 4th shot. Most people probably have made the right choices for themselves given the various risks and benefits for them personally.
Not many get paid to do it, and those that do are paid because it's entertainment, people like watching them play. Nobody is paying to watch developers code.
I wonder if having larger arm muscles reduces this risk. Great workout motivation if so.
very interesting app! i wish the authors all the best.

i have collected thousands of unread articles as bookmarks. and they all have the tags "unread" and "article". i remove the "unread" tag on articles i have read. the process of going through my list became tedious. so i wrote a chrome extension that opens a random unread article for me in a new tab.

the first thing i looked for, when i opened this app, is how to import bookmarks. and it surprised me that the authors overlooked local bookmarks or bookmark files. that's how most people save what they want to read later, no?

looking forward to seeing that feature.

thanks.
Has A.I. Become Self Aware?
I've put well over a million km on Mercedes vehicles and not a single breakdown. That's anecdata, but compared with the other vehicles I've driven whose brands I will not mention their record for me at least has been outstanding.

That said: the newer generation is not for me, I had a C-class with automatic emergency breaking try to murder me twice and I've sold it and gotten something much older without that kind of accessory.
I think they meant it in a more abstract sense; also see relevant sister threads.
At what scale have you decided you’ve outgrown it?
this just is repeating what someone wrote on twitter with extra ads, also dupe: https://news.ycombinator.com/item?id=33926564
This almost sounds like a description of my local unitarian universalist church (minus the “trained psychologist” part - there are quite a few in the congregation, but our minister went to theology school).
> The thing is, Google+ had a dedicated user base.

Indeed. I really preferred Google+ to any of it's competitors. The circles idea just makes a lot of sense. Most other social media ignores the fact that people in your social circles might have different interests. People interested in programming languages might not be interested in baking and vice versa. Why spam all baking followers with your latest programming language realization?
I wonder if it's along the lines of 30% of the pages have PII on them. something along the lines of "visited ${person} at their home located at ${address}" and they're censoring that portion?

Will be interesting to see what all's been released, but I feel like at this point he (jfk) had so many enemies (Cuba/three letter agencies/mob) that short of someone coming forward with a confession and new solid evidence we'll never know much beyond Oswald.

I do think most likely though that Oswald was just off his rocker.
Idk if I'm drifting too far to support my argument, but I'd assume the pilot may didn't want to experience the g forces or was unsure till the end.

In the end, I'm not settled on this & we really need to find & recover the plane.
I'm sorry that there isn't a free/cheap tier.

I don't mind paying US$8/m when I'm actively using it, but I wouldn't want to continue that if I have a period when I'm just using it a little.

So, when/if that happens, can I easily export all my configuration data?
Pursue the lawyer route too! Just make sure to ask “is it worth it?”

It’s possible this can be cleared up quickly. His lawyer might say “stop breaking the law, and acknowledge they own the company.”
I am laughing in technical translator.
“rules are different for you because you have a lot of money” is a concept we can’t get rid of. Trying to make it irrelevant is exactly why people throw money at ethical issues and socially disruptive behaviors, and get away with it unscathed.

When street parking laws have nothing to do with wether you’re rich or not, that becomes an issue. Charitable contributions having nothing to do with it is (to me) an issue.

TBH I’m atheist, so my sympathy for churgoer tax breaks is limited, but I’d argue donation to orgs that benefit yourself shouldn’t be tax free in general. To take a silly example: if my street looked like a garbage slum and I made a non profit to make it look gorgeous, while there might be wider communal impacts, it’s something I and the street residents should have been doing anyway, and with no tax break involved.
To be nitpicky, the OODA loop is an Air Force thing, as Boyd was a fighter pilot.
Thank you for pulling this all together here, it really helped me understand what everyone is talking about!
"Chrome first sends an encrypted, 3-byte hash of your username to Google, where it is compared to Google's list of compromised usernames. If there's a match, your local computer is sent a database of every potentially matching username and password in the bad credentials list, encrypted with a key from Google. You then get a copy of your passwords encrypted with two keys—one is your usual private key, and the other is the same key used for Google's bad credentials list. On your local computer, Password Checkup removes the only key it is able to decrypt, your private key, leaving your Google-key-encrypted username and password, which can be compared to the Google-key-encrypted database of bad credentials. Google says this technique, called "private set intersection," means you don't get to see Google's list of bad credentials, and Google doesn't get to learn your credentials, but the two can be compared for matches."
https://arstechnica.com/gadgets/2019/12/googles-password-che...
It does if you can’t think of any that would demonstrably cause 1.3M excess deaths in the US, yes.
Sorry, but I can't guarantee that there isn't a bug in it that could corrupt data. While I have run thousands of tests against it, I don't think any database startup can offer you a solid guarantee that you won't find a bug (especially in the first few versions).

I take data integrity very seriously and it sounds like you do as well. You would make a good beta site.
One wonders what "throwing sheep" would actually mean, as slang.

is it similar to "being pwned"?
I spotted two women in the testimonial sliders. Can't remember the last time I saw testimonials from older people or children in a tech product pitched to Hacker News in showHN/beta stage. It's hard enough launching a product - give them a chance to get established and broaden their audience.
Every time I see the two words social and network together, I keep asking myself: what do I need a social network for? I've never found a satisfying answer.
I don't think so... in your example those are functions we just call in SQL right? I'm talking about exposing arbitrary data as a table like an FDW, but without having to compile a whole module.

So more like, (this is a bit contrived but bear with me):

Let's say I wanted to make a table that lists all my keybase proofs (so sad Keybase is basically dead, but I digress).

I'd build a graphql endpoint where you can query those proofs.

Then I'd have to define a metadata endpoint that maybe returns a JSON schema?

Then you can tell the FDW to define a virtual table that (as much as possible) uses the JSON schema to generate columns in this virtual table.

You'd define the FDW to say, here's the virtual table (like you'd do now), and then put in an option to say "you'll get the mappings for this table with the JSON schema returned by this metadata endpoint" and then tell the FDW "send select queries to this REST/graphql endpoint" which would be something in our example that returns keybase proofs).

I wouldn't need to build a whole new keybase FDW. I'd just use the generic one to hit that existing endpoint.

Is that making sense? It's kind of a dynamic FDW that can be configured for the long tail of API endpoints.
Heyo! Yeah there’s a free trial for 30 days and after that you can definitely export all data (links, metadata, highlights, etc)
For one, the "integrated" damage model does not use any climate data other than temperature. Rainfall, for instance, is crucial for agriculture, but is ignored. Note the parameters of the model:

https://web.archive.org/web/20141014141710/http://www.econ.y...

Secondly, the damage function is a quadratic polynomial (see the parameters a1 and a2 in the formula). But that is an unreasonable assumption, as heating can induce exponential or logistic effects (or worse). More explanations about this by prof. Keen starting 14:42 in the video:

https://youtu.be/5LvyxH3O7kE?t=882

Take, for instance, a phase change. Water boils at 100°C extremely nonlinearly compared to temperature. In fact, in a stepwise manner.
I don't think there's an urge to move to SHA-3, certainly I didn't mean to imply that, rather the opposite. I don't think there's much discussion about SHA-4 either, outside this particular comment thread :)
Services like Have I been Owned (IIRC Firefox makes use of) work similarly.