skysight-inc/HackerNews huggingface dataset:
The current stock price is always a prediction of future earnings x the probability of those earnings. A lottery ticket might in theory be worth 50 cents but have a high probability of being worth nothing.

In essence guessing if a stock is likely worth it’s current price is asking if it’s a low variance bet (T-Bills), high variance bet, or miss priced.
Hi HN,
CloudYali is a service to discover AWS Cloud resources across accounts and regions instantly. I have worked in AWS cloud for last 6 years, and many times I had to get an inventory of resources in one place. The tools I found were not adequate, including AWS Config.
Two major issues I found that needs to be fixed:
1. Coverage: Many these tools cover a limited set of AWS Resources. e.g. AWS Config covers merely ~103 resources across ~230 AWS services. The coverage is less than 20%.
2. Usability: These tools are either designed at regional or account level. Eg. AWS Config is at regional level, and requires configuration changes to make it work across regions.

CloudYali, is designed to work across multiple accounts and regions by default. To begin with we have added support for ~250 resources (and will add more in going time).

It is also possible to search for the resources based on Account IDs, regions, resource types.

CloudYali, also maintains the resource configuration change history and shows a visual timeline for the changes. Which means, you can compare the configuration changes in UI head-to-head.

CloudYali, also maintains the information about the "dead" or inactive resources. These are the resources which no longer active or live.

CloudYali is easy to setup and is a readonly service.

This post is for the AWS users who might be interested in such service. We are looking for cloud engineers who are willing to try our service and provide feedback.

For the early signers we are giving 2 months free with multiple AWS account support. Please note that the product is slated to launch in September'21. The Live working demo will be functional by next week.

Thank you!
nobody's got time to make obfuscated code rather than solve actual problems
Questions of jurisprudence are occasionally raised on here. The story surprised me, and in this day and age, I suspect there's a problem worth solving in this. If I stood outside you home and took pictures of you every day, should I really profit from that, without you having a say?
Name one game that a human is better at than a trained NN. Starcraft 2, chess, go, Dota 2, have all been shown that AI wins. If a game is digital, AI will win after sufficient modeling. I don't think any of that negates the merit of the games themselves for human play.
Another subtle issue with SQL is that it tacitly assumes a great deal about the internal architecture of the database engine implementing it. SQL is designed to be easy to implement for the way SQL databases worked in the 1990s. Unfortunately, modern high-end databases today have radically different internal architectures, are capable of much greater internal expressivity as a minimum, and are designed to support data models as first-class citizens that weren't even on the radar in the 1990s. Patching the first-class capabilities of modern database kernels into the SQL language, such as generalized recursion, can often be awkward or require non-standard syntax or behaviors that defeat easy optimization. The DDL has similar issues, particularly around its concept of what an "index" can look like under the hood or the myriad ways in which data can be organized.

I've used and even written SQL databases for much of my career. SQL is pretty satisfactory for what it was designed to do. I view SQL like classic inheritance-based OOP; it works well for the problem domains for which it was originally designed, but is poor for efficiently expressing problem domains that are better expressed in a composition-based or functional way. Yet it worked so well in its original domain that we try to apply it everywhere. The diversity of data models and the kinds of operations we want to do with them today is far greater than was considered when SQL crystallized into its current form.

The limitation of most nominal SQL replacements I've seen is that they commit the same sin of SQL originally: overfitting for a problem domain that the designer was most interested in. There is an appetite for a really good SQL replacement if done well, and in principle anything SQL can do could be directly translated into a new language for compatibility.
I'm in the same boat - introverted and living in the country. I have tons of human contact because I have a family with whom I live. I spend most of my non-work time with them. I go out to stores, I go to church, I even see friends and extended family on occasion.

Frankly, I have very little difference in the amount of human contact I have now vs. what I did when I lived in a city before the pandemic.

Where you live can certainly influence how much contact there is in your life, but you can be surrounded by people in the country just as easily as you can be a hermit holed up in your apartment in the city.
Sadly using the renamed column name in a group by or order by doesn't work on all database engines.
The FA presents a good argument and as a consequence I deleted Google Maps and a few others. I also turned off Location Services for a few apps, notably WhatsApp. I'll try Apple Maps for awhile which in the Bay Area should be a low bar to clear. I'm also looking at OpenStreetMaps apps.
I think when looking at least at large scale applications in the context of games (and not just super-expensive showcases), like in the Stockfish chess engine, we see that it's not primarily about depth, it's about architecture design. Reference: start here https://stockfishchess.org/blog/2021/stockfish-14/ and go down the rabbit hole...

In the broadly useful domain of recommender systems (which typically make use of some type of RL-like feedback loop, but can be implemented using simple clustering approaches), at least in 2019, neural network-based approaches didn't seem to fair too well, either: https://arxiv.org/pdf/1907.06902.pdf (arXiv pre-print, but this is an award-winning paper).

Since then, it seems that researchers are moving away from getting deeper and deeper (the low-hanging fruit), and try to be more creative instead: new architectures, combining symbolic (logic-based) and sub-symbolic (ML-based) AI, etc.
We plan to release 1.0 in a month or two. The upcoming beta 3 (in 1-2 weeks) will be the last beta before the RC.

That said, EdgeDB is already stable and solid thanks to the amazing Postgres that we're building it on top of. It's definitely ready now to play with and learn.
>All work on my Personal Game will be performed outside of my regular working hours.

>I grant to Amazon a royalty free, worldwide, fully paid-up, perpetual, transferrable license to any and all of my intellectual property rights associated with the Personal Game and my Personal Game development.

So by working for Amazon, you're obligated to give them something you create, that they will not pay you for...

This has to be one of the most insane things I've ever seen...

I swear every big tech company is so far up it's own ass it can see out it's mouth.
I have decade old hardware that is certainly inefficient, but my services hosted have taught me so much it's not even worth the comparison. Yes, electricity is cheap in America but we all choose to spend money on our hobbies as we please.

I'll bet there's a few nitpicks with your hobbies where you trade a lot of time/money/something that I don't necessarily understand. And that's okay.
Who is "we"? In many places, vaccines for children are restricted or not recommended.
It looks like in this case it was known to be ineffective when it was approved. I thought the FDA was supposed to protect us from snake oil like this?
IRC technology news from the first half of 2021
That decision was so overtly concerning, I already knew what the headline was about.

I'm suspect that a lot of lesser, bad behavior had to go unchallenged, for us to wind up with a decision that was this blatantly corrupt.
I think Germany is kinda special case in Europe (privacy laws etc) so google maps are probably a lot worse then in the rest of Europe :) [Never use google maps in Germany and i only visited Germany once in my live :)]
This is a switch and switching is hardware accelerated. While you can theoretically route with this this, it is incapable of routing at gigabit speeds, let alone 10 gigabit speeds, once you need even a few rules.
Cuz it's a hard job. Try telling someone in a position of serious power who is going to loose his kid next year to back off. Who wants that job? Put your hand up.
I’m sure he’ll get right on that.
Why describe them as soy? I understand the criticism, but I don't see the relation between bloated sites and soy.

Inline the SVG and CSS.
Doesn't clarify this much to me. Thankfully the wikipedia article does:
"ClearOS (also known as the ClearOS System, formerly ClarkConnect[3]) is an operating system marketed by the software company ClearCenter. It is based on CentOS and Red Hat Enterprise Linux"
take more <g>
Having our mind staying young in a body that stay young longer is not guaranteed
All the other ideas get dark very quickly. In addition, CO2 accumulation makes the mind a bit stupid quite quickly, even in an office, so I wouldn’t stay there…
Every time a company like Enron fails with positive stock value that theory is demonstrated to be objectively false.

As we know that theory is wrong we should discard it, which then opens the question back up. Anyway, expectations of future earnings are far from the only way stocks are valued. If you can predict a short squeeze for example you expect a jump in price independent of fundamentals.
Same here. I live in a quiet house far away from everything in the middle of the Swiss Alps. I get the majority of my food from small farmer stalls around me. The most of other things I just order online. Except my partner the only real contact I have right now is my family I see maybe once a month. However they visit me as I don't really want drive down to a busy town. I have no work related contacts either as I life from my own projects.

Even when my partner is away for a few weeks I don't feel alone. I've spent months alone in Asia without feeling alone.

I feel really lucky today for being in this situation. Some people turned their life upside down and I just got more of the life that I always wanted.

Edit:// I forgot to mention that I indeed have friends and also did all the social things regularly 2 years ago. My point is that I often felt like I have to attend these social things and I actually don't miss them. Still chatting online from time to time.
That's a bit of an odd example to choose.

This[0] has a $600 MSRP, with twelve 10Gbps ports and two 25Gbps ports. It's ~32W before you add the SFP+ modules, and upwards of 50W if you have all modules populated.

In the benchmarks they list, this can provide somewhere on the order of 13Gbps to 40Gbps of routing, depending on exactly what you're doing. (Smaller packets will lower these numbers, but if you care about bandwidth you're unlikely to be worried about smaller packets... at that point, you probably care more about kpps.)

[0]: https://mikrotik.com/product/ccr2004_1g_12s_2xs
you don’t even need bluetooth. there’s license plate readers on all highways which feed into traffic indicators on apps or those road signs that say how many minutes away places are
Global Tax Overhaul Gains Steam as G20 Backs New Levies
You are right people shouldn't be prescribed labels. You think people are limiting themselves because of labels. Isn't it the other way around? People act in such a way that they believe a label describes their personality or behavioral pattern?

I think you are the one mislabeling people. Being an introvert doesn't mean social skills are low. You might work with or be friends with strong introverts and have no idea.

There is also this idea that as an extrovert you have great social skills. I know plenty of people who crave social experiences, attention, or constant companionship that have poor social skills. You know them – they may say hurtful things, claim their own jokes as funny and laugh at them, disregard other people's feelings, lack the ability to control their vocalizations or comments, get in people's faces, create distractions, try to control conversations, etc. You get the point. Should those "strong extroverts" work hard at improving their social skills? Sometimes that means not talking or seeking solace in their own thoughts before entering a an existing social gathering.
What experience have you had? How many INDs, 510ks, etc have you worked on? Because this does not line up with my experience at all. IME FDA is very anal about even the appearance of the conflict of interest, and loosey-goosey is the last descriptor you would ever want to use for any interaction with FDA.

That being said, informal interactions where FDA talks you through regulatory options do happen for high priority / unmet need diseases, but there the “friendlies” are compartmentalized away from the those who review the applications.

My guess is that the review will show that someone from FDA met with the company to facilitate the application because Alzheimer’s is a priority disease, but strict compartmentalization from the review process was maintained. If not, then someone is getting fired.
The people who want more privacy - including zealots - also don't want the notices, popups, options, etc.

It's a mistake to think privacy zealots are requiring all those things. They are not; they don't want them. And so they are not to blame for them.

They do want to be able to find out what commitments a company is binding itself to, to be able to hold the company accountable under the law, which acts to curtail some abuses, but even that would be much preferred in the form of statutury commitments that could be assumed by default everywhere, the same way consumer protection law works.

Those endless annoyances are the result of companies that are actively hostile to users who value privacy and to statutory privacy policies in general. So companies make the popups, in particular, intrusive and often difficult to reject properly. Sometimes they outright lie about the GDPR requiring some heavy duty options lists.

I say companies. Usually the worst popups on a site are not from a site's own company, they are from third party surveillance-based advertising services or similar used by the company. Naturally, those third parties are the ones most actively hostile to a privacy oriented society, and on an individual level, most interested in persuading or tricking someone into accepting the tracking.

With regards to CA privacy notices: Imagine how refreshing it would be if it was like consumer protection law protecting you when buying things mail order and against false advertising and faulty products. You wouldn't need to receive a privacy policy at all, because there would be a statutory privacy policy you could always assume and all companies adhered to it. Perhaps you would be able to opt out of privacy explicitly, but you always had the option to take the service without opting out of the statutory privacy policy if you wanted.
Ask HN: SQL tooling: REPL-likes, Intellisense, etc.
I’ve gotten quite spoiled by the nodejs REPL and by TypeScript. I’m in love with the idea of sum-types. Threads over the years on HN about SQL have me constantly telling myself: there must be a better way to “live” SQL so that I feel like I’m having a more proactive dialogue with my db. I feel like I should be able to know, as I’m typing a query, what the semantic possibility space is for eg syntax completion / tablename / return type of object, before I have completed or sent a query.

I mostly use my “host” programming language or pgsql to write queries. Is there better tooling for this for either SQLite or PostgreSQL? I’m interested in moving my personal structured data into this format to make working with SQL feel more natural and interactive to me.

Surely this tooling exists. But surely the tooling is better than what I’m finding in my Google searches. Anybody have a killer setup for something like this?

Online is ok. One-time software purchase is ok. A working tool-chain of multiple tools is ok, as long as it results in a more real-time interaction with the existing real model of the db.

Any recommendations?
I don’t see how voluntarily letting a service see your location is an invasion of privacy.
> Also will it handle large scale deployment with Fail-Over and Replication?

Built-in support for that is coming, but it's already possible to run EdgeDB on top of Amazon RDS, for example. Ultimately EdgeDB is built on top of Postgres, so it will support replication and fail-over and many of the existing deployment strategies.
Practical system design for recommendations and search in industry
I haven’t used Google maps since 2017. I started using Apple maps once they fixed their issues in California and took the stance on privacy.

I have never missed Google maps.
How to Create Events in JavaScript
Orlando’s Newsletter
Surface Tension by James Blish?
That's no terminal, that's an entire computer you got there. Albeit a very sad one with a busted keyboard.

Doesn't need to be plugged into anything but electricity, and probably didn't even have one of your fancy Ethernet jacks. No Wi-Fi either; that hadn't been invented yet. Just a standalone machine that did what it could, until it was so cruelly abandoned.
I think the "not a pandemic" was a reference to the WHO's month-plus delay in declaring a pandemic.

There was definitely a mindset of potential panic being worse than the disease itself early on. Perhaps not downplaying per se, so much as resisting making any major pronouncements of danger until the evidence was overwhelming.
Thanks for sharing. I dream of making my perfect UX design tool and little things like this help keep me inspired.
> nice office where I can focus

A nice contrast to the frat-house bullpen of many offices. It's like trying to study for an exam while your roommates are having a party. "Oh, just wear headphones."
Are stocks (and real estate) just an appealing store of value for wealthy people? Are changes in typical price to earnings ratios over time just a marker of inflation?

Edit: looks like the P/E ratio almost doubled in 2021 from 20-25 to 40-45. Is that just because revenues were down during COVID, or is it where all the stimulus spending ended up? https://www.multpl.com/s-p-500-pe-ratio/table/by-year
Yeah it also seems like he didn't give in to the fear and went about his life as best as he could. He went to the dentist early in lockdowns. My social circle would've cast you out for that and it is for sure a smaller circle than it was in March 2020 because of media provided moral imperatives that if you didn't follow week to week, you were no better than a Republican

Actually, it eventually made me Republican.
Every day over 100,000 humans die due to age-related disease. The lack of research in aging and life extension is one of the biggest resource misallocation of our times, and it is leading to massive welfare losses.

There are so many entrenched beliefs that curb research in this field: 'Aging is "natural"', 'Who would want to live until they are xxx years old, anyway?', 'Aging keeps population levels down', 'Aging removes bad people (dictators etc.)', 'Death makes life scarce and therefore valuable', ...
No, aging is fixable and all other problems, real or imagined, have more direct solutions.
We have to realize this, as a society, immediately and stop all the nonsense prevarications.
Parents should not have to outlive their children, and neither should children have to outlive their parents.

Mathematical models that claim to “prove” that aging is inevitable are trivial to construct by introducing assumptions that fit your narrative. The assumptions are biologically plausible in isolation but fail to account for the full complexity of biological life and, indeed, reality [1].

[1]: https://doi.org/10.1186/s12915-018-0562-z
klib? https://github.com/attractivechaos/klib
Yeh, this is lacking right now. GQL makes joins much easier to write than SQL, which is what you want to be using in your components. But GQL is not great for offline-support and caching. You want your frontend to know about how your data relates to each other. Your frontend GQL should query a local SQL db.

I'm not sure you need a full SQL implementation on the frontend though, as the data is not going to get all that large to need the optimizations it affords, but it would be nice to be able to use the same queries on your browser DB as your backend DB.
Is this just a quote with a semi-random table of contents/outline below it?

What is the purpose of this post?
And if you are going to talk about personality traits then at LEAST talk about ones with some scientific backing (the Big 5)
On this topic, I love the (too rare) CSB videos. I’m baffled that 1L of liquid nitrogen expands in 700L of gas, and despite being inert, can kill in a minute.
amazon is one of the most rusted institutions in America. 70% of americans view it favorably. https://drive.google.com/file/d/1OgPzcB75uxXiFmTjUUb-ITIr7BF...
You know that most people don’t have a choice in whether or not to have a cell phone, right?

Privacy fatalism helps no one. Demanding that someone who is concerned about their privacy to “justify” their situation — one which they have no practical way of opting out of - is victim blaming.

Some people don’t want to be tracked. Any steps they take to reach that state are valid. Absolute privacy is impossible in this dystopia we now inhabit —- much of which has been built by the people who frequent this board —- but these doesn’t make Google’s absolutely trash privacy practices any less egregious.
The counterpoint here is that the internet archive isn’t a for profit service which is claiming exact reproductions of other people’s content as “new work”
What? I think that’s also a bad idea. I didn’t mean “advise” in the sense of “I’m a lawyer giving you free advice” I meant it more as “that sounds like a bad idea to me, some random person who isn’t a lawyer”
Amusing typo inverts the meaning (rusted vs trusted).
Agreed, I struggle to get anywhere close to 1gbit/sec apart from Steam.
my mom cooked a bass last week for dinner. was cheweing through and swallowing micro plastics. it was bad
If it's a fake drug that's been priced at a level to break American health care [1], they could potentially be this kind of employee that actually care or perhaps they just considered the corruption too obvious even for the FDA and wanted to clear themselves of charges.

[1] https://www.theatlantic.com/ideas/archive/2021/06/aduhelm-dr...
Safari also blocks GA by default, also plausible have some versus articles about Cloudflare analytics (both server and client side)

https://plausible.io/vs-cloudflare-web-analytics
https://plausible.io/blog/server-log-analysis
> hck is a shortening of hack, a rougher form of cut.
Not to get into a flame war with Frontend devs, but does this 'akin to engineering' only apply to backend? I know that there are a lot of choices made on the frontend too but don't know enough to see if it has engineering-y constraints in this context.

Similarly, even on a team that does engineer a distributed system, only some of the team members do that sort of activity, the other members follow the set conventions so things work out. Eventually they could work their way up to doing 'real' engineering. I really don't like calling only some things engineering as much as I agree that software development doesn't have the rigor of traditional engineering fields.