skysight-inc/HackerNews huggingface dataset:
Two questions:

If I'm not mistaken, creating an index is a blocking operation in SQLite (other writers are blocked). How do you manage this in production?

How do you create a stored procedure? Do you have to recompile the whole program? How do you deploy with zero downtime?
>Something has to be done.

About what exactly? What is this massive harm being done to children if they see a pair of boobies? Where are these people that at one point saw something disturbing on the internet and became fundamentally broken as a result. Is there anyone struggling to be "well adjusted" because they watched Faces of Death when then were under 18?

I just can't wrap my head around this "something must be done" worry. It is so vague, so undefined, and such a pessimistic view of people in general.
By going directly from the moon to shuttle, you conveniently forget Skylab.

Also, something about hubble.
Or better yet, since you don't care about your data anyways, just don't bother storing it. Infinitely scalable and always blazingly fast.

>I have never seen a properly denormalized table

Do you mean normalized? There's no such thing as "properly" denormalized, anything that is not normal is denormalized.

>The whole article seems to be quite academic from my personal experience a textbook normalized database is slow beyond belief (i did exactly that once and we had to revert it back).

I've seen lots of people say that, but then consistently found those same people don't actually know what the normalization rules are, and all they did was create a different denormalized database that happened to have poor performance for the queries they were using.
How Math’s Most Famous Proof Nearly Broke (2015)
Also https://twitter.com/esaoperations
As the saying goes... Normalize till it hurts..then denormalize till it works :-)
CSS Colors Names
"not feasible due to lack of profit"

Is that really true or is it just that they can make more doing it the way they are? I'd love to see a big company that boast about the money they're not making because they have standards they're not willing to give up on.
Yes it is: http://spacefellowship.com/news/art35863/exomars-lander-modu...

He made a surface map of Mars nearly 150 years ago.
If someone can't be bothered to obtain an ID to vote, possibly they shouldn't be voting at all.

And when those people without IDs happen to be poor and minority voters, so much the better, right? Getting a government ID is not 'taking a few moments out of your daily routine', or we would not be having this conversation. How about you ask an American how fast and easy it is for them to just waltz in the the DMV and walk out a few minutes later with their shiny new ID card. State IDs are done by the same agency, and a lot of those poor people have one or two jobs they are working where taking an entire day to get an ID could cost them serious money or their job itself.
Seems pretty similar, but simpler. Just thinking about it Id prefer something like a "Strongly Disapprove, Somewhat Disapprove, Approve, Somewhat Approve, Strongly Approve" on all candidates. Most people should be familiar with that and then you could "downvote" ones you strongly dislike, and its weighted.
Tech who deleted Clinton’s e-mails was “joking” when he said “Hillary cover-up”
Hawkpost (the project introduced here) is also vulnerable to a coldboot attack - if the server that sends the page with the javascript is compromised, all bets are off.
That was another part of what I was getting at when I said that I was handwaving around some issues. :) In much of the US, net metering is currently available, so it isn't really a problem for the consumer in those places.

On average, a US home consumes ~30KWh per day. A single Tesla P100D has a 100KWh battery. It isn't hard to imagine ways to shift the charging profile towards the day for a lot of people.
I don't understand. ID is something everyone needs over there, no? Elections are after every 4 yours, people really can't take time to fix this problem?

I'm euro but with the whole id thing I agree with Republicand. This whole system screams FRAUD.
So I can't release something bad about one side until I have something equally bad about the other?

Lets be 'HONEST', your problem is that the leak looks bad for the candidate you like. Were you against the Trump video that came out or is that okay?
Large portion sizes increase bite size and eating rate in overweight women
"The choice before Altman is not a complicated one, though. He can continue to lead Y Combinator with Thiel as a part-time partner, thereby giving Thiel, and thus Trump, the imprimatur of the company’s reputation. He can ask Thiel to resign. Or he can resign from Y Combinator."

Regardless of your political leanings, I hope we can all agree that this is a ridiculous proposition.
Does such a setting actually exist? I cannot find any information about that. There hasn't been any other source for this post either.
Android SafetyNet Now Tripped by Unlocking Bootloader
What are you talking about? A table has as many columns as the thing it describes has attributes to be described. You can have a fully normalized database with 50 column tables in it, and there's nothing unusual or suspect about that.
I don't know what credit card you have experienced this with, but with mine I just indicate that I want cash back in the form of statement credit and it's good to go. There are no hoops to jump through.
This is just a proof of concept lander
This guy's hilarious! He'll crack 'em up at the unemployment office.
To be frank, this sounds ridiculous to me.

Also, why is it important who is doing the journalism to uncover the fraud? Sure, I don't have to agree with their interpretation, but I can plainly see and hear what was said.

Organization of payed protesters to disrupt a political opponent and lay blame on another political opponent. Massive voter fraud by way of out-of-state voters.

I don't doubt for a second that the other side is doing very similar things. The problem is this election both sides seem to be united to stop the outsider, which should make people think.
The Power of Less Code
Whatever happened to the Diebold voting machine company anyway?
Yes! This is the concept between ISS! The idea that we are regularly sharing launch missions is a great work for international diplomacy.
It's not silly and it's not paranoid, the Great Firewall of the UK is a troublesome thing already.
https://en.wikipedia.org/wiki/Web_blocking_in_the_United_Kin...

At that time, I was probably listed as requested access to mature content; reasons were not required but a few years ago they were already asking for identification, eg. passports.

What's frightening is how silent everyone is about this.
I suppose one could argue that cities in the early - mid 20th century weren't as heavily populated. I could be wrong, but I would also assume that noise levels were much lower and the streets much less congested. Looking at old pictures of city life, you often see kids playing in the streets. I don't think that would be possible today.
ExoMars Livestream
"this is something that before Trump no one had claimed (the GOP or otherwise)"

Except when Democrats claimed Bush stole the election. Otherwise no one has ever...
The trouble is then competing with the ones who do stay online.

The BBC gets a lot more Wikipedia refs these days than the completely-paywalled Times.
Wow just checked it out and seems awesome so far. Are you running the server in the cloud or locally?
>Many meds have extreme side-effects in part of the population

My daughter was given Montelucast/singulair for treatment of asthma; now it turns out that it can have severe side effects with kids - anxiety and suicidal behavior [1]. The funny thing is that these side effects are not listed on the medication guide, as these are supposed to be 'known risks'. What exactly were they thinking when they omitted this information from the medication guide?

https://www.ncbi.nlm.nih.gov/pubmed/26620206
> I applaud the Ecuadorian government's attempt to at least distance themselves from this latest attempt by Wikileaks to influence our democratic process.
> While in the past I viewed WL as a crucial part of openness and democracy, I'm very suspicious of their current sources, and their intentions. Not to mention Assange's personal interests (he expressed hatred towards Hillary - wonder what he thinks of Trump).

The hypocrisy in these threads is unreal. Would you feel the same way if things were being released about Trump? You only care about openness and democracy as long as it supports your views.
> The Raspberry Pi is really a VideoCore IV processor with an ARM bolted on the side.

I knew that the bootloader worked that way but didn't think of it being that way until reading your comment. Interesting to think of the hierarchy that way.

Naively this makes me think that the ARM ISA could use something like UEFI (or BIOS) to unify the devices' bootstrapping logic around some common metaphor.
Not angry at all (:
I just can't understand why people assume things (like github invented git) it saddens me
thanks, I didn't had the time to carefully see the provided link, but the concepts looks interesting. The code is still changing with some frequency, when it starts to slowdown, we will come back to this.

note: I also have been contributing to hawkpost.
Trump is not honest; telling obvious lies is not honesty, it is incompetent dishonesty.
Note that Monoid here is ONLY for the reason that Cow<str> doesn't satisfy Add. In fact, String doesn't satisfy it either. So I need to have a trait that allows me to call a function that concatenates my types. I already wrote how to concatenate Strings and Cow<str>s in my Monoid crate so I'm just re-using that.

It could be T: Concatenable for all I care, but the rest of the function needs to look this way, more or less.

I only have one type parameter, that's very common. I'm abstracting over String and Cow<str> because I want to bench the performance of both. (Cow<str> is always faster)
I wish there was a way to sign up and say "I'll take your crap" for everything electronic.

I just pick stuff up when I find it but it's pretty hard. If people could just say "I'm throwing out a powersupply" I'd head over and pick it up.

Just pulling caps out of that and selling them at hamfests could make you some nice pocket change.
I believe the answer is no.

You might be interested in monitoring this list of what gets closest: https://www.fsf.org/resources/hw/single-board-computers

Also, the Novena mainboard has a chance of getting there, if you look at this page: https://www.kosagi.com/w/index.php?title=Novena_Main_Page and then note that the Vivante GPU is close to having free drivers: https://www.phoronix.com/scan.php?page=news_item&px=Etnaviv-...
Just rig the election paper.

A sane person can't vote for either of them.

But a good citizen's duty is to vote. Write my name on it.

If you vote for Trump you're a bigot.
If you vote for Hillary you're a hypocrite.
How long has Clinton been in the game, receiving a fortune from Saudi Arabia? That's why there is so much dirt to dish. Everyone has been familiar with Trump's dirt since The Apprentice.
Not really, in many cases. And no, a LOT of people can't afford to take time off in the US. Their employment systems really are that fucked up in certain cases. Plus, not all IDs are valid for voting!

Hell, it's a hassle here in Switzerland to get your ID renewed. We don't need it to vote, though.
Personally I enthusiastically support Clinton because she has inclusionary policies - for a country with such a terrible (and continuing) history of exclusion, it's the right step forward.
Cat Dozers Working Autonomously
Not if port 22 is blocked and there is no ssh client and you don't have your keys. That's why the cloud console is so nice. Log in via browser for an instant shell/environment/whatever
Nowhere in Europe can you cast a vote without a valid ID.

Who exactly is disenfranchised by this? Illegal Immigrants? Dead People?
Does anybody know how using multiple virtual card numbers impacts your credit score (if it does)?
Well, let's extend even further - why restrict to things abusive to kids, why not extend to all things abusive to anyone?!? Like news shows that obviously have "wrong" news or different opinions, history-channels that focus on the less glamorous sides of say the British in WWII, etc...

This is a slippery slope that one should not enter. If your kid encounters porn then banning porn will not fix the kid. Educating will fix your kid...
Spoofer Project
Sorry to hear about your experience. Been using it for years as part of our build processes with no false positives.

You're always welcome to write a replacement if you find it unsuitable.
Imagine this potential future with me.

At first, it's just Amex. Then, to remain competitive, other major card vendors do something similar. Most of us (developers) still use something like Stripe for simplicity, but libraries start popping up that abstract away the vendor-specific APIs and make it easy to use them.

Long term, though, as more and more payments are handled electronically and online, this opens the door for a more competitive credit card market. Now, to compete with Visa or Mastercard, all I need is to get my API into those popular libraries and merchants can accept my card just as easily as theirs--except I charge a lower rate.

You'll start seeing cards that are virtual only--allowing them to cut fees below what companies handling physical cards can do. With the payment process being decentralized, now even requiring a card number is unnecessary. Users specify the ways they'd like to pay for things in their payment client (browser? phone?) and this is negotiated behind the scenes with the payment types the merchant will accept.

Users and merchants can directly decide between more traditional payment means (centralized / fiat currency) and upcoming ones (decentralized / cryptocurrency). The limiting factor is no longer what the PoS (point of service) machine will accept, but what the popular payment processing libraries support (and the merchant has configured them to allow).

I don't expect we'll see Visa or Mastercard do this, but this could be a key first step toward a more competitive payment processing market (which has had the same entrenched players for decades).
Gartner makes predictions about the ongoing digital transformation
I trolled my IRS scammers for weeks–and learned something dark
Maybe the public opinion doesn't need pictures to feel proud of this scientific/engineering feat, but I think policy makers (here: ESA mission managers) should consider the inspiring impact images have on people, especially the youngest.

When I can show a pic to my nephews and say "look, this is from another planet!" their eyes shine. And some of those excited kids could one day do science themselves, and advance our knowledge. I think it's an investment one should consider making, beyond the mere going there and collect rocks (which, of course, is the essential part).
Does anyone have any ideas how likely this will actually become law? Crazy laws get proposed here in America all the time. From what I've seen by watching the Prime Minister's questions every now and then, lots of far-fetched proposals are made across the pond as well. But they never get far, and not worth getting bothered about.
I think the Jetson TK1 from NVIDIA can run mainline Linux with most of the devices working.
We do in Canada.
If you load this page on an iPhone 7 in landscape mode, it shakes like crazy and is unreadable.
How about Google? Apart from illegal movies, you can also find porn there as easily.
Great stuff and many thanks for responding!

Hah... it wasn't me talking at Muc2016. I wonder who it was? I'd love to know who... :-)

FWIW, here's my EuroPython keynote, including singing micro:bits:

https://www.youtube.com/watch?v=JVaF6uZuSIU

Would love feedback!
Show HN: Cross-Platform System Dashboard Using Flask and Freeboard
Sorry, but that's a stupid excuse. Getting an ID takes time everywhere. For how long are they valid? If you use that excuse, Americans don't have time for a lot of things. Getting an ID should be a priority. It's common sense.

I don't understand Americans. One side thinks Earth is 6000 years old and other think that having ID to vote is racist. What is this bullshit?
I have never worked at true "web scale", so my experience may or may not apply to such scenarios. I tend to make a more or less fully normalized structure, and introduce aggregated data outside of the core database. It is essentially introducting eventual consistency, for performance critical data. This data can be stored in a database or a cache layer in front of the database if it is accessed frequently enough to keep it off the disk all the time.
> SQLite is not a good project to mention rewriting

Which, as I said, is not what I'm doing. I'm only disagreeing with the premise that 100% test coverage means 0% chance of an unsafe bug existing in the code base (for any code base, not just for SQLite).
Maximite? http://geoffg.net/maximite.html

> The Colour Maximite is a small and versatile single chip computer running a full featured BASIC interpreter with 128K of working memory and eight colours on a VGA monitor.

> It will work with a standard PC keyboard and because the Maximite has its own built in SD memory card and BASIC language you need nothing more to start writing and running BASIC programs.

> The Colour Maximite also has 40 input/output lines including an Arduino compatible connector. These I/Os can be independently configured as analog inputs, digital inputs or digital outputs. You can measure voltage, frequencies, detect switch closure, etc and respond by turning on lights, closing relays, etc - all under control of your BASIC program.

It's showing its age a bit, but still sounds useful.
I think today, most often than not, the fault is between the keyboard and the chair. There is clear lack of domain knowledge. RDBMS's like PostgreSQL, Oracle, DB2, etc. can do much more than people expect them to do.

Relational databases are relatively easy for anyone to start working with, but optimizing and tuning queries requires fair amount of domain knowledge. You'd be surprised to learn how little denormalization big financial company databasees have. They have people who are experts that do only databases.

For I/O intensive work you may need transaction rows where data written together is stored together, but it's not denormalization, it's optimizing for I/O bottleneck.

Query planners can do most of the work, if the person crafting queries has understanding of how they work. Carefully grafted queries and tuning memory layout for tables correctly is usually the right way to fix performance problems.
Approval voting is my favorite, too - for single-winner elections. But no single-winner voting system beats proportional representation systems [1] when it comes to electing Congress members, legislatures, councils, etc.

Everyone gets much better representation when "their candidate" can actually get a seat at the table, instead of having one party/candidate "take it all" (in that local region of theirs). It also spurs collaboration [2] and "bridge-building" rather than division and obstruction as it happens with the FPTP in the U.S. (and elsewhere)

My biggest hope is that Canada is closing-in on a proportional representation voting system, and adopts it within the next year. That could (or should) make it an election issue for 2018 and 2020 in the U.S., too.

[1] https://www.youtube.com/watch?v=pWPx8hmd4pQ

[2] https://www.youtube.com/watch?v=vS62N5b5L7Y
You can probably thank the US election for a lot of general confusion about what the Star of David looks like, and let's not even get into sheriff's badges. At least it's over soon.
What's Ben doing next?
Yes, Assange and wikileaks have built a strong mythos around themselves, in part based on true events.
I thought that about part I, that maybe some of the really terrible lines ("I've payed mentally ill homeless people to do some crazy shit!" or whatever) could be jokes taken out of context, but part II released today is less cobbled together. I don't see how there can be any doubt about the criminal intentions that Scott Foval and Bob Creamer had, and their respective firing and resignation are further evidence of that.
I have, and I am 50/50 split on those :). I sidewith.com had me at 1% point between bernie, hillary and trump.

I

1 - am rabidly pro-choice

2 - think the second amendment is pretty good as is, maybe with a few additional checks.

3 - default pro-cop but think we have too many laws

4 - like the wall but not a fan of massive deportations

5 - would not like to have the migrant influx that europe has, even if the crisis is partly our fault

6 - anti-PC

7 - pro pot-legalization (that's actually more repub this go-round)

8 - believe in climate change

9 - pro-israel

10 - want liberal supreme court justices

11 - think we are taking a very naive approach to the risk of terrorism in order to avoid offending many groups

12 - massively turned on by this https://www.donaldjtrump.com/press-releases/donald-j.-trumps...

13 - have to admit if you put them in a box and made them play jeopardy with only geographic/polysci questions, he would get killed.

14 - want less of the typical pro-jesus anti-gay slant the old guard GOP has had (admittedly that's not him but is the Silver Fox at his side)
Thanks! Is there some documentation already? Do you plan to integrate "BEGIN CONCURRENT" in the standard SQLite distribution?
Show HN: Create the most advanced bots in the simplest way with Bot Builder
Work at Home Jobs US
At least he is consistent and he is the same person in the locker room as well as in public. A total scumbag.

Hillary is a habitual lier and hypocrite. Happy voting.
Bravo for paying attention. :-) Normal for credit cards. Not normal for plebs like me.
My feedback: The virtual card numbers and the ease of generating them are tempting. But I'm already protected from fraud by my existing Citi DoubleCash (2% cash back, no annual fee). I'm not going to lose 1% cash back and the fee to get a Final card.
I use Tile Studio as my only sprite and map editor for 2D platformer development (first in C, then C++, now Lua/Love). The ability to define my own output format instead of having to deal with somebody else's XML is a killer feature for me - a primary reason I've previously tried and discarded Tiled.
Highly unlikely, tbh.
It depends on what you build into your containers. Your customers will need storage at some point, unless they're just using the containers as processing engines. You'd also be surprised at how lean you can built a VM with Linux (or one of the BSDs) as the OS.
Show HN: Programming Design Systems – Custom Shapes
You can accidentally cross the street and die - that doesn't mean we should put guards on the pavements and issue pedestrian ids.
There is a better solution. How about parents take responsibility for what their kids do?
You mean sending multiple children to Yale is expensive.

The entitlement in this thread to ultra-elite luxury goods is insane.
> The reality is that most people want either Trump or Clinton

Is that actually the reality? My impression is that most people do not want either Trump nor Clinton but they want one a lot less than the other so they'll vote against that candidate rather than voting for one.
Yeah, it's a little sad. ARM based servers have been on the horizon for a couple of years now, but they seem to be forever out of reach. :-/
Aren't Chinese space travelers called Taikonauts? The title make it sounds like Americans are invading China's space station.
Are you really suggesting that people shouldn't watch videos that they might not agree with, or which might contain propaganda?

If that was the criteria for consuming information, no one should ever watch/read any media outlet.

Also, I still don't understand why I should not believe what was said in the video?
What fee?
I did too, until we drew the ghetto elementary school where the average 5th grader can't read.

Fortunately, we're able to afford a catholic school.
What to do when IT alerts fail