skysight-inc/HackerNews huggingface dataset:
It's better to use a native date/time with a CHECK that ensures that the time portion is 0.

You'll have to do a CHECK on the YYYY-MM-DD string anyway to protect your database from bad data, so why not just do it on the native type?

The native type is likely to be more compact, performant, consistent across the database (with strings, some columns may be YYYY-MM-DD, some may be YYYY.MM.DD etc.) and more readily convertible to the client's type system.
Windows 11 is more invasive than 10. Why? Because all the anti-privacy bullshit on Windows 10 worked and nobody complained...

We can call this situation the "Fuck yourself" pattern, where you give money to companies so they can innovate in new ways of fucking you.
It's not that they are extreme left positions, it's that that other 35% thinks that universal healthcare, or abortion, or whatever === Stalinism and will paint moderate views as if they are extremism when disingenuously asking "why isn't the extreme left content taken down".
You don’t need to. Read up on the grammar if you encounter an odd construct or as a refresher, but remembering grammar rules is useless (And I say this as someone who can cite most of the grammar rules for English and German). It’s better to expose yourself to a lot of language and etch the patterns in your brain. In fact, I think not explaining grammar sparks curiosity, which is much better for remembering the rules you really need to know.
Unlocking your phone, opening an app, possibly unlocking that one, tapping to scan, and then accept is NOT more convenient than NFC in your card. Unless your talking about costs.

For private free money transfer, the US and many other places have similar if not better methods.
Why would you expect a crypto stock to go down on a day when Crypto was up almost 10%?
Given there's an electronic lock on the other side with a keypad, it makes me think that thing has its own actuator and didn't want to mess with it. Otherwise it would just be a matter of adding an "Electric strike?" (https://www.tesa.es/en/site/tesa/products/electromechanical-...), feed it 12/24v through a relay connected to the pi zero, and add another api endpoint
Exodus Effect 2021
As a restricted period offer, you can buy the book and all its extra aides at just $67. Try to tap on the Exodus Effect Book download choice to get moment admittance to the advanced substance. The book likewise accompanies a moneyback ensure, which means you can generally guarantee a full discount of your cash on the off chance that you're not fulfilled.

Official Website:- https://wintersupplement.com/the-exodus-effect-book-reviews-pdf-download-scam-or-legit-recipe-price-to-buy/

https://gocrowdera.com/US/company/exodus-effect/Exodus-Effect-38240

https://kit.co/exoduseffect4/where-and-how-can-i-purchase-the-exodus-effect
The difference is Tesla makes cars, good cars, that people can use. Bitcoin makes "investors."
Your answer only rephrases the question. The only way for it to hit $0 is if nobody is willing to buy the stock. This seems unlikely, given that the Bitcoin they're holding, even at 50% of present value, is still worth significantly more than $0.
Self-hosting MariaDB with multi-master replication. Works pretty well for my cases. Have a friend that was surprised by the AWS pricing changes on Aurora (they charge per query now instead of bandwidth/usage?)
Again, the argument that because bad x exists and is allowed freely does not mean y should be allowed. You can not use transitive arguments for this. I would think that pain killer should also be restricted. Anecdotal small sample sizes are also not convincing either way, I do not think we should be so cavalier with allowing or disallowing.
The project box aesthetic works really well for this. Did you waterproof the mounting holes and seam where the box fits together? Some silicone sealant will help keep out the moisture and keep out the wasps (ask me how I know lol)

My ideal DIY doorbell would be like a progressive-enhancement to the oldschool physical bell chime, just with the addition of a camera, maybe using something like this: https://www.2nusa.com/en_US/products/intercoms/2n-2wire
Our plans to improve navigation on Gov.uk
What app, if I may ask?
Quarantine / stay at home orders == time to learn a new language
Amazon announces Elastic Firing Service. Build on years of AWS and e-commerce. You too can hire and fire your drones to adapt to the shifting realities of today's gig economy.
how can any engineer or inspector know that what they can see from a surface inspection means a building is about to collapse? How many buildings do they inspect with damage that don't collapse? all of them until this one. So when they see damage they say, this should be repaired, and then when the repair gets underway, maybe people see that it needs more than anticipated, and it all gets fixed. Probably by that point in time the inspector is out of the picture.
On this endorsement I watched the video upthread. I didn't care at all about HTM, but that was super interesting. If you've got more Click things to check out, I'll check 'em out.
Polyglot Youtubers seem to be divided when it comes to Anki's effectiveness for language learning:

Anki Vs. Input-Based Learning

https://m.youtube.com/watch?v=t26IPxExmzs

How to Learn a Language: INPUT (Why most methods don't work)

https://m.youtube.com/watch?v=J_EQDtpYSNM
I'd hold off buying anything Ubiquiti in the near term and wait for them to decide if they totally turn hostile their consumers (well, prosumers in that case) or not.

Just search the recent (3 to 6 months ago) news for them...
to me it sounds like McCoy from Star Trek telling our doctors that they are from the dark ages. https://www.youtube.com/watch?v=_R_WbAhKyAk
The losses from their bitcoin position can exceed their current market cap.
Too bad no such projects in India despite having such a huge genetic diversity in the subcontinent
As mentioned in the article, having a digital menu allows for a restaurant to adjust its offering in subtle and responsive ways. If a place is out of one ingredient, those items for which it is necessary could be struck.

Or one could have "surge pricing" — not desirable as a customer, but certainly for a dining establishment. And one could also collect more information on customers.

I'm still inclined toward tangible menus. For the one positive point (adaptability), I am reminded of one of the best restaurant meals that I ever had. The beer menu was a small laminated card, but the brief food menu was just written on a chalk board each day. When I arrived a few items were already struck with a line through them. One really can't beat that kind of simplicity, with no reliance on digital devices unless for payment, if desired.

(kelnos pointed out that I missed something in the article; edited to address that point.)
You're right but publishers know their bounce rates so for some, people rarely navigate after landing on their pages. For others, it's almost always the case.
Depends on the setting, honestly. In a cafe, it's nice to continue working while just ordering on the QR. In some sit down restaurants, it does feel like the service is strictly lower quality with the QR codes. It's hard to convey what exactly you want sometimes, especially since not all these QR apps have a notes section.

Allergies? Substitutions? This stuff just gets slightly harder/annoying, albeit not horribly difficult ofc. I find myself agreeing most with the authors on this, though:

> I despise spending the first 10 minutes of a social engagement on my phone.

This just sucks and I'm tired of it.
do political things not start, get normalized, then serve as a foundation on which new trends can build?
thanks for the link

>that estimate indicated that the concrete damage observed would begin to multiply exponentially over the years, and indeed the observable damage such as in the garagehas gotten significantly worse since the initial inspection.When you can visually see the concrete spalling (cracking), that means that the rebar holding it together is rusting and deteriorating beneath the surface.Please note that the original scope ofwork inthe 2018 report has expanded. The concrete deterioration is accelerating. The roof situation got much worse, so extensive roof repairs had to be incorporated.

>Because so muchof the needed concrete/waterproofingwork is underground, we must pull up almost the entire ground level of the lot to access the areas that requirerepair. That means we have to put itall backat the end. This includes the pool deck, the entire entrydriveand ground level parking,north side contractor parking,and planters/landscaping. Electrical work and plumbingare involved almost everywhere. Balcony concreterequires repair/waterproofing,and the railingsrequire repair. And-we have to bring all this up to current codewhen repairs are completed.
As a former waiter, I tip extra well. If I encountered this, I'd be tempted not to tip at all except maybe slipping a $10 bill to the runner or the bus boy. And I wouldn't go back to the restaurant.
Hadn’t heard of LingQ til now, this seems really good.
What seems amazing to me, is that after all of that data manipulation attempting to support their anti-vaxx premise, they still manage to prove the vaccine is the most logical choice for absolutely everyone, reducing deaths by over 30%. (Despite that a tiny minority of people need to discuss with their PCP first due to underlying medical reasons)
Precisely why I tend to look for inspiration in real life rather than social media. Facebook keeps showing me ads for synths and other electronic music related stuff, while in real life I have already moved on to classical music.

I think life in a big city can be your "social feed" without any bias. A big city can offer so many things and ideas if you just go out, meet random people and listen to what they say.
A cheap precision scale will accurately measure up to 0.01g precision, with the caveat that most will only measure things weighing less than 100g or 200g. I currently use one like that (0.01g precision, 200g limit) for coffee beans, I was originally looking for a 0.1g precision scale, but there was no price difference.
Although, I fully agree that it is overkill for the kitchen - I have never used it for cooking.
They would send me ads in languages I didn't know, which was hilarious as if any app should know what languages I speak it's Duolingo.
The (possibly apocryphal) version I was told includes another layer: The problematic code was part of a last-minute kludge for the Ariane 4. The kludged code violated the Ariane 4's specifications. The Ariane 4 team knew this, but the code "couldn't" be triggered under the Ariane 4's conditions.

A few years later, the code is pulled out for re-use in the Ariane 5. Apparently the kludge wasn't documented and no one bothered to confirm that the Ariane 4 code was actually up to the Ariane 4 spec. Had the Ariane 4 code been up to spec, the code reuse would have been fine.
here is a better link: https://www.sciencemag.org/news/2021/06/crispr-injected-bloo... they say that they are using lipid nanoparticles, that's the same stuff that is used in the Moderna and Phizer covid vaccines. https://www.sciencedirect.com/science/article/pii/S037851732... We are living in the twenty first century...
Yes, we should just add more avoidable surfaces of contact which do not get cleaned as often as utensils, thanks to your big brain right?
Typically no but they have the authority to do so and this isn’t a typical situation.
I'm of two minds. Cryptocurrency is a beautiful technology. But the current prices have absolutely world-changing speculation already priced in.

I think the price is largely meaningless, and cryptocurrencies are likely to crash hard, but at the same time, I don't really care, because the price is not the beautiful thing about crypto.

Crypto achieved its purpose as envisioned by the cypherpunks that created it, the moment people started using it - for, say, Darknet drug markets: anonymous or pseudonymous exchange of value in a manner that cannot be censored by governments.
Same thing happened with cable TV back in the day. It is about extracting as Mich value as most people will tolerate. There is no escaping ads if a company isn't principally opposed to them and charges directly for their product
Hydrogen combustion engines can contribute to zero emissions
It varies on Android, some manufacturers ship custom camera apps that include automatic QR code detection and decoding. Many people don't even realize the Android they're using is really a highly-customized vendor skin and suite of apps. Samsung in particular does this, and its camera app auto recognizes QR codes.
OO doesn't think. Functional doesn't think. Paradigms don't have ideas about anything.

Advocates for those, and others, characteristically think badly. People who build things that work do not limit themselves with pat labels. Nature has no respect for pat labels.
Every cycle converts more people, people who will never sell. These are also the same people who will buy hand over fist when the price approaches anything in the ballpark of their cost basis.
> If a place is out of one ingredient, those items for which it is necessary could be struck.

The article actually does mention that exact thing.
Interesting that they're running plaintext HTTP on the HTTPS port. Are some networks filtering 80 on egress now and this is how people get around it? Or are the devs just using some cloud setup that tries to force serving HTTPS but the builders of the service don't want to?
I'm just saying, in Washington there's a 37% tax rate... so clearly you can get it pretty high. Probably because weed is cheaper even with the tax than it was on the black market.
I studied German in college, and was just terrible at it: And because it was a class, the further behind I got, the worse my experience was. Standing in front of a class and sounding just.. obviously bad really hit me hard.

I'm about a year and a half into daily Duolingo German: I'm not going to say I "get it", but I'm doing better at grokking the grammar and I'm further than I ever was in class. I'm a few months from being entirely done with their course.

I'll be doing italki afterwards.
Self hosting PSQL via Docker container + Ansible.
Also hosting MongoDB, Elastic Search, Redis instances (for session & caching, separate instances).

Might consider researching using pg_bouncer later (but really not needed right now).

Pricing and support for vendor solutions are too bad for small scale app.
Everything I’ve ever achieved in life is because I put in the hard working hours. You want a degree from MIT while holding a job and raising kids, there’s no way around hard work. You want to gain experience, got to put the hours in doing project after project after project. You want to run a marathon, you need to put the miles in. Absolutely, just toiling away is not helpful, you better have a good trainer, pick the most useful projects and plan your time right, but the work has to be there.

I guess my point is that if you get lucky or are willing to bend the rules or are super talented, hard work indeed is not necessary. I’m none of these and for me, there has been no substitute.
I'm sorry, but you've been breaking the site guidelines so frequently that we're pretty likely to ban you.

I'm not going to ban you right now because I don't think that would be quite fair thing to do in response to a post like this. But you've definitely not been posting in a good way for HN. We really don't want flamewars here. Also, comments like https://news.ycombinator.com/item?id=27637580 are bannable offenses in their own right.

If you don't want to be banned on HN, your best bet is to read the site guidelines, internalize them, and completely change how you've been commenting. They're here: https://news.ycombinator.com/newsguidelines.html.
Washington state cannabis has something like 47% tax and it’s very healthy, the black market is not exactly booming. Most of the material on the black market is leaking from licensed grow ops though.
What is really boggling is people paying to 'gild' posts, which is very profitable, while the company also employs all these dark patterns / user tracking / data selling
Cottonwoods grow pretty quick in the right conditions (lots of sun and moisture), so a 10 year old tree may be 40-50 feet tall.
> it is a private service

Should there be a certain size threshold after which they can't claim "private" anymore? It has a huge effect on society.

> What we really need, I think, are options

Yes, but they don't want to allow those options to exist. It's not in their interest.

All this said, if YT would vanish from the internet I'd be devastated. So many technical talks that are not mirrored anywhere else, great courses, hobby stuff, documentaries, not to mention the breadth of music. Together with Wikipedia and arXiv I think it's one of the fundamental resources of the internet. And the content is, like Google search, generated by the users, it's our work.

Does that still qualify as "private" when it gets to hoard so much of our creations? Is it their right to assert their massive size and power against content creators who are many and small, and can't coordinate to mount a meaningful opposition?
Hand-Picked Open Source
in fact:

>also, when performing any concrete restoration work, it is impossible to know the extent of the damage to the underlying rebar until the concrete is opened up. Oftentimes the damage is more extensive than can be determined by inspection of the surface.

from the HOA letter:
https://s.wsj.net/public/resources/documents/miamiletter0628...
The SEC does.

https://www.sec.gov/news/press-release/2020-266
> Can statistics ever proof causality?

Yes, this is an entire field of study. It’s what spawned phrases like “statistical significance”.

> I call BS on numerous years with numbers higher than I claim.

You said in your two earlier comments, “The most you would get would be 80-85 once a year.” I shared evidence that Seattle regularly surpassed that level historically. You’re now moving the goal post by asking me to show a higher temperature than today. That question doesn’t matter since it still isn’t evidence that the record high is caused by climate change.
I think this is a good strategy if you look at the fundamentals. But the thing that's been making BTC work isn't the market or the technology, it's the behavior of other people. That's something that isn't taken into account in his list of justifications.

People are behaving 'irrationally' and it's been working over and over again. It's created throngs of people who are believers and nothing will change their minds.

BTC isn't going anywhere, despite my reservations about it's use as a tool for financial systems.
Wash your hands before the food is served, it's super common and recommended even in the pre-covid times.

If you're touching your phone right before eating you DEFINITELY want to wash your hands. Think about where your phone usually sits, tightly pressed against your body absorbing all the sweat and detritus and bacteria on your person. Think of the last time you actually washed or sanitized your phone too...
They can but only if all market participants act irrationally. Just want to make it clear that it’s not a law of nature that stock prices are bounded at 0.

One could imagine a different legal regime in which equity ownership actually carried unlimited liability, in which case negative prices would most certainly be a thing.
I've sold Tether for both USD and CAD without any issue or significant delay. What are the difficulties the author is referencing? (Asking genuinely, not arguing.)
The big one was ballpark 115’/120’. We had to have a crane remove it. Sad day; as much as poplar drive me crazy — they’re invasive weeds really — it was a giant. We’ve planted a lot of oaks and maples (and a bunch of other stuff).
"... it's nice to continue working..." yes, this is also the problem with so many cafes. People go there to get some work done but also to interact. To strike up conversations about work or life with people outside your usual bubble. If you didn't want to be around other people you could stay in the office or at home. But in recent years everyone wears headphones and has so many devices that walking into a cafe at lunchtime is like going into a call center. What's the point? I've worked on laptops in cafes since the early 90s when I was usually the only one with a computer. But I learned the civility that if you're going to work in a public space, part of the reason you're doing that is to take time away from your work to interact with other people, including the service staff. Usually I would never go work "out" until all the job reqs for the day were done and I was comfortable being interrupted. To go into a public space and tune everything out and demand that it function like your private office is a bizarre antisocial feature of a generation that has spent too much time on social media and doesn't know how to act or respond in real life. Walking into those places now just makes me sad.
To add, the Affinity apps (Photo, Designer and Publisher) are cross-platform: Windows and Mac for all apps, and also iPad versions for Photo and Designer.

The apps are currently on sale at 50% off - the offer ends on 30 June 2021.
Legalization would allow people to try it in a safe controlled environment and find out what something will do to them. And that would also be an ideal time to educate them about the actual risks and experiences they may experience before taking anything.
Sand Castle Holds Up a Car – Mechanically Stabilized Earth
Peddle your snake oil where it sells.
Never mind, misread
Doing old things better vs. doing brand new things (2020)
I am currently learning Japanese on Duolingo, I am wondering how long it has been since you tried their Japanese course? I noticed it changed significantly between now and when it first released. It certainly doesn't feel like a course like traditional education provides, more like a flashcard vocabulary and grammar builder. I have had to Google plenty of things while using it because nothing is ever actually explained and Japanese has plenty of arbitrary rules, but I don't feel that's all that bad.

I am also curious if you need beta testers for your app, I would be open to giving it a go.
> People and their actions don't exist in a vacuum - we are all players on a team called "society"

If you really want to think of it as a system, then the proper way to think of drug usage is as an escape valve for societal issues like loneliness, hopelessness, etc. If so, then it's important to legalize it so that it can be monitored and measured; if it's measured, then society's government can focus on reducing that measurement as low as possible by treating the systemic issues and not the symptom.
PS except from this one issue I'm a very happy customer, it's a great app :-)
If someone breaks into your server, database Auth won't protect you. And you have to reinstall everything including your database just to be sure he didn't leave holes in those.

And the hacker can still delete your database or steal your data. He will simply download the datafiles and then delete those data from the server. Drop database done without a database password. And no, databases aren't kept encrypted on the server.
If it's so biased and opinionated, what is its value to HN readers? Is there any merit to his opinion? Is there any proof?
Develop stronger cultural and technological safeguards to let people remain anonymous and unmasked, preventing the eventual erosion of privacy.
Beta Release of Collectives on Stack Overflow
In general, genetic differentiation in populations of India is low (0.26-1.7%), but overall genetic differentiation in 18 mixed populations of India is higher (2.23%), similar to the largest single study on 16 tribal groups from central India (2.18%).

https://pubmed.ncbi.nlm.nih.gov/8908794/
VT100 User Guide