bonesmoses

Well, we ran a billion queries per day on a 1.4TB system I was in charge of a couple years ago. Now we're building a 500+TB reporting system and probably putting it on Postgres-XL. Seems to scale fine to me. ;)

That's pretty much it. No time series just yet, just an existing Mongo set that I'm trying to wrap my head around, and that means picking it up ASAP.

I've messed around with Cassandra, but not in much depth. I ran into the way it treats NULL, and that all searchable fields must be indexed, and put it on the backburner for later.

Wait, you're telling me that a highly sensitive organ that maintains a complicated electromagnetic and chemical signaling system within a medium of fragile and compressed axions is difficult to tweak with grossly tuned omnidirectional fields?!

Surely, you jest.

Not really good enough. There are massive changes between OS versions. Until a couple days ago, my LG G3 was still on KitKat. The underlying structure, performance, and a lot of other significant details are directly tied to the OS and can only come with an OS update.

And we can't get those because carrier stranglehold, proprietary drivers that need to be compiled for every kernel variant instead of using generic hooks, and so on. Android is still Wild West of smartphones, and it's embarrassing that Google's updates are hilariously terrible compared to Apple.

> Yet I'm unemployed, 30 year old, and can't manage to get hired or to do work that is given to me.

IQ and that kind of intelligence is only really a predictor of how quickly you are capable of learning. Unfortunately, it means very little regarding motivation, ambition, or any of the other traits generally associated with being successful. It's difficult to derive success entirely from pure intelligence, especially with cognitive biases humans are prone to accumulate through experience as they mature.

Most people would say that's why we have society: to prevent misapplied potential in various areas, and to competently leverage mental resources such that everyone can benefit. But people, being imperfect, fuck it up along the way, so we all have our cross to bear, and society becomes shaped by its malignancies.

Talk to any cultural anthropologist. :)

Potentially. I deterred many bullies because I simply didn't give any fucks. I grew up pretty poor and moved a lot, so I was always the new kid, and I also stood out because I usually immediately rose to the top of the class. That usually painted a target on my chest, but it didn't last long.

The few times I was bullied was always the first few weeks after I arrived, and they quickly found out I would fight back pretty aggressively. Was that a "being poor" thing? Was it my notorious "punched a kid in the face for cutting in front of me in line when I was five" temper? Was it simply because I wasn't an "easy" mark?

I can't rightfully say, but one of those things definitely reduced my propensity for being the target of bullies.

Eh. I used to do that until my 30's or so. Now I just want those damn kids off my lawn. ;)

HN is a forum comprised primarily of extremely tech-oriented and innovative people. Are you somehow surprised that some of these would be a standard deviation or two above the norm? And heaven forbid they comment on an article with which they can relate directly, and possibly provide some insight.

But yeah... hurr, durr, braggarts, etc.

Isn't that a housing issue, though? Paying for a $2350/mo place on $60k is... pretty ridiculous.

Indeed it is. Legit avenues like Netflix and iTunes are showing people are willing to pay for content, so long as it's available. There's dwindling tolerance for manufactured scarcity.

Make it available, and we'll buy it. Don't, and it'll be pirated. That's just how things work.

The only thing that concerns me overall about bike sharing is helmet use. It's so easy to casually walk up and rent a bike that riders rarely consider safety. In Chicago, I frequently see Divvy users riding around in traffic without a helmet.

Alternatively you're carrying a helmet everywhere you go for no reason. I'm not sure how to solve that.

Good to know. Also, pretty cool emulator!

I like the end result. However, it makes me wonder just why it's so acceptable that simple programs like this even compile down to a 160KB executable in the first place.

The actual active code is essentially some text and an interrupt. That much, at least, should be language independent. Are modern compilers incapable of discarding unreferenced code, or am I missing something?

Tell that to Bernie Sanders:

http://www.ontheissues.org/senate/bernie_sanders.htm

I'm a bit older than the author, and for me, it has come down to this:

"The time you enjoy wasting is not wasted time."

The article contains a lot of good, sensible statements. But it was clearly written for, and by, someone with far more ambition than I'll ever have.

Maybe I'm just burned out from all the Work Hard rhetoric that got me here, but nobody on their death bed laments that they didn't spend enough time at the office.

Or Python, or any language that has a PL in PostgreSQL. Unfortunately a lot of people consider that a hack, and they're not wrong.

If we can address fields with operators (->, ->>, etc.) then why can't those operators modify, too? It works for everything else, after all. It's fairly counter-intuitive from a dev perspective.

That, and PLV8 still doesn't support JSONB. With JSONB being so much more efficient, faster, and so on, not being able to interact with it using the most logical procedural language is an EPIC oversight.

Unfortunately that's not where it ends. I wish it was only gender or sociological issues.

Beyond that, you don't have to be poor, or female, or black, or... etc., to understand empathy. In a world where empathy didn't exist, maybe they would have a point. But humans can and do empathize, and can bring in elements from that divergent background to improve the overall situation. But only if the discussion isn't cut off with, "STFU, what do you know!?"

Which, to me, raises an interesting question:

If someone can direct the wrath of the lunatic fringe at you with utmost impunity, can it really be claimed that they have no voice?

Because they're claiming they don't, while still exercising that exclusive privilege.

I don't know this is exclusive to Millenials, so I'll be generic:

As an online discussion grows longer, the probability of decrying someone's argument due to race or gender approaches 1.

Really, this is just a precursor for Godwin's Law, because this will be inevitably followed by the argument that Hitler or the Nazis also utilized zealous discrimination.

Ironically, by dismissing your input because of your race or gender, they are engaging in the exact behavior they are purportedly against. That kind of juvenile hypocrisy should be avoided by everyone, but sadly, is not.

Yeah, I didn't see that there was a previous post; sneaky. In any case, that just accentuates my point, really. Were this more automated, the businesses wouldn't need to file either. If forms were handled more like an API, i.e. filed when expenses/income happens, it would all be live info.

The government bitches about the digital age stealing their income, but they're not even trying to adapt. Nobody anywhere should have to "file" anything. The very act of buying and selling means it's already on file somewhere, and that means a live view is possible.

Unless you're using computers from 1960...

And this is the way it should be.

Our government seems to think computers are operated entirely via witchcraft. I doubt we'll get something like that before 2050.

I used TaxACT from 2000 until last year, when its interface for handling my HSA made me want to immolate my computer. Then TurboTax helped out.

This year, I just said "fuck it" and went to H&R Block, because I'm just done with doing it myself. Someone else who does this all day can do it faster, yell at the computer less, and I'll get the same results.

All of this should be automated by now, but no...

The annoying part about all of this is that our taxes are already done. Due to various required forms for businesses, the IRS pretty much knows exactly what you make and how you did it.

Banks file forms. Charities file forms. Employers file forms. They know how many kids you have, they know how old they are, they know if you own or rent, and how much your mortgage is and the interest being paid. They have info on your outstanding student loans. Except for the edgiest of edge cases, there really should be no surprises. Even a moderately powerful desktop should be able to precalculate the taxes for everyone in the country in less than a day.

Why is filing taxes even a thing anymore? Hell, at this point, I wouldn't be surprised if Facebook could do our taxes for us due to all of the info they have. Our tax system is stuck perpetually in 1960, and it's just sad to watch.

It's interesting watching this from a somewhat detached perspective. I only have a B.S., but I did it back in the late 90's. In my industry, it seems like the average level of education is an M.S. based on my coworkers. However, I garnered enough industry experience to remain essentially immune to that metric. So I feel no pressure to go back to school, yet I see that most of our incoming hires have an M.S.

Regarding a Ph.D., unless you're in an industry that needs it, it's still vast overkill. I have a couple friends who opted to be ABD to increase their career prospects. But those decisions were made 5 years ago, so it may be less relevant.

Sadly, all I have are anecdotes instead of solid numbers. It seems right, though.

That's some pretty good stuff, right there. Out of curiosity, any reason you're using HSTORE instead of JSON? I've been watching what contexts JSON gets used in PostgreSQL systems, and having another data point never hurts. :)

Well... generally this is solved via indices. An event log indexed by user ID would have the same effect. You get all the user info, and if you really need to grab historical or event data, it's there when necessary for parts of the app that actually need it.

I own a lot of stuff, but I don't drag my house everywhere in case I might need something. :p

Introducing the caveats of PostgreSQL arrays is informative. However, I can't help but note that this app probably would have been better served by a classic event log table. Why have each user forever carrying tens, or hundreds of thousands of events directly in their user record?

If data mining is necessary, it's right there in the event log and can be manipulated by much simpler (and faster, possibly by orders of magnitude) SQL. Additionally, it's not bloating regular access of the user records.

I've been seeing these designs more and more, recently. Is it a natural extension of non-DBAs taking DDL design roles? Because this data manipulation style doesn't really mix well with any RDBMS I'm familiar with.