skysight-inc/HackerNews huggingface dataset:
> Instead of smartly reasoning about the data, it is all to easy to just "JOIN ALL THE THINGS WITH MEGA TEMP TABLES!".

This is so common, I'd love for the popular databases to add table flags that prevent it by accident. Letting me configure "this table most not full scan or file sort implicitly" would get rid of half the incident callouts I've been involved in. You could always override it in the query where needed.
I bet some clever person on the marketing team just went ahead and inserted the tag. My first experience on a large corporate dev team was eye-opening. While the core product code was version controlled and reviewed, the marketing team had the power to insert any kind of scripts onto the page without clearance. In theory, anything new on the page would require many ridiculous meetings. In practice, they could and did put in whatever through a third-party like New Relic.
Sounds like Microsoft is trying to make a big push specially considering the 8000 strong number in their AI division. Interesting juncture as they seem to have an opportunity to catch on. I hear there is a holy war within Microsoft where one sanct feels Windows and Office are still the bread and butter and therefore all AI related investment should go in the direction whereas the other sanct is pushing towards independent offerings through Azure like Cognitive Services,
It's RDS in general, which supports a number of RDBMS.
There is a theory called regulatory capture, according to which, regardless of the original purpose of a regulatory body, it will be "captured" by the very entities it was supposed to regulate, and end up used for their purposes.[1]

In fact, the shameful behavior of all crypto related markets puts the lie to that theory. As we know, the SEC does not result in upstart startups not being able to raise money. It does not result in bigger, established startups monopolizing their markets, or doing anything else inappropriate. We can all found a traditional startup if we want. Literally anyone.

Indeed, the SEC protects investment markets and makes them a safe and sane place to build startups in. It is safer for an investor to hand money to a startup in California, and safer for that startup to accept it (and abide at reasonable expense by the laws there), than anywhere in the world. We know this. That is what this whole site is about.

At the same time, crypto currency markets are wastelands of fraud and crime. In fact, I do not even feel safe posting under my long-established name, because I don't want to be targeted by criminals now or in the future for it. I steer far, far away from this.

This is a 100% genuine comment, I am not being sarcastic, I have no association with the SEC (in fact if anything I'm on the other side in the sense that I'm more of a startup founder), and this isn't shilling of any kind.

I think the SEC does really good and important work. All the (traditional, fiat-based) valuations of startups that we speak of are thanks to the hard work of the SEC in establishing a fair market. How do we know? Because everyone can see the snake oil all over the darkweb, in crypto currency exchanges and markets, in ICO's, and everywhere the SEC hasn't been touching.

I am really thankful for their work and welcome this.

https://en.wikipedia.org/wiki/Regulatory_capture
Update: I upgraded, and everything happened automatically. No option to opt out of APFS conversion so yeah, if that effects your workflow you should know that. Went without a hitch for me though!
> How do you suppose more innovation would have happened if instead of China, blocking US tech, they let them have the whole market from the get go and instead of WeChat there would be Whatsapp and instead of Baidu, there would be Google?

1. Competition breeds innovation. Monopolies and the like encourage stagnation.

2. How do you know Google would win in China if China didn't block them? Unlike Europe, China is extremely nationalistic. Even if the home brand was slightly worse, it would still probably win the majority of the market. Of course, the only thing stronger than Chinese nationalism is Chinese pessimism so we'll never know.
Tính Năng Không Thể Không Có Của Lều Xông Hơi Tại Nhà
Based on the press release, this really seems to be focused specifically on cybercrimes related to taking advantage of stock markets, such as stealing non-public trading information or using exploits in trading software to trigger market fluctuations and profiting from it. I really doubt this SEC "Cyber Unit" is going to have anything to do with stopping your average phishing scam or even stealing things like SSNs.
It's pretty much everywhere in Japan. I have a 200Mbit device and pull down 30-40MB/s when I have full bars and I haven't exceeded my plan (then reduced to 200-250kbps).
Xeoma Video Surveillance 15.7.27 Free Download Full Version [HERE]
Generating startup names with a neural network
>So then you have to determine, did we save enough money on the design side (using NoSQL over SQL) and then piss it away on reporting?

I spent two years early in my career as a report writer. It sucked horribly, but I learned how important reports are to the business. I remember a professor telling me that any business application reporting is 50% of the value. This is something many developers don't even consider.

Having said that, the solution, as I understand it for the reporting issue with NoSQL is to move your NoSQL data to a proper warehouse for reporting/BI. You'll of course need an ETL layer to do all that, and the ETL layer will need to be smart enough to handle very nullable data and data structures that often get extra, unknown properties, etc.

This solution continues to work even when you have multiple, loosely coupled NoSQL databases handling various parts of a larger system and various separate systems.
OP probably means not worrying about instances, scaling or over/under provisioning etc, just service usage at a more fine grained level.. more like Spanner
I don't think this article is correct.

As the blog owner you opt into ads on your blog in disqus. If you don't want the ads go check the settings in the disqus control panel and all 3rd party requests disappear.

checking my own blogs using disqus I see no 3rd party requests at all with my ad blocks off
Here, saved you time on reading 3 pages of bloat.

> A new programming language that is designed for developers to create apps to debug on quantum simulators today and run on an actual topological quantum computer in the future.
A bit interesting, just posted after you made this comment was https://news.ycombinator.com/item?id=15335146.

So maybe companies like Paragon will get in trouble with the SEC for their dealings, even if they do not sell 'securities'.
Speakers are compensated handsomely for their engagements, no? I don't see anything wrong with students refusing to see their tuition bankroll the likes of Kissinger or Rice--people with blood on their hands.
Based from what I read of the article, its more about SQL the query language instead of the normal ACID compliant RDBMS over NoSQL databases.

Of course, having a common query language is a big advantage, but NoSQL varies in paradigms and implementation due to the subset of problems they choose to solve, thus having a standard query language does not make sense for NoSQL.
There is so much wrong with this post I don’t know where to start

Old school sql replication is awful. It’s awful in Postgres (single threaded replay? A single vacuum can make your slaves fall behind). It’s awful in MySQL (go ahead and tell me how you do dual master without rewriting your app).

People use nosql not because it’s eady or flawless, but because doing it with sql is an order of magnitude harder.

Go ahead and describe resharding a sql DB as your company grows 100x

Or how you’ll handle a dc failover and fail back

Or how you’ll shrink your resources after the holidays - without downtime.

These are trivial with Cassandra and god damn near impossible for most MySQL users.

More reliable? Your “big iron” is still a single point of failure. If not a single cpu, a raid card or a top of rack switch or a DC in a hurricane zone.
SQL never really left the table. People just like to try out new things and talk a lot about them. Its actually a pretty great feature of tech culture; we don't accept that everything is perfect, we always want to try for something better. And in this case, people tried to have a database with a different and potentially "easier" paradigm. Nothing wrong with that at all. But its hard to compete with years and years of tuning and optimization that SQL databases have gone through.
What a nightmare.
Crocodile tears from the New York Times, I see.

(Nah, it's an op-ed, they don't care either)
Stonebraker wrote MapReduce: A Huge Step Backwards [1], which basically tells exactly the story you mentioned, the "Hadoop is Codasyl" comparison.

[1] https://homes.cs.washington.edu/~billhowe/mapreduce_a_major_...
Because it's better in every single way except maybe for massive scale, a problem fewer people have than think they have, would be my answer to that question.
At what level does china block internet access? Technology wise? It sounds impressive to be honest (in a scary way).

I wonder if the US has similar tech that is ready to be deployed at will.
This is how they operate, in fact this is the MO of modern propaganda techniques: divide and conquer.

If we keep the fracas alive by distrusting our neighbors (loudly and proudly!), this lowers our ability to face threats from outside head-on. We need trust in our compatriots to do a good job doing whatever it is we want to do as a collective.

State actors with intent to harm a citizens' coalition only need to sow distrust and more than a few wrenches will be thrown in the cogs by people who feel they're doing the right thing protecting their country.
Nice job on that house you have there. Looks like you might even be able to play Warcraft 3 over LAN without spending the entire party trying to get it set up.
I don't think the article could have said it much better.

SQL is super powerful and makes much sense in so many ways. Nearly all apps have a relational structure to them and SQL is a reasonable way to interact with them.

Some of my favorite conversations from the Postgres community 5-6 years back were when they were talking about a time when Postgres was being disrupted. The gray bearded DBAs (Hi Berkus and others) were talking about JSON like it's fad and how it's going to come to pass. They were saying so because they'd heard about this disruption before... there was this new thing XML and these document databases were so much more powerful. They waited a few years and added an XML datatype [1]... And then XML databases came and passed.

At first they scoffed a bit on JSON as the new hip thing, but came around a little in Postgres 9.2, and then in 9.4 [2] we all really got what we wanted.

SQL has never been a particularly elegant language, but it's always been a powerful one. The lone knock against has either been usability or scalability [3]. On the usability side that's a bit of a hard one as well it's not super pretty. But once you understand it's foundations around relational algebra or relational calculus you're so far ahead. On the scalability side there are definitely some options such as Citus, but also core Postgres is massively improving here.

[1] https://www.postgresql.org/docs/9.3/static/datatype-xml.html

[2] https://blog.codeship.com/unleash-the-power-of-storing-json-...

[3] https://www.citusdata.com/blog/2017/02/16/citus61-released/
Can't continue to have an inflation tax (our government outspends what it takes in year after year after year) if the population moves to cryptocurrencies.
NVMe SSD's are 100x faster than 15k disks. How many shops run 100+ machine NoSQL instances?
GIPHY World: AR GIFs and Stickers
So, all that text to tell people he is refusing to rename a single file? :-P

I encountered that issue a few times in the past, most recently when a couple of years ago i was writing the console support for my 3d game engine and made two files called `con.c` and `con.h`, checked them in to version control and then at some point (much) later synced it on the Windows side. Fossil (the VCS i use) simply skipped that file (maybe it complained? i don't remember, but the files weren't created) and when i tried to build the engine it didn't work - i thought that i forgot to add the files, rebooted to Linux, forced a re-add, back to Windows and nothing again.

Eventually it clicked that "con" is a bad word in Windows filesystems, so i simply renamed the files to `csl.c` and `csl.h` :-P. I found this a bit irritating because my naming convention follows a mostly rigid pattern where `xxx_` prefixed functions will always recide on `xxx.c/h` (or `xxx_yyy.c/h` where yyy is a subsystem or specialization) and i really prefer the `con_` prefix to the `csl_` one. So far i've kept the `con_` prefix and made a special note for that in the readme file where i explain the naming conventions, but every time i have to use or work with that part of the engine i feel the irritation :-P.
No tool is good when abused. NoSQL was a knee-jerk reaction and the truth lies somewhere in the middle. Putting everything in relational databases is as bad as putting none of it there. If everything is treated like a tool the world becomes brighter at the cost of having to learn and understand more.
By no means am I an expert, but here's the thing. You can't say "Cars are the new thing. Airplanes came to be but now they're not the shiny thing anymore."

You don't take your car to go intercontinent, and you don't take the plane to go a couple of kilometers.

One thing NoSQL databases excel at, is scaling. Scaling in Cassandra for example means adding a node, everything else is just magic. THAT is what made MySQL and the SQL language popular.

SQL may be popular with developers, but scaling MySQL was a nightmare for quite some time, even with the introduction of vitesse etc.

Point is, please do not compare apples to oranges.
Yep, Fetch API would be fantastic....if it was widely supported.
Caveat, this comment isn't directed at you (I agree with your comment), but rather the points around what you are saying.

One thing that helps is if people stop referring to things as SQL / NoSQL as what ends up happening is various things get conflated.

When talking about stores, it's important to be explicit about a few things:

1. Storage model

2. Distribution model

3. Access model

4. Transaction model

5. Maturity and competence of implementation

What happens is people talk about "SQL" as either an NSM or DSM storage model, over either a single node, or possibly more than that in some of the MPP systems, using SQL as an access model, with linearizable transactions, and a mature competent implementation.

NoSQL when most people refer to it can be any combination of those things, as long as the access model isn't SQL.

I work on database engines, and it's important to decouple these things and be explicit about them when discussing various tradeoffs.

You can do SQL the language over a distributed k/v store (not always a great idea) and other non-tabular / relational models and you can distribute relational engines (though scaling linearizable transactions is difficult and doesn't scale for certain use cases due to physics, but that's unrelated to the relational part of it).

Generally people talk about joins not scaling in some normalized form, but then what they do is just materialize the join into whatever they are using to store things in a denormalized model, which has its own drawbacks.

As to the comment above you, SQL vs NoSQL also doesn't have anything to do with the relative maturity of anything. Some of the newer non-relational engines have some operational issues, but that doesn't really have anything to do with their storage model or access method, it just has to due with the competence of the implementation. MongoDB is difficult operationally not because it's not a relational engine, but because it wasn't well designed.

Just like people put SQL over non-tabular stores, you can build non-tabular / relational engines over relational engines (sharding PostgreSQL etc.). In fact major cloud vendors do just that.
>The GDP rate has skid down to 4% just as the previous PM, Dr Manmohan Singh said it would and at that time, everyone mocked him.

The GDP growth rate has been low from 2012 to 2014[1]. And anything a former prime minister tells about the opposition party, I would take with a pinch of salt.

Also, the power ministry has done a great job over the last few years. They distributed LED bulbs across the country which reduced power consumption
http://www.ujala.gov.in/

They might have made mistakes, but I would choose this govt over the corrupt congress any day.

1:http://statisticstimes.com/economy/gdp-growth-of-india.php
Because they are poor, they do not have the right access to the resources both nutrition and education. Eliminating poverty is at the top priority of the gov't plans. It's said to totally finish the plan in 2020.
I disagree with this.

And MySQL != SQL
So pre-global warming we where having at least 4 a century, now we are down to one or less (with the new ability of satellite data to catch them all, you'd conclude we are even better off)

1893: 10, 1886: 10, 1878: 10, 1880: 9
Social and Asocial Enterprise
If I didn't have five kids, one in college, and monthly financial minimums that preclude taking time off from regular work, I'd jump at applying for YC. I even _had_ a great ed-tech startup... 5 years ago ...

Textfyre Final Presentation, 2012
http://plover.net/~dave/textfyre/Textfyre%20Investor%20Prese...
(The slide with the team has been removed...no need to share that info)

We were in talks for a couple of months with Gates Foundation, but our timing was off. They had just pivoted away from helping startups to giving millions of dollars to big education publishers like Pearson.

I gave up after realizing that I'd vastly under-estimated the networking (and cash) requirements in even proving the plan. Education is a really hard business to crack and we were targeting textbooks.

Fast-forward a couple of years, maybe 2014-15, and I'm listening to a gal from Pearson being interviewed on NPR. She's essentially spouting many of Textfyre's ideas (embedded testing, interactive content, variable reading levels).

I laughed and cried at the same time.

The funny part is, not a single person ever told me the plan was bad. They just told me the education business sucks and it would cost a lot of money. But bar-none, everyone _loved_ the plan. And this goes through to today. I chat about this plan once in awhile with someone that's peripherally interested in ed-tech and they all say, "Why aren't you still working on THAT!"

I'd love to. Write me a check.
ORMs lure devs into thinking you can have a single schema for your app. At launch, this might work. Once you scale, though, ETL is a fact of life. And running a job from you daily stats to the weekly stats, and then to the monthly, quarterly, etc. becomes a requirement.

Which isn't tough, but is often unplanned.
The $2.5B is ~$60 per connection (40 million households). Only households of "poor citizens" don't have to pay a fee, so if the cost is more than $60 per connection you can charge the non poor households to cover the difference.
Just because something is "real" doesn't mean you should blindly put your trust in it.

Document 1 says: "President ABC bombed a school in Syria today, killing 50 people."

Document 2 says: "This action was carried out after President ABC learned that the school was being used as a base for terrorists, and only terrorist combatants were killed during the bombing."

Both documents are real, but only releasing document #1 and keeping document #2 secret is a very easy way to shift the narrative against President ABC.
I don't honestly think many people have the kind of scale where this is a sensible trade-off to make.
I think it's less about swaying their minds and more about making them more active and vocal about the topic, which spreads their opinion to people who otherwise would stand no ground either way. The people they would directly affect are their family members and established friends, who have an inherent trust for people they know and have opened up their lives to.

In essence, it created pseudobots that serve as outlets for the kinds of messages (read: divisions) they wanted to sow.
"The Antminer D3 is the latest product by Bitmain, released in 2017. It focuses on X11 mining, an algorithm used by the popular Dash cryptocurrency. With a 15 GH/s hashing power, it consumes 1200w."

It seems there's an ASIC for monero now. I doubt that javascript miners will be worth much as these become more common.
The article is talking about something more than protest.

Most of the hatred was focused on Dr. Murray, but when I took his right arm to shield him and to make sure we stayed together, the crowd turned on me. Someone pulled my hair, while others were shoving me. I feared for my life. Once we got into the car, protesters climbed on it, hitting the windows and rocking the vehicle whenever we stopped to avoid harming them. I am still wearing a neck brace, and spent a week in a dark room to recover from a concussion caused by the whiplash.

That's basically mob violence. Respectful protest and disagreement is to hear someone out, not intimidate and violently stop them from speaking. It's just an odd mindset. You're at college, so presumably you are there to be educated, to experience different points of view, to learn.

edit: Asked if modern media or some other factor was the biggest cause of this, saying this so the reply makes sense.
You got downvoted, but I agree with you. Traditional RDBMS is inherently single-node and a pain to scale. The actual sad thing here is that there's no mature/reliable commodity (i.e. open source) distributed RDBMS for transaction processing yet.
And NoSQL is only better for massive scale when you don't need to do anything with the data.
That is what you got out of this lecture?
> So maybe the article is onto something about the value of the language.

The strongest feature of SQL is the lack of specificity about "How it should return results" and primarily deals with the details of what the expected results are.

I work on a SQL engine which honestly breaks so many rules of "How to do things" and basically tries to avoid nearly everything a sane SQL engine engineer would do.

But the advantage of the lack of forcing implementation is that a new idea like this could still implement the "give me expected results" part of the implementation.

Whenever it doesn't - it needs fixing, not documenting in a "vs vs" comparison.

> I actually love SQL, but it does have its limitations. I wouldn't mind a solid relational database with an alternative query language

MDX is a pretty interesting thing to think with.

Mostly because if you're used to spread-sheets, it is a more natural way of expressing what you want generally in a straight forward lookup order - get me some columns from these rows, where some condition is satisfied.

That makes index & cube lookups so much easier to detangle for an engine than a more free-form SQL tree which has so much more variety in it.
Ericsson and Telstra encrypt in-transit data over 100Gbps link
How to perform database recovery in few steps?
Right, this is true for software in general. You don't optimize for out-of-date hardware and an older battery is not going to fare well with a new iOS update doing different things with your files and make the adjustments it needs to in the first few days or weeks.
> On the contrary if you want to reimplement a BSD you need to reimplement their libc (and perhaps some other libraries)

To clarify, what you're saying is that in BSD land, the syscall API is not considered stable, but libc is?
Listen to your enemies, they have more to teach you than your allies.

"It has always been the prerogative of children and half-wits to point out that the emperor has no clothes. But the half-wit remains a half-wit, and the emperor remains an emperor." -Neil Gaiman
MySQL has a slow query log with all non-indexed queries.