skysight-inc/HackerNews huggingface dataset:
> If the parent entities never have their primary key values changed and are never deleted, then the database engine itself will never use the index to enforce the key.

Enforcing referential integrity is not the only thing we can do with foreign keys. Once you have an FK, you're going to want to query against it. To do that without data races requires a join. The join can be optimized better if the FK is indexed.

Come up with an example of an FK you never want to join on and then maybe we talk about not wanting an FK indexed. I've never seen anyone make a convincing argument that this is even as much as a 1% case. It should be so incredibly, almost inconceivably rare to not want an FK indexed that yes, I'm saying it should go against the traditional grain and just be the default. Traditions are not sacred.
I set up a new machine a couple of days ago. Looked for neovim in FreeBSD ports. It wasn't there. Shrugged and installed vim.

I'd happily have switched if only for the code quality reputation. But it needs to be easy - no, that's too weak a word, it needs to be trivial - to install in the usual way I install things.
It looks like $49.99 unties it.
Absolutely. Relational databases are so useful that I happily use SQL even though it is not a very good language. I have thought about making a "compile-to-SQL" language in the same vein as Typescript. (Does this already exist? You would think so, but I can't find one.)

HTSQL has some great examples of where SQL could be better: http://htsql.org/doc/overview.html#why-not-sql. I would love to get that goodness in a language not tied to the rest of HTSQL.
25%-50% of the market? Where do you find them? I've never seen a programmer unable to write at least a fizzbuzz.
With the GUI toolkits its the other way around. And the beans you meant are "visual beans" (`java.awt.Component`).
> That's a feature of the references, not of objects.

That doesn't seem like an unreasonable way to draw the lines.

> The sharing and overlapping of data slots is however an inherent feature of closures.

Is it? When defining a lambda in C++ you can choose for things to be captured by copy rather than reference. I agree with saying that a function that captures nothing is "not a closure", but I don't know that I'd say the same about something that captures only by copy. Would you say that a language that only supported capture-by-copy "lacks closures"?
Escape analysis is also static and deterministic (which doesn't mean that changes to the code can't cause the optimization to stop happening without warning, but the same is true of retain/release elision).
Is there any work on a successor to SQL (just the language, maybe as an optional frontend)? I am not a fan of SQL, it works great for simple queries, but fails (in my opinion) for more complicated ones. They get way to complicated and hard to understand for something that would be easy in other languages. This is not a critique of relational databases, only the language.
"NoSQL" databases existed before SQL. For example, look at multivalue databases like Pick/D3, or the sparse map like persistent data storage structures of MUMP. We had plain text databases, key value storage, hierarchical databases or multivalue databases before we had relational ones.

Actually, pre-RDBMS those were the dominant systems. The concepts invented from RDBMS were the new kid on the block that was hot and cool and more powerful that supplanted the original "NoSQL" system and had remained dominant until we hit "Internet scale" and people wanted to 1) scale to huge data volumes requiring distributed databases and processing cheaply and 2) wanted to return to finding alternatives to the dominating SQL platforms.
My goal is to hopefully cut down on that number. I hope you'll like all the songs. But if you don't like it you can always try tomorrow. That's the fun :)
You do realize most of the people running big corporations came out of elite business schools? I like the ideal. My entire point was that universities are responding to market pressures so at least we agree that is happening.
Wasn't the who is hiring thread yesterday?
I don't think HP, but Oracle is definitely plausible in my view.
Somebody should buy a television ad for them: "Feeling tired?
Ask your doctor if Docker is right for you". Include an actor in a lab coat, with a quote from the CEO saying "Docker is being used to cure diseases".
I think the "we run a buisiness, not a school" could be the answer to this guy's dilemma. Hiring diamonds in the rough and cultivating talent relentlessly is how the best engineers were found and kept in my limited experience at Apple, and it seems Google has an even stronger internal education culture.
AWS down?
http://aws.console.com/ shows
"Site Temporarily Closed

For further information please contact the webmaster."

Everything we host in North Virginia is down. Ireland is fine. We are located in N Europe..
Network Performance Issues in multiple locations
I agree with your take, many will not see improved security as a benefit but will instead resent the limited functionality. This is nothing more than a rebranded Windows RT which already failed in the market with the Surface RT. IMO this laptop will also fail, regardless of whatever hardware they pair it with
As an emacs user, I would love if its lisp interpreter were sped up or replaced with something faster. There's a lot of computationally expensive stuff written in elisp. Even for text editing, it can be laggy when parsing large files of source code for IDE purposes.
> most libraries use random order

Most libraries use an undefined order. This is not the same as random.
My biggest lesson in product strategy from operating and selling URX (YC S13)
In reasonably sized datasets, you'll also find a lot of spurious correlations simply by chance. That's one reason in science you're supposed to write down your hypothesis and methods of analyzing data before touching the data. Otherwise you risk finding some random noise and thinking it's important.
This thread exploded after I went to sleep. Apologies for the silence and again a huge thanks to everyone else in the thread.

It is possible to craft a sudoku that has a unique solution without having any forced moves at the beginning. Turns out most are not actually hard, but it is doable. When I get back near my book at home, I an post an example, if folks are interested.
Which university is that? It died at ours already a few months ago :(
Answering Your Climate Questions
I'm interested in neovim as well and I think you're asking a legitimate question. I would also add that if neovim is developer-friendly(er?) then that could also be a reason.
Transcelestial Technologies http://transcelestial.com | Singapore | Full Time | Onsite | Visa Covered

Transcelestial is re-imagining communications technology for the 21st century by creating the first ever, super fast space laser network which uses a constellation of nano satellites. Our network will transfer data 1000x faster than current radio wave technology for terrestrial, satellite and deep space applications.

We are part of the inaugural batch of Entrepreneur First in Singapore, working under the patronage of SGInnovate. We have an incredibly fun and ambitious team who are looking for extremely motivated engineers and researchers. Our office is located in the heart of the business district, with a stone's throw away from the best pubs in town. We love people who challenge the status quo and show extreme grit and persistance.

Join us, if you find space exciting, and define the rules for how our civilization grows and communicates!

-- Machine Vision Role: https://angel.co/transcelestial-technologies/jobs/234904-mac...

-- Embedded Hardware Engineer: https://angel.co/transcelestial-technologies/jobs/234900-emb...

or email directly [team {at} transcelestial.com]
Global transit issues it appears, not AWS specific.
I agree very much. Just came to say that this has always been the case with the know-how of starting fires, metal molding, forging tools and weapons, inventing microscopy, large scale industrial processes, computers... software is the extension of the exponential acceleration of abstraction and reuse that our society was built on.
Unfuddle.com Security Breach
> This is a company we're talking about here, not an individual

I'm not saying pull punches, I'm just saying maybe remember that we aren't talking about a faceless politician here, and that to many, Solomon is someone they've interacted with, and likely in a positive way.

Referring to the guidelines, I'm imploring us to "be civil" and "avoid gratuitous negativity".

> I appreciate [etc]

Thanks. :-)
Sounds like actors, not objects.
Major routing issues on the Internet
The problem with this 10X myth is that no one ever defines X. Lines of code? Inverse of defects found? Delivering in 1/10 of estimates? There is no definitive way to measure the end result of what people develop and any of these values can be gamed. Clearly there are major differences between programmers but turning it into math is not really possible.
Defcon 20 - Dan Tentler - "Drinking from the caffeine firehose we know as shodan"

https://www.youtube.com/watch?v=5cWck_xcH64

Warning - watching this may readjust your faith in humanity. Telnet is just the tip of the iceberg.

edit: (15:42) "Econolite [stoplights] listening on telnet. There are intersections [with] stoplights; you can telnet into them and put them in 'test mode'[sic], and the warning says, 'Don't do this, you could kill people!'"
Ethereum is the AWS of Blockchains
Because progress comes after many dead ends.
I'd imagine the majority of sports have a fairly loose correlation between money spent and winning due to (a) limited sample size leading to high variance (even with a superior player selection strategy), (b) limited number of games played (though baseball does better than other sports here), and (c) games consisting of more dependent than independent events (leading to low chance events having cascading repurcussions).

At least in MLB, 40 multi-year players isn't that large a sample!
"attention" sounds like "ä Tänn-schen" in German, which is Saxony dialect for "a small fir".
This doesn't make much sense to me. I think the answer is just lack of experience.

"noSQL" should be read as "not-only sql" and I think sql in this acronym should be interpreted as "relational databases". I think the relational model is convenient for a lot of purposes but at some point (maybe ~10 years ago) some companies where trying to use it for everything even when those things didn't actually fit in that model. So, "noSQL" for me actually means "alternatives" for different kinds of data time-series, graph, key-value, documents, etc. with redis, neo4j, graphite, mongodb, etc.

What I would like to see in the future is some ecosystem based on small pluggable modules that you can use to build the embedded store for a micro-services. Instead of using a full-feature database system (relational or not) you assemble your store like Legos with only the stuff you need. Something like this https://github.com/level/levelup/wiki/Modules
inccommand is one of the coolest features I've seen. I haven't made the switch to nvim yet, but this is high up on the reasons to do so for me.

https://www.youtube.com/watch?v=dY9dME3l-iQ
They're now demoing the Surface Laptop. Thinner than a MacBook Air. Faster than a MacBook Pro. Longer battery life than either.

The downside? "Windows 10 S", which only runs apps from the Windows Store. The upside over Windows RT from the Windows 8 era? You can port Win32 apps to the Store today, don't think you could back then.

Edit: You can upgrade Windows 10 S to ordinary Windows 10 Pro for $50. Laptops that run Windows S from other manufacturers will start at $189.
I'd love to see neovim embedded in Firefox, and have it be just a standard part of every text field. Having a seperate editor window pop up as with the It's All Text extension is just not the same.

It'd also be great if there was a way to have neovim "wrap" arbitrary shell commands, kind of like rlwrap[1] does, only with full vim editing features available instead of the relatively crippled readline.

[1] - http://utopia.knoware.nl/~hlub/uck/rlwrap/
To your original point, they do not consider these "backtracking" in the standard sense. So, I'd actually agree to your original point and that I was wrong.

I should also have stressed harder that I agreed with your definition of brute force. I was just offering an explanation for where I think the post went awry.
How far away is earth's horizon? [pdf]
SQL is a declarative reactive language. There's something to gain by adding functions as first-class objects, but I don't think rethinking it from functional foundations would help. Lambda calculus is focused on data processing, and a query language must be focused on data searching, those are completely different applications.

But I do completely agree with the pain points you pointed there. I'd go further on the first point, client software should have an easy way to check its guarantees at connection time too.
I just saw this as well. Got a downtime alert, but app seems to be working from my location.
He called himself a "EE' -> 'excellent engineer'.

That being said I could see how having these boards who define the standards could make a berror preventing people from some backgrounds from being able to get a job.
My money, in this case, is something like Akamai Kona or Shape Security, that does bot blocking. Comparing user-agent against known header order for that specific user-agent sounds like something they would do.
You and the parent are not using quite the same definition of "types", I think.
Technology moves in cycles. We went through this back in 90s and 2000s with Flash, Dreamweaver, ActiveX, Ruby, PHP, and etc.

I suspect we'll see us going from Electron > React-Native or identical and then realizing the benefits of native stuff and back to native code once MS/Apple/other OS try to replicate the ease development process with their languages like Swift, C#, Go, and etc.
Not OP, but I find the syntax to be arcane and bizzarely restrictive. Every query has to be SELECT FROM JOIN WHERE GROUP BY HAVING ORDER BY; for some reason the table comes after its fields and the ORDER BY can't be expressed using field aliases defined at the start of the query.

Instead, I've been toying with the idea of a language where queries are expressed as a pipeline of operations on result sets, like this:

FROM employee
/* result set: all employees */
LEFT JOIN department ON employee.DepartmentID = department.DepartmentID
/* result set: all employees + their department */
ORDER BY employee.last
/* result set: all employees + their department, sorted */
WHERE department.name IN ('Sales', 'Engineering')
/* result set: Sales and Engineering employees + their department, sorted */
FIELDS employee.first, employee.last, department.name
/* result set: Sales and Engineering employees' first, last, and department names, sorted */

This is a SELECT, but you can for example turn it into an update just by adding a clause to the end:

UPDATE employee.salary = employee.salary * 1.05

This is a much more regular language; there's nothing enforcing you to write these operations in a certain order, and you can add or remove clauses as necessary. For complex queries, I find that I write in this style anyway, using a chain of WITH clauses as a pipeline with a final SELECT on the end to get the results.
Louisiana DA's Used Fake Subpoenas to Trick People into Talking to Prosecutors
Embracing Mastery
Python Seaborn Tutorial (Gotta Catch 'Em All)
Hey I have a question for you. I would like help writing an extensive business plan, since VC's have asked for one.

I've found a qualified consultant who already did work for me and would be willing to do this on a deferred basis. Can I include this expense in your opinion? It's under 6k usd but would have to be paid out of the budget. The person said that someone they asked said VC's don't like to pay for any past expenses.

thanks for an opinion.
Everything runs on written signed letters and the post.

If you have relevant insight, why is that? Digitization makes most information-oriented work easier and it stands to reason this would be true for law as well.
Investors betting 3DR can find life after Solo as a drone data platform
Yes, I think that's exactly the insight that underlies this article, and that's why I think it makes sense. Unguided "exploration" coupled with large datasets leads wasting time on finding nonsense.

That doesn't mean flexibility in a tool isn't warranted - it's just that such flexibility should have a goal, and people should be discouraged from aimlessly applying it and then claiming they found something important.

(Also "exploration" is kind of a weasel word for student assignment; you can call your half-assed project "exploratory" and spin a good story from it that will give you a grade without any real work on your part.)
FWIW, Cloudflare is betting on Cap'n Proto, and Cloudflare is pretty big too.
Or sometimes you can't accept it.

Yesterday who is hiring made me sort of depressed, I am in desperate need for work, yet all work I was qualified for was non remote in other countries, or semi remote, the few ones that allowed real remote required some random citizenship I don't have.

Seemly being born in the wrong place can heavily cripple a career.
To be clear, though, you're talking more about the Relational Model than SQL per se.
10x the worst literally means nothing at all if you find a sufficiently bad programmer you can have an infinity times programmer and the 10x developer as it is normally expressed is 10x average.

Further author even punts at the end of article by claiming that its not needed to measure difficult to measure things as we can instead reason our way to the right answer which is practically nonsensical. Measuring is step one in actually reasoning about things.

In short author may be a good developer but he is certainly not a 10x author.
I think the public is largely aware of the difference since housing prices are often reported using the median. Intuitively, everyone knows that median housing price is the price of a 'regular' (most frequently sold) house in a given area.
Thanks! I'll give this a try.
I would be very careful of that advice. There are many ideologies that use that exact thought process as a justification for divisiveness and intolerance, especially in an echo chamber like Facebook.

Is there another side to the argument? Have you investigated it? Is the constraint or division unjustifiable? Who/what is being excluded in that argument? Many patents and anything politically correct fail that test. Eg, do we need a "women in engineering"* or should that be "people in engineering"? If you have "women in engineering" (because of percentages), do you have "men in veterinary science" because of percentages too? You see? Feelings may tell you one thing, but considering divisiveness, exclusion and an opposite view tell you something entirely different.

If people asked that last question more often, the world would be a much better place. Leaving the criteria as a logical reasoning rather than a feeling would eliminate a lot of prejudice, intolerance, division and constraint.

* I'm married to a qualified and practising engineer. We discussed this topic when she went to a "women in engineering" meeting. When I asked if we should hold a "black people in engineering" meeting, she said "of course not, why would we?". Now we agree on the divisiveness/exclusion test as well as the inclusiveness test. Be warned, my views are not popular.
Here's a thought experiment for all Singularitarians.

If a modern-day Music Man appeared in your town with virtual everlasting life in a box, and all the miraculous brain-uploading equipment attached, then started selling tickets and "uploading" your neighbors... how would you be able to tell whether he's actually migrating their consciousnesses, or just using a deep network to train simulations of their minds inside the virtual world while concurrently euthanizing them?
,not a 10x developer, a 1/10x developer
For lots of use cases, four cores probably saturate the memory bus. But, yes, Intel does try to protect the Xeon brand and core count is probably part of that story.
Why not be secretive? We have seen how all those people who are dealing in fake age extension shout and ballyhoo their stuff - and how they are razzed and discounted.
As they say "Speak softly and carry a big stick; you will go far."
> I would have described SQL as statically typed because columns are given a type when created.

The biggest problem is that SQL has no well defined "compile time". For all practical purposes, it's always an interpreted language. I can't check my code against the production database without running it.

> You don't need to specify the table name for each column if you're only querying one table.

I do think the GP was about doing stuff like that:

SELECT * FROM function_that_returns_table();
Wow - they advise employees to remove all company data from devices, leave the company 1password account, disable touch ID, and put their attorney on speed dial every time they go through customs.
It appeared to mostly resolve itself after 15 minutes but we're still seeing reduced req/m

https://imgur.com/a/JAQ5B
Well, why wait. I made a repo for "Electrino":

https://github.com/pojala/electrino

Sorry, it's totally empty! But I'm hoping to get around to making a Cocoa+WebKit proof-of-concept this week. I guess the starting point would be to implement just enough APIs to be able to run the main.js example from this Electron tutorial:

https://github.com/electron/electron/blob/master/docs/tutori...
Microsoft Surface Laptop: Price, Specs, Availability
That's true, and a lot of effort is being poured into it.

I hope that this activity is being sponsored by victims of botnets or their governments to reduce malicious infections, since the Internet of $#!^ has no incentive. This may be the best case scenario.

You describe the worst case scenario. I hope you're wrong, but only time will tell.
Aha, always start hating my alarm clock music, no matter how much I liked it before. Hopefully this will counteract that.
Voix off
1. Each leaf node is a fixed size block that contains compressed values and timestamps. 1000 values is just an example, number of values in one leaf node is variable.

2. Because there is a lot of data-structures. I'm using tree per series. The database can simply store hundreds of thousends of series. Creating WAL per series is not feasible.

3. It maintains a list of roots.

4. One I/O operation per node. You will fetch a leaf node for every ~1000 data points and a superblock for every 32 leaf nodes. It's not as bad as it sounds because you will read data for one series only. To span over 4 levels the series should contain tens of millions of points.

5. Yes. You will need a beefy machine for this with a lot of RAM.

6. Random reads are fast on modern SSDs. It's optimized for SSD (I simply don't have a computer with HDD).

7. It stores only composable aggregations - min, max, count, sum, min/max timestamps.

8. All series names is stored in memory. During the query time this memory is scanned using regexp to find relevant series names and they ids. This is a kind of a temporary solution. It works good enough for the datasets with small cardinality (around 100K series).
Kuberetes pods lifecycle
"Addicted to professional sports" is a poor way to describe the situation of ESPN.

If I want to watch professional sports I use my OTA antenna and I get ABC, CBS, NBC, Fox in beautiful HD. Between the big 4 networks and some others that broadcast sports, you can usually find something really good on any given weekend.

ESPN might add another game or two at peak times, but most of the time ESPN is playing sports hilights, lowlights, or gossip. If you really wanted to pay money to watch games, you might rather get regional sports networks: for instance, if you are a New Yorker you probably want to watch the Yankees or the Red Bulls and that would mean YES or MSG, not ESPN.