skysight-inc/HackerNews huggingface dataset:
I've worked on a few apps that relied heavily on SQL stored procedures as the data access layer. In a database like SQL Server or Sybase, a stored procedure is like a function with a body of SQL that is stored on the server, receives typed parameters and can return more than one result set, each result set having a different shape (different columns). So, a call to get an entire graph of data would only require one request and one response, saving many round trips. You could write a stored procedure that selects a customer, their recent orders, the products on each of the orders and so forth. You can also insert/update into multiple tables in one trip and you can wrap any parts of your SQL in transactions.

The SQL variant used by SQL Server and Sybase, called Transact SQL, also has elements of procedural programming such as variables, flow control with IF/THEN/ELSE/switches/etc, looping, calling other SQL procedures or user defined functions, exception handling and so on.

These features have been part of SQL Server since the 90s. It's extremely powerful and if used well, can be much more elegant and flexible than an ORM in my opinion. It's a shame that PostgreSQL doesn't support stored procedures quite as well or have an SQL variant that's as well crafted as Transact SQL because I'd love to be able to write apps in that style again. Somewhat recently I believe PG got something like stored procedures that can return multiple heterogeneous result sets and although I can't remember the specifics, I don't think it's quite as robust as what you can do with TSQL and it lacked client/driver side support maybe... (Also PG has some support for running TSQL itself, but not with all the same features.)

Here's an example of how you might call a stored procedure in C#, using a library written by Marc Gravell of StackOverflow - https://stackoverflow.com/questions/5962117/is-there-a-way-t...
Location: San Francisco Bay Area

Remote: Yes

Willing to Relocate: Yes

Technologies: Python, Javascript, HTML/CSS, ML

Resume: On request

Email: a.huang@nyu.edu

Github: https://github.com/sssss465

Recent graduate from New York University. Looking for new grad / junior roles in full-stack, backend, or machine learning. Has experience working in the front end and on the backend. Most recent role was working on model compression on Tensorflow Lite. My interests lie in creating visualizations and working with data. I have also created d3 chart statistics.
... except I am suggesting a 4 phase system: 2 outlets with each the usual 2 phase AC!

consider 4 phases in 90 degree turns (I wish HN had a button to render LaTeX or so when a reader wants it on demand):

V_0 = V/2 sin(w t + 0 pi / 2)

I_0 = I sin(w t + 0 pi / 2)

V_1 = V/2 sin(w t + 1 pi / 2)

I_1 = I sin(w t + 1 pi / 2)

V_2 = V/2 sin(w t + 2 pi / 2)

I_2 = I sin(w t + 2 pi / 2)

V_3 = V/2 sin(w t + 3 pi / 2)

I_3 = I sin(w t + 3 pi / 2)

Now outlet "in" (in-phase to avoid clashing with "I") is across terminal 0 and 2, and outlet "qu" (quadrature) is across terminals 1 and 3, so the current and and voltages are:

Vin = V/2 sin(w t + 0 pi / 2) - V/2 sin(w t + 2 pi / 2)

= V/2 (sin(w t) - ( - sin(w t) ) )

= V/2 (2 sin( w t) ) = V sin(w t)

Iin = I sin(w t)

Vqu = V/2 sin(w t + 1 pi / 2) - V/2 sin(w t + 3 pi / 2)

= V/2 (sin(w t + 1 pi / 2) - ( - sin(w t + 1 pi / 2) ) )

= V/2 (2 sin( w t + 1 pi / 2) ) = V sin(w t + 1 pi / 2)

= V cos(w t)

Iqu = I sin(w t + 1 pi / 2) = I cos(w t)

and the powers flowing through the outlets are:

Pin = Vin Iin = V I sin(w t) sin(w t) = V I sin^2(w t)

Pqu = Vqu Iqu = V I cos(w t) cos(w t) = V I cos^2(w t)

so the total power is

Ptot = V I (sin^2(w t) + cos^2(w t)) = V I

constant total power out, just like constant DC power into the inverter so no need for storage capacitors / inductors.

QED

It makes sense for solar parks to use 3 - phase because the back-bone power distribution of the grid is 3 phase.

Do you know if the inverters from solar park panels to 3-phase use storage capacitors to convert to 3 phase?

Do you know if any residential inverters are commercially available that split into 4 phase (2 AC outlets) like I describe, without unnecessary storage capacitors / inductors?

according to:

https://www.energycentral.com/c/cp/solar-photovoltaic-pv-pow...

>China now leads in total solar energy capacity followed by Europe with 114 GW.

>Remarkably, 64 percent of solar systems in the EU are installed on rooftops, 26 percent of them residential, 18 percent commercial and 20 percent industrial.

so residential solar in Europe is 26% of 114GW = 29.64 GW

so a line frequency of 50Hz in europe implies single AC outlet inverters need an energy store of 0.01 Joule per Watt (in the US only 0.008333... J per W, because they have 60Hz)

This amounts to 296.4 MJ (mega joule) of capacitor / inductor energy storage, elements whose raw materials must be sourced, must be built, must be bought by the consumer aand which are potential points of failure (what is not present can not break down). That could have been avoided. Which we still can avoid for future inverters, without replacing all our consumer electronics with DC consumer electronics.
Current research shows a 20~30 point SAT1 improvement from specialized coaching [1]:

> From 1981 to 1990, three separate analyses of all the prior studies were published in peer-reviewed journals. They found a coaching effect of 9 to 25 points on the SAT Verbal and of 15 to 25 points on the SAT Math. In 2004, Derek Briggs, using the National Education Longitudinal Study of 1988, found effects of 3 to 20 points for the SAT Verbal and 10 to 28 points for the SAT Math. Donald Powers and Donald Rock, using a nationally representative sample of students who took the SAT after its revisions in the mid-1990s, found an average coaching effect of 6 to 12 points on the SAT Verbal and 13 to 18 points on the SAT Math.

I have not seen any studies on
the effect of accomodations, though.

I think the amount parents will pay for those relatively meagre extra points, and the fact that the parents in this case had to resort open bribery, speaks relatively well for the meritocraticness of the current system.

Open the books, show us that nothing is being swept under the rug, and just let the undeserving children of millionaires go to third tier schools.

[1] http://www.aei.org/publication/abolish-the-sat-2/
Making you feel bad is a proven effective advertising strategy, and a proven terrible world to exist. There needs to be a pollution tax for advertising the way there should be for carbon. If you deliberately pump a harmful product out into the world you should have to pay through the nose for it.
13” MacBook Pro, mid-2012 edition (non-retina)

The disk has been replaced with an SSD and I’ve replaced the RAM with 16GB. The battery will likely need to be replaced next as well. I’m hoping to use it as long as possible.
The popup dialog you get when you click either "like" or "dislike" is annoying - show it the first time and then don't show it again. I'm happy to scroll through a bunch of logos and quickly mark some likes/dislikes, but not with a popup on each one.
I'm not entirely sure this is true wrt the gender thing, one could easily substitute grandpa and it would still make the same sense. As far as being discriminatory against age, I really can't see how you came to that point. Perhaps assuming that old people don't get technology in general might be an unfair assumption as there are plenty of those in that age range who do get it, but I don't think that makes it wrong to use such a conception.

At that, I don't particularly think it's being discriminatory at all. It isn't perpetuating some ideal that all old people or all females just don't get the idea of databases. This comment sorta strikes me as unnecessarily reactionary, rather than focusing on the content and substance of the article.
That’s already the case; drivers choose to sell their services to Uber at the rate Uber has offered, versus selling their services to anyone else that participates in the unskilled labor market.
There's likely plenty:

https://www.quora.com/Is-there-enough-lithium-in-the-world-t...
SimplePay | Ruby on Rails Developers | UTC+4 to UTC+8 | REMOTE | $42k-$60k

SimplePay is online payroll software for South Africa, Ireland, Singapore and Hong Kong. Our software lets thousands of small business owners (and their accountants) run their payrolls without headaches, so they can focus on the challenge of building their businesses

More than half of our developers are now remote, and I'd like to continue the trend.

To find out more about us, check our developer blog (https://tech.simplepay.cloud) or about page (https://www.simplepay.co.za/about)

Stack: Our work is back-end-heavy Ruby on Rails and we use PostgreSQL as our data store. We use a bit of Vue.js but believe server-side rendering is still the best default.

Experience: Due to our full pipeline, we can only hire developers who have a few years of Rails experience at this time, or highly experienced polyglots who at least know some Ruby.

Location: UTC+4 to UTC+8 preferred, although we'll also consider candidates in UTC+1 to UTC+3 if they have the right skills and experience.

Please mail developers+hn@simplepay.cloud and include a direct link to an open source contribution you've made, or an issue you've logged, no matter how small.
‘Satori’ IoT Botnet Operator Pleads Guilty
"Xkcd" isn't a person's name.
2020 Democratic Party Presidential Primaries
I had a similar experience, eventually I found the message in my spam folder. It's ridiculous that messages marked as spam show up on the calendar, but now we know.
This is a ridiculous criticism. Ancient Greeks didn’t look at sculptures of ripped dudes and “feel bad about themselves.” They got INSPIRED and felt GOOD about themselves. Be like an Ancient Greek.
thank whatever or whoever that no one has yet thought of using water cannons with pellets in the water.
That's a nice image, but you are making a case for storage, not transport.

Transportation of (flammable) liquids require either vehicles (and hence roads or rails if you go inland) down to the last mile. Electricity requires a wire, which is far less costly to build.

Also if you consider the logistics of bringing energy to different places of a building, wires are much easier to lay down than pipes.
true, and the 4-phase I propose would also need a neutral for safety... so this advantage for 3-phase persists, as it can do with one conductor less..
I don't even know where to begin, my friend...
In-your-face ads are so annoying. How on earth someone upvoted this?
“8% of the variance in sexual orientation is determined by genetics” is literally a quote from the study. I don’t have a personal viewpoint one way or another. I’m literally just reading the facts as they’re presented and saying “many types of variance exist.”

Obviously some people choose to be gay, Cynthia Nixon for example, who got in huge hot water for saying that for her, being gay IS a choice. She was specifically not “born that way.” Others clearly are. It’s a spectrum. :)
> whether or not the MOF will also trap dust particles and other things

This is the crux of the matter, yes. Of course you will need filtration to avoid clogging your MOF with sand and dust. Then you increase the power draw, having to push the air through a filter, and you have added a potentially expensive consumable.

As TFA states, people have been making MOFs since the mid 90s. And people have been scrambling for applications since. The unanswered questions are, as always: Can they be made cheaply enough? Do they last long enough?
The downvotes are probably because your question could be asked of any new thing. "If this is so great, why didn't someone do it before? Therefore it is probably not so great." I mean you could literally paste that same comment with almost no modification as a response to almost anything new thing posted on this site. That's a good signal that the comment is not helpful.

Also, I don't think the author claimed it's "objectively superior." It has objectively superior asymptotic performance in certain relatively niche workloads. However, its constant time factor is iffy due to all the pointer following and calculations you have to do for random accesses. And the benchmark results in the README show this clearly -- both the strengths and the weaknesses.

Actually, your whole train of thought around the claims in the README is puzzling to me. You seem to think they're grandiose and over the top, but the README seems mostly explanatory to me. What statements in there do you think ought to be qualified, specifically, and how?

If you want upvotes next time, explain in detail what claims you object to, and why. This comment I'm afraid did not add much to the discussion, at least for me.
> The solution is to update laws that reflect the future (ie, giving contractors better rights and better temporary unemployment social support)

Agreed. Classifying them as employees, per this bill, doesn’t do this.

Employment classification comes with a myriad of fixed costs. Particularly in California. Contractors lack these fixed costs—it’s all variable. That’s what makes them attractive for unpredictable workloads.

We need a third category, a low fixed-cost zone between contractors and employees, that includes some employee rights but not others, and confers some employee restrictions but not others. That would be transformative to our economy, and strengthen it to boot. Unfortunately, that’s is not what the California legislature is discussing. (Surprise.)
Well, maybe I'm just missing something in this meme, but...

Back in the day, deploying code to cgi-bin first required buying and hosting your own server; which I have neither the time or patience to do today.
The objected ads will continue until morale improves.
I'm using this for the second half of letting authors generate fake faces for their fictional characters and then putting those faces on top of video snippets from actors. I'm still in the exploratory stages of what all is possible/useful, but feedback so far has been generally positive ("characters feel more real", "easier to empathize", "super interesting potential").

Could also make for some interesting low-budget book commercials/trailers where authors (or I guess anyone making a video starring people) can design the characters in a video without worrying about what actors are available and/or what CGI costs.
The article says the tear gas cannister uses potassium chlorate (KCIO2) as its oxygen source, rather than atmospheric oxygen, so I'm not sure how effective smothering it would be. The thermos probably is just to protect the protestor's hands.

Based on the other method
Fibalivestream
https://medium.com/@dsgdfh552fghfh/basketball-tv-angola-vs-philippines-livestream-online-fiba-world-cup-fff692eed534

https://medium.com/@dsgdfh552fghfh/basketball-tv-argentina-vs-russia-livestream-online-fiba-world-cup-bc5976a17069

https://medium.com/@dsgdfh552fghfh/basketball-tv-china-vs-venezuela-livestream-online-fiba-world-cup-300efff15232

https://medium.com/@dsgdfh552fghfh/basketball-tv-serbia-vs-italy-livestream-online-fiba-world-cup-2d30855e90f

https://medium.com/@dsgdfh552fghfh/basketball-tv-tunisia-vs-puerto-rico-livestream-online-fiba-world-cup-3b2455c36bf7

https://medium.com/@dsgdfh552fghfh/basketball-tv-nigeria-vs-south-korea-livestream-online-fiba-world-cup-e53a01236420

https://medium.com/@dsgdfh552fghfh/basketball-tv-poland-vs-ivory-coast-livestream-online-fiba-world-cup-c4585b0e8c47

https://medium.com/@dsgdfh552fghfh/itv-angola-vs-philippines-livestream-online-fiba-world-cup-17f343cb6f5e

https://medium.com/@dsgdfh552fghfh/live-fiba-philippines-vs-angola-live-stream-free-150ca484c2f1
I posit these days it’s a company that’s valued as a multiple of earnings instead of a multiple of EBITDA. Most companies these days are “tech companies” once they reach a certain size, to the point where the distinction isn’t particularly relevant.
>Do men on Instagram contend with this many half-naked dudes and their butts all the time? I really want to know.

In a way, yes. Men are shown ads or muscular, successful men with chiseled jawlines reminding us that we're inferior, our clothes style sucks, how we can't be a man because we don't smoke the same cigarettes as he.
Is China Manipulating Its Currency?
Many of us also know stories about how ORMs can be slow if developers don't pay sufficient attention. In some cases told by database experts who see the query code locked up tight by the app team, etc :)

Having a separate "DBA" from the developers or having an adverserial relationship with said person is not really a technical problem I think.
A beefed up response to the "dual offering" was just added to the interview.
Got it, we'll fix this. The likes and dislikes are really important for our ML models. Thanks for the suggestion.
I'm curious how the real world numbers work out here. Assuming that you're using electric heat to heat the house, I get that a traditional fridge is better than venting heat outside.

But, if you have a ground source heat pump as your home's heat (sourcing from 45° ground temps) - wouldn't it be more efficient to use the outside air as a source for a fridge?
I agree with the author and wish I could see less ads for bras. I am a male and mostly follow makers and woodworkers, yet I see a ton of ads for bras. My wife doesn't send me too many links to bra companies either.

I deleted my Facebook 2 years ago, and my Instagram is only about 6 months old. I used the same email address in both accounts.
I mean, if you want to stick to the 1.5 MB/s transfer rates of USB 1, more power to you.

Analog audio technology was basically perfected 40 years ago with the Walkman. You couldn't develop a significantly better connector today, even the size was optimal for small portable devices.

Data transfer technology OTOH is still improving by leaps and bounds, and the old ports are too big for modern portable devices like tablets and phones.
You could begin by choosing to feel good when seeing an inspiring (even “unrealistically” inspiring) image like Michelangelo’s David. :)
Oh shoot, I totally do. Well that explains that, sorry for the noise.
Trucks become solar powered when you put biodiesel in them.

But seriously, there comes a point when it's more efficient to build housing for people that is closer to sources of clean water. Whatever they are doing out there in the desert without water and infrastructure probably isn't very productive in the first place, and if they can't even do it sustainably, we should question what the point of it is. Not every environment is suitable for human occupation. How many billions of dollars would you spend shipping bottled water to the moon before you put your foot down and tell people to stop living there?
No. When a pop-up pops up, I hit the "back" button right away. I don't even do it consciously, actually...
The paper probably isn't out yet. But there is quite some previous research on using MOFs to make fuel from CO2:

https://scholar.google.com/scholar?hl=en&as_sdt=0%2C5&q=MOF+...

The challenge in that regard is always: turning CO2 to fuel takes at least as much chemical energy as was released from burning the fuel to CO2 in the first place. If you have that (presumably emissions-free) energy available, it's infinitely better to not burn the fuel in the first place and use the emissions-free energy for something else.
Have you been to the Midwest lately? It's fat people everywhere. Not just fat, obese. The stores practically only sell clothing in the XXXL variety, it's horrifying. The July 4 parade I went to...I needed eyewash. It was just fatties from end to end, some of them were stuffing their faces during the parade.

And then we get the Internet where the total opposite of reality is going on, so more gas lighting there.

Crazy world we live in. Clown World.
Marginal cost = cost of producing one more unit of something (energy in that case) once your capital has been spent.

It just says that if you have a solar panel, you don't need to spend additional money to make it produce electricity. Unlike, say, a diesel generator. It is purely capital spending, zero marginal cost.

Another way of counting would be to say that _not_ producing costs you money as you are losing capital over the panels' lifetime.
> Is it one of those things that everyone reads on marketing blogs and will continue to apply mechanically for another 10 years?

No, they work, just not on this audience. The same goes for exit intents ("Do you really not want to buy this great product? [] Of course I want to [] No, my life is the best it ever could be, it doesn't need improvement"), they convert for large audiences but are hated by others. The question then is: is the trade-off worth it. Apparently, it is for many.
I usually sell or give them away to friends that need them, with anything that isn't wanted sitting in reserve in case I ever need a backup phone (I always keep an extra one in my backpack in case my current driver breaks).

The only phone/tablet I've actually thrown away was my 2012 Nexus 7 that finally completely died last year. Everything else finds a home somewhere. :)
Hi Slaven, sent you an email.
Hardware Intrinsics in .NET Core
Is “Social Science” an Oxymoron? (2013)
The Fed could loosen monetary policy in order to devalue our currency, but it seems to this me that another approach would be to implement a universal basic income funded in part by money printing e.g., Yang's Freedom Dividend without the Value Added Tax.

edit: changed wording so that I wasn't suggesting one way would be optimal.
It's a cool idea and all, but how do the calculations look for actually moving enough air through the "net"?

One cubic meter of air at 100% humidity and 25C only holds 22g of water. For the 8 liters per day value it doesn't seem like an unreachable amount: 363 cubic meters of air need to pass through the filter. You probably need to more than double that number due to relative humidity not being at 100% and we probably won't get all the water in the air, but it seems reachable.

On the other hand, 22500 liters per day seems quite crazy. I'm interested to see how they're going to tackle this.
But the key difference is in the "why". Serving that HTML from a nearby web server is a lot faster, and it's easier to distribute static content to a bunch of servers around the world that are near the people requesting them.
Well done on your optimized flight routine, but a true 200 MPH+ bullet train from SF to SD wouldn't take much longer.

Cross-country express trips could be done in less than a day.
Dunno, I'm pretty non-puritan and got desensitized to nudity of all shapes just from the web, but the lesson was that I shouldn't assault people's gaze with my pitiful physique.
Actually:

> The HIPAA Privacy Rule protects the individually identifiable health information about a decedent for 50 years following the date of death of the individual.

https://www.hhs.gov/hipaa/for-professionals/privacy/guidance...
Bloomberg has a study.[1] But they see electric vehicles hitting 50% of new sales about 20 years out.

The battery Ford F150 is two years out.. At that point, most consumer vehicles can potentially be electric, but the electrics will not be lower in initial cost yet. Bloomberg sees that happening in 2024.

Conversion may happen faster in China. Already, there are heavy incentives to go electric in Beijing. As in, you can get a car license much more easily.

[1] https://about.bnef.com/electric-vehicle-outlook/

[2] https://thinkprogress.org/electric-vehicles-cheaper-gasoline...
What are the great benefits? As far as I can tell, Google voice + Hangouts has all the features and more.
I don't really get what the risk to proprietary information? The only thing that leaks for private repos would be the URL and version number, right?

While opt-out for this not ideal, this seems like a minor privacy risk relative to the security risks ameliorated by enforcing checksums by default.

I guess an option which solves would be a mandatory prompt about proxy usage unless there is an explicit environment variable set?