skysight-inc/HackerNews huggingface dataset:
I have seen at least one case where I could ascribe no meaning to several of the tables in a database. To be fair, seeing the code did not help either, until it became apparent that it was all an attempt to work around a fundamental error. The creator of this mess was blaming the users for it not working, and I was happy to refute that claim and exonerate the users.
Note that "tables" in this statement had a different meaning than today. That one wasn't about relational databases, it was about tables as in-memory data structures.

In today's words, "flowcharts" means "code" and "tables" means "data structures".

I don't care if it is:

- tables in a relational database

- nested structs (records) and lists

- nested dictionaries (hash tables) and lists

- JSON

- XML

- ... whatever

What I do care is that I can see the data structures, and not just the code. Static typing often gets that job done fairly well. If you don't use that, please use at least type annotations. This is the most important part of your documetation, and the compiler ensures it remains correct over time. Most of the time, this (+ the function name) is the only documentation I really need.
Trump Adviser Jared Kushner Didn’t Disclose Startup Stake
I think it's funny when the author compares SQL being most loved with least dreaded. They're the same thing. The percentages all add up to 100.
The 1800X is bad value though. It's the "I'm rich and afraid of overclocking for some silly reason" option. It's only slightly better binned. Most 1700s will reach 3.9 GHz easily (77% of them, according to siliconlottery.com). The R7 1700 is the real deal.
What do you do with your mouse?
5 of the Most Effective Ways to Increase Ecommerce Sales
Because MongoDB is web scale. It doesn't use SQL or joins and that's the secret ingredient in the web scale sauce. That and sharding.
>a phenomenon of people finding SQL 'too complex' and moving to noSQL?

Fyi... the "SQL vs noSQL" means at least 2 different ideas and some of your replies are highlighting one aspect but not the other.

1) "SQL vs noSQL" can mean "SQL syntax (e.g. joins) vs object syntax to save/retrieve documents (e.g. Javascript JSON/BSON)" . This is probably the main driver of MongoDB adoption. (They don't care about Mongodb's scaling aspect; they just like the easier syntax.) The counterpoint to this idea is that "people are using terrible db engines like MongoDB because they are unwilling to learn SQL syntax."

2) "SQL vs noSQL" can mean "OLTP RDBMS engine (e.g. MySQL/Postgre/Oracle) vs distributed db engine (e.g. Hbase/Cassandra/etc)". The counterpoint to this idea is that "people are deploying to distributed db engines when their use case actually fits in a 1-node RDBMS engine."

From your wording, it looks like you're talking about #1. To that point, many programmers don't like the compexity of 10-way joins of a dozen normalized tables to reconstruct a customer data entry screen. With a document-oriented noSQL db, you just retrieve the entire denormalized "document" with no joins. However, there are tradeoffs to the "easier" noSQL engine such as performance.
That's a small trade-off I'm willing to take. It beats having to have a completely separate engine for the PDFs (compared to just using what you're already displaying on the web) and it's way more complete than using something like DOMPDF which doesn't even have support for some of the most basic CSS features.
Ah, I was under the assumption that it is standard practice to have a different key for each machine that you log into.
My personal take on using electron if the following: If you are creating a big app that gets a lot of attention from the user electron is fine.
If you are creating a little tool running in the background, electron doesn't work so well because it often uses a lot of memory.
So, building a chat application with electron is bad and your main text editor for your dev work in electron is totally fine. Ultimately, the deciding factor should be your users, is it best for them that you use electron or are they better of, if you are using a different solution.

Something else to consider are your development skills. If you never worked with something else than web technologies, electron is hard to beat in terms of dev experience.
Nice and thorough work!
Inside the design process of Tinycards by Duolingo
Exactly. I can't think of any use case where I would want to use a desktop app that doesn't have the native performance of a real native solution instead of just using a web app.
That's the reality of an overwhelmed court system, they make choices to optimize. It's a system of trust, balanced by a Judge reporting abusive attorneys to The Bar, which means most subpoenas are actually what a Judge would sign.

In the case of this Louisiana Prosecutor, it seems like perhaps the courts are so overwhelmed they can't even get stacks of pre-signed subpoenas so they write their own. And the article states that when said Prosecutor has been called on it, a Judge issues a real subpoena. So yeah, meh.
Loving Common Lisp, or the Savvy Programmer's Secret Weapon
There are a lot of comparisons here which don't make any sense. It's not the same people making HoloLens work (which may be overblown, since not many people have had heads-on time with one to report back) and making Skype so awful, because Microsoft is huge and have different teams doing different things and some of those teams are clearly better than others or get their priorities set by people more in line with what the author would want than others.

Likewise at Google, Hangouts and self-driving cars won't share any people. Especially as their self-driving cars are now handled by a different company, Waymo, who have the same parent company as Google.

I get the point that it's astonishing that videoconferencing tech is still so awful. I remember interviewing at Google's London office years ago and two of the interviews were done by video links, and they worked flawlessly - but this very impressive conference system was one Google had bought in from somewhere and presumably paid ridiculous sums of money for. That experience gave me hope for consumer video tech - but it's now ten years later and where are we?

FaceTime seems to work, but it only works between Apple devices. Google Duo seems to work in my limited experimentation, but only works between phones running the Duo app, because Google have more hands that don't know what any of the other hands are doing than just about anybody else - especially in the consumer communications arena.

I wish someone would get their pants on and seriously invest in sorting out video calling.

Heck, getting audio to work reliably would be good. Best one for that currently in my experience? Slack.
This is why corporatized, "media as entertainment" culture in the US is so dangerous. In reality, we live under a regime of insane violence and mass incarceration compared to other developed countries. But because the distinction between news media and "Law and Order" episodes is blurred in the minds of average Americans, people think everyone is escaping justice on a clever technicality vs. being forced to plead guilty to crimes they either didn't commit or are in excess of their actual offense (what really happens).
SQL is the second most underused tool we have with dealing with data. AWK being the first. SQL is great because the logic works with dealing with data and forces you to make good decisions earlier.

Everyone should spend a day learning SQL if for no other reason they the ability to think logically about data.
I can't say that I'm not a fan, I'm a hater who rolls his eyes off anything built with Electron.
Something like Prey comes to mind:

https://www.preyproject.com/
That's ok, they don't either.
> I find the @ syntax a little distracting.

I guess that's a matter of personal preference. I can imagine arguing for both: the syntactic sugar reduces the number of characters needed and makes dealing with whitespace in the string easier (no " " in between vars). The function version reduces the need to visually parse the whole string every time to learn what forms are inside of it and makes the amount of things you need to keep in your head at one time lower.

Personally, I have nothing against the plain `(string-append ...)` and I probably wouldn't use the extension from the post. I just wanted to show one way to write such an extension. There are very few examples of modifying Racket's reader or readtable because it's unnecessary to get most syntax extensions to work - the arithmetization's post is a great example of this. This is why I gave up (early in the process of writing this post) on finding an example actually useful or needed. I came up with something that is widely understood and missing from normal Racket and used that instead :)
I think your views on police are mostly appicable in the U.S. because the U.S. has (one of) the most militarized police force(s) in the Western world.

Your views do not match my experience in the Netherlands at all. My largest irritation regarding Dutch police is that they seem incapable of helping with bike thefts (even though all bikes have a mandatory unique ID), and sometimes they give you a ticket for carefully biking over pedestrian ways (excellent shortcuts) or for biking without a light.

However, I do think your post contributed to the discussion because the advice seems coherent and accurate for U.S. citizens and anyone planning on visiting there.
Primarily, it sits as its own entry in your task switcher, and can show the number of pending alerts you have. It also uses OS native notifications, though I know that's increasingly possible through the web too.
As the web grew, so did the scale of websites.

Many sites and apps found themselves in a situation where they would gladly trade strong consistency, for more performance and eventual consistency.

Further, schema changes for relational databases with billions of rows have to be very carefully orchestrated to avoid downtime. Databases with more flexible schemas allow schema changes more easily (though obviously the code most accommodate the fluid schemas).

Various NoSQL solutions were developed to fill these needs.

Sure, they were overused for a bit (though that fad has basically passed), but they definitely arose to fill a real need.
If the threat was solely limited to an attack on the baseband that could be valid.
IPv6 means every device can have a globally routable, unique address. Hence bypassing the need for relay or hole punching servers.

On a side note, I don't believe it to be a major problem in this context though.
I used to use linux desktop since 2012(ish) and I remember the time when most of my apps were Windows and Mac only! As a broke university student, I could not afford to upgrade to a Mac just to use some tools!

Electron has made me forget those days! Today, most of the tools I use are available on all platforms and while they do take up a lot more ram and disk space - both are generally things I can buy and fit on my computer and will be supported out of the box but not having those apps won't.

I know it's great to hate Electron because of how much ram and disk space it takes, but for those few on Linux, it's truly made life easy!
Been programming for 30+ years, and 99% of my projects use SQL databases. I've tried and dropped NoSQL many times. I still wake up in a cold sweat thinking about the earliest version of Firebase where I had a project that tried to join three tables together to get some meaningful data.

I still remember the response of a Firebase team member to my forum question about it - "These days, storage and computing power is cheap - just duplicate the child table as nodes in the main table and do it all that way for every parent/child relationship you have. Don't worry that you have to duplicate the same set of data for every parent that is related to the same child...That's how NoSQL works..." <shudder>

Even though I use ORMs in my project these days, every time I have to test a complex query, I write it in raw SQL first and check it before trying to make the ORM duplicate the same query.

Granted, NoSQL has its place and its advantages, but for me, when it comes to "money code", I will stick to SQL.
The relational model provides a pretty general and unified way to represent information, together with a cohesive and powerful set of primitives for working with it, yet many systems architects insist on hiding it behind an ad-hoc interface that looks like a throwback to pre-relational days.
> no schema

Do you read them back? Does your code expect property "X" to be on a "Player" object? Do you put a check everywhere for when it doesn't? Do you have default value for objects that were created before new property was added?

All that work could've been done by your database (which is probably has some kind of JSON implementation anyways), but somehow it's a "no-brainer" to implement data consistency at app-level. Okay.
SEEKING WORK - REMOTE (London, UK)

GitHub: http://github.com/sebinsua

LinkedIn: http://linkedin.com/in/sebinsua

Email: me@sebinsua.com

* * *

Two things...

- If you're just browsing and you run a business, drop me an
email, I'd love to figure out ways that I can add value.

- If you have an idea already I work with most technologies
and can quickly build an MVP/prototype from scratch or
get up-to-speed on a currently-running project.

* * *

I'm an experienced full-stack developer that practices TDD.

I've worked in the following technologies on the server-side (Node.JS, Python, Rust), and on the client-side (JavaScript, React, Swift, ReactNative.) I particularly enjoy doing data visualisation and working within data science teams to expose insights.

Don't hesitate to get in touch if you think I can help you in any way!
We offer both, about 20% subscribe to annual plan.

It's pretty common for SaaS to offer a monthly plan and an annual plan for each tier that is 10 x Monthly cost so users get 2 months free paying annually.
Just from my pov, SQL does not support a document view of data and does not easily support versioning of same and this is a huge problem certainly in complex business systems.
Have to agree with this assessment, just recently tried both of those services in the hunt for a plumber. Everyone I called from HomeAdvisor didn't return my calls or else called to tell me they weren't actually plumbers. Angie's List was a laughable disappointment with only one search result for my entire zip code and a testament to how the pay-walled garden approach just doesn't work.

I finally resorted to asking around in my neighborhood and found a good plumber who was not listed on Google maps or any other online source. Reasoning was obvious: one bad review and your business is shot down forever, the best thing to do is to stay off the radar.
Collaborative Knowledge Foundation – Transforming Knowledge Production
Not sure if intent but this is AMD issue.

Having experienced first hand AMD driver instability on both Windows & Linux, AMD have lost my custom for the next 10 years..

Multiple re-occurring driver crashes using their main graphics card product line(RX380) on Windows 10..
So, pretty mainstream and yet having driver crashing (even when doing non-intensive tasks e.g. web browsing)

For the record, I'm not so sure Nvidia is any more stable either.
The only (constantly) stable graphics provider over the years has been Intel's on-board graphics.
I've raised a $2M Seed and $6M Series A, used Google Sheets for prospect tracking both times. The process was pretty simple: we'd add investors to the list, stack rank them in order of preference, contact them, and then use color coding and a status column to keep track of where they are in the process (BLUE="need intro", YELLOW=contacted, RED=declined, GREEN="term sheet", etc.)
None. My question is what is the advantage of upgrading Intel (quad core) processors every 3-4 years? I bought i7-4770 almost 4 years ago, I couldn't name any single application that is too slow to run on i7-4770 due to its single core performance - the constrain is always the number of cores in a single box.
A typical cheap chinese webcam will have an open telnet port.
For me, I'd just love it if progressive web apps would have a desktop offline install mode that allowed them to deliver notifications, a desktop icon, and a separate window.

I was expecting this to happen after chrome discontinued their "chrome apps", that the underlying tech would come back with progressive web apps, but I haven't seen anything in that space.

I think it would solve the problems with Electron apps (wouldn't have to rebundle the runtime for a massive binary size and massive memory use).

If anyone knows if anything is happening in this space (progressive web app installation for desktop) please let me know.
https://news.ycombinator.com/item?id=14121780 on go ssh security
And what is the use of this when it runs on a platform that is an active target for every intelligence agency in the world with irregular updates, regular security problems and other problems like preinstalled spyware and so on?

Nice idea, but only if the phone was a platform you could trust.
Monitoring with Push vs. Pull: InfluxDB Adds Pull Support with Kapacitor
There is probably a correlation between IoT devices that get pwned and IoT devices that use Telnet.
Show me your well structured code and well named unit tests and I won't need your flow charts.

Show me your well defined normalized tables and I have all I need.

But for the love of $entity please don't show me tons of business logic in stored procedures. I actually won't work for a company that expects me to build or maintain a product based on stored procs.
Best C# Programming Books for Beginners 2017
I can't speak for the New York Yankees, but the 'Galacticos' policy of Fiorentino Perez, where Real Madrid would try to sign one expensive, world-famous footballer every year, is widely considered to have been a failure despite initial success - partly because of a lack of interest in signing defensive players (they didn't want to pay Makelele's salary despite it being relatively low), locker room egos, and constant interference from the Club President over hiring.

To throw another example on the list, the New England Patriots are 30/33 for salary money spent. The Miami Dolphins are 5th. Spending big money for rockstars is neither necessary nor sufficient.

http://www.cbssports.com/nfl/news/look-nflpa-salary-cap-char...
I had assumed Facebook started off with MySQL and now is NoSQL but that was just ignorant of me:

Zuckerberg may have had to rely on a typical LAMP stack but FB's newer user-facing features still use SQL. For example, the Timeline feature released in 2012 was built on MySQL/InnoDB: https://www.facebook.com/note.php?note_id=10150468255628920

And last year Facebook released MyRocks, which is a space/write optimized replacement for InnoDB, and is being used for their "user database tier" https://code.facebook.com/posts/190251048047090/myrocks-a-sp...

I guess the things I've read about FB using NoSQL [1] is for other parts of their infrastructure, particularly Messages. It sounds like they had considered using MySQL, even though Cassandra was built for the Inbox feature. They ended up building a new system for Messages [2].

Now that I've spent a little time in that rabbit hole, it looks like one answer to your question is Facebook's Inbox Search, which used MySQL originally to store inbox data (7TB for over 100M users, which seems laughably small with respect to Facebook's scale today):

http://docs.datastax.com/en/articles/cassandra/cassandrathen...

> Before launching the Inbox Search application we had to index 7TB of inbox data for over 100M users, then stored in our MySQL[1] infrastructure, and load it into the Cassandra system. The whole process involved running Map/Reduce[7] jobs against the MySQL data files, indexing them and then storing the reverse-index in Cassandra. The M/R process actually behaves as the client of Cassandra. We exposed some background channels for the M/R process to aggregate the reverse index per user and send over the serialized data over to the Cassandra instance, to avoid the serialization/deserialization overhead. This way the Cassandra instance is only bottlenecked by network bandwidth.

The acknowledgments section makes it more clear that the MySQL data was indeed migrated over to Cassandra:

> Cassandra system has benefited greatly from feedback from many individuals within Facebook. In addition we thank Karthik Ranganathan who indexed all the existing data in MySQL and moved it into Cassandra for our first production deployment.

[1] https://news.ycombinator.com/item?id=7891316

[2] https://www.facebook.com/notes/facebook-engineering/the-unde...
"Say this movie took place 200 years from now -- I’d give it a chance," he said. "100 years ahead? Maybe. 50 years ahead? I’m a little hesitant to say TARS and CASE would be at that ability 50 years from now. It’s just not there. There’s too much to do, and there’s not enough money being put into it to see that that kind of engineering is going to come forward. It’s all about the money, you know?"

http://www.mtv.com/news/1996022/interstellar-tars-robot/

After reading this article, i know it will cost A LOT to build a robot like TARS, but what about the level of AI of TARS?
I think most developpers using SQL use it a bit like most office users using VBA (ie they know how to record VBA macros but not much more). Most developers know how to write basic queries so have a very superficial understanding but most likely know very little about the performance implications, structured indexes, nesting of queries, etc. Whereas I would expect developpers who claim to use C to have more than a superficial understanding of the language.
Though fairly decent, FaceTime gets shaky with what seems like just slightly sub-optimal network conditions.
That web runtime doesn't ensure that people have the same experience. You're still relying on the abstractions of that runtime. Plus that there haven't been any changes to it.
(Building desktop apps in native languages since a lot of time.)

While I haven't use Electron, it looks very enticing. In particular the HTML/CSS combination allows to build UIs very fast. WebGL abstracts away the graphics drivers problems (at least in theory?). 2D Canvas is optimized and looking nice.
And being non-native shorten the iteration times.
Particularly for games it looks very adequate.

Users surely care about download size but not as much as functionality.
I'd be wary of taking HN's opinion as gospel unless your target market is HN users.

I don't like Electron apps particularly, but I understand why people make them. I think that if your desktop app is "the thing" you're making then you should avoid Electron if possible, as it does provide an experience that's subpar. But if your desktop app is just a convenience offering for your product that lives mostly on the web, I think it's fine to use it.

(there are exceptions like VS code, but they're very finely tuned compared to the average Electron app)
An interactive map of over 1,600 investor relationships in NYC tech
https://en.wikipedia.org/wiki/Lego#Manufacturing

The moulds are permitted a tolerance of up to two micrometres, to ensure the bricks remain connected.
NIGERIANS WORKERS ARE TIRED OF NIGERIAN GOVERNMENT OVER MINIMUM WAGE
I've never tried it, but I hear good things about Kivy [1]

[1] https://kivy.org/#home
Shipamax (YC W17)| London | ONSITE

Shipamax develops software for bulk shipping companies to
manage their business. Booking a ship is currently done manually using pen, paper, phone and email. It can take 2+ weeks to book a ship. Shipamax uses AI and machine learning to help shipowners and brokers streamline their processes.

Software Engineer (backend focus)

Senior Software Engineer (backend focus)

Data Scientist / NLP specialist

more here: https://angel.co/shipamax
Cost is not the only factor leading users to Android. And cost certainly isn't driving users to Google's Pixel phones - they are priced similarly to iPhones.
I don't understand... What does it do that's better or different from youtube?