skysight-inc/HackerNews huggingface dataset:
This is not a good use case for Postgres. You might want to look into one of the schemaless solutions, like Mongo. If you're using a single table with lots of duplicate and empty data, Postgres is going to waste space and processing time. You're not going to use features of or gain any benefit from a RDBMS. You might even be able to get away with using Redis or a similar key-data store, for even better performance.

What I really think you need to do is reconsider why you're storing data like this. Anonymous columns, duplicate data, and excessive nulls are all big red flags. If you're not storing relational data, don't use a relational DB. It sounds to me like you might be cramming relational data into a junk bin for what are likely ill-conceived reasons.
> The whole point of EV was that users would see the name in the address bar and trust it.

This is not the point of EV. That's what I'm trying to say here.

It's obvious this would never be 100% reliable because sometimes the corporation has a different (lesser known) name from the popular product, and sometimes company names are similar.

The idea that EV only works if consumers 100% recognize and trust every possible green name is a strawman that was propped up to be knocked down.
If that's seriously canon, then your reward is "citation needed."
That would be why in many other systems a public entity picks up the tab, not the employer.
Why does open source software have such ugly interfaces?
I thought on-demand escalators were the norm, from subway to malls I don't think I have ever seen an escalator that not my on-demand.

But I can't say I've put a lot of thought into it.
Isn't Boston's climate very similar to most of Germany's?
Such lack of gender neutrality! I don't even!

Doubleplus ungood!
Help them buy goggles and stuff.
Assuming everyone's selling it back I'd imagine there have to be easily swappable batteries then to deal with the increased wear. At least so it's not a big operation for the dealer. I wonder how much more difficult this would make car designs...
The Big Yellow School Bus Is Going Green
EV certs do include enough info to uniquely identify a business.
Generate the recommended markdown documentation to improve contribution (CLI)
The premise that needs to be fought is the suggestion that there can be no such thing as a private conversation.
I don’t think the main objective of women when they decide to take that leave is to reinforce traditional gender roles about caregiving.

But if your objective is to fight traditional roles about caregiving it makes sense that you’d prefer that other people didn’t have choices.
Ten years ago viable electric cars did not exist. At all.
Hey, could you please not post in the flamewar style here? We're trying for something other than that on HN, including avoiding old-school programming language flamewars. It's been many years since any of those were fresh.

https://news.ycombinator.com/newsguidelines.html
What does this have to do with Boeing? Engine was from Rolls-Royce. The customer decides what engines they want to install on the plane.
Balsamiq if I just want to get an idea across (layout, story boarding)

Figma for higher-fidelity discussions (colors, spacing, icons, etc.)
EVs don’t have “engines”. They have “motors”.

Someone in the EV business should know the difference.
Trisyllabic Laxing
How to highlight your strengths with a Johari window
I wonder how the pricing affects taxes on this.

On a home, the salt is capped. But if you are not directly paying salt, maybe it is different?
Hi HN, I'm Ryan, one of the co-founders of Arrived. Feel free to ask us anything about the service and I'll try to answer some of the questions that have already been posted. And of course all of your feedback is deeply appreciated!
Boeing has nothing to do with the engines. They are purchased by the end user/airline.
2500-Year-Old Smashed Jewel Found at Site of Babylonian Destruction of Jerusalem
What happens to your pseudo-equity when Arrived goes bankrupt?
You don't think Apple cares whether you feel safer downloading the Bank of America iOS app from their carefully curated App Store, instead of navigating to bankofamerica.com in mobile Safari?
"Meditations on Moloch" is pretty clickbaity.
> If memory serves Rolls placed the blame on the initial problems with the Trent 1000 on air quality in SE Asia (high sulfur content specifically).

As a related factoid BMW doesn't sell some of its engines in North American, Australian and Malaysian markets due to high sulphur content in the fuel (e.g. [1]). It would be interesting if the same thing happened for aircraft engines and South-East Asian air.

1. https://en.wikipedia.org/wiki/BMW_N53
I need to change my name to that
Confirmed, Equity does this nationwide. I've transferred leases in SoCal and the DC metro area. There are a number of requirements, but it was extraordinarily helpful to not have to scramble finding a replacement tenant, so that I could just focus on moving.
I was going to say the same. That sounds like my on chronic sleep deprivation, and as you say, after months or years of sleep deprivation it can take weeks of consistent good sleep for the symptoms to fade.
Please don't break the site guidelines by calling names.

https://news.ycombinator.com/newsguidelines.html
People are not being abused. Companies give them exactly what they want: affordable products that customers replace every 2 to 3 years with new shiny ones.

Another aspect is the useful life of batteries.
The US are also banning some food that isn't banned in EU. Now what - should European countries leave NATO about it?
> What else could they do?

Mandate that the "choice screen" must display the top 5 search engines in the EU by market share as identified by an established, independent market research firm. If the regulator or a competitor feel that Google is not executing this mandate in good faith they can take Google to court.

Done. Justice works. Pay for placement, my ass.
Please don't respond to a bad comment with another one. That only makes this place even worse. Instead, flag egregious comments as described at https://news.ycombinator.com/newsguidelines.html and https://news.ycombinator.com/newsfaq.html.
U.S. Long-Bond Yield Nears All-Time Low as Global Anxiety Grows
Am I the only one noting the irony of criticising a piece of software by writing a post on Medium?
Android Application Testing with Firebase Robo Test
A doctor once told me that so much of our higher survival rate is based on a few key drugs and supportive care to keep us alive while the body heals itself. We seem to possess remarkably few cures for the majority of diseases out there, we are mostly able to treat symptoms to buy time for our bodies to self-repair.
#!/bin/bash
lname=‘todo+%y%m%d+.html’

vim $lname

But seriously other than a learning project for someone who wanted to see if they can put all their skills into the development of a single “app” is there any added value here?
China Media: HK protesters ‘asking for self-destruction’ as military assembles
No risk, no gain.

Having meticulous plans and preparedness means you're already ahead of they pack!
Congratulations. Cherish it ! Take care of your partner - eat healthy food.

I would like to add - stop worrying.
Yes you don't have a predictable income, but your constant worrying about it will hamper your ability to have one. It is a vicious loop. Be calm, keep improving your skills and producing better results.
In your anxiety to provide for your kid, it is easy to forget to actually "be" with them, love them. Children can easily pick these things in you.
Read/tell them stories every night. Goof off with them - this is your chance to be a kid again !! It is surprising how easily you can get away with "my kids insist I do/play this with them" :)!. The world can wait, it will be there still, when you return to it.

Like others have said, lower your costs - increase your savings. Keep increasing your Savings Rate. Drop things that cost but add little/no value. Convenience has a cost - Embrace inconvenience. Prefer buying used things, learn to invest at a low cost. Stay healthy. Parks and libraries are free, use them over other forms of entertainments.
I like it. The reason is that in my situation, large enterprise corporate setting, it's the best I can get. Believe me it's been a breath of fresh air.
That's a big question. As in "who really owns the property" and "is this a a real investment fund?"

They filed with the SEC.[1] But just a no-info Form D.

If this was legit, I'd expect it to be set up as a Real Estate Investment Trust. The REIT would own the properties, borrow at bulk rates, tenants buy shares in the REIT, and the company behind the web site is the fund manager. That way, if the management company goes bust, the tenants still have their equity.

[1] https://sec.report/CIK/0001780774
I have always thought I had dyspraxia[0], which although totally unrelated to dyslexia, made teachers think I was dyslexic when I was young as I was unable to (and still can't) write in a legible way unless I write slowly and in block capitals, however I can read very well, and when in the mood can consume books on many topics at quite a fast rate.

That said... I've just read the list of dyslexic symptoms[1] and I'm shocked. I can legitimately tick about 80% of that whole list. So maybe I am dyslexic after all ?

--

[0] https://dyspraxiafoundation.org.uk/dyspraxia-adults/

[1] https://www.dyslexia.com/about-dyslexia/signs-of-dyslexia/co...
Contextual Parsing with Combinators and Functional Programming Magic
Well, yes, I'm still using Xorg too :-)
Middle click paste is not yet supported in KDE with Wayland [1], and it seems that KDE and Wayland don't like suspend / resume on my machine, and recently (after a bios update ?), adding a screen have made the system crash.

Besides, as far as I know, it is not possible to run Wayland apps on Android (yet, but it seems that it is a hard problem [2]).

[1] https://bugs.kde.org/show_bug.cgi?id=373907

[2] http://www.jlekstrand.net/jason/projects/wayland/wayland-and...
Two methods for exploiting speculative control flow hijacks [pdf]
From what I understand, Islamic financing of home loans is almost there same as a traditional fixed interest home loan, only the house is legally register to the bank and instead of calling it an be interest payment you can it an installment payment. At the end of the term of the loan the house is registered to the party.

This is a little different. You lease and get equity in real estate fund that you are required to contribute to. At the end of the lease you can move or cash out of the fund of you wish. You don't get the home.

This is so you can participate in the upside of owning a home without actually owning. This isn't a way to buy a house. It is a way to lease and still get the appreciation of ownership.
That's why I said have both with the emphasis on the one that better expresses it so people know what you're aiming for. I've written FP blog posts in the past with Javascript to accompany just in case it wasn't clear because of syntax. But if you'd just looked at the Javascript, your takeaway will probably be similar to many FP-in-JS articles of 'why so much ceremony?' The 'other' language is merely a bridge. And if you can only communicate from the bridge language's perspective, you won't be able to grasp intermediate topics.
I think the downvotes might have something to do with your dismissive attitude.

How is the nationality of the lecturer (w/ a diploma) a relevant fact? Why the "... ok" reaction? Was is more credible if the lecturer was based in SF ? Is medicine different if you're not from SF ? Are you automatically bad at everything you do if not from SF? As for the "invented by NASA", i do think they were referring to this:

In 1974, the World Health Organization described spirulina as "an interesting food or super food" for multiple reasons, rich in iron and protein, and is able to be administered to children without any risk," considering it "a very suitable food."[52] The United Nations established the Intergovernmental Institution for the use of Micro-algae Spirulina Against Malnutrition in 2003.[53]

In the late 1980s and early 90s, both NASA (CELSS)[54] and the European Space Agency (MELiSSA)[55] proposed spirulina as one of the primary foods to be cultivated during long-term space missions. ( source: https://en.m.wikipedia.org/wiki/Spirulina_(dietary_supplemen... )
>(google "american inventors")

LOL, pretty funny results there.

Nice job though, Edison.
This has basically the same effect as an auction model except that you totally lock out the smaller search engines like Ecosia.

Is improving the market for startups like Ecosia your goal, or just to decrease Google's marketshare (by increasing the market share of other big tech search engines like Bing/Yahoo/Amazon Product Search)?

Being somebody's search engine is scarcity. As a society we've been solving scarcity for thousands of years with auction-based models.
And of course this is a self-reinforcing downward spiral. Sleep quality destroyed by kids, underperformance in all areas of life due to sleep deprivation, anxiety and stress due to underperformance, making it harder to get to sleep...
The VALIS trilogy and his exegesis are probably the most philosophical but almost most impenetrable of his works.

Some of his intermediate period stuff, like Flow My Tears the Policeman Said and Radio Free Albemuth is a softer landing, as you can see the ideas that lead to his later work building from his earlier more facile metaphysics.

I re-read his corpus last year in the order he wrote them -and finished feeling like I understood his entire mental journey, tortured twists and turns and human fallibilities and all. He was prolific, so I only recommend that route if you have a thousand hours spare.
On UI Design and Using UI to Tell a Story, Convey Emotion, Create Personality
If you want open source I would look to postgres and try out the cstore_fdw foreign data wrapper.
I'd call that a worm, not a virus. The main distinction being that a worm propagates all by itself, while a virus requires some user action.
(F)acebook, (A)mazon, (N)etflix, (G)oogle.
While not very common, it is also a thing in Spain. "Alquiler con opción a compra" (renting with the option to buy), lets tenants live for a predetermined time at a place. When the lease ends, they can choose to buy the place with a discount equal to their rent payments up to that moment.
Raiders of the Lost Ark is more accurate in real life, unfortunately. I don't know why they show such sanitized versions of the diseases (for SJS they show a photo of someone with Erythema Multiforme Major). The photo for TEN is almost certainly after a great deal of "clean up".
> Let me also remind you that the story is talking about a specific strain and my comment was clearly not about that strain.

Since TR4 has reportedly been present in Southeast Asia for quite a while, sighting a ton of TR4-vulnerable bananas growing there would be evidence that the story is sensationalized.

But if the bananas you saw are TR4-resistant, your anecdote isn't really relevant at all.

In that case, or if you don't know which case it is, you really can't justifiably say that the article is sensationalized.
Build Your Portfolio as a Professional Full Stack Web Developer
In the government or at a technology company?
Like others have quoted, south of 20m means south of 3m. At that price tag grave digging makes complete sense if you can stem the running costs.
Renaming executables to explorer.exe worked with the application whitelisting solution my school implemented.

That's how we ended up with 8-player age of empires 2 deathmatches after hours ;)
How do you making money? Is it just capitalizing your fund for a specific timeframe (the lease period) and you essentially take a management fee? Is it essentially a REIT of the properties that people are leasing?

What happens to the house at the end if the period? The description wanst very clear on that.

The big one: what happens if the fund doesn't make enough and has to close up from another market downtown?

Interesting idea, but more technical description would need useful for us finance geeks.
That's common in Germany as well. See Mietkauf or rent to own- https://en.m.wikipedia.org/wiki/Rent-to-own
Of course you end up paying more than the house is worth, just as you would if you paid down a mortgage with interest.
You convince yourself of that. With male parental leave in place there won't necessarily be less children. Guys like sex after all. But we can be sure there will be less doctors available at any given time, because some of them will be on an unnecessary leave.

Besides, loners tend to die earlier anyways so we don't need so much Healthcare.
I am Jürgen Schmidhuber, AMA (2015)
Would you please not be a jerk on HN, no matter how right you are or how wrong or ignorant someone else is? You've done that repeatedly in this thread, and we ban accounts that carry on like this here.

If you know more than others, it would be great if you'd share some of what you know so the rest of us can learn something. If you don't want to do that or don't have time, that's cool too, but in that case please don't post. Putting others down helps no one.

https://news.ycombinator.com/newsguidelines.html
And then we end up in GTK hell:
https://stopthemingmy.app/

At least the web platform is open enough to do this and still function.
So... It's a landlord whose tenants invest into an investment fund on top of their rent.

IMHO, these are things that don't mix.
They can believe that rhetorical fantasy, but HK being a part of China isn't going to be re-litigated. Everything else is theoretically possible, though the more protests try to tear down the "one country" part (anti-Article 23, 2014 protests, etc.), the more the "two systems" part becomes endangered. That's a cold-headed assessment of what has been happening since 1997.
"The person who makes a particular assertion has the onus of proving the same."

But both sides are making assertions. The appreciators of Examine and other resources, are not the only people making assertions.

And the assertion that Examine isn't the best- the skeptics position- should be far easier to prove.

For some reason, that one guy will go to great lengths to make the general case for skepticism, when the specific case for skepticism- that there are sufficient websites objectively better than Examine such that Examine shouldn't be ranked near the top- should in theory be much easier to establish.

But he avoids that at every turn.

"In criminal cases, the burden is on the prosecution to establish their case beyond all reasonable doubt. The defence does not have to prove innocence; it merely has to establish there is insufficient evidence for a guilty verdict."

Lol. As though the defense never provides evidence boosting their client. But thanks for telling me what anybody could ever tell you who has served on a jury, or had a class in basic civics.

Look, skeptics need to furnish evidence, too. The people who appreciate Examine have provided a ton of evidence. It is LAZY LAZY LAZY that every skeptic wants to avoid digging deep.

I've already DONE immense research on supplements and the websites providing information about them. So have many others.

None of the skeptics in this thread are people who claim to be familiar with this domain. They just want to act like they are superior know-it-alls because they can lazily tout the general merits of skepticism.

Just like the defense will eagerly provide any evidence of innocence that they can muster, it is in the interests of skeptics to furnish evidence that the skeptical position is warranted. But few skeptics in this thread seem to want to do that.

If they think there is something better, they should let the rest of us know. Or they should build it themselves.
I thought people like that would use the Tesla self-driving robotaxis. They won't need their own car.
And maybe the street layout?
France has indeed been out of NATO from 1966 to 2009 due to disapproval of US hegemony.
Taxing Africa's Digital Economy
I don't use Teams but would assume so. My Pi hole captures a lot of other Microsoft telemetry, including VS Code related (though that seems to handle it fine).
Going to get downvoted for this, but whatever.

It is cruel to mother, father, and child to force a father to take care of a newborn or < 1 yr old without the mother. The newborn is used to the mother's body. A newborn gets stressed being away from its mother and source of food, even when with the dad. Breastfeeding from the breast is not just a source of nutrition but also a source of comfort for the baby, and healthy for the mom (both physically and mentally). Men do not have this need or ability.

Putting a man at home with his newborn, without the mother, is a recipe for disaster. Not because a man cannot do the actions required to take care of a baby in this circumstance, but because, if the woman wants to do the recommended thing for her child (breastfeed him or her), then she would have to pump (which is a lot of work) and store her milk (a lot of work). Oh also, she'd have to do this at work, which again makes her unequal to her male colleagues. The man would have to disinfect and clean bottles, and be unable to soothe a child if he runs out of milk (unless he has formula on hand). The child doesn't get the human touch of breastfeeding.

So to recap... the mother loses because, despite going to work for the sake of 'equality', she's stuck every few hours pumping milk, losing work time her male colleagues can use to further their career. The baby loses because it doesn't get the psychological security of suckling at the breast. The father loses because he is simply less able to calm the baby down and feed it than the mother.

By all means, help men to stay home with their older children. This is great, but a father with a newborn is simply a bad idea, IMO. Formula is possible, but from a public health perspective, it should be discouraged unless necessary.

I will never understand why people make parenting harder on themselves. Newborns are hard enough, but the human body has an easy way to fix it. Whenever my daughter is fussy, she goes straight back to her mom for comfort nursing, and then when she's done, she's back to me for fun times. This is easier for everyone involved, and fosters a positive father-child relationship.

Both my wife and brother-in-law were breastfed whenever they were fussy, and it always calmed them down, according to MIL and FIL. Not being breastfed myself, I didn't believe it at first. But sure enough, with my daughter, literally all problems can be solved by suckling for a minute at her mother's breast. Why make this harder on ourselves? By the time she's back with me, she's happy, laughing, and ready for tickles and fun, and mom can get a well-deserved break.
> That is true, but mixing spaces and tabs is a contrived example. Literally nobody actually does that.

Contrived or not this has happened to me when copying and pasting, but I take your point that people won't mix and match.

> I guess my point is just I think you subjectively dislike Python’s syntax (which is fine) but are trying to make objective justifications for that which seem really far fetched. Why not just say you don’t like it?

While the issues I encountered might seem contrived and far fetched to you, they have happened to me, granted I don't do Python professionally.

As I said on first comment, I don't like it because of the reasons I mentioned, some are factual,e.g. indentation when copy and pasting can mean that the script/program won't run, some are opinion-based, e.g.
they [braces] are easy to visually parse.
- have you defined what would happen if Arrived went bankrupt?

- would I buy homeowners insurance or renters insurance?

- Who has authority/responsibility for major work on the house?
thank you, this looks very readable. I was very much looking for a treatment like this that spends more time on how the primitives - perceptron, backprop, etc. came about.