skysight-inc/HackerNews huggingface dataset:
I didn't mean the `SELECT STAR` in a literal sense, but more like, please select only the stuff we need. But indeed with PgTyped, as far as I understand it, it wouldn't work because it creates interface from SQL queries.

To achieve what I want you need to do it like all the other ORMs where you have some kind of description of your model and how it maps to tables and columns. Unlike the usual ORM I want to write SQL queries which are then rewritten in an intelligent manner.

So something like query(`SELECT STAR FROM user LEFT JOIN post …`, UserWithPostsModel). Since the library would know the target model, it could rewrite the `SELECT STAR` to something that only asks for the data it needs.

In other words I want to execute arbitrary queries that a mapped into ad-hoc models (unlike typical ORMs where the model usually maps directly to tables).

STAR = *
The cost of living is not being factored in here. Falafel wrap in Berlin is 2-3 EURO. In Switzerland it can be 10-12 eur...
There is no absolute free speech in any country on this planet. There is always a line, and the question to which different nations give different answers is where to draw it.
Kind of production. It was initially written in Lisp, then translated to C++ to go to production and maintained / extended from there.

That's a great way to prototype -- use what you know and then rewrite (or in this case transpile?)
They cancelled because someone caught it and posted it here on HN. It would have been a different story if it's given no publicity
I don't think it has anything to do with the genre or content of his music (which is far from unique), but rather the fact that he's still technically serving a custodial sentence and apparently shot a video violating multiple public health and safety guidelines. I think it's legal for him to engage in commercial activity, but the federal government will probably take most of his profits until his sentence is complete.

https://www.nytimes.com/2018/02/17/books/curtis-dawkins-gray...
Quadruped Robot Using Jetson Nano
At least on the coast in California, the climate is much milder than anywhere else in the USA, and it's easier to have enough clothes for the cold (for the area) spells even when rough sleeping in a cardboard box or your vehicle. I live 50 miles south of San Francisco and do not have air conditioning or use the heater in the winter - most places I have visited or lived in the central USA require both to make it liveable in a house.
Testing components that make API calls
Writing literal SQL in JS would IMO need more tools than just a preprocessor like you describe.

The few times I tried it (mostly in tests to check that the ORM is working properly) the #1 thing I was missing is a prettier-plugin that automatically formats SQL in the same way it currently works for `html` tagged templates.

I completely agree to the 'constrained by ORM' and 'useless features' part though. Postgres `json_agg` is a godsend and I love to be able to reason over simple joins and queries.

BTW, my own approach to use `json_agg`, `json_build_object` and json columns within a typesafe query-building DSL is this: https://github.com/hoeck/typesafe-query-builder

But its mostly for replacing simple ORM fetches, it wont do complex analytical queries. For that I'd like to write SQL directly as query-DSLs tend to quickly stop being usable in that situation.
First off, I want to say that as a past Triplebyte user who was concerned about my privacy after hearing the original news, I appreciate your decision to cancel the feature, and I appreciate your apology.

In the end, I don't think this was an enormous mistake as there was no harm done to your customers.

Still, you can't erase the information you've indirectly put into the world about yourself and your company. Your near-actions have shed a bit of light on your priorities, and customer privacy was apparently not at the forefront of that list. The unfortunate truth is that this begs the question of whether other decisions have or will be made which similarly disregard customer privacy.

I'm very glad that you realized the err of your ways in this instance, and I hope you continue to demonstrate your dedication to protecting your users' privacy in the time to come.
There's also Nitter, which doesn't require sign-in: https://github.com/zedeus/nitter
This is my fear; as developers become more productive, more of a typical programmers job will be non-programming tasks. The in-demand programmers will effectively be more like air-traffic controllers whose job is to just keep track of what needs to get done.
CSS Basics for Typography
Why does USB keep changing?
Oh. I see. Thanks! Seems like a petty symbolic favoritism, very much like what I would expect. Good for Kazik for pointing it out.
The United States has a limitations on free speech written into the constitution: copyright, trademarks, defamation, and libel laws. Do you believe that these alone mean that there are no principals of a free and open society?
Or the band.
You don't have to look far at all to find such cases. Startup takes forever. It's not that there's a specific small operation that programs in both languages do and is O(log n) in C++ and O(n^2) in Java. It's more that the Java programs do work that is unthinkable with C++. They run an optimizing compiler (once they decide its worthwhile on a given function). That's not something C++ programs do. [1] Until that happens, they may be running completely unoptimized interpreted code. They might go through the whole thing again if they fill their perm gen (or whatever it's called) and evict the optimized version of the code. They run a garbage collector which sometimes stops the world. Your tiny function might have to wait for gigabytes of heap to be scanned.

Over sufficiently long runs, throughput is easily within the factor of 2 you mentioned. But over short timescales, thousands of times slower is completely plausible. Some C++ CLI application might run in 5 ms where the equivalent Java program takes 5 seconds.

IIRC there was some article recently challenging the assumption that Java programs commonly reach the optimized steady state at all. I can't find it though.

[1] Except V8 of course on the user-supplied JavaScript. I'd call that quite different than optimizing all Chrome's own code.
I don't really expect the 68k macs will be fast enough to even set up a connection without timeouts, but it's hard to say until I do some more work
Zoom End-to-End Encryption Whitepaper
This is a fair point, there definitely is the ability for these tools to levy a lot of destruction to capital, structure, and people as well. If someone is really looking to construct this as an investment, negative results does not necessarily mean a negative investment strategy -- maybe the machines of war are a hedge that sometimes works and sometimes doesn't.

I think the construction of nuclear weapons post-1950s are an example of a successful hedge, wherein machines of war were invested in, but never caused destruction. To your point, though, it is definitely an interesting and worthy data point if the proposed thesis is being pursued.
Or a PR stunt. This sort of backpedaling has become very common to promote brand awareness
For the same reasons that production, staging, and dev environments are standard.
> The mayor opposed the idea, but it gained support from local powers such as Benioff and Pelosi, and passed as Proposition C. The tax has raised three hundred million dollars annually. But, for now, that money remains unavailable, ensnared in legal challenges from the business world.

Does anybody know about these legal challenges?
We’ve accomplished this with a combination of postgraphile and graphql-codegen. Our setup is basically the same as the postgraphile starter app. [0]

It’s pretty awesome.

[0] https://github.com/graphile/starter
Ask HN: What are your outdoor friendly remote work tips?
Do you do anything to allow yourself to spend more time outside whilst working?

I.e. laptop glare protectors, shadings for monitor or laptop, devices to keep laptop supported while standing or walking.

Appreciate any thoughts!
You bring up a great point, which is the idea of client territory or domains in services. Geographical distribution is usually the main one I imagine with services because of legal compliance. Do you sell personal accounting services or do you do B2B?
The deduction in the US is no longer available to most people working from home since Trump's tax breaks [1]. And even if it were, many people would not get it because it wouldn't be worth losing the standard deduction over.

1. https://www.forbes.com/sites/kellyphillipserb/2020/03/23/wor...
I like MikroORM, but haven't yet used it in a production environment.

Class-validatdor puts you in a deep hole, though. Consider ajv; it's what Fastify uses under the hood. (Honestly, just consider Fastify. It's great.)
AssemblyScript: Passing Data to and from Your WebAssembly Program
Edit 2: You are Kirsten, right? https://news.ycombinator.com/item?id=22083351 If so using third person is extremely deceptive writing in my opinion. Change it to first person: “When I, with a PhD in physics, writes about it first and with much more background knowledge...“. “Writes about it first” is also plain wrong, it’s not like the physicists aren’t arguing and articles already exist https://www.heise.de/tp/features/Fake-News-from-the-Universe... Rest of my comment was written before I thought nixtaxen was Kirsten.

I think your comment is disingenuous: you are the only submitter of articles from Kirsten Hacker: https://news.ycombinator.com/from?site=kirstenhacker.wordpre...

It takes some effort to get banned on HN (and ban is clearly removed now):
https://kirstenhacker.wordpress.com/2020/04/29/ive-been-blac... and personally I think her recent article is a pointless rant: https://kirstenhacker.wordpress.com/2020/04/29/evolution-of-...

I had looked through her site earlier today - lots of skepticism without good follow-through reasoning that can be evaluated.

Examples:
“I don’t really believe that black holes exist because I think that theorists got drunk on general relativity and invented them.“ - https://kirstenhacker.wordpress.com/2019/08/24/signs-of-the-...

It is science to question everything, but it is also science to look for flaws in ones own guesses. https://kirstenhacker.wordpress.com/2019/09/05/blue-skies/ questions Raleigh scattering, but it then seems to accept those questions as equals (her article reads like bad journalism, or evolution vs intelligent design.)

Finally, you are framing this as sexism, which I think will usually give you a poor response. Sexism exists, and it is hard to find effective ways to fight it, but some approaches do more harm than good.

Edit: PS: I do think Kirsten Hacker’s articles are interesting, and a bit of her scepticism seems reasonable and valid to my ignorant eyes: hopefully scientists can use her criticism when it has value. Also if Kirsten wishes to be able to say “I was right” then I think her targets need to be more focused and well argued — if she is sceptical about everything and cherry picking her supporting material, then there is no signal in the noise, and there will be zero recognition for any “predictions”.
Intelligent Disobedience has also found its place in Children's Rights Education offering instruments that help to keep children safe from the rare, but traumatic instances when authority figures abuse their power.

I really don't think this is rare. People do crappy things all the time, especially when they imagine they know what is best for someone else. This is the default assumption of most adults in how they relate to any children in their lives.
I wrote the original typescript bindings for objection. One of the library authors is a contributor to knex.js, which objection uses for query building. Both are quite nice.

With either library, you aren't writing naked SQL, but something like `query.where("updated_at", ">", Date.now())`. Tsc comes into play when you send typed objects into your .where, .insert, ... methods and what you get back from the query.

It's close enough to SQL that you don't lose expressiveness, you're not behind walls of magick due to orm, and you don't have to worry about Bobby Droptables.
Can give me an example?

Let’s say I need to update state.tweets, what do I need to know here?

I know the fetch got handled, then I have my state and new data, what does message passing solve here? Or even better, if it solves something, how do you justify this level of scaffolding that it warrants that trade off?

Edit:

I’ll make one other suggestion. If you believe for sufficiently complex apps something like what you are suggesting makes sense, then provide that sufficiently complex example.

It’s very hard for people to assess this stuff on a simple request/response handler. By this I mean it actually gets used in the simplest possible use cases, where it has no business being used.
The term "phatic" is somewhere in the neighborhood of what you're talking about, I think.
I did not want to request permission to post on behalf of users. With that out of the way, the most minimal way to reply and create new tweets (and even like/retweet) without write permissions is using Twitter's intent feature which opens a (surprisingly) minimal UI for those actions.
I disagree that the city is hellbent on killing off its homeless population. If anything, the city is hellbent on improving conditions for them. The city has allowed encampments to remain untouched in many places around the city since the shelter-in-place started. They have even brought bathroom facilities to their encampments so that they stay in place. These bathroom facilities are supervised and cleaned by an attendant 24 hours a day, 7 days a week.

Again, I don't know why people think the city of San Francisco wants to kill their homeless population. Their policies favor the homeless population over the safety of families that live in neighborhoods other than the Marina, Pacific Heights, and North Beach.
No it’s about where does one draw the line to events that led to the present situation.
> They can ED single-family homes

At market rates. That's expensive. $1M per lot expensive.

> rezone the properties for multifamily dwellings and either auction them off...

Expect those single-family homeowners to sue because the land as clearly worth more than the city paid, they just gamed the system.

> the city could clear out lots of under-assessed junk

The taxes were too low, the buildings are often junk, but the assessments are correct.

> even the owners who get bought out in the ED proceeding will get a huge paycheck

Again, the paycheck is too low unless you making the zoning change before a new appraisal. ED isn't really needed for this; you just need to rezone areas and actually allow building, but SF does neither.

Your reply also had ~nothing to do with property to house the homeless in the short-term. This is how you build housing projects.
Note: There was an MS-DOS 8.0; it did not come with Windows 98, but rather with Windows Me.

I guess we'll probably never see this updated to include that, though!
Qmake. It’s simple, it’s cross-platform, it gets out of my way.
Never realized INSTALLHIGH and LH were not documented. I recall using these, so I always assumed they were commonly known.

And :: for comments is just a creative trick based on how labels in batch files are parsed. It wasn't originally supposed to be used this way, so no wonder the documentation never mentioned it.

The difficulty in writing batch scripts was always that the best (or sometimes only) way of doing many things was to use a command originally intended for something completely different, in a completely non-intuitive way, and examples for such usage were never part of any official documentation. For example:

To display an empty line (instead of "ECHO is on"):

ECHO.

To create a file:

COPY CON FILE.TXT

Even now, the way to load the output of a command into a variable is to use FOR:

FOR /F %T IN ('TIME /T') DO SET TIME=%T

And the best way to empty a directory of all its contents is to use ROBOCOPY /MIR.
I didn't check those typings, but I don't think the model itself is type safe from the looks of it.
SARS-CoV-2 seroprevalence in donor and patient blood from the SF Bay Area
I've been through Triplebyte and am a fan of the mission. This was definitely a major screw-up, both for the opt-out and email dark patterns (I had skimmed the original email and assumed it was opt-in before I saw this thread), and for the subsequent doubling down in response to feedback. Glad you took some time to reflect and reverse course.

I do think the bootstrapping problem is unfortunate - hopefully you can hit critical mass via opt-in.
It is mentioned in this post:
Wealth And Energy Consumption Are Inseparable
http://www.declineoftheempire.com/2012/01/wealth-and-energy-...

I don't know a book in English out of my head that explains some inherent features of capitalism. Gail Tverberg does a pretty good job but she does not explain a lot of things, she just assumes that you are aware of some things:

"There is No Steady State Economy (except at a very basic level)"
http://ourfiniteworld.com/2011/02/21/there-is-no-steady-stat...

Limits to Growth–At our doorstep, but not recognized
http://www.resilience.org/stories/2014-02-12/limits-to-growt...

Partly relevant if you accept:
1. The need of growth in capitalism
2. That growth and energy consumption are interlinked:

Galactic-Scale Energy
http://physics.ucsd.edu/do-the-math/2011/07/galactic-scale-e...

The was one guy he wrote, I think it was in the HBR if I remember correctly, that he found that the US has more and more industrial output/GDP growth with fewer energy needs. This is not wrong but it is only true because the US outsources energy hungry productions to China. I actually emailed him with some data. Unfortunately he never replied.
It exists! You want Scala Slick plain SQL
http://scala-slick.org/doc/3.0.0/sql.html

See tsql string interpolation with typed result sets!
"your pain is better than mine"
yes, appreciate the added detail, but even if it were solely propaganda, enough of the populace latched onto the idea that the opium wars were humiliating to sway history away from western ideals. the fascinating part is the butterfly effect[0] in action.

[0] https://en.wikipedia.org/wiki/Butterfly_effect
I want to do a bunch more of this in the future.
To be clear, there is a quantity of one ADC in the STM32F4, with a multiplexer in front. You could emulate this with an analog switch like 74HC4051, which costs pennies in quantity.
Boeing, were the leader in their industry until they decided to pay $9 per hour. Obviously they went extremely cheap and outsourced the development and that is how they achieved $9/h. They could have bring the same developers in Seattle on H1B and pay them $40 per hour. The result was going to be the same. Importing cheap labor is not beneficial, importing talents is the thing which brings benefits. However, talents are not cheap.
You probably spend most of your time listening to popular podcasts with a large enough listenership that they can get advertisers. There are thousands of smaller podcasters that can’t get advertisers.

Also, most podcast ads are for direct response ads where the effectiveness of the ad campaigns can be tracked somewhat via coupon codes and that either are for large purchases (Casper, Warby Parker) or for subscriptions where the lifetime value of the customer and churn rate can be estimated.

You don’t hear that many brand advertisements on podcasts. That’s the market Spotify wants to go after.

Besides, an advertiser doesn’t need fine grained targeting to know that for instance anyone listening to “The Talk Show” or “Accidental Tech Podcast” is a probably a computer geek with lots of disposable income.
well i don't know how many, but if it's two, isn't that two too many?
That's one way to solve it. More generally, thinking of edge cases or simplifying the problem is a good problem-solving strategy.
I just deleted my account. I was unaware that I even had one. I clicked on a little puzzle that popped in my FB feed back when I was still using.(FB)

This quiz was super easy, and I got pulled into doing an interview, just for fun, and a programming test in a language I had not used in 5 years. I did not do too well, but I did not care, it was for fun!

Well I did not expect that bad score to be recorded and become public!

This economy built around private/public information quiproquo has to be reigned in. I feel for the founder. But I still think there's something going on we need to stop before we get to the Stasi.
Any chance of a post-mortem write up on how exactly things went wrong? Including some discussion on how data's going to be protected moving forward? Now that everyone knows this is a type of privacy violation that could occur, it's going to stay back of mind (a "why should we trust you with this sort of data now?" sort of deal). Potentially losing a job or having career plans stunted because a website added a new feature is a lot of power to trust a website with.
Colombia, Mexico, Toronto, Montreal, New York, SF, Shanghai, Istanbul
Thought, you misunderstood my opinion, mostly that sometimes there are project constraints, usual the language.. between the python constrain asyncio it's not bad.
I disagree, the site is by developers for developers. Every developer on planet earth is well aware of privacy issues and the evil dark pattern of negative options. They knew this ahead of time, they took a gamble and shit hit the fan. The apology is not heartfelt or sincere, its just damage control.

If they want to correct this mistake, turf the product manager or make a $25K donation to the EFF as an act of penance.
Can anyone explain why they'd be a LinkedIn data partner yet did this to compete with LinkedIn?

Go to their site and paste this in your console:
window._linkedin_data_partner_id
Do you have a Chief Privacy Officer? Or Chief Information Security Officer? Was the issue raised and the privacy impact miscalculated (not ideal, but mistakes happen) or were the potential privacy implications overlooked entirely?
Opinions on Gitlab's Workgroup model for eng team efficiency
Curious to learn about anyone's experience in an engineering team with this type of structure to help with team velocity, clarity, and less cross-team friction...

Pros and cons?
So I guess they banned the CDC
& WHO from posting anything after they both parroted Chinese propaganda (read: lies) about no human-to-human spreading ;)
Have a look at the Wikipedia article about the 4477th Test and Evaluation Squadron and Constant Peg :) [1]

1 - https://en.wikipedia.org/wiki/Tonopah_Test_Range_Airport#447...
Another song feelS
s quote relevant in light of this comment thread:
"You're so vain, you probably think this song is about you".

A racketeering rapist in a different country being delatformed isn't relevant to the President of Poland blocking criticism of his misbehavior from appearing in the media.
A real-world analogy is a brick standing upright on the table. If you topple it and it falls, some of the potential energy is gone.
This ^. This is the issue.

Calling it only a "feature" is just downright twisting the facts.
What exactly is true? That remote working is always better in all conceivable scenarios and that anyone saying anything else is stupid and wasteful and probably smells too?
“oops we forgot to NOT do the plainly shady wrong thing and make your private data public, for our benefit - thank you SO much for reminding me. Shady shit will never happen again. I promise. ;)”
The Rage of Research
Quantization and Floyd-Steinberg Dithering in Go
I don't think the Cybertruck's styling is truly groundbreaking. It looks to me like a simplified and exaggerated version of the Lamborghini Countach's angular bodywork. And I'm not even particularly interested in cars, so that's just a famous example I happened to know, not the oldest. See this earlier work (1968) from the Countach's designer:

https://en.wikipedia.org/wiki/Alfa_Romeo_Carabo

Maybe it goes back even earlier than that.