skysight-inc/HackerNews huggingface dataset:
We have started looking at something along the same axis of "improving understanding of your queries". Our product has nearly 10k SQL queries that need to be managed for each logical installation.

By converting a SQL query into an AST, you can start applying business logic to the actual syntax of the query. Put another way, you can query you queries. You can also run reports across all SQL to determine things like "show me everything in the product which references this table & column", or "Which queries reference a specific magic string constant?". More advanced reports can be made too, such as "Which queries join tables A, B & C together?"

We haven't taken it to the next step yet, but hypothetically we can go from AST back into SQL and start doing some super crazy shit like patching hand-written queries programmatically. Once something is in AST form, you are basically working with playdoh that another tool like LINQ (and a bit of recursion) can trivially cut through.
Of course this is a rumor, but if true, they can somehow make it work.

https://www.macrumors.com/2022/03/10/studio-display-pro-laun...
This is par for the course. Done by majority of big corps and nothing wrong with it imo. Stating TikTok is a danger isn't a stretch. The hyperventilating in this piece is hyped up by republican and FB angles but almost every big company is doing comms like this.
Even if they do, it’s not their responsibility to fix those problems. It’s government’s responsibility to step in and fix bad behavior that market forces can’t fix (like when it’s more economically viable to destroy thousands of livelihoods per year than to invest in human review processes)
I can't wait until the tipping point when people realize just how nasty Google is and start avoiding all of their services.
How do you use comment fields for a botnet?
Ask HN: How to negotiate contract details Amazon (specifics in post)
Some context: I have negotiated b2b contracts for businesses, as well as contracts for work in the past; but I have never ventured father than pushing back on a non compete, or benefits of some kind.

I am interested in the following areas/I don't have experience in the below:

* Being able to do (unrelated) consulting work via an SCORP while employed at Amazon.
* Being able to work on a game while working at Amazon as if I didn't work at Amazon (licensing).
* Continuing to contribute to FOSS projects

All of the above are obviously off company time and hardware.

I am searching for and reading previous posts on these topics; but would appreciate any links to previous discussions on this, or direct feedback from FAANG employees.

What would you have done differently in the above areas?
At what point in the hiring process should I be pushing for the above?
If these are unrealistic, is there a middle ground I can shoot for?

Once again thanks for sharing your time/experience.
Or they will use your IP, say it was from the same device, or different IP same geo location...be afraid...be very afraid.

"...Youtube Account Suspended" - "...All i do is watch videos and subscribe to my favorite youtube channels while sitting on the toilet!... I have no idea what to do."

https://support.google.com/youtube/thread/21108892/youtube-a...
Installing the Asahi Linux Alpha on My M1 Mac Mini
No, voting is much more complicated than that and the history of our voting system speaks to that. Purely popular voting, as in a pure democracy, is demonstrably flawed - that's why representative democracy came about. The foundation of your argument is also flawed; if rural areas are so overrepresented then we'd be seeing a lot more emphasis on the funding of rural schools, hospital systems, clean drinking water, and broadband. Instead, these issues are regularly underfunded and are even joked about on forums like this.

There's lots of issues in the US to solve. Voting, imo, is just the pet issue of the losing party.
People who consider this an issue either wouldn't work for Google to begin with or end up butting heads with management and leave the company. The benefits of self-selection.

There is also a lot of internal corporate training and team-building designed to redefine "ethics" to make this sort of stuff acceptable.
Not in many culturally conservative households. These parents exert a lot more control over what their children are exposed to / allowed to engage with.
It doesn't look like digging in, it looks like they're preparing for a pivot, hopefully towards the points you addressed. It's kind of obvious people are only miffed because of who they're suing, but this is a required step in moving forward. It doesn't mean they just want money (it's kind of a low amount) or don't intend to settle.

This situation also brings a much more interesting problem to light, namely, how do companies protect themselves and recover from internal sabotage?
At least in the United States fictional depictions of children having sex, without the involvement of actual children, are legal.
Apps are effectively utilities today. Apps have replaced taxis and phones. Order food through an app. Transfer money and buy things through apps. Find jobs and work those jobs through apps. Pay parking with apps. A lot of the developing world don't have a web app for certain things.

Refusing to have say, Telegram, on your app store is similar to not allowing a telco to operate. Also as much as I dislike Meta, if Apple/Google decided to remove WhatsApp/Instagram/Facebook, that would disrupt a lot of lives. Many businesses heavily rely on WhatsApp, more than they'd rely on landlines in the past.
Like in Nazi Germany or like Communist East Germany?
All I've said is that your ideological prejudices will cause you to have more difficulty finding good quality candidates (you are selecting against things correlated with quality) and you'll be paying more for equal quality candidates as a result.
Changes in food, availability, cost, marketing, etc would be obvious things that could cause it.

Whereas plastics -- When you look at the staggering amount of plastics pollution coming out of rivers in East and South East Asian and the subcontinent, it correlates pretty well with some of the lowest obesity rates in the world.
> ban developers from using personal accounts to associate with a project

As I understand it, this may not be sufficient, since Google also looks at things like "logged in from the same browser" or "logged in via the same IP" to find associated accounts.

> mark a developer's account as "fired for cause"

Which, practically (and maybe legally) speaking is not something Google needs to know. Then again, in a world where Google can shut your company down arbitrarily, perhaps it is something Google needs to know...
In the software development world I would suggest: knowing how to interface one's own software with existing systems to automate tasks.

I am thinking specifically about programming in pyhton/javascript/etc. and the act of requesting web pages, reading files, or databases and parsing this to quickly gather lots of available information about something. This could be a weather data scraper, reading all files from a directory to transform them, checking repeatedly if some signup for something important is open yet, pushing receipt pdfs from emails to an archive, ...

The examples all have in common that you need to know how e.g. REST/file/database access works and you can use these to gather information quickly and automatically. Knowing how to interface with common systems can save you lots of time, therefore I would see this as a productivity multiplier.
Hey, thanks for the feedback! We try to follow as much as possible the RGPD, do you have some insight on the topic for us?
If you are doing too many parallel things and context switching become a PITA, have an org document for each of your tasks, write your thought, experiments with code and output, your decisions, keep a references list with links and other important things.

Is also quite commnon to go back to some tasks to copy some code or pattern which you used, this will save you a lot of time.

If you have ADHD, us it to keep focus, you can easily manage tasks inside an org document, even go to the point of using just the console for work if too many things distract you.

Also check where you waste more time, optimisation should be focused, trying to increase your performance in some task which is not a bottleneck will cost you more time than if you just don't do anything.

Most of the time I asked myself "what is the next step?" and "what I was doing?", as well creating small pieces of code which require a of plumbing/debugging to later on fit into a bigger system. So org is the most productive thing for me.

But consider what you want to improve, before trying to improve any/everything.
HB11 Energy's method is non-thermal. They use a petawatt picosecond laser, which is so intense that it shoves the target nuclei sideways into the nuclei behind them.
Appreciating art often requires suspension of disbelief.
In the drug dealing business cartels always try to wipe out competitors before taking over their markets.
I haven't checked in a while, but with Apple you used to have a much better chance of people shelling out money for/in your app.
If you deal with computationally hard problems, I think there's a whole toolbox of utilities with unbelievable performance, in which millions of PhD-holder-hours have been poured, but that get ignored more often than not.

- SAT modeling languages & SAT solvers

- same for SMT (satisfiability modulo theories)

- Constraint programming

- MIP (mixed-integer programming) and its special cases, like

- TSP (traveling salesman problem)

The latter is maybe more anecdotical (as in: fewer direct applications), but it is emblematic of the whole phenomenon. We see a steady stream of claims that NP-hard problems are "impossible" or take "billions of years to solve". We also see blog posts with the latest ML approach "doing the impossible" and providing reasonable (not optimal) solutions to 50-city TSPs. All this while ignoring that with proper maths, we could solve 50-city TSPs to optimality by hand in the fifties, and now Concorde routinely solves 100k-city instances in seconds on an iPhone.
Zoned Storage
This makes me proud to have been faculty at University of Tennessee, even if I recently resigned :)
You know the fear of nuclear war that the younger folk have been experiencing for the first time the last few weeks. It was like that. Constantly.

Sure, video games and MTV were new and fun. Computers were new. But aside from that, it was different decade with different styles, but the day-to-day life was the same. Go to school, hang out with friends, have dinner with family, maybe watch a little mork & mindy on channel 57, and go to bed.
What is the best SASS based dashboard solution for Prometheus?
> I still don’t understand what anyone is proposing - force companies to provide support against their will?

That's what laws are: forcing people to do things they would otherwise not do.
"the majority of the community and industry is in the middle group"

I.e., "intermediately-experienced" and younger than the "most experienced". As I said. You are unlikely to find yourself relying on a library written by a beginner.
I use Discord regularly (and moderate a couple servers), but the experience has never been like IRC in the slightest. They're very much different platforms, and while I won't say that Discord is a bad platform per-se (beats Telegram groups), it certainly isn't the next incarnation of IRC in any sense. A more apt comparison might be calling Discord a fast-paced and immediate Reddit; a centralized service that promotes the illusion of different communities while ultimately serving to extract value from it's users.
That's an emoticon ;)
Hi Hacker News,

Alon from Switchboard here!

We’re really excited to share what we’re working on at Switchboard — a platform to help teams develop tailored onboarding, feature engagement, and upsell experiences that activate and engage their users. Think of Switchboard as a layer beneath your interface — a platform to define the underlying flow logic that powers your product’s UI components.

We’ve spoken to over two hundred people building these types of experiences and have heard a consistent set of problems:

- The experiences are complex and it's hard to develop the logic and timing

- Ways to keep track of “who’s seen what” don’t scale

- Customer data is hard to access

- Teams lack the control to orchestrate experiences

- Non-devs don’t have visibility and can’t self-serve

We're building Switchboard to help! We're hard at work on:

- A visual flow builder that lets the whole team collaboratively define logic and content

- SDKs and APIs that plug into your UI components, make it easy to access customer data, and abstract away flow state & content

We’re still looking for a few folks willing to give early versions of what we’re building a try. My email is in my profile if you're interested!
> The problem seems to be that tech companies approve EDRs without much checking. Then the argument somehow becomes it is essentially impossible for them to check because there could be any of the thousands of police departments in the world requesting the EDR?

What I got from reading is that there are conflicting concerns. An EDR needs to be answered as quickly as humanly possible; they exist for cases where it's likely that someone would die while waiting for a warrant/subpoena. Secondarily, tech companies really don't want to have a headline like "School bombed because $socialMediaCompany refused to hand over records in time".

The competing concern is privacy. The problem isn't directly with the number of police departments, but that there's no way to automatically authenticate the requests. They'd have to manually look up the police department, call them, and try to get routed to the officer that supposedly sent the request.

The difficult part is that in order for EDR's to be at all useful, they need to be faster than getting a warrant. They can probably get a warrant faster than Facebook or whoever can finish their game of phone tag to check on the request. So right now, they're checking the only thing that can be validated within the request itself: the domain name.

The solution he calls out seems workable: a global identity provider for police through the FBI or another government agency. In my rough interpretation, we could use something like GPG to sign the requests and have the FBI run a keyserver. We would need to secure the GPG keys, but if they were kept offline on USB sticks except in the rare case of submitting an EDR, that should be far better. It would require physical access to the keys to submit an EDR, and tech companies can infer that someone has physical access to the keys by the signature.
I feel this user’s pain. Obviously we don’t know of food action was warranted in this case. Sometimes it isn’t and there being no recourse is unacceptable. Knowing someone at the company, having a sufficient Twitter audience or relying on posts like this getting attention should not be how this is resolved.

Side note: I absolutely won’t use my Gmail account for any other Google service. It’s just too great a risk and it’s ridiculous that a developer ToS violation can also kill your Gmail access.

I see a fundamental mistake these companies make with automation: optimizing for the wrong metric.

The metric they seem to use is the number of cases handled by automated systems. What they should use is the number of cases their workers can deal with.

The difference is that the second one doesn’t reward false positives. There are some cases that need human review. You should even be able to pay for expedited review (ideally refunding you if the decision is made in error).

A good example of this is Tiktok’s reporting system. Like many such systems it’s clear that it just takes actions based on the number of reports. There is no penalty for fake reports. So people brigade creators they don’t like (typically politics and science) and those affected have to go appeals processes. It’s ridiculous.

Put another way: automation shouldn’t replace people. It should augment their effectiveness.
So, please correct me if I'm wrong, but I think I read a similar HN article a while back, that said a users company and their personal google developer accounts got "associated" somehow (can't remember the specifics), so I'm not sure if that would be a mitigation for this issue.

I do agree that it's a sensible thing to do and it _should_ be enough to mitigate issues like this.
It's interesting to me how much of "I got over X" is framed as "X is no longer interesting".

It reminds me of how "younger generations are going to ruin everything" has been said by older generations since at least the ancient Greeks.

It's a rather self-centered way of looking at things, IMO.
> We need legislation forcing companies to manually review algorithmic decisions that impact people's lives, and have a proper appeals process.

What you want is human judgement, but it will be hard to legislate that. What can easily happen is the human parroting back the underlying reasons for the decision. In this case "We have reviewed your case, and according to our records the account is associated with the problematic account"

I have had this happen to me in bureaucratic situations with no computers involved.
On average, these sorts of undermining tactics are uncommon because most companies have limited resources that are better spent on improving their own product or service.

That said, for the subset of companies that operate in fiercely competitive markets with well-funded players, this sort of activity is common.

In my prior company, where 2 competitors & us had raised 9 figures in venture capital, we found multiple instances of such undermining attacks going on from 1 of the competitors. Although we never engaged in such activities, it was clear to me that we were at a slight disadvantage due to our lack of willingness. Imo, such activities require sociopathic leadership, and unfortunately, that sort of personality is overrepresented in the c-suite.
They only have that share because developers continue to support their platform.

Too bad developer greed prevents an effective boycott of their ecosystem. If enough people stopped giving them money, they would change.
You don't get the 500K for your coding skills. Sounds like it's to soothe your conscience...
And vim in particular: free, vast availability, no GUI needed, regex, macros, plugins, folds, block editing, syntax highlighting, drop in your vimrc and go, runs shell commands, etc.
If the environmental impact is the only relevant factor for human interaction, then yes you're right. However society doesn't abide by isolation.
The Future of Literature Is Video Games
This kind of thing is entirely normal.
Satellite offices seems a good idea, if it's cheaper for the company.

In the case of my job, they could have maybe 20? for the price they're paying now.

But I wouldn't go anyway. Maybe once a month or every six weeks or so. Just because there will be people who prefers an office and to keep up with their faces, but I have no business there.
There isn't. Google is just in the news more frequently simply because they have many customers, but that doesn't make it any less of a problem (across the board, not just Google).
Today, people from Ukraine are glad of products of such war machine companies.
You'd be amazed at how a little regulation right-sizes things in corporations. I work in banking -- there's no grumbling about our regulatory landscape. We just have teams of people who make sure we're compliant, and we get through our audits. So, to answer your question: yes.
These stories are always one sided and gloss over the minor policy violation parts.

When we get the full story it's usually less black and white. Quick skim over the thread and it sounds like they let an ex-employee have access to one of their accounts and he committed multiple violations? Was he spamming? Was he uploading malicious content to the store?

Also, don't build on others platforms if you want to control your destiny. You can't have it both ways.
This is the issue with data being tied and connected....

Not long ago, someone here raised similar concerns with Microsoft 's ecosystem

It stemmed from their current underway process to force all Minecraft accounts to Microsoft accounts, and the current Microsoft account process, if you don't add a phone number during account creation, locks and bans the account automatically after a week with they only recovery option being to then give a phone number, and most voip ones are auto detected and not accepted.

If you set up the account with an alternate email, that has no effect. Setting up TOTP has had scattered reports over sometimes allowing the account to not auto ban you, but recent reports are that this too often won't stop it.
There are reports that using Microsoft s own authenticator app, does stop the account from auto banning you unironically, that I have not confirmed

Of course this means they can then tie it to potentially your computer pending how you set up Windows, or Xbox live, etc.
Which is a risk if you've been formerly banned from something like xbox- everything is now linked, and therefore subject to action automatically with no human team to talk to about the process.

Also, if you then go and give it to them then afterwards try to remove it, the system will not let you without extreme effort, and more details.

I worry greatly about this situation where our personal accounts are all tied together through hardware ids, mandatory phone numbers,IP addresses, and different accounts across systems, only to all get banned or locked out at once with no recourse - or demanding more data(like Minecraft indirectly giving Microsoft every single phone number for the biggest player base in the world, as mandatory(with specific exceptions for like one or two countries who's laws they are working around now, with Korea appears to be one)

Also, so many companies use Amazon, Google, Microsoft company emails and systems- your full name is there, so there is a increasing risk that if something happens to your company account, the systems knows your personal accounts and by name, bans or affects them too.

Privacy advocates are being proven right about the need to be able to not give info that ties everything together
A few months ago (around the Christmas break) I decided to build a web UI for something. The last time I personally touched “front end” HTML or JS was when IE5 was a thing, although I’ve done a lot with server side TypeScript and the Node ecosystem.

I spent a couple of days evaluating the options, coming at this with fresh eyes, but not as a beginner to programming or architecture, and found the following:

- Ember makes the most sense to me personally, but at the time the stable ember packages pulled in several dependencies npm called out as vulnerable, and editor support was not great. The webstorm plug-in basically didn’t do anything useful. Finally, it was not obvious that TypeScript was a first class citizen, which put me off.

- Vue seemed ok, if a little harder to reason about than Ember - I can see why people like it but there didn’t seem to be a compelling reason to put effort into it.

- React is hands down the “winner” of the ecosystem, is easy to get up and running with and has great editor support. As someone that generally likes functional programming, the concepts clicked nicely. TypeScript was first class, TSX seems nice enough.

In the end, the limited time I had meant I just wrote a native Mac app with SwiftUI, and resolved not to touch web stuff for another 2 decades if I could avoid it.

I have a huge amount of respect for people who can keep the front end web ecosystem straight in their head - I really don’t understand why people consider “back end” the more complex technical domain.
It's also a tribute to their favorite band: Buddy Holly and the Crickets.