skysight-inc/HackerNews huggingface dataset:
You are a long way from the practical limits. I have used SQLite databases with billions of rows that were still able to retrieve hundreds of arbitrary rows in less than second. We used it to store time-series performance data and generate charts. We had tens of thousands of these databases (not all with so many rows) and they performed their job admirably.

The one thing that SQLite cannot handle performantly is deleting large numbers of rows (millions) - so don't plan on deleting any data from your tables once they get that big. It appeared to me from a cursory examination of the code that B-tree rebalancing was happening after deleting each row which makes the big deletes very expensive. We got around this problem by sharding our data into a new table and a new database for each week and then mounting all of the databases necessary for a query. When we wanted to delete data we just deleted the database file with the corresponding shard. Obviously that only worked for our particular time series data.

Anyway, the bottom line is that SQLite is more scalable and has better performance than people give it credit for.
Can anyone confirm whether this is a portal 'in the cloud' or if it's simply a web server hosted on the Squink itself?

Very cool project, I wonder if future iterations by competitors will drive the cost down.
Yeah, it's almost all open source now and we're releasing the last bits (plus the coordination code) between now and next week.

We will post another article when it's ready next week. Email me at sqs at sourcegraph.com in the meantime if you are too curious to wait. :)
That was a very forceful argument for something Patrick had already said.
This is way more interesting than the title makes it sound. From the title, I expected something that just made a PCB, and then you would have to place the components on it and attach them.

What they are proposing will make the PCB, then put conductive glue at the places where the component leads are supposed to attach, and then pick the components from a tray, rotate and aline them, and place them on the glue.
He's also assuming that basic income takes away the brakes on population growth, and that is a completely unsupported idea. Experience so far suggests that the best way to limit human reproduction is to give them more resources, not fewer. The poorest countries in the world are generally growing the fastest, while the richest have trouble just keeping their numbers from falling.
Because they were recruited by an FBI agent posing as a terrorist recruiter.
> I thought we were all much more conscious of how these types of programs start to spin out of control.

The FBI followed up to get the story straight. The FBI didn't know what the guy was doing or why he wasn't doing it, therefore they went to go find out. They sought out the truth. So please enlighten me as to how this can "spin out of control".
The underlying issue probably requires a reformulation of the Constitution to resolve.

The problem is that the police can investigate anyone for any reason. Arresting them is harder, but not that hard. You have no redress for this; investigations and arrests that don't lead to a conviction (or indictment) can waste an infinite amount of your time. The Constitutional protections (however weak these days) only prevent you from being punished without a trial. If no charges are filed, you can effectively be punished without the Constitution mattering.

I'm not sure what the solution is -- I'm not a lawyer or political scientist or whatever -- but something seems not right.

(I've been investigated before; it really wasn't as bad as people say. I thought the agents were extremely competent and professional, which is not quite what you hear from the average Reddit commenter. Some things need to be looked at in detail before being dropped on the floor; asking the person suspected can be a good way to decide whether or not to continue the investigation.

I think I've posted the details to HN before, but I'm not sure how to filter that out from my many other comments :)
Yes. Yes.

(Not counting me & Dave, two of our three founders, neither of whom have any college CS).
Is hardly out of context with the article being commented on.

"You don't get rid of history by blacklisting people from viewing it, you don't convince people that Nazis are bad by, literally, stooping to their level and censoring (okay, I went there). And, as this leak clearly proves, it doesn't work anyways."
If you were a security guard for the largest piece of copyrighted art work in the world, and you saw someone trying to take a picture of it, you'd think he's maybe a terrorist?

Context is very important when making judgements.
So law enforcement shouldn't surveille?

Law enforcement shouldn't keep information about people unless they've been convicted of a crime?

Pray tell how do you propose a system of law enforcement can work without both these things. Or do you think that law enforcement is an unnecessary evil?

>I've read about this happening //

This being 'someone asked about their whereabouts'? Really. This is too much of an invasion of your liberty to simply confirm that you were indeed the person in a particular place?

Perhaps he bought something on ebay from a person financially linked to terrorist operations abroad the week before he went visiting a natural gas storage facility .. we don't know. The outcome for him was to answer a couple of phone questions; I find it really hard to see anything in this story that shows the SAR program has failed.

I imagine they get a few folks taking pictures. Photogs tend to take lots-and-lots of pictures, and want to get in places where other people don't, get close-ups and such. TBH that this might look suspicious doesn't seem especially unreasonable. The security guards don't know he's a professional photog.
I'm about as unskilled a lockpicker as you can get, and I can pick the four-pin locks on my apartment fairly easily. Someone with practice could do it even more easily.

(I've never used a pick gun, but I hear that makes it even easier. Especially for locks that don't have any particular anti-picking features, like the majority of locks on people's homes.)
There's a trick. You can for example name a file .gitignore. (with a starting and trailing dot), it will warn you about changing the extension which you agree to, and you're left with a file named .gitignore
I've used the "first" (?) version of Sourcegraph and now this new one, and I have to say I'm a huge fan. I'm learning Go in the evenings and I was struggling to grasp some of the concepts in Go and how to use the Gorilla package. Personally, I learn better after I skim the API, look at an example and rinse/repeat as needed. For me, Sourcegraph is a great way to help speed up that process of finding that one example that helps make whatever it is "click".

I've been using their Chrome Extension because it injects their stuff right onto Github pages. Now all they need to do is make one for Firefox, so I can go back to Firefox.

Disclaimer: I meet Quinn at GopherCon and we talked about Sourcegraph. I loved the idea then, and I still do now.
I had just finished drafting up an article on Yahoo when I wrote that, so in my head I had the letter Y followed by an exclamation mark. Surprised, it's not a mistake a lot of people frequently make.
http://www.stratfor.com/weekly/detecting-terrorist-surveilla...

This is a good start on the terrorist attack cycle and the surveillance techniques that are used. One of the problems with defense is that you had to protect against all possible attacks, and that includes people conducting on the ground surveillance.

As you suggest, more sophisticated groups will find better means of gathering the intelligence they need. Unfortunately, that still leaves crappy groups that don't know any better. Surveillance remains the best time to catch terrorists.

I can't speak to the specific example in the article, as usual the US is paranoid and over reacts, but the fundamentals are solid. Look for people conducting surveillance to catch terrorists.
>All of the down-votes in the world won't change reality. Just because you personally don't have access to evidence that terrorists conduct photographic surveillance doesn't mean that no one does.

I didn't downvote you, but are you asserting that this evidence exists or just that it might? If so, what is your basis for thinking this?
Prohibiting or limiting access to information is always censorship. Censorship of third-party information by governments is universally wrong. If you want to protect your children from certain types of information via censorship, that's not necessarily wrong, but it's entirely your own responsibility.

There would be absolutely nothing wrong with this censorship list if maintained by a private entity and voluntarily applied by individuals to their own Internet connections.
LG G Watch Review
You think the guard knew it was the largest piece of copyrighted art work?
You think he even considered it artwork, and that's what he was paid to guard? I think he probably thought of it as what it was: a large gas tank.
What about Humming Board? http://www.solid-run.com/products/hummingboard/

It has ARMv7 and has a reasonable price.
Don't quote or bill hourly:

https://news.ycombinator.com/item?id=4101355#up_4103417

Do price high; weeding out deadbeats is just one of the wins for doing that.

Without knowing anything else about how you work, my recommendation is to select only those clients for whom doing the work of a proposal on spec is worth it, and then: write proposals for them.

You can write a proposal with a single total project number in it without committing to deliver that project in exactly X billable days, for what it's worth.
They certainly drive a lot faster when they have a fare.
When the FBI investigates someone from a tip that isn't very obviously a serious threat they do not treat the person being investigated like a criminal, that's half of what I wrote above.

Many times if they want an extended chat they will even take the person out for coffee, just to get a feel of the situation and ask questions.

http://www.banterant.com/2013/08/homes-for-hackers-gets-visi...

Yes, if an investigation is more serious then the FBI can be very intimidating, such as: http://arstechnica.com/tech-policy/2014/04/whitehat-hacker-g...

I'm just saying that if the FBI did investigate me there is a reasonable chance they would act civil and objectively rather than abusing their power and using unnecessary force, and that's the way it should be.
No, I don't think I am missing the point. My question was basically: is censorship always a bad idea? If yes, how can we enforce the law otherwise (forbidden pictures)? Or should we make our laws towards "showing everything is allowed"? Where does it start and where does it end?
> Where does 'protecting our kids' start?

It starts with parents, who's responsibility it is to supervise their children and educate them about how to use the Internet responsibly. If you're reliant on easily-circumvented blacklists to protect your kids, you're doing it wrong. Specifically, the responsibility (with regards to Internet content) does not rest with a government.

> Is prohibiting something always 'censorship'?

Yes (at least when the thing being prohibited is information). That's what censorship is.

One can validly argue about whether or not a particular instance of censorship is right or wrong, but that doesn't change the fact that it's still censorship.
Go with what? The OP came to HN asking legal questions. Non-attorneys on HN have no business speculating and trying to provide legal advice to the OP. Attorneys on HN may not be licensed in the OP's jurisdiction, may not be engaged in the relevant practice areas and have obviously not been retained by the OP. They, therefore, cannot provide the OP with the type of guidance the OP would receive from an attorney with whom he has established an attorney-client relationship.

If the OP had posted "Ask HN: I think I just had a heart attack", I would hope that most of the folks here would be responsible enough to suggest that the OP go to the nearest ER or call 911 right away instead of playing the online differential diagnosis game. But legal issues that could have a material impact on someone's career and finances? Speculate away!

For heaven's sake, the most upvoted comment here, which starts with the only correct response ("find an attorney"), goes on to suggest that the OP find any attorney ("basically any will do"). Really.

I hope you see the problem now.
I am fine with the term 'censorship', but we should discuss: where does it start, where does it end? What kind of censorship is allowed, and what is not allowed?
You Can't Sit on the Sidelines and Become a Philosopher
Here is a recent example: http://www.propublica.org/article/how-hezbollah-trained-an-o...

There are others.
The problem with this chart is that it's heavily biasing the "center of economic activity" towards the center of the Map. The reason it's constantly above Europe is that Europe is pictured between Asia and America.

If you center the Map over America you'll see the center of economic activity being America. If you center it over Asia, it'll be Asia.

Therefore this map does not contain much more information than "Greenwich lies in the middle".
We can take the law as a starting point.
How to install Cacti Server Monitor
Or .... , but that one is fairly easy as long as you COPY from the CONsole to a <fileName>. And remember ^Z to save and quit.
> Common sense? An 80+ year old man standing on public property taking a photograph of a famous piece of artwork isn't remotely a terrorist threat. Presumably the FBI could have even figured out that he's been a professional photographer for most of his life, and done a little research on their that would make it entirely obvious that there was nothing fishy going on there.

Everything you just said here is the point of a follow-up.
To get the story about what straight? The man was taking a picture of a natural gas tank with some art on it. What about that elicits involvement from the FBI?

Sure, you could argue the guards were concerned he (some 86 year old guy with a camera) was part of a terrorist plot to blow up the natural gas tank. If you draw the line for suspicious activity there, though, then that time I searched Google Maps for local dairies should be equally concerning, since I could be planning to poison the food supply (I'm not. I am, however, looking for a good source of fresh milk for cheesemaking).
>What kind of instances? Taking a photo? [...] that anybody photographing a public piece of artwork shouldn't raise suspicions or trigger an FBI follow-up. //

If he took a single photo he's nothing like any photog that I've ever met. Sure, they probably have tourists, art appreciators or whatever, taking photos sometimes. But, I'm guessing, they don't all get added to an FBI SAR list - so this person was clearly not "[just] [t]aking a photo". Indeed he was probably taking dozens of photos, from lots of angles.

There's too little detail of course in the story to know - that would move against the angle they're trying to sell.

This was targeted intelligence gathering, surely.
yes @jordsmi, I agree. This project actually started as a programming exercise to learn a new lang. and not as something to solve my problem - that might be another reason for my low interest level after developing the first version.

I want to continue this, because this helped me learn/develop few new items, which I wouldn't have done in my regular job.
Ask HN: Is there really a shortage of developers in the startup world?
I've read a lot that there is a shortage of developers for startups to hire, but I don't really believe it. Can someone in the industry confirm that there is in fact, not enough developers up for grabs, for startups?
Please. Stop Using Git. Matthew McCullough [vid]
See Grover Norquist. He approached congressional members of both parties with a pledge to never raise taxes. If a member refused to sign or signed and violated the pledge, his group would go into the local elections in that person's constituency and heavily fund their opponents.

If you aren't familiar with this, you might be surprised to see who signed it.
You already can zoom while filming, two finger gesture (reverse pinch) to zoom.
Fork and revert https://github.com/RadiusNetworks/radiusnetworks.github.io/t... while you can
The solution to this is really simple. Photography is never illegal. It literally infuriates me every time I enter the midtown tunnel in NYC to see the "PHOTOGRAPHY PROHIBITED" signs at the entrance[0]. No, it fucking isn't.

Don't put it in public if you don't want people taking pictures of it. We use that argument for Street View, for aerial photographs, for countless other things. There should never be reason to harass people for photography, regardless of what Tom Clancy told you in his latest novel.

[0]: https://www.google.com/maps/@40.745975,-73.974759,3a,75y,86....

(The irony of being able to link to a publicly-accessible image of the "STRICTLY ENFORCED" no photography sign is not lost on me.)
More transparency and punishment for abuse of power would go a long way.

Law enforcement releasing details about investigation statistics would do much more good for the country than keeping it secret in effort to prevent criminals from learning how to avoid law enforcement.
The FBI is older than 2001. Greybeards remember using telnet to send mail 'From: president@whitehouse.gov' , triggering a reply with some colorful language, prompting a visit from Secret Service.
There's part of the story missing: how did he jump from "Have you been to Boston?" to the security guards reporting him?

No reason not to believe him per se, but if he's trying to be persuasive he needs to paint a fuller picture and explain what let him make the connection, not suddenly jump to conclusions like that.
Happy user of Liya[1]. Free but not open source; Mac only.

[1] http://www.cutedgesystems.com/software/Liya/
Doesn't work on Chrome Android (Nexus 7) too (latest, whatever that is)
I think Chris was exceeding his Mapbox limits, and that was causing problems.
.html isn't quite served exactly the same way as .htm on a Windows OS. Although both .html and .htm will open up a page in your default browser, the latter will attempt to locate predefined folders that presumably contains images/scripts for your .htm file.
Marc Andreessen says more net neutrality laws are not the answer
I think if some terrorist actually did try to poison the food supply like that, it could very well make you become a suspect for that too. Except I don't recall anything famous like that actually having happened in the recent past (correct me if I'm wrong).
This is really great. Scribd can suck it. Also props for mirroring to the Internet archive.
Because MOST people don't mind. You are in the minority, complaining about this. It's quite hopeless, really.

Now about those electronic voting machines. Surely those are fair game outside the UK. And I'm sure "everyone does it" so what possible objection could there be?
This article is about horizontal scaling and distributed systems.

Some commenters here are missing the point.
They had his name and address. I suspect they also found that he was a published photographer of the subject matter in question. Did no one think "oh, I see, he was just doing his work." and left it at that? No need to contact him.
IANAL, but many European countries have something called "Database copyright" (see https://en.wikipedia.org/wiki/Copyright_law_of_the_European_...). Basically if you build a database of something you can get a copyright for the database as a whole, even if there's no copyright for the individual items. I wouldn't surprise me if the German government claims that their list falls under these database copyright laws. But even if that's the case there would still be the question how copyright treaties affect such a copyright and if this copyright is enforcable in the United States.
http://www.businessinsider.com.au/the-fbi-hatched-some-crazy...

It is difficult to determine the efficacy of this strategy although of course it results in successful terrorist arrests.
The argument, if you have approached it correctly is then "what level of pre-crime do you want?" Ideally it would be none, because there would be none, because the world is awesome. Reality tends to fall somewhere in the middle.
> To get the story about what straight?

If the security guard suspicion was justified. The FBI found out that is wasn't. Case closed. They did everything by the book. And are you telling me that they shouldn't?
Sometimes Low-Tech is Better
What the World Cup win taught us about social, data and football
Unless you are in a war zone, which USA is not, there aren't terrorists to find. USA soil is incrediy safe as a baseline, and all the security theatre doesn't stop anyone who actually tries. Nearly all the "wins" are entrapment of mentally ill people.
I wouldn't say I'm an expert in maze generation either, but I would agree that it would be nearly impossible for the following reasons:

1.) The specific maze style used, with the semi-random angled lines within a circle shape, isn't the most mathematically simple form of a maze. If it was a grid pattern in a rectangle, there might be a tiny chance of two people making the same maze, but to create a maze of that style would require more creative programming, with more tune-able parameters, and more decisions left to the implementer.

2.) In order to choose from the vast number of possible mazes that fit a certain pattern, the algorithm is almost certainly going use some random number generation. Even if two people were using the exact same maze algorithm, they would have to also have to use the same randomization process, and start with the same seed in order to arrive at the same maze. I guess it wouldn't be impossible for both people to explicitly choose the same initial seed, (or arrive at it randomly) but that would be very unlikely.
>There are extensive public subsidies that have been given in the US for telecom -- and specifically broadband -- infrastructure [1]. So can we have our neutrality and universal access already?

Where do you live that you do not have universal access and net neutrality?
Any advice on choosing what should be the dominant colour(s) for your start up?
Hi, I am working as a freelance PA for a start-up company that was set up on July 1st and they received a customer after 6 days and they need to have a logo and a professional invoice so that they can get paid properly. The start up is not fully sure on what they are looking for in a logo as they wasn't planning on getting a logo designed for another 1-2 months. In short, does anyone have any good advice or experience in choosing what should be the dominant color(s) for their start up? (The start-up has spent a few hours thinking about it and has come up with 2 alternatives: Red, Black & White or Brown & Yellow. But the company is worried that they don't have any robust reasoning or logic to back up these suggestions). I am hoping somebody else on this forum may have been through a similar experience and can offer some advice.
Why don't I just grab a conductive pen and draw my circuit??
Brewing your own probiotics may be a safer option. People have been eating Sauerkraut for 1000s of years. I just add chopped cabbage and a tablespoon of salt into a quart-sized jar, fill with filtered water and wait a week or so until it tastes sour enough.
Article is from 2010. For the same reason you want shorter domain names, people want shorter extensions.

Decade later you can see that there a greater amount of 4+ characters extensions.

> http://en.wikipedia.org/wiki/List_of_file_formats
Wow, love this so much more than Scribd. Already clicked on the latest uploads and found something cool, and it just worked and didn't require login. Amazing.