skysight-inc/HackerNews huggingface dataset:
For version control, I put .sql files right alongside my other source code, and check them in. I might try snippets out interactively, but after a statement grows so long that it wraps a couple of times, I usually move it to a text file and edit from there. I run it in psql with the \i command:

psql> \i test.sql

Usually I have one terminal window for the text file opened in vim, and another window for psql where all I do is keep running "\i test.sql".

When the code is polished and ready to go live, I turn it into a view or function and move it into a permanent file (views.sql, functions.sql, ddl.sql, make.sql, or whatever you want to call it). This file can be run as many times as I want, idempotently. This is because it starts off dropping all the views or functions that it later defines. You can try instead saying "CREATE OR REPLACE . . ." but PostgreSQL only lets you replace a view or function if its outer appearance stays the same (for views, the output columns can't change; for functions, the input and output can't change). So I find it simpler to just drop all of them ("DROP TABLE foo IF EXISTS...") and then create them (You usually have to drop them in the opposite order you create them, if any depend on one another). I wrap the whole file with BEGIN and COMMIT, so if there is any error the whole thing aborts. Actually I wrap it in BEGIN and ROLLBACK, and run it to see if there are any errors. Only when it's solid, polished, and error-free do I temporarily change ROLLBACK to COMMIT, run it, and immediately change it back to ROLLBACK. The file that gets checked into version control ends in ROLLBACK, for safety.

Later if I want to change something, I always do it first by editing the .sql file and then running it from psql. Then I check the changed file into version control.

---

For views and functions this is easy, because they don't keep their own data. You can drop and recreate them at any time. For tables, it's a little more complicated. You can't just drop and recreate them, or you'll lose all your data. So for tables I keep their definitions in a separate file. I run this file at an app's inception but seldom afterward. If I need to make a change to a table, I do it interactively, in the command-line tool ("ALTER TABLE foo ADD COLUMN blah ..."). Then I will probably edit the tables.sql file to reflect the change, just so it's in version control. But it's up to you. You can always pull the table definition from Postgres with the pg_dump command.
I hope there will be a lesson that a steady business or being conservative is often a good thing. It seems there is a lot of pressure to grow until the only way for growing more is to take on a lot of risk or doing unethical things.
Lorenz's Deterministic Nonperiodic Flow is the earliest work on the topic that I can think of. It's relatively accessible too.

http://journals.ametsoc.org/doi/abs/10.1175/1520-0469(1963)0...
The internet decided the keyboard is terrible. Did you miss that memo?

...I actually really like it too.
Splunk, Geoserver and Wordpress deploy in just 7 minutes on Jelastic cloud
At the very bottom is did say "Reported to MSRC" with a copy of the email.
> Skimming the list briefly

I was surprised to see CounterPunch on the PropOrNot list. One of my favorite authors from the 2000s, Werther, wrote for CounterPunch.

http://www.counterpunch.org/author/werther/

However, I haven't read CP in a long time and skimming articles mentioning Russia, PropOrNot may have a point.
The end game is that you have a product market fit figured out and then you go public. Pretty much the opposite of what Twitter did.
Yes, but in principle the computing for the fracking could have been done with the computers 40+ years old.

Yes, but, e.g., CD/DVDs are also terrific because of how the lasers are used to read/write the disks. So, CD/DVDs are amazing even without the connection with computing. So, the computing is not the whole story. IMHO, similarly for the other examples I gave.
I just tried out Defold engine and it was super easy to get started with and well documented.
>>The edges are very sharp

Just curious, have you used Mac laptops previously? Because sharp edges are something that have existed since the original MacBook Air.

I do agree they are annoying though. I always have outlines on my wrists after using my laptop on my lap for a while.
Related: http://www.alphasheets.com
Have you tried SpriteKit? I chose SpriteKit with Swift for my first game and like it quite a lot, but I keep wondering if it was a good choice to limit myself to iOS.

What I'm interested in mostly is if I at least got a significant performance gain from chosing SpriteKit over Unity.
Rent control still leaves people who want apartments without them, it simply changes the allocation strategy from "willing to pay market price" to "was here first" or, in the case of designated affordable housing, lottery.

Increasing density limits, or improving transportation to allow wider sprawl, actually add housing supply in a way that might keep up with demand.
Part of the answer is that the App Store review process checks for sufficient text size. Web pages aren't subject to this process, and so are more likely to have overly small text. Certainly that's been my experience as a user.
Someone please tell 2017 it's not a competition.
> In other words, exactly like the early days of usb-micro/mini?

Overall worse, because USB-C may also be used for other connections (eg DisplayPort), adding to the confusion.

Plus all the different cables which can do different things and not support specific profiles of some things and others but they all have the same connectors. Confusing as heck.
Wholeheartedly agree with you.
I consider myself to be on the left, in the classical sense, but the political discourse of the United States does not tolerate multi-faceted and nuanced opinions about the issues.

The groupthink is prevalent on both sides of the aisle - you're either on my team or you're on the other. What sucks is when you're ostracized from both.
That was as Reddit a comment as they get, but a good one.
Ethical guide to smarter tech gifts
The support library regresssions, oh god, this +1000000. It appears that the prevailing attitude is release first, then maybe fix based on developer complaints.

Then there is the mess of manufacturer bugs, but that isn't strictly google's fault.
Germany bring always nazis in my mind. I wonder why. Lol. History start repeating on very tight loop and people's "rights" are pushed again. Big thanks to data collection NSA friends Facebook, Google & Twitter.
Why is it pointless? There is never too many cpus
And how is this totalitarian?
it was unanimous approval of a panel of just five people...

Needless to say, you'll find other economists all across the political spectrum that think it's a jaw-droppingly awful policy prescription, rivalled only by the idea of replacing all income taxes with a consumption tax, which was also favoured by the five economists on the panel.
We detached this flagged subthread from https://news.ycombinator.com/item?id=13042192.
That's satire, almost by definition (as opposed to other kinds of humor).
Do we know what policies are genuinely effective at improving housing affordability? This is the one biggest thing the (proverbial?) middle class have been struggling to make gains on over the last generation in a lot of otherwise successful places.
This is not entirely accurate. If the median rent drops, this means necessarily that the rent for at least some portion of the renters below the 50th percentile has dropped. So while it is possible that the very bottom hasn't changed much, the middle/top of bottom necessarily has.
It's also worth bearing in mind that America, the godfather of capitalism, have just had their crazy election. People were saying they as a nation had been left behind due to globalization. Isn't the capitalist market supposed to self regulate and spread the wealth? If US citizens are feeling left behind, how exactly are other nations supposed to feel when western nations "come to liberate them and give them democracy"?
> The newest member nearly always ended up at the bottom of the social order and became "chronically stressed", received less grooming and more harassment from the other monkeys.

> A detailed analysis of the monkeys' blood showed 1,600 differences in the activity levels of genes involved in running the immune system between those at the top and bottom.

Could it be that the grooming procedure itself helps with the immune system? For example, cats will often lick their fur, which could bring in small quantities of pathogens to help build an immunity. If something similar happens with the monkeys, the result might not generalize to humans.

> Dr Snyder-Mackler said: "Status is always relative, but if we could flatten the slope so the differences between the highest and lowest weren't as much, or find ways to focus attention on lower social environments so they are not as 'crappy' we could mediate some of those consequences.

It's fine for the doctor to have his own political philosophy and motivations to do this study, but I would wait for a biologist to do a more careful analysis of why those genes are being activated before using this to justify any political action.

Certainly, if every conceivable biological variable except for feeling like you're at the bottom is accounted for and the effect remains, that would be a very interesting result.
Yet $1600 is still absurdly high for such a simple living space.
San Francisco is building, like they always have. They are building luxury condos. Condos that only the wealthy can afford. An outside econonomist, would claim the supply is widening.

As someone who works on these luxury condos, as a union electrician, these condos are only bought by the very rich. Many units are second, third, tenth homes the 1 percent buy, and many times left vacant. San Francisco can be a charming city if you have money. I arrive at the job site at 8 a.m.
I gaze into units I once worked on, and so many are vacant. Yes, there's always a naked woman putting on a show. It's San Fransisco. Not a lot of straight single guys. Women don't realize just how invisible they will be when they move here. It's hard not to notice the attractive woman in the buff, putting on a show, but honestly; the empty units bother me.

I haven't worked on a reasonably priced apartment complex-- ever.

I have no idea why the market in San Francisco is "softening".

I have a feeling tech workers are being let go? That gold rush feeling is dying. I don't have numbers-- just have a hunch. It almost feels like a lot of start-ups are spending their last bit of money; hoping for a hail marry?

I don't blame developers for building these luxury condos. There's just no way to make a healthy ROI in San Francisco. It's just too small. The workers who put up these buildings are paid $100/hr, in most cases. It's all Union work. San Francisco is a union city. Tech workers should take notice. You guys are expendable, exotically once you hit your Kate thirties. Even though a local 6 Union electrician makes over $100/hr; there's no way I could buy in SF.

And after all; we all love Capitalism? Let them build their cocoons. Let them build to the stars. Let them build into the sand with friction piles.(Millenial sink hole). Build out into the bay--who cares?

It's all working out so great for service workers; and 95% of tech workers are basically service workers. Some of you like to think otherwise, but when the boom slows, I see you guys going home real fast. The only guys I see sticking around are usually founders(they always seem to have a rich relative though), or guys who met a woman with rent controlled housing. Just don't piss her off.
That pl/ruby embedding is unmaintained for years and doesn't currently build.

To me the most interesting current extension language is javascript, via PL/v8: http://pgxn.org/dist/plv8/doc/plv8.html - now you can have isomorphic code at all three tiers of your web stack.
We detached this subthread from https://news.ycombinator.com/item?id=13046582 and marked it off-topic.
Nice pointer. And in particular, Figure 2 of the paper you linked, which shows the simple "Lorenz System" orbiting about a state C for a long time, and then transitioning (at a hard-to-predict time) to a far-away state C'.
I am as concerned about climate change as anyone. I think it's the most serious problem we face today. But it is very important to keep some perspective here, if for no other reason, so that we who believe this is a serious problem don't lose credibility in the political battles to come.

1. Earth is not going to become Venus. The surface of Venus is hot enough to melt lead, hot enough to completely sterilize the planet. That is not going to happen here even under an absolute worst-case scenario.

2. Homo sapiens is almost certainly not going to go extinct even in a worst-case scenario. We are a very robust species capable of adapting to an extraordinarily wide variety of situations. We are very, very tough to kill en masse. We ourselves have tried to wipe out segments of our own population in the past and barely made a dent. The biggest killer in our history, bubonic plague, barely killed a third of us.

3. What is at risk, and what IMHO is worrisome, is the modern technological civilization we have built for ourselves. Our infrastructure and political systems are highly dependent on a stable climate. If we lose that, would could easily go back to the middle ages. (We probably won't go back to neolithic times because knowledge is also pretty robust, and we will almost certainly be able to keep basic technologies alive. But a Mad-Max type scenario is a real possibility.)

4. Colonizing the moon or other planets won't save us. All extra-terrestrial environments accessible to use with current technology are much harsher than earth will be even in a worst-case scenario. If we and our civilization can't survive here, we can't survive anywhere.
I tried to get back into PhoneGap after a two year absence. This was after the PhoneGap/Cordova split and it seemed to me like the entire ecosystem was in smoldering ruins.

Figuring out if you need to use either the PhoneGap or the Cordova binaries, and then finding correct documentation for the respective forks, was in itself a big hassle. But no more than trying to get the toolchain up and running. Holy backflipping cow was that a nightmare. I have managed to repress the details but it was something with installing NPM and then typing in magic commands and hoping some byzantine series of effects would occur correctly, which they never did.

I somehow managed to hack and slash the platform into a working configuration, only to discover that performance (for games) was still far from adequate. I'm sure it has its (non-game) uses, but the developer experience was probably the worst I have ever experienced.
I'm talking about the UWP/XAML/DirectComposition world, which admittedly is not game-related.
That, and swiss army chainsaw.
Android 7.0 Nougat on PC
The issue being that renting in the city effectively becomes a lottery, because not everyone can live there that wants to.
> I agree that their tweets, as presented by The Intercept, are disturbing.

I went straight to the source (https://twitter.com/propornot). I found this tweet vaguely interesting:

Pretty much anybody hating on Soros is echoing Russian propaganda. It's a good rule of thumb. http://ind.pn/2g5wcC3

I'm a leftist myself and admirer of Soros, but saying 'hating' on him is tantamount to being a 'useful idiot' is rubbish. They spend a lot of time defending Soros...hmmmm

For an independent team of concerned American citizens with a wide range of backgrounds and expertise, including professional experience in computer science, statistics, public policy, and national security affairs, they sound anything but professional.
Hello,

I work on lms and we are preparing a new version where Rep is implemented as a typeclass instead of a monad. It's much more pleasant because you manipulate IR.Int and scala.Int. So with the proper import you actually handle IR.Int so you're staged code is no different than a normal code.
I have another example of this sort of thing that I came across recently.

There is much talk here in New Zealand, as there is in the US, about the possibility of a Universal Basic Income.

Looking it up, I found a relatively short investigation into the idea commissioned by the government back in 2010[1], that has more real statistics and conclusions than all the other talk I've ever seen put together.

What you call "high-value" writing still, of course, has the possibility of errors, bias, etc. But man is it still more informative to read than everything else.

Of course the punishment for reading this stuff is the pain of living in a world full of people commenting who "didn't read the article." :p

[1] Available here: http://igps.victoria.ac.nz/WelfareWorkingGroup/Downloads/Wor...
I'm with millstone. I've never had that issue with an actual app.

Maybe that's because of app review, maybe it's the system defaults, it just isn't an issue.

I don't think I ever had an issue with a webpage that seemed purposful. It always seemed to be something they were trying to do for the desktop (perhaps not a great idea there) that was a disaster on mobile. Or maybe they tested on an iPad and when the screen is 4" instead of 10" it's unusable.
Postage – Free PostgreSQL Admin app faster than PGAdmin3 and 4
Yeah. Build more housing.
> payroll taxes would need to continue.

I believe you mean that the revenue currently generated by payroll taxes would need to continue.
I'm not too familiar with the German culture. Can someone explain to me what is this "German provincialism" that they talk about? Do Germans see themselves as provincial? Does anyone else see them as provincial?
And how, exactly, does this contribute to the discussion here?
I've always thought about this the other way around. When I feel sick or depressed I tend to drop out of society for a bit.
Are these really that CPU intensive? It's a very basic transform. Probably a rounding error in terms of overall rendering energy usage.
"Oversupply" at $3000+/mo, haha.

We can start talking about oversupply when they're more like $700.
Many claim that Haskell is easiest to learn as a first language.
This is not strictly correct. CoreAnimation does it's work in a background thread, so the mechanical work of scrolling pixels is not done on the UI thread unless you are doing custom drawing. Under the covers its a texture so the scrolling is really just translation.
Hopefully these results can be put to a good use in hospital, where extreme weight loss is a problem for many diseases
Wow, thanks for the in-depth reply (on a post that doesn't look like it's going to get a lot of views).

I'll admit my ignorance of information security (it's something I'm working on), but as a naïve reader I got the impression (considering the supplied ciphertext block) that the article was using paper-tiger/theater encryption that was practically broken in the sense that (given some CPU/GPU time) the tools existed to decrypt it. (Hence my "just for the fun of it".)

Thanks a lot for the links, I'll definitely be checking them out!
No, that still has not changed yet.
Does it? Last I looked it did 1 by default, 2 if you ask nicely.

The main reason it's slow is that it does a lot of analysis, even at -O1.
I worry about Tom Waits daily.
Less zoning and less barriers to building new supply.
I'm currently using NativeScript and react-native for app development and I have to comment because items like <ListView> [1] and Grid-Layouts [2] can be done using both technologies which use native rendering and achieve 60 FPS.
They both have listeners for common UI gestures. If you're building a normal app (no video game) with some forms, list views and maybe some diagrams, just use those. They give you a native experience and you don't have to build it for each platform - we're currently not in the state of "write once, run everywhere", but we're close.
It's really easy to get started, please read about those if you're not satisfied with the current level of Cordova and Web apps.

I used Framework7 for a PWA (Progressive Web App) and it has a very lean learning curve if you already know web stuff and it was very easy to integrate e.g. Chartjs, so if you don't like react or NativeScript's XML you can also use HTML and plain Javascript, although the iOS 10 change is a bit troubling. I don't have any problems like a scrolling titlebar with it. Try and see if it fits your use case.

[1]: https://facebook.github.io/react-native/docs/listview.html
[2]: https://docs.nativescript.org/cookbook/ui/layouts/grid-layou...
I quit Facebook in 2010 because of an article that ran in the NY Times. Grateful it's given me time to do other things. Grateful it's limited Facebook's ability to influence my thinking with dissonant communications which unfortunately drives their revenue.
Also ++, $, ., and some others. But yeah, you don't need to know too many to be able to read 90% of Haskell code.
Hmm, I haven't heard of any banks leaving yet.
Interesting read!

I wrote a (simple) 3d game using WebGL and released it on the Android app store using Cordova, and found the performance was pretty solid.

This might be due to Android vs iOS, WebGL vs plain HTML or something else entirely - any thoughts?

In case anyone is interested, the Android version is at https://play.google.com/store/apps/details?id=com.github.wil... and an earlier web version is at http://matt-williams.github.io/ld29/
> It took me a couple of days to get used to the Macbook keyboard

To be (un)fair, you can get used to a rock in your shoe as well. That doesn't mean you should.

Having to "get used" to a keyboard to return to your previous typing ability seems to be a contra-indicator of the new Macs having a good keyboard.
Don't know why you're being down voted. Sure if you're extremely generous with your definition of "two bedroom" or "Boston" you can but a real two bedroom apartment in Boston proper will run you at least $3200. I'm moving to New York right now and my rent isn't increasing drastically (a tad less apartment for the money though).
I call it "the state rewrite problem", which consists of two assumptions: one, that the quality of any constitutional framework degrades over time as political actors adapt to it over generations (except maybe if the constitutional framework was particularly bad from the start) and two, that any rewrite/reboot intended to counteract that degradation would be even worse than that if the established set of political actors is involved. This traditionally is only ever avoided in the aftermath of some particularly violent crisis. Now the art would be to avoid that crisis.

Drafting random collaborators for a rewrite could be one approach, but they would still be prone to getting influenced by the establishment. Maybe dozens of randomized committees working in parallel, with all but one draft discarded at random, to make sure that writing happens out of the spotlight, and with little incentive for self-serving elements?
The main problem is the greenbelt.
Sounds useful for the very few macOS or iOS developers who happen to have Android phones.
I wouldn't blame it all on wealthy NIMBYs. There are poor, renting NIMBYs too, and they're just as much a problem.
If I read the article right, it's not that you get fat from the aspartame (which the body can't extract any energy from), but that aspartame blocks IAP, which is thought to work against the detrimental health effects of a high-fat diet.

They also noted that blood-sugar levels for the aspartame-consuming mice where higher for both types of diets.
Thanks, that's a very insightful way to think about it. Reminded me of PG's "How You Know" (http://www.paulgraham.com/know.html), where he points out that not being able to recall information from a book doesn't mean that the book was "useless", because the process of reading a book weaves it into your subconscious model of the world.

Makes me feel a lot better about all the time I've spent reading books that I can't immediately recall the details of.