skysight-inc/HackerNews huggingface dataset:
> I JUST WANT IT SAVED

Storing data is a hard problem and likely to be a leaky abstractions. "Save my object" is OK until you need to ask questions like how to find such objects, by which attributes. If I update this and another object, do I care that they are done in a single transaction?

An "I JUST WANT IT SAVED" friendly abstraction would be JSON as a value in a key/value store. As a bonus you can choose your consistency/availability trade offs by going "nosql". For example Azure table storage. Nice!

But now what if your object is an invoice with a link to an account. Is than an ID or is the account info embedded in the invoice. Etc. There is a lot of design thought that needs to go into data. You can stop using SQL, Tables or whatever but these problems don't disappear.

ORM allows you to almost forget about these issues for simple CRUD-like tables. And for the start up style SaaS doing a bunch of boilerplate crud stuff (to begin with) something like ActiveRecord saves the day. But anyone using such conveniences should also learn database design, query optimization and such things too.
What an interesting rabbit hole this took me down. So it looks like Ampligen is "Poly I: Poly C12U is designated by the molecular formula, [rI(13):rC(12)rU(1)]n where: n = 46–138", which has now been improved to longer dsRNAs with additional U (https://patents.google.com/patent/US8722874).

The most interesting thing I've come across is that they dosed it as naked RNA by IV and it is rapidly cleared (https://www.ncbi.nlm.nih.gov/pubmed/1974294).

They should try formulating it in a lipid nanoparticle. I bet they'd get some really interesting PK/PD.

So the drug turns on RNase L, which basically shreds all RNA in the cell. It's a kill switch for the cell. Kind of like the last ditch effort to stop a viral infection. What's interesting about this drug is that doesn't turn on TLR3 really well because of the U:I mis-matches so it looks like only some cells turn on RNase L. I don't really get that part.

The other part if they see increased in NK cells but not Tregs. Again, some cell (maybe APC?) is taking up the oligos from the blood and activating things a little bit, but not enough? That may explain why the clinical results for CFS (for example) were so hit or miss: the clearance kinetics of this type of drug is going to vary wildly from patient to patient.

Another weird thing I noticed is that today, the company changed their name to AIM ImmunoTech and just got a twitter account (https://twitter.com/AIMImmuno). Seems like it's tied to the New Yorker article coming out.
I believe it will be in Typescript and, if you look at his last couple of posts, he mentions building a documentation generator for Typescript code specifically for this project.
A browser extension that replaces occurrences of 'serverless' with 'CGI-bin'
Show me your source on that quote. More and bigger? If you don't have a quantifiable prediction (temperature, sea ice extent, drought extent, hemispheric snow mass totals, precipitation amount, etc), you don't have a valid hypothesis. You just have broad blind brush that you can conveniently retroactively fit any outcome. That's not science. Nostradamus had the same methodology. Make your predictions as generic as possible and you'll always be correct.

"More and bigger" are relative terms. Pegged to what date in history?

It has everything to do with NOAA's ability to predict 6 months out because uncertainty for predictions increases as a function of time. If you can't predict 6 months accurately, you have even less of a claim to predict 60 years accurately. That's how predictions work.
According to my compilers class professor there’s a broad literature of optimizing the “giant table with all signatures” approach with heuristics for saving space by rearranging and merging the tables of different classes into the same space or re-using offsets across classes to make tables smaller. But the general problem is NP-complete so can only be solved heuristically.

A SAT solver should actually be able to handle this fairly easily, because in practice, you don't get long complex chains of overlap between the interfaces implemented by common classes. If someone feeds your compiler an adversarial input you can just fall back to the naive implementation.
Here’s an old article about the performance characteristics of Deques.

https://www.codeproject.com/Articles/5425/An-In-Depth-Study-...
I need to read the paper, but on high-level looks indeed similar.
Just FYI, TypeScript is expressly a superset of JavaScript, so you don't need to guess!

https://github.com/Microsoft/TypeScript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
Are you by any chance placing these ads in-feed? They do call this out. It's definitely odd that they're doing this.

https://support.google.com/adsense/answer/9189959?hl=en
At my company we use C#/EF with 50 developers and a gigantic codebase and database.

A statically typed binding to the database with 'find all references' etc.. The ability to write a few lines of simple understandable code that turns into a much more verbose SQL query aids in readability, maintainability, and understand ability of the code base.

I have used other ORMs and feel that EF/LINQ is way simpler in that the same query syntax is used for in-memory and database operations. They can be mixed and matched for doing really intensive data processing with relatively few lines of very easy to read code.

My only comment would be that using an ORM - you do need to understand how it works, and how the code you write turns into SQL and a lot of the details of contexts and tracking.

It's like flying a plane - big, complicated, it will get you where you need to go very fast and effectively, but if you don't know what you're doing you'll crash right into a mountainside.
DEQs also allocate internal arrays with hardcoded size only (8 in std, if I remember correctly)
Nice demo! I definitely agree that the experience of building a real-world products out of ML-related ideas is what often differentiates juniors from seniors. Building sklearn models out of clean data can only prepare you so much for the real life.

Luckily people are trying to address this gap in education options! For example, https://sharpestminds.com is a platform where you gain skills by building such a full-stack ML project under a mentorship of an experienced data scientist yourself.
Ask HN: Why are you coasting at your day job?
Deciphering dark matter: the remarkable life of Fritz Zwicky
You can enforce patterns via types. You can also have default optimizations. The problem with SQL is to choose optimization you have to do it by poking the syntax.

For example:

query1 = select(table, columns, optimization_method="auto")

query3 = join(query1, query2, joinOptimizationMethod="auto"...)

Obviously the above example is trivial, wrong and probably won't work. But I hope it paints a fuzzy picture of my point. That is that the optimization or 'plan' should be explicit. You choose auto or you dive in and you change it yourself. No language or syntax hacks.
It's not the electrical performance that bones you - it's the emissions performance. USB stands out like a Dutch brothel in the emissions chamber if you mess up the routing or return path.

In signal integrity terms, I've found it quite robust.
Do you have a job posting portal? I couldn't find one on your site. Your product and tech stack looks appealing. I was curious about a job description if you had one available.
> since the voting public did not have "all the available information."

What information then was available but the public didn't know?

> Because no one could have possibly known what the terms of Brexit would be, because they would have to be negotiated.

So then it's fair to say that information was not available.
I couldn't give concrete evidence to support nor oppose your arguments since I'm not a sociologist by any means. For any reasoning I could think up, or just observation I have to say, you might always find much more "another factors". How I wish you could speak a little Chinese so that you can investigate each pro-China account with social engineering and provide more proof on your conjecture.

However, I would like to translate a comment from that Weibo link (feel free to call it propaganda):

多个英文媒体对这次封号问题的报道反映出了西方社会及媒体对中国近几年来民意变化状态不了解的事实，也反映出了他们对中国民间广泛接受反分裂和支持政府价值观这一现象的不理解。依据他们的理论，共产主义国家的平民必然是反共的，当事实与他们深信不疑的理论相左时，他们选择发明事实来修正理论。

The coverage of this blocking issue by several English-language media reflects the fact that Western society and the media do not understand China's public opinion changes in recent years, and it also reflects their failure to understand the widespread acceptance of anti-secession and support for government values. According to their theory, the civilians in the communist countries must be anti-communist. When the facts are contrary to their belief in the theory, they choose to invent the facts to correct the theory.

And another comment:

we know them well, they know nothing about us.

But all in all, I can't make 100% sure they are not bots/brainwashed/part of the operation/mindless repetition... Any help to know the truth better instead of just speculations would be appreciated.
The site loads but the article content does not
> AWS does tons of stuff around VPCs....I feel like they really want me to use them (or their customers really want to use them)

VPC is a very convenient fit for enterprise customers extending on-premises networks into the cloud, I think that's the market it's mainly focussed on.

> I know it's "public", but that seems irrelevant in the era of cloud services.

It's not irrelevant, but neither is it necessary critical all the time; there doesn't need to be a one-size- (or even one-shape-)fits-all universal approach to network security, and AWS encompasses a lot of different customer setups, including enterprises for which it is a virtual extensions of the on-premises internal network.
Clockwise | San Francisco (SF Bay Area) | ONSITE | Publicly debuting #1 on Product Hunt, Clockwise makes your calendar work for you by creating & protecting "Focus Time" across entire organizations.
We've raised >$11M in Series A funding from Greylock, Accel, Slack Fund, etc.
We are looking for experienced engineers to join our current team coming from RelateIQ, Salesforce, Google, Twitter, Asana & Zephyr Health to help reshape productivity, calendaring & employee health.

Open Roles:
* Back End Engineer (IC - Senior - Lead) * Front End Engineer (IC - Senior) * Product Designer * DevOps * Machine Learning Engineer

Apply here: https://www.getclockwise.com/careers

or email your info to michael(at)getclockwise(dot)com

If you want to help, we're always open to chat!
Another way of looking at the problem is that (in many naively-implemented backend codebases) almost every layer and component of the stack ends up depending on the ORM objects, which has the consequence of allowing any of those layers or components to do arbitrary database operations.

You might have some 'data access layer' class/module but if you're using an ORM, it more than likely accepts as arguments and returns as results some ORM objects. The ORM objects returned from the data access layer invariably have methods like `save()` or `delete()` or `validate()` or some magical property when called ends up issuing another query (think: `customer.orders` or `order.customer`). The objects you're supposed to pass to your data access layer as arguments probably also have constructors that, under the hood, grab static references to singletons (often the connection factory).

In this way, the data access layer is leaking the opportunity to (if not the responsibility of) invoking save/delete/validate functionality to any and every part of the code base, when it should really be contained in one module. Moreover, you cannot reason about whether a particular data object is persisted, could be persisted, or was persisted just from its type.

That is, your Customer object always exposes `save`/`delete`/`validate` even if you got it from a data access layer method called `getCustomersWithRecentOrders`. (Idem for the elements of `getCustomersWithRecentOrder()[0].orders`.) There's nothing stopping you from pulling out `getCustomersWithRecentOrder()[0]`, mutating it, then calling `save()` (or `validate`, or `delete`)—which never-ever makes sense.

Instead, `getCustomersWithRecentOrders` should return behavior-less structs, and your data access layer should provide an `updateCustomer` method. Moreover it should be impossible to construct the type that goes into `updateCustomer` with data that does not validate.

When you implement this kind of data access layer, maybe you use a low level DB driver, maybe you use an ORM for some niceties, but either way, you shouldn't leak types from these dependencies out to the consuming module. However I rarely see this kind of discipline in 'naive' ORM apps (rails/django/laravel/CoreData/Hibernate/etc).
How to Build Hangman with JavaScript
The good: ETP by default, battery life improvements, flash deprecation (finally!), about:debugging, event breakppints (finally! #2)

The bad: userChrome/userContent not being loaded by default, I don't understand why it would cause a delay at startup.

The ugly: More Pocket crap.
There are many serious issues around how Lyft/Uber (and many others) treat their "employees" and I'm happy if things are moving in a direction to help them out. However, as a customer, Lyft/Uber has been HUGELY better than any previous taxi experience, in the San Francisco Bay Area.

Before Uber was a thing, I tried getting a taxi in the Bay Area at 3 different times. Months apart. Calling different companies (that I found by searching "Bay Area taxi"). In ALL cases there were issues, huge issues:

* the first one I called said he'll be there in 20 minutes(!!) but 30 minutes later he didn't show nor called. I call back and someone else answers and says they'll be there in 20 minutes, ofc 30 minutes later nobody showed up...

* the second time I needed a taxi I called, said they will be there in 30 minutes and never showed or answered any subsequent calls

* third time I think someone DID show up, after about 30 minutes (15 minutes later than they said they will)

Absolutely horrible, unacceptable experience. With Lyft/Uber I never had any such issues and I took many more rides with those. Not to mention it was much cheaper (the latter likely has something to do with the main complains being raised now by their employees).

Look, I fully support cab riders to get a living wage, even if that means significantly increasing my fare, but I do hope the new legislation doesn't result in going back to the pre-Lyft/Uber taxi experience because that was just insanely bad. Also, at least some of the drivers I talked to were doing this as an aside so it makes total sense for them to be contractors (one guy was temporarily in the Bay Area doing some construction work so he was Uber-ing on the side for extra money) so that is another issue that needs to be considered in legislation to still enable this type of use case.
Prepared statements on anything but Oracle are only asking for trouble, if the distribution of your parameters does not match that of the query the statement was compiled with you can easily end up with bad query plans. Furthermore these issues are hard to analyze (no parameters in logs) and even harder to solve.

I have hit this problem in just about any system using prepared statements. The performance overhead of query planning is minimal compared to the headaches it prevents.
Economics of Electric Vehicles Mean Oil's Days as a Transport Fuel Are Numbered
Well, even Ramanujan claimed that the Goddess of Namagiri use to give him mathematical solutions. You are in a good company!
> That you view the situation as ORM or concatenation terrifies me. No wonder SQL injection remains so prevalent.

I don't think others mean concatenation of values where placeholders should be, but the fact that the query itself is a big string. Unless some sort of query builder is used to literally build this big string for you.
This recently started happening to me too! Spam emails with ical/calendar attachments get loaded into my calendar even if they're appropriately flagged as spam in my Gmail inbox.

It's especially annoying as the spammers create repeated alerts (often late at night). I've wound up with dozens of these I have to manually clear from my calendar.

All of this started a few weeks ago. Perhaps it was a regression rather than a new exploit?

Google/Gmail engineers: please file this as a bug.
ADF Improves Physiological and Molecular Markers of Aging in Healthy Humans
4C Insights | Chicago, IL & Seattle, WA | Full-Time | Onsite

- Software Development Engineer (Full-stack)

- Software Development Engineer (Frontend)

- Software Development Engineer (Backend)

- Senior Software Development Engineer (Full-stack)

- Site Reliability Engineer [Chicago]

- Database Engineer [Chicago]

See all positions here: http://jobs.jobvite.com/4ccareers

4C is a global leader in data science and media technology with solutions for multi-screen marketing. With more than $1 billion in annualized media spend running through its software-as-a-service platform, 4C offers activation on Facebook, Twitter, LinkedIn, Pinterest, Instagram, Snapchat, Amazon, and NBCUniversal as well as TV Synced Ads across display, search, social, and video.

4C is building the next generation of marketing technology and data science. A little about our team: we are a full-stack team of experts in frontend, backend, product and design. We care deeply about our stack and tools, focusing on the best to get the job done.

We work on hard problems of scale and performance, while making sure our users can be as successful as possible through using our platform. Our stack is mainly Python and Javascript (ES6). We leverage React, Flask, Celery, Kubernetes, GraphQL, MySQL, Mongo, Redis, and other technologies to help us get the job done.

Our Headquarters is in beautiful Chicago in the Loop with sweeping views of the Chicago River. In Seattle, our office is located in the heart of downtown with easy access to all things great about the Pacific Northwest (and is a dog friendly office!).

We are looking for colleagues who are agile, creative, smart and generally amazing. 4C is committed to diversity and inclusion, and we are proud to have a team from multiple locations, cultures, and backgrounds. This is what makes 4C great. Find out more at https://www.4cinsights.com/careers/ and what it's like to work at 4C at https://www.4cinsights.com/resource/like-working-4c/
I thought this was the idea behind the USB-C eMarker.
I think it’s a signal that says “I run the newest OS, so I have fairly recent hardware, so I’m relatively wealthy”, and that sells phones.
> RDS is the cloud atop postgres

Or MySQL. Or SQL Server.
Edit, was a link to different content with the same title
* without changing hiring and management practices at major chip designers and fabricators
REMOTE FRONT END DEVELOPER @ OSMOSIS

Apply here: https://help.osmosis.org/en/articles/1373731-front-end-engin...

We are a fully distributed medical education technology company looking for a talented Front End Engineer to join our Product Team to design and deliver the best user learning experience to our learners. We are on a mission “Empower the world’s clinicians & caregivers with the best learning experience possible.”

As a Front End Engineer, you will take care of our learner-facing product and user interface. Reporting to our Director of Engineering, you will be expected to:

- Build, test, ship, and maintain code for Osmosis’ learner-facing platform and user interface
- Collaborate and problem solve with the Product Team to develop the most user-friendly medical education platform
- Improve site usability, integrate user feedback, and implement best practices
- Assist the Design Team to turn mockups into functioning web pages
- Maintain brand identity across all medias and keep design thinking front of mind
- Work closely with Content and Marketing teams to build out and iterate on user funnels
- Contribute to a high-impact medical education platform that reaches hundreds of thousands of learners each year

Qualifications:
- 3-4 years experience with popular JavaScript tools, frameworks and design principles
- The ability to wed design sensibilities and functionality in support of maintaining the Osmosis brand across organization websites and platforms experience
- Strong understanding of web standards (accessibility, mobile optimization) and current web-dev tech landscape (Javascript (+ jQuery), CSS)
- Experience with front end frameworks: Knockout.js, Jade/Pug templates, Less
- Excellent communication skills and a willingness to give and receive feedback - especially in a remote setting
- Proven track record of running funnel optimization tests to improve retention especially in education technology
Can they really last that long (on their own)? I looked into this when the ESP8266 first became popular maybe 4 years ago as I wanted to build WiFi temperature and humidity sensors. My calculations were that a set of AAA rechargable batteries (~2000mAh) would last a few days at most, with the device in deep sleep most of the time and waking up every 10 mins to take a reading and send it over WiFi.

Right now I'm looking to create smart blinds. The motors don't use that much power, but the issue is the MCU listening for commands. The ESP32 support BLE, but it's power consumption is still rather high, so batteries would only last a few days at most.
This page does not contain an article for me. Simply a header, an ad, and some blocked content.

I am not blocking scripts, and there are no errors in the console. The only network requests that are failing are analytics requests that are being blocked. The HTML source does not appear to contain an article that has failed to load. None of the requests appear to be for article content, just a lot of libraries, stylesheets, and images.

Interesting snippets I found while reading the source:

<!-- real people should not fill this in and expect good things - do not remove this or risk form bot signups-->

I'm guessing they have a fake form honeypot to prevent bots from spamming their real signup form?

/* <![CDATA[ */
var newsletter = {"messages":{"email_error":"Email address is not correct","name_error":"Name is required","surname_error":"Last name is required","privacy_error":"You must accept the privacy policy"},"profile_max":"20"};
/* ]]> */

I can tell from this snippet I really don't want to see their build pipeline if they have to escape such a simple statement such that it won't break XML or JS.
If "SQL is the source of truth" means you have no in-memory state, I'm not sure that's feasible, with or without an ORM.

Once you fetch something from the db, you have it in variables in memory. With or without an ORM. That could no longer be sync'd with the db a ms later. That you will probably re-use for more than one access (if you need it more than once), because issuing the same SQL again the second time you need to reference any data returned, in a given routine, would be insane.
It's not just online that this happens. I was listening to some people talk on DMR ham radio last night, on Talkgroup 91 Worldwide. (DMR is a digital voice mode used in commercial and amateur radio, and talkgroups let you talk with people who are on the same talkgroup, roughly akin to tuning into a common frequency.)

John Miklor jumped into the conversation; he has a website [1] where he reviews various handheld and mobile radios.

Someone else jumped in and started thanking John for the good work he does "reviewing ChiCom radios." He kept saying ChiCom over and over again and I started wondering what he was talking about. I thought he must mean radios made by Chinese Companies like Baofeng, AnyTone, or Wouxun.

It slowly dawned on me that this was not what he meant at all. He was talking about Chinese Communist radios!

I guess I'm writing this on my Chinese Communist ThinkPad!

[1] http://www.miklor.com