skysight-inc/HackerNews huggingface dataset:
I've been to a few chinese restaurants in the Bay Area that have nailed this. Especially the ones near commercial and office areas. Menu has tons of images with a number on every image. A list next to those images running from top to bottom with a comprehensive list of names and ingredients with a number for each dish. Ordering for new and regular customers is a breeze, fast and I believe low error rate as well.
> the “ravenous, fast-moving fall armyworm” that can fly up to 100 kilometers in one night

Thats some distance. Assume thats only possible if greatly aided by the wind?
Lightning Labs | Frontend Developer, Crypto Protocol Engineer, Dev Ops, Infrastructure | San Francisco | Onsite or Remote | Full-time

https://angel.co/lightning/

https://lightning.engineering/

Lightning Labs is hiring! We’re looking to expand our team to build technology that scales Bitcoin and blockchains. Our current focus is the development and deployment of the Lightning Network, an open blockchain scalability protocol. We push the edge of innovation with regard to blockchain scalability, privacy-preserving smart contracts, and cryptocurrency UX. If you’re interested in one of the positions below, please apply using our careers page: https://hire.withgoogle.com/public/jobs/lightningengineering. And if you know someone who might be a good fit, we'd very much appreciate any referrals.

{Crypto Protocol Engineer}:

Experienced systems software engineer versed in applied cryptography, peer-to-peer networks, distributed systems, open source software, and cryptocurrency protocols to design and implement core protocol and algorithmic components of the Lightning Network. Solid programming skills, experience with Go, C, or C++. Prior contributions to crypto protocols and open source software collaboration preferred.

{Frontend Application Developer}:

Frontend developer to build secure cross-platform second-layer blockchain applications. Our applications are built on React, React Native, MobX, and Electron, communicating with a Lightning daemon over a binary RPC protocol. Ideal applicants will have experience building and shipping React Native applications and maintaining open source projects.

{DevOps Engineer}:

We currently deploy a number of backend services that make Lightning easier to use built on technology such as: etcd, Kubernetes, Prometheus, Grafana, and Traefik. Your role would be to help us secure and scale these systems via intelligent automation and robust service architecture. Experience with AWS is a bonus, as well as experience with Bitcoin, particularly in the area of key management.
the source gives a description: "We're killing more people because more people are ignoring traffic signals We've charted the ominous increase in road deaths in the past several years, and now there's a new bit o...

and links to this picture of a red light.
http://cityobservatory.org/wp-content/uploads/2019/09/red_li...

That's all the content I can get out of their source code.
>The number of generations a moth will have in a year varies based on climate, but in her life span a female will typically lay about 1,500 eggs

From wikipedia.
It sounds to me like there's a reasonable middle ground here, where you treat your SQL query more like an AST than a string. So you can do something like myquery = select("col1").where("col2 < {}", my_value), then later myquery.limit(10).offset(20).

You're still working with SQL as a language, but you're manipulating it directly instead of trying to go via string formatting.
Is there any sort of user management, so each user have access to stats about its own website? We are building a WordPress hosting company and would love to offer this as an alternative to Google Analytics to all customers.

Right now, each customer gets its own Fathom install, but I would prefer to have it centralised to make management easier and decrease the amount of non-standard packages on the WordPress containers.
SQLAlchemy can accept raw SQL with:

result = db.engine.execute("<sql here>")

I haven't met an ORM that wasn't more work to implement, especially when trying to keep schema changes in line with existing deployments. That said, I'll take a decent DB client SDK any day; I don't want to spend too many cycles on connection pooling and such. I just want it to handle variable substitution and concurrency primitives at the language level.

I don't think there's anything wrong with using tools to help you generate good SQL queries, but you should see them clearly and own what the database is doing. MySQL and Postgres have a myriad of useful functions and extensions that ORMs don't utilize or hide from the developer. That leaves the application to do multiple queries or a lot of logic that isn't needed.

It doesn't have to be gnarly; any SQL query that can't be handwritten on an index card is probably too cumbersome to maintain. A 1000 line SQL query is a code smell that means the data model could probably be improved, perhaps with views.
> I don't think others mean concatenation of values where placeholders should be, but the fact that the query itself is a big string.

They explicitly contrast using an ORM to the practice of concatenating strings here:

> > SQL is backward to a programming language. Creating statements by concatenating strings?

> Unless some sort of query builder is used to literally build this big string for you.

I'm not entirely sure they're aware of the existence of query builders outside of an ORM given the dichotomy presented.
Right, I misspoke. Thank you. It's a subtle difference but the implications are massive.

For anybody following along (since daenz seems more informed than me already), the 9th Amendment and the discussions that led up to it flesh out the idea that the Bill of Rights merely guarantees that certain rights won't be infringed even though many other rights also exist but were not explicitly mentioned. (https://en.wikipedia.org/wiki/Ninth_Amendment_to_the_United_...)

The biggest modern example I can think of is the non-enumerated yet Constitutionally guaranteed (according to the Supreme Court) Right to Privacy which played a pivotal role in the Roe vs. Wade decision.
> Pedestrians continue to die in disturbing numbers. Things like speed bumps, red light cameras, and more signage are virtually useless.

Haven't red light cameras been linked to increases in accidents? I'm pretty sure I've read it was in part due to decreasing the length of yellow lights to try to increase revenue.
I don't use "raw Arel", I use most of the parts of ActiveRecord -- but I definitely appreciate that about Arel, and use that aspect of Arel intentionally. Composable query parts made of code.

I think it's a mistake to think you can't write good efficient SQL for well-normalized schemas with AR. You can. Usually anyway, for a great many use cases.

[Arel is _really nice_, but sadly Rails absorbed it and considers it "private API", especially in it's most sophisticated features. I use em anyway, they generally don't break... but if I wasn't using ActiveRecord as a whole, I'd probably use Sequel instead.]
> The problem is prepared statements aren't composable. So saying i want this query but also with this extra where in there and a limit and an offset means you have to write a whole new prepared statement. Or concatenate strings!

Absolutely, prepared statements would not be appropriate for that.

> With an ORM you can construct the prepared statements programmatically.

That's not limited to ORMs though. You can also just use a query builder. In fact I would argue that an ORM that provides that functionality is a query builder with additional ORM features on top.
I actually do use Ubuntu every day for development. I also use macOS every day. They both get the job done relatively painlessly. I enjoy macOS more in general, but I like using Ubuntu in a VM because I can snapshot and restore.
I don't think being embedded in a system is an excuse. Especially when that system takes money from people by force through mandatory insurance requirements and shuffling around costs so that you're paying for more than the service you want. Not to mention how the medical community criminalizes anyone but themselves providing healthcare, even though biochemists are better equipped to handle chronic illness. Doctors could work outside the system, and many do. Or they could quit being a doctor and work in the alternative healthcare industry in a myriad of ways, and many do.

And how am I the difficult person when I tell a doctor that I have excruciating pain everywhere, they do some tests, the tests show that I'm "fine", and the doctor gets angry at me? Sounds like the doctor is the difficult person in this scenario. They assume that they are so correct that it justifies treating me like shit. Or maybe it's my illness that is difficult and the doctors are taking that personally and taking it out on me? This has happened to me over and over again and the interactions were always pleasant until tests came back negative. If I was the problem then wouldn't the interaction go poorly from the start? If a doctor can't help but stereotype people, then they are not a good candidate for the job and should be fired. I don't think there is a single industry in this country besides the healthcare industry that says they just can't help but stereotype people.

I can't even get testing done without a doctor's approval. It's a racket.

It's not a mental illness. And there are millions of sick people getting together online talking about the exact same experiences that I've had.
I've been trying to turn old broken micro/mini usb cables into new ones using these https://www.aliexpress.com/item/10PCS-LOT-YT2153B-Micro-USB-...

But they're a tad too tiny/frail. Anyone knows some larger micro usb connector kits ?
Hey, thanks for this link. I can't believe I haven't come across this before now.
iPhone 11 benchmark leak spills what few secrets were left
Goroutines are quite a lot nicer than async for a few reasons. Firstly, there are no “forgot to await” errors, secondly there is no need to worry about some library making a sync call way down the call stack and therefore blocking your event loop, and thirdly goroutines can use all cores on a CPU to parallelize CPU intensive tasks, which means you don’t block the event loop unless you really are out of CPU. Blocking the event loop is a really big deal since it can cause health checks to fail which can cascale onto other instances and bring your app down. We’ve experienced this with both CPU- and IO-bound event loop blockages, and they’re really hard to debug. These just aren’t issues that happen in Go.
No, the FSF did not transition everything to GPLv3. glibc, IMHO one of their most important projects remains at LGPLv2+.

This is due to Stallmans fear of losing popularity of 'his' code and is the reason I no longer have any respect for the FSF, who unfortunately have been exposed as hypocrites.
Location: NYC

Remote: Sure

Willing to relocate: probably not

Technologies: Full stack web dev

Resume: patientplatypus.com

Email: pweyand@gmail.com

I'm a full stack web dev that makes artsy websites right now. I can program in anything that involves a website more or less - if you have anything super specific let me know. The website I'm making now is in React and Clojure. Clojure is pretty neat.
Shape (YC S15 | Start X F17)
San Francisco, CA | ONSITE | Full-time Hiring | 3D Computer Vision ▪ Sr EE ▪ Sr Data Scientist ▪ Sr Backend ▪ Sr iOS App & Web Developer ▪ and more | $120K-170K + equity

Shape is the company behind ShapeScale, a 3D personal body scanner, scale, and fitness tracker that digitizes your body in photorealistic 3D. Its companion app then shows you where exactly you have been gaining muscle and losing fat by color-grading your 3D avatar.

We are looking to expand our engineering team. It's challenging both on the software and hardware, due to ShapeScale's robotic, rotating and expanding arm. On the computer vision side, we face interesting challenging involving 3D reconstruction, rejigging, and data collection.

All open roles: (https://shapescale.com/careers/

Interested in hearing more? Reach out to careers@shapescale.com for more information
Sounds like you want a query builder.

A quick search for "query builder golang" (We are on HN after all) provides the following library:

https://github.com/fragmenta/query

An example from the README:

// In your handlers, construct queries and ask your models for the data

// Find a simple model by id
page, err := pages.Find(1)

// Start querying the database using chained finders
q := page.Query().Where("id IN (?,?)",4,5).Order("id desc").Limit(30)

// Build up chains depending on other app logic, still no db requests
if shouldRestrict {
q.Where("id > ?",3).OrWhere("keywords ~* ?","Page")
}
> You don't create statements by concatenating strings.

> Sometimes you have to concatenate, e.g. to specify order by clauses.

So, should I concatenate or not?

> This is something database vendors need to fix.

How long do you propose I wait before giving up and using a library that allows me to safely and sanely compose queries?
If we can't read the article we can at least judge their code, like the 18 lines of JavaScript and CSS to display an emoji, or the fact that the entire text of the article is missing.
> (I have this problem with SQLAlchemy right now, where it's taking several seconds per request CPU bound in the ORM). Undoing this is literally impossible without a near total rewrite.

for the write? writes are not usually much of a performance issue except when people are inserting thousands of rows. You can replace flush with direct INSERT/UPDATE or use the bulk API. Pre-setting primary key values will also improve performance by an order of magnitude. Share some of your code and profile results on the mailing list and we can look into speeding it up.

SQLAlchemy always provides many techniques to optimize areas that have performance problems, not to mention the primary direction for most major releases is that of new performance features and improvements year after year, despite having to deal with the dog-slow cPython interpreter. No "total rewrite" of your application should be needed.
My experience is actually the opposite - every project I worked on that relied on an ORM actually benefited from replacing it with a clear architecture pattern and a query builder. Having the concrete notion of what is being passed to the DB allows easier debugging, and it is way easier to solve performance bottlenecks. As an example, recently I replaced several hundred lines of complex ORM oriented code with a 10 line CTE that would perform the iteration and calculation being done on the client side - the result was a 10x increase in performance with a fraction of the memory.
By not using an ORM, the developer also stops treating the database as a "black box". It is a "black box" conceptually, but the more you understand how it works, the better your applications will perform. As an example - knowing if, inside a transaction, when you're performing a read it comes from the server you just started the transaction or some slave that may or may not be updated (due to propagation delay) may seem picky, but its one of those things that is very hard to debug afterwards as a transient error.
Let's say I'm in the closet, and GLAAD sends out an invite that lands on my father's calendar. Hmmm, who among his contacts also has GLAAD in theirs?

I'm sure there are other scenarios. I don't want my contacts list being used to filter email for other people in my contacts list. It's my list. Not a public web-of-trust thing.
Woman Opens Her Home to 97 Stray Dogs as Hurricane Dorian Strikes the Bahamas
With the MS stack it's really easy. You can design the schema and procs, views, etc. in Visual Studio, then have it compare against each environment to create the deployment script.
I have no idea what the API you describe would look like. Where you somehow describe to it data to save (and fetch), without any reference to tables, the fundamental unit of an rdbms? I guess it'd probably look a lot like... an ORM?
That limit can be raised, apparently. I've seen mention of limits up to 30K concurrent invocations.
The type system is more expressive, but much clunkier and also it needs to be expressive to accommodate all of the weird things people do in Python (and you still can’t model SQLAlchemy types).
If a doctor thinks the system they work for is the problem then maybe they should be getting a different job instead of always making excuses.
Yeah most cities are removing red light cameras, it's been universally accepted as a failed experiment.

I think distracted driving is the problem IMO. I cannot go anywhere without seeing people driving while looking at their phones and cops right next to them not doing anything about it.
Yeah, although it's a bit more involved than just getting any NodeMCU board.

A bare chip makes it much easier, and you need to balance what comes online and how long it sleeps to still work in your use case.

It's not all that easy in some cases, but it can be done. I've used [1] as a resource before in my own projects.

[1] https://github.com/z2amiller/sensorboard/blob/master/PowerSa...
In my experience and limited testing, even with warmed-up caches, Chrome (without Adblocker) was faster than Firefox (with or without Adblocker), sadly.

I still use Firefox due to the security benefits of ad blocking, but I don't find the experience particularly enjoyable (although, thinking of it, it may have either significantly improved in the past ~half a year, or I just don't notice because of a more powerful CPU in my new phone).
I think what they’re proposing is something like “if I want to read and then update a value, incrementing it by one, the proper way to do that is to tell the DB to increment whatever value it has stored; not to increment my local representation of the value and then tell the DB to overwrite the value with it.”
That “unless” is the whole point...
What's surprising is that doctors are legally required to order lab tests when they are non-invasive and have 0 risk of harm. They do not need a doctor's approval and could be much cheaper by cutting them out of the loop entirely.
Same. I had to turn off the feature. It's rather unprofessional to have a meeting for (and this actually happened) a $15 blowjob on my calendar. I mean, I guess there are some illicit businesses that, being very time conscious, plan and slot such things in detail. But it's still the sort of thing I expect Google to catch, especially when the email is already in the spam folder.
I think we're saying the same thing. :-)

I would imagine that the AirMessage Android app is actually in communication with the AirMessage server on your Mac. It uses some automation (perhaps via something like https://github.com/shusain93/OSXMessageProxy) to talk the the Messages app. The connection is encrypted from there to the other side, as if you were sitting in front of your Mac. This happens in reverse the other way.

Hacky, and now you own the weak links in the E2E encryption chain. But a neat workaround, in a pinch.
You will if you ever do concurrency stuff in go. The way goroutines capture their working variables in a closure make things like `x := x` useful and clear (once you know why you do it in the first place )
seed the whole system with live bitstream of a video feed trained on a wall full of lava lamps
Woah thanks. Dunno why someone downvoted this lol
IIRC we don't even have masks that can really take EUV, the mask is destroyed after each exposure.
I don’t think we can really put the genie back into the bottle there. Uber and Lyft have proven that app-based hailing is what people want. The costs will go up though.
Wondering whether it's possible to rent mainframe time...there is a guy on youtube who once gave old mainframr accounts for free.
I'm extremely worried that once Google disables ad blockers in Chrome, websites will wholesale block any and all non-Chrome browsers. Be it through user agent sniffing, feature detection, or fingerprinting, Firefox simply won't work anymore.

The future of the web where Google is in complete control is straight up nightmare fuel. Microsoft in the early 2000s never scared me as much as the future we're headed into does.

This won't be IE versus Netscape since websites are no longer served as plain old HTML. They're messy, thick, and impenetrable javascript blobs--not documents. We're not arguing about websites simply not rendering correctly in the less popular browser. This is a battle for the absolute control over information distribution.

What do we do to prevent what's happening?

Google already shot down XHTML, which was rich with semantics. That was a web written for documents and tools that could query those documents for meaning.

Whatever Google has become needs to be dismantled. The ad company can't be the browser company and phone company. It's a perverse alignment of incentives.
See my peer response. I would imagine all traffic from the Mac<->other device is encrypted. You're responsible for securing the Android<->Mac link.
Major is a bit harsh.

As far as I know this was only an issue for legacy architectures.
Note that if in Google calendar you mark one of those events as spam, all the recurring ones are automatically removed, whereas if you just delete one it does not remove the others. There's a 'report spam' option (desktop only) in the little drop down options when you open the event.
A big part of it is the fact that the Chinese government hold enormous sway over private companies. The US for example has a constitution which protects private ownership, and which the courts have upheld. China has no such protection for its private companies.

Take for example the recent law requiring companies in China to “support and cooperate in national intelligence work“. Private companies in China have no ability to fight against such a law.

So I wouldn’t say it’s a “holdover”... let’s not forget that even with China’s economic modernizations, it’s still a totalitarian regime.

See:

https://www.afr.com/policy/foreign-affairs/no-such-thing-as-...

https://www.theguardian.com/world/2019/jul/25/china-business...
Large org, existed for 10-20 years, 100-1000 employees, worldwide offices. Either worked, or had someone chucking some serious money at it for years down the drain.
Maybe I'm just not in a targeted locale, but the "basecamp" serp on Google for me looks totally reasonable:

https://imgur.com/AVRTl60

If anything, this is an over-commitment to a single interpretation of that query, which could also be about a variety of different topics, including climbing, an Airstream trailer, and others which appear farther down the page.
Same here. People messing with their phones are the new drunk drivers. Texting, messing with stuff on Waze/Maps, changing songs on spotify, etc...
I highly doubt anyone is using 64 character wifi passwords because QR codes are an option.

Good luck typing that into your playstation with a controller and your chinese IoT product.

The best solution is still the middle ground between readability/memorability + strength. Or stored in a password library until needed.
I suspect it’s one of those case where things are bad because it made no economic sense to make them better, a bit like airplane boarding.

In the case of taxis, replacing them by Uber and lyft made no sense globally, because it was just exploiting the drivers, and using venture capital in an unsustainable manner.
Personally speaking? I don't think so. I liked the first one but the rest felt like a cashing-in attempt. But that seems to be the case with everything these days.
Apparently i forgot to link the first study i referenced: https://conbio.onlinelibrary.wiley.com/doi/full/10.1111/cobi...
Just to be clear app didnt stop working only the backend service had a downtime close to 2 hrs. During this time i was able to still use phone as a key. Only things that rely on backend service wouldnt work, like remotely unlocking you car from different country for whatever reason.