skysight-inc/HackerNews huggingface dataset:
I'm suggesting, maybe it wasn't ignorant. I can think of a few examples of where I'd want to be transparent in my actions. Seems like as a whistle-blower you should be as transparent as possible. I think it is time that we see the Russian evidence though. A bunch of techies deserve to disseminate if it is legitimate. Afterall, WikiLeaks has been doing nothing but providing verifiable evidence.
That something happens over a long time does not mean that it does not have several causes.

I can remember well how the UK promoted the 'service' and 'finance' industry in the past decades. Manufacturing was seen as obsolete. Especially when North Sea oil brought wealth to to Britain for some time, they were mostly busy managing and consuming this wealth - currently oil is cheaper and North Sea oil is less competitive.
Free Cross-Platform UI Kit for Photoshop and Sketch – InVision
I use Lewinsky to manage my favorites on www. p o r n h u b .com
I'm not clear on what the motivation for this 'leak' would be. Is it morally reprehensible for the NSA to withhold this information from the public? Was the NSA doing something illegal by withholding this info?
If the only actionable information leaked is politically charged or simply falling within the established/mass media narrative, is it wrong to suspect this 'leak' is disinformation?
It does feel gross, even if we all implicitly do it. Some things aren't meant to be consciously commodified, I think. It's like the thought experiment of asking a friend (or your mom) how much you owe them if they make you dinner.
This is why I like HN, and why it continues to be a much-higher-quality place to visit on the web than many other forums: there were no snarky replies, no "I can't believe you don't know cron" - just multiple friendly, helpful replies explaining exactly what this format is.

What a good community.
I think this is a very interesting point.

How important is it to be something of a generalist, who could answer questions like this at least in broad terms, as opposed to being purely a specialist who has little knowledge outside of their domain of expertise?

Would it be significantly helpful to understand more about the things that happen under the hood, as it were, of technologies that we use?

Would a developer who could at least kind of answer this question show an aptitude for broader thought and a deeper interest in technology, and be a potentially more valuable hire as a consequence?

EDIT: To attempt to answer your question, any collection of structured data, whether objects in a memory-based data structure, delimited text fields, or a DBMS file, could be considered a database.

In many data structures, such as hash tables or primitive key/value stores, there is only one key. If you want to find data based on a field that is not the key, you either have to search sequentially through all the records, finding matches on that field, or create an index on that field.

If the number of records is small and the storage medium is fast, a sequential search may be adequate. If not, an index is needed.

Creating an index generally involves scanning all the records in the database and extracting the field required for searching, together with the location of the record within the database. The location would preferably be a direct record number to avoid unnecessary indirection, but it could also be the primary key of the database.

The list of key values and locations is put into a suitable lookup data structure. This could be something as simple as a sorted list in memory, a hash table, or a disk-based structure like a B-tree, B+-tree, or one of many others.

In the most simplistic case, looking up a record using the index means searchng the index for the matching record locator, then using that to retrieve the actual record in a separate step.

Obviously this is a bit more complex for non-unique keys, but that's the general idea.

Finally, the choice of index structure has tradeoffs, because once the index is added, it must be maintained when records are added, deleted, or modified in a way that affects the index. If the db has 100 million records, having to add a new one to a simple sorted index and re-sort it could be a performance disaster.
If you're bored and hanging out with physicists and/or mathematicians or maybe some engineers, perhaps over some beers you can have a fun conversation along these lines:

Here's something uncontroversial: if its in physics, then its in math.

Here's a weird proposal: if its in math, then its in physics at a greater than trivial level or it can easily be proven not to be in physics. Or if its in math, either its obviously not in physics or it is in physics even if we don't know yet.

Discussion: Aside from souls and such your brain used physics to come up with some math thats not in physics so at a very trivial level that non-physics math was simulated in your physics brain, so it is now in physics because a physics simulation of the particles of your brain, however impractical to actually simulation ... naw thats trivial cheat that would include everything. And speaking of easily be proven, a classic example is we know two dimensional geometry fairly well and it doesn't apply to the greater world although it makes an entertaining plot for a book named "Flatland".

So as your buddies gulp down some beers, challenge them to think up a math that is not in physics as kind of a parlor game. It can be fun, especially if you allow extremely extended analogies and have a very relaxed beer fueled attitude toward handwaving arguments.

Some topics like string theory or the multiverse will have to be banned to prevent pointless fighting.

Anyway the relevance to OP and the comment is that in a drunken handwaving sense math that hasn't been found in physics is possibly a failure of the imagination of the physicist, so Riemann seems useless today is an attack on physicists not an attack on mathematicians.

You can just picture some seance between Newton and Maxwell, Yo Mr Physicist I invented all the math you needed centuries before you got around to noticing electromagnetism, like whats your excuse for the delay?
Wow, I'm now a fan of Sandstorm!
I was hoping that you might explain why.
I think they could just have tried optimizing the query? My knowledge could be out of date, but I read that the problem with Limit is that it is applied on the end. Meaning their original query will happily take all available results, sort them and then return the first 9. If normal values for freq are known, a simple WHERE freq > X could have helped.

That might also make the join less painful, right? Additionally, I think there might be a logic issue with the query itself, but I can't fully wrap my head around it.

Also, activities.user_id = #{id} smells like an SQL injection. But maybe that's just because of the simplification for the blog entry, or id not user chose-able. Still.
They probably just forgot about it.

If someone asked you to write all the brands of X that you've ever used, can you remember all of them, especially if they were nearly equivalent in quality and use case?
are you the type to ask that question about google and facebook too? uber is facebook minus a few years and has similiar numbers
Thanks! We've just removed "Show HN" to avoid confusion.
Living in a tiny apartment with my partner in New York, I love it. The way we see it, we have less stuff to own, clean, (if it didn't come included) heat, etc- and it works out just fine. I personally think that having more stuff and space doesn't make me happier, having better life experiences (good friends, travel, walkable neighborhoods) does. Also, I also value community involvement very much, which makes anywhere I live way more interesting and engaging.

However, I can relate to the wildly opposing viewpoint perspective between you and your SO, so perhaps a mediator may be in order- an impartial friend, a therapist, whomever you trust and isn't biased. Neither side needs convincing, but perhaps both sides may need a happy medium. Perhaps a new house may be in order regardless, or maybe just reorganization or expansion on your current place. But the way you describe it now, it sounds like nobody will end up really happy with the outcome.
I work at another Boulder company just down the road from SparkFun, also founded by a CU student in his dorm room, which has been successful without VC investment. Boulder is an odd hybrid of new tech companies and more traditionally bootstrapped companies like SparkFun.

There's plenty of VC-funded startups in Boulder, too. The main pedestrian mall downtown, Pearl Street, is flanked by tech companies on the 2nd/3rd floors, above the retail shops. It feels quite similar to University Ave in Palo Alto, back when I lived there in the 90's.

Perhaps the biggest difference is that where Silicon Valley is geographically locked-in and there's no cheap office space to be had, in Boulder you can go East a little bit and the price of office space drops dramatically. Taking SparkFun as an example, it's not on Pearl Street, it's several miles outside of town in an industrial park.

As such, Boulder gets to be both a micro-size Silicon Valley and a more normal commercial environment as well. It's also just a great place to live, housing costs are reasonable (relative to California anyway), there's tons to do, and it's a good place to raise a family.
I am not a database expert but as a developer, I of course work with databases and SQL as needed. My answer would be:

"Index helps you locate information quicker than usual in a database. If database is similar to a Book, then think of index as a Table Of Contents with page numbers for specific topics. Imaging if I gave you a book with 1000 pages and ask you to find a specific topic but there is no table of contents. You will have to look through many pages before you find it. If it had a table of contents, you could flip to that page much faster.

Will this answer be good enough for you ?

But then, I have no technical knowledge of how index is implemented within various databases and that is where I will say "Sorry I can't tell you the technical details".

EDIT: I will also add that it is difficult to list EVERY possible topic in a book in the table of contents. It will then defeat the purpose of the TOC. So you have to pick and choose the topics that you want to show with page numbers. Same for database index. You cannot index everything.
You can use the leaks and still be critical of the way it was done.
They're in a lot of counties and have a massive infrastructure. This number isn't that surprising.
St. Louis here. The startup scene here are also trying to copy the Silicon Valley model, instead of trying to be something unique and different. It is frustrating.
I remember when these were called "witch-hunts", not "probes". How progressive we are.
René Descartes: Scientific Method
1) No
2) no
3) nothing
4) by email :-D
Does anybody know where the trend is going? Do electric cars have standard buses or are they moving to proprietary (and not published) buses?
It's a question of "do you charge 3% more for credit card payments to cover the charges from the credit card companies, but leave off that fee for non-credit card payments?"

Most credit card companies _don't_ want you to do that because charging more to pay with a credit card makes using your credit card a less enticing idea. IIRC, this stuff is usually handled in your contract with the credit card processor.

The last company that I worked for that used a credit card processor other than Stripe, the rules were something like:

* 2-3% of the transaction is the processor's keep

* You are allowed to charge a surcharge, but _only_ if it's a flat fee. You cannot add a 2-3% fee to cover the credit card charges, nor can you have some sort of "flat-fee schedule" where the flat-fee changes based on the amount being charged (e.g. charges of $1 - $100 get a $0.50 fee, but charges $100+ get a $5 fee). You can only do something like $0.50 fee to all charges.

* You cannot charge a different price for products when they are purchased via credit card.
I would argue that this isn't a new concept, we just lost a lot of those jobs in the industrial revolution. If it feels like a new concept it's because we're only just now starting to drop a lot of the toxic habits introduced by it.

I could easily see a tradesman before being "passionate" about his work, though they probably wouldn't have used that language.
"Here are everything you can do with Monica" -> "Here is everything you can do with Monica"
The article doesn't discuss the seniority of the fired employees. It's very hard to distinguish between scapegoating and actually working to fix the problem without that information.

The problem with Uber isn't that some employees engage in sexual harassment. The problem is that there's a culture where sexual harassment isn't taken seriously, is tolerated if the perpetrators are "high performing" in other respects, and there's common knowledge that being "high performing" covers all sorts of other ills. No amount of firing of the low-level scum that grows in this environment will fix this issue.
I wonder if events like this turn Uber employees who leave around this time into a market of lemons. Obviously nobody will put on their resume that they were fired for sexual harassment so hiring managers will have to wonder if a person who left Uber recently was fed up or fired.

Seems risky to hire a recent Uber employee at this point because bringing a toxic sexist into the company can inflict massive damage.
Well, this is world-wide. Presumably most of them are local support and such.
Our Lessons Learned Building a Backend-as-a-Service: A Technical Deep Dive
About Facebook, yes. Google does genuinely seem to have fingers in very many pies so their headcount is not really a surprise.
Excellent idea. If only I knew how to do it though :-D
I describe myself as a starving artist pretty frequently. What it means is that every week I find myself choosing between materials and food. Sometimes food wins, sometimes materials do (they did this week). Every penny I can spare goes towards materials and tools but I still can't afford everything I need to not only make my work but make it good enough to match my vision, slowing progress significantly which can be pretty disheartening. And so my struggle will continue until I can start selling my work, make my money back plus labor+profit, and I finally no longer have to consider replacing a $15 electric pencil sharpener a burden.

Honestly it's no different from living on ramen while pouring all your money into a business you're trying to start. It's just more romanticized.
Yea it's tech heavy but not really startup heavy, which seems to be HN's bias. I'm pretty sure Intel and IBM have big campuses there still. Also quite a bit of finance spills over from New York. And lots of tech workers live in NJ and commute over to NY.
Ramroot: lightweight solution for live-booting Ubuntu or Debian over HTTP
WaPo is the WSJ of D.C. They know which side their bread is buttered on.
I guess I was expecting a little more substance to the post. It seems like a long-winded for the little substance in it.
At a valuation of $6m/employee it's hard to argue with.
I could give a general explanation about reducing the number of disk seeks by using B-trees to store index values with pointers to the database row.

That being said I mostly agree with the other commenters that while a senior developer should know the answer, it isn't disqualifying if they don't. And if that's the case what is the point in asking it?
Does it make having "Uber" in your Career Profile look bad now?

Even if someone wants to genuinely switch job within next few month out of Uber, It would raise eyebrows at next interview table. So Uber gonna have very mall attrition rate now. Every action has both side of coin. :)
I don't think there's anything wrong with people posting about their hobbies, or what's up in their lives, even multiple times a day.

I have people that post multiple times every hour. Sometimes 8-10 times an hour for short periods. Generally it looks like reposting everything they read. They become a one person news aggregator, if by "news" we mean Facebook posts tailored for meme propagation (which means a good portion of them range from misleading to blatantly false).

I don't really use my feed, so I'm not bothered by the posts being in my feed for my own sake. I'm just a bit worried that they've become obsessed with Facebook attention to an unhealthy degree.
If you're a low volume business, then the difference of 1% probably isn't worth much headache. I can't comment on how easy those services are to integrate, but I've personally found Stripe super easy.

Even if a business is doing $500k of charges a year, I'd guess it's probably not worth the time to save $5k a year... there are usually more impactful uses of time. And when businesses get to high volumes, where integration costs become much smaller as a percent of revenue, then Stripe will give you a better deal.
Yes! This! Exactly! tx.

wait, what?
No worries. Hyperion was ultimately a letdown (compared to its promise), so better than that is good!
can you explain your process after payment ? Like design, how do you collect requirements that are in scope ? etc.

What language or frameworks do you use ?

Do you at least try to write good code ?
For one thing there is no single canonical way. Cassandra indexes (sstable indexes + bloom filters) are quite different than e.g. SQL server indexes (probably some variant of B-trees).

If I wasn't prepared I could probably say something about these schemes but database indexes are kind of specialized knowledge since they combine some attributed of in-memory data structures with the performance characteristics and limitations of storage.

Let's turn the tables here, explain in detail how a B+ tree works and what's the difference between that and a "standard" B-tree? What do you know about sstables? LSMs?
Help manage the 1 million rides that happen every day in 450 cities. Multiple products, localization, recruiting, customer support, operations, etc etc etc.

Look at their job openings to get a sense of how massive of an operation Uber is: https://careers-uber.icims.com/jobs/search?iis=joindot-V101A...
I did, but I sort of talked myself out of it. I keep a lot of PIM-level info on people in my address book already (which is on my computer and syncs to my phone, etc), so it's not like I don't keep some of this, but I don't go to the level of tracking when I do stuff with people other than placing reminders on my calendar. I think calling it a CRM is what's weird - it's making your friend group something different, when really it's just a fancy rolodex. The trick is for them to never, ever get hacked, should you keep some unsavory stuff in there - I think it feels like a better offline thing to me, not because I like to keep a shit list on people, but because my friends are worth more to me than most of the stuff I do online.
I live mostly in the front end world, but if I was asked this (without looking it up) I'd say a DB builds a tree (balanced tree, binary tree maybe?) using the columns requested. This allows for very fast lookups when the table is queried for its indexed column(s), and blows away the worst case scenario of a non-indexed query time wise, where the DB has to do a full table scan to find out that a record doesn't exist. The trade-off is that the index must be rebuilt on inserts (probably deletes and maybe updates too?) and the resulting data structure stored, which is why you don't just index all the things.
Have any of you guys ever written or read scientific papers before? This is a pretty poorly written article and I'm surprised it has so many upvotes. It's a bold headline, but the article itself makes many logical leaps that are pretty sensational and unfounded.

Overall I'd say this is a pretty garbage article and that we shouldn't be upvoting it so much / only reading the headline and accepting it as fact.
The Great Hanoi Rat Massacre of 1902 Did Not Go as Planned
The article contains so little information (that isn't already revealed in the nicely succinct headline) that clicking through is almost certainly not worth your time.
The scrolling infographic was a very nice touch, especially with the DBZ style animation.

It's only natural that in little league coaches tell players to hit ground balls because kids have trouble fielding (it requires extreme precision, speed, and dexterity).

It's also quite obvious that you have to hit the ball high and hard to get a triple or home-run. Good to know data backs this up.
> Do you know, did the case I mention have someone else they conspired together with?

I was extrapolating to the more recent events where there were several killers but it applies often to the case where there is a lone wolf because often there is someone else who enables them, perhaps not enough to pin a formal charge of conspiracy on them but close.
Isn't an index sort of like an index?

It gives you mappings that don't align with the primary ordering (ToC/page num).
I don't think either of them are addressing whether sexism is acceptable in the workplace. They're talking about whether a "fun" culture is an indicator of sexism in the workplace. If you have another interpretation and the time to break it down, I'm always interested in understanding things from other people's perspectives.

Victorhooi is arguing that alcohol culture is not exclusive to men, but according to personal preference. Wpietri is saying that it can be a strong indicator of a place being a dumpster fire. The discussion is fine and I think both have valid points.

Incorrect tone can cause people to become completely unperceptive to an argument. It's important to not be hostile when looking to change views. A collaborative approach is often the most successful. Belittling people for their opinions doesn't achieve anything besides pissing them off.

>While I agree with X, we should also consider Y and Z because words.
Seriously seems like this was a whistleblower with a legitimate concern for the American people. Maybe she was careless on purpose. If you know you are going to get caught, might as well make your trail obvious so that you can claim that you are a whistleblower.
> Boulder, CO

I don't know, that place has actually tracked SV in a lot of ways, from a good university, to a concentration of smart people, to some good VC's, to being a nice place, to ... rampant NIMBYism that has driven housing prices up to nearly 700K (Zillow).
Ask HN: How to privately share photos/videos from multiple devices
We probably have a typical tech household setup: multiple phones, several camera's (DSLR, action cameras, drone) and multiple laptops and a desktop. We generate currently 40K photos and 5K videos (around 2TB) per year.

Some images are private, only for my wife or for myself, some should be shared. I tried having a 'shared' folder (synced using private OwnCloud), and then manually selecting which photos and videos should be shared. But that is too time consuming and therefor fails.

1. What setup do you use to manage and share large amounts of shared photos/videos?

2. How do you backup and prevent duplicate data?
I would expand on that a analogy a bit, as a book index (like a database index) is not without cost. It takes up space in the book that now can't be used for the actual text, it may not be useful for certain types of searches (i.e. the book index lists topics by title, but you're trying to find them by author, etc), and you have to keep the index up to date with later editions of the book (a topic inserted in the middle means you have to adjust the page numbers for a bunch of topics), etc.

All in all though, I'd personally be pretty happy with that answer (I'm not the OP, though...)