skysight-inc/HackerNews huggingface dataset:
SQLite 4 will have one storage engine record for each table row, just as it was in SQLite 3.

Fundamentally, there is little difference in how SQLite stores data in the storage engine as compared to, say, Postgres, except that Postgres' SQL implementation is more tightly bound to its storage engine (e.g. index tuples are encoded using knowledge of the engine, whereas in SQLite they simply use the record's primary key)

Postgres and suchlike don't have some magical data structure that makes ALTER TABLE possible, all row oriented stores have the same choice: either implement the alter immediately (involves a scan and rewrite) or lazily (on next record update).

Not sure if there are any that take the latter approach, but the method is commonplace elsewhere
They won't communicate to their employer that they need more money to pay down debt, but as a motivation for seeking higher salaries, jumping to new positions. With less debt people do what they want, when they are hungry to feed debt they will do things they otherwise wouldn't.
When you take an investor's money and lack the ability to generate revenue, you're forced to use shady 'growth hacking' techniques in order to fake hockey stick metrics for the purpose of finding additional investors ad infinitum.
Agreed. Mark Rippetoe's diet will make you gain body fat. In his defense, he mentions this several times in the book, writing things approximately like, "People are in love with their visible abs. This diet will break your affair off."
That's true. I really needed to bulk so it worked for me (gained 30 pounds in about half a year). That being said, for those looking to control weight and do something more manageable I would definitely recommend McDonald's guide.
Get a bachelor's degree in biology or related science. Since you have the IT background, you'll thrive :-).

ps. If you could attend a university full time, I would consider pharmacy.
Bitcoin - The economy of WoW, writ large.
Ask HN: Do you struggle with getting more customers?
I’m not looking for advice or tactics and tips. There’s plenty of that online and more than enough people telling me what to do. Sometimes, it just doesn’t work, no matter how awesome your advice is. Getting customers is hard.

Do you or have you struggled with this? I figured all the founders on here would relate and thought it'd be helpful to have a thread where people can just share their struggles instead of being bombarded with all sorts of advice. I'll start:

I started my own online business with much hoopla and announced it to everyone. Big mistake. Now that I’m struggling to get customers, everyone is coming out of the woodwork to tell me what to do and telling me not to quit. Ironically, their support now makes me feel like more of a failure. If I stop now, it’s like I’m letting everyone down. If I don’t, I may just be digging a deeper hole. I feel like I’ve tried everything, I invested my time and money, but it’s just not working out.

TL;DR - Instead of asking for advice on how to get customers (there's plenty of that elsewhere), join this thread to share and vent about how difficult it is to actually find new customers.
>To help find a way back to academia, you can get a big boost by contributing to an open-source project with strong academic connections

Woah, haven't thought about it from this perspective. Thanks.
You're right. My bad. Thanks for correcting me.
Medical professionals have used FUD(fear,uncertainty,doubt) and requiring very high burden of proof(trying the technology for a very long term, even though preliminary results show favor ability) for ages as a tactic to scare the public and politicians from accepting innovation and change.

I wonder, what are good tactics to fight such efforts ?
Mark Rippetoe changed my life. I second this recommendation. And I've only learned to squat and bench properly so far. Looking forward to (if you'll forgive the pun) picking up the other lifts.
> Last friday I lost a commit using git reset --HARD (shit happens), so I decided it was time to study

Mercurial?!

> git again

Aw.

It may be interesting to compare the safety nets that Git and Mercurial provides. Mercurial tries to steer you away from rewriting history, but it does supply a complete set of tools for doing it - it has rebase, strip, commit --amend and so on. The difference is in what happens to deleted history.

In Git, as i understand it, history is defined by the branch pointers and the commits reachable from those. Deleting history simply means fiddling the branch pointers; the underlying commits are still there, completely unchanged. But now you can only find them via the reflog (unless you wrote their hashes down or something). They will stay there until the next garbage collection cycle. I don't know what determines when garbage collection occurs, so that might be ages, or it might not be long.

In Mercurial, history is defined by the commit graph. If something is in the graph, it's in history. That means that to delete something from history, you need to actually remove it from the graph. Commits which are removed are written as bundle files to the .strip-backup directory inside the repository's .hg directory. These are compressed binary files, so they're not much fun to look at directly, and i'm not aware of any way to display their contents, but Mercurial can import them, so restoring the changes. These files are never deleted automatically.

Really, Git's safety net is more tractable - once you have identified a deleted commit, you can work with it in the same way as any other commit. Mercurial's safety net is purely cold storage. I believe this reflects the tools' different opinions on rewriting history: in Git, it's normal, so you'll need the safety net a lot, whereas in Mercurial, it's not normal, so you will only need it if you have been bad, and you should feel bad.

Fortunately, something that is slowly arriving in Mercurial is the concept of changeset evolution:

http://mercurial.selenic.com/wiki/ChangesetEvolution

Which basically keeps deleted commits in the tree, like Git, but marks them as deleted. Moreover, when you do things like amend or rebase, it marks commits as having been replaced by other commits. Those marks are in the committed metadata, and are propagated between repositories, which means it becomes possible to do things like safely rebase public commits, merge different attempts at rebasing some commits, and more besides. If changeset evolution works as well as is hoped, it will provide all the advantages of history mutation without any of the drawbacks, which will be super sweet.
A brief history of mathematical symbols
This is a topic I have been thinking about a lot lately, so this article is quite timely.

I was a bad programmer for a long time. For a few years, I was an engineer and basically wrote quick and dirty matlab or python scripts to do physics based modeling and simulations. But, it was never elegant or efficient or anything that I guess you learn about in upper level CS courses.

It didn't have to be. A customer would never see the code, it would never have to perform under critical conditions, it could almost never be reused because each project data set was completely different. The code was just supposed to crunch input and produce meaningful output that could be analyzed.

I got to thinking that I was a pretty good programmer because I could write those scripts.

Then I quit that job and moved to a different country. The only job here that I managed to get was as a software engineer. Here, I learned how very wrong I was. Writing quick and dirty scripts that crunch data is easy. Programming is hard. Really really hard.
I've got to say I prefer leatherman to swiss army knives. They're somewhat heavier, usually being all-metal and bigger, but the bigger blades and the pliers/cutters are worth it.
This guideline has been ruining HN discussions for a very long time. There should be a way for a submitter to explain why the submission is relevant and what is offered as a discussion topic. The only place to do that is in the title. And the solution has been suggested a million times - keep both the original and moderated titles and let people choose which one to see - any plans to implement something along these lines, preferably soon?

PS. Just look at this very submission. "Algorithms ..." version would've made me read through the linked page, because it clearly identifies the relevant part of it. But seeing the "Nurses ..." title and skimming through the opener makes me think that this is some sort of US-specific content that just happens to be of a great local importance.
Starting Strength works because it's easy to understand, follow, and see results from. By far the primary challenge newer folks face is establishing the discipline and consistency, and that's a lot easier to do when you're motivated by increasing the weight on the bar regularly.

My favorite quote from the book is from the very first page (which is probably very relevant to the HN crowd):

A weak man is not as happy as that same man would be if he were strong. This reality is offensive to some people who would like the intellectual or the spiritual to take precedence. It is instructive to see what happens to these people as their squat strength goes up.
It would be really nice to have a Mill simulator, perhaps running on a web page.
> he is only using the first (blue) tile

That's what I assumed too, but I didn't want to be sure of it because one have to be too stupid to do a demo of a product using always the same part. "Look I designed a keyboard and I can type with it: 'aaaaaaaaaaa'".

Okay, so it means that if I want to type 'n' I hit the 3rd tile and then I have to move four tiles away. Except I can't. So I guess I'll have to go backward when I reach the last tile in the direction I chose. But that seem to conflict with what I inferred for numbers…
How much have white Americans benefited from slavery and its legacy?
I'm sure there will be a financial innovation to address that. Like Reserved Instances, but more so.
No he describing a training void of periodization. He does the same routine for a year just increasing weight. In a per iodized regime he would maybe start with low weight high reps then move to 8-12 reps the doing maximum strength training with 5 reps. This is usually only necessary if you start plateauing on your current regime.
Maybe it is also transmitted that way, but changing the time zone from Australia from New Guinea has repeatedly fixed my OS X WiFi issues when a Chinese roommate used an illegal channel (in Australia).
>Results in research need ambition, duration and vision more then being the smartest person in the room every day.

Thanks for mentioning that. I only recently realized that “mad genius scientist” stereotype has probably scared away a lot of fine folks from science.
Hack money out of politics: Democracy Hackathon (May 31- Jun 1 San Francisco)
Digitial music should learn from vinyl
if you are interested, there is also a separate blog post, http://www.codecademy.com/blog/143-eventhub-open-sourced-fun..., in which we talk about some high level architecture consideration
But then they'd have to come up with a different solution for the iPod touch :)
Another similar workout plan is Stronglifts 5x5[1]. I have never done starting strength but I am a fan of stronglifts and it has a free app that does wonders at the gym for tracking your progress.

[1]http://stronglifts.com/
I couldn't get through this article this guy made me so mad. He's like the worst sort of intellectual, the one that loses his own morality and culture to abstract ideas.
You post seems to be insinuating that we deem GAs as a panacea. No one here is saying that; to the contrary, we're just trying to see how we could use them for dynamically generating interesting test-input data. In addition to that, I'm just thinking out loud if you could possibly append to that functionality and see how to "prepare" more interesting test cases when multiple layers are involved.

No one is disputing the fact that you need an expert to tune these to get the desirable result for hard problems. I argue that having a "good enough" understanding of GAs (i.e. you don't need a PhD in the subject) should be sufficient for you to solve simpler problems such as the one we're discussing.

Do you have any counter-arguments to that? Can you cite any other examples where this view is challenged?
Ask HN: Cost to incorporate your startup?
How much would/did you pay to incorporate your startup? Price for Delaware C-corp (gold package) on legalzoom = $706.00 when all totaled up.

Is price the most important thing to you? How did else did you choose your startup lawyer/legal service?
Free download: Halftone Automator Photoshop 
When mass printing dominated the mid-twentieth century, the number of colors in an image was reduced by replacing gradients with dots. The technique was seized upon by pop artists, like Lichtenstein and Warhol, to such an extent that it’s entered our visual language.Happily designer Matt Borchert has fixed the problem for us by providing Halftone Automater, a great set of Photoshop actions, free to download for WebdesignerDepot readers.There are 12 distinct actions: dots, diagonal lines, and horizontal lines; each divided into small, medium, large, huge and gigantic sizes.
Star Trek: The Next Generation Was the Last Sci-Fi Show Hopeful About the Future
Never ever use csv to export. Use tab separated, as it takes work to type a tab in excel.
>i hated being a biologist. I didn't like the culture of science, I didn't like the work itself, and I didn't like the schedule and lifestyle it demanded. I also really didn't like killing mice.

Thanks for an honest perspective.
great point and this is the exact rationale behind the architectural design
WhattaPlay The social sports page.
WhattaPlay gives all fans a voice. Stop just listening to sports talk and start sharing your takes. WhattaPlay keeps score and all our members are ranked on a comprehensive Leaderboard.
Stating the obvious stuff mostly.
Thank you and your parent for shedding light on some of the issues. It's very informative and not something people tell you upfront (or even recognize is there).
In my world, if you invade a country on a pretext and kill tens of thousands, possibly hundreds of thousands, you're out of control. Especially if in the run-up to such an invasion you squelch every possible voice of opposition or reason.

That's where the problem lies, by your own definition your country is evil (not by mine, I don't believe in the whole good/evil thing, it's just a simplification to make it easier to delude voters into thinking things are easy to understand when in fact they are not).
Amazing how the difference in the time of submission affects the voting so radically. Amazing. It's a "feature" of HN in so far as it's documented, but is it something that can be improved? The fact that something gets lots of votes at some stage shows that it's relevant and interesting. The fact that it didn't get votes first time around shows that it was missed.

How many relevant and interesting articles get missed because they are submitted once and sink without being noticed?

Is this a problem?

If so, can it be fixed?
I'm located in Russia but I plan to move to US for an unknown period of time, and later either stay in US or move to Europe. I'm not in a hurry—just trying to imagine what I'd like to be doing in ten years.
ohhhh that's interesting ... especially as all it takes to make cloud a capital investment is a contract with the cloud provider and rental agreement ...
Changing a link from a carefully written summary of the highlights of a long paper into a link to that long paper is not good.

edit: upvoting the original link.
Joi is an extreme example, sure, but now he's recruiting people for tenure track jobs from outside the traditional academy track. Read their most recent job listings.

Moreover, many top universities have positions called Professors of the Practice. And that's a common enough path that Neuroscience, as an interdisciplinary field, would do well to adopt. Geoff Hinton now works at Google for a reason.
"wanted to get more fit and healthy [...] to shed off the weight or gain muscle"

Those are two, three, maybe four different things. The typical marathon runner, for instance, is fit, not fat, but also not muscular, and may or may not be healthy; a sumo wrestler is surprisingly fit and muscular, but also fat, and a body builder is muscular, but need not even be strong (world champion weight lifters look quite different from body builders)

The optimal training program depends on what you want to achieve. That's also what this NY Times reporter seems to be confused about. Training programs focussing on getting fit (especially those focusing on endurance fitness) may have a side effect of looking better in the mirror, but if that is your goal, there are better/faster ways to get there.
Interesting that “don't drag them down” appeared several times in this thread.
The real reason children don't listen to their parents
This is a great place to plug the importance of the Simple Wikipedia section. The main wiki page for a complicated idea shouldn't be dumbed down, but there can be a coexisting version using simpler language. Explaining something simply is often an exercise in how well you truly understand a concept.

https://simple.wikipedia.org/wiki/Main_Page
Only after several requests and several months.
Postgres almost warrants its own non-generic ORM. That would actually be kinda cool.
What does Paul Graham think of Quora joining the next YC batch?
The simple yet difficult thing is to let the panic happen. When you run away you're distracting yourself which can dissipate the panic but it only prolongs it. So instead of being at a 10 you're at a more manageable 6. But you're there for hours. Letting the panic happen means you're at a 10 for a few minutes tops and then you're down to below a 2 pretty quickly.

I didn't come up with the tasks on my own. I learned them while working with my therapist. What seems to work for me is to run up and down a flight of stairs a 3-4 times and then breathe through a straw for about 45 seconds while holding my nostrils closed.

I'm getting plenty of air but my brain's reaction is to flash panic. The first flash is around a 6 for about a second or two. Very easy to manage. But I stay present for those few seconds and even try to make it last. Try to have the panic.

I do this for about 20-25 minutes every other day. In this way I expose myself to little bits of panic consciously. When an actual panic attack happens now (which it still does on occasion) its increasingly less severe than the last time. And each time I recover more quickly.

But most importantly, I now know a part of me I never really knew. I have and have always had a strength I wasn't even aware of. All I had to do was look fear in the eye and watch it shirk away.
Considering this: https://news.ycombinator.com/item?id=4503910
Watch_Dogs torrent secretly installing a Bitcoin miner on thousands of computers
I don't think RNs need to feel threatened. If anything, medical technology will enhance their status and make doctors more dispensable. Nurses are the ultimate interface between the medical system and the patient.

Right now, there is a trend to allow NP (Nurse Practitioners) a greater autonomy in what they can do. While they still work under the authority of a physician, that's becoming more and more of a rubber-stamp.

More and more doctor activities can be replaced with an algorithm. Diagnoses are made before even seeing the patient and only rely on data from nurses and EMRs. That's the territory of software right there.
(Of course this is not to say docs are obsolete, but their work can shift to research. And (at least for now) surgery remains more cost-effective if done by docs than by robots.)
HEAD is a good fit. We'll add support for that. Please open github issues to help us track the feature requests or bug fixes at https://github.com/strongloop/loopback/issues.
Yep. I said “engineering” so I could sound fancy. Also, it's not about MV* anymore.
Now imagine I know very little about computers and just want to upload and share a PDF file, i.e. click "upload" and get a link--an imgur for PDFs. I don't know of a solution like that.
It's a failure of facts to assume the best schools are so narrow in their thinking. Neuroscience is opening up most especially because it's a field based on information processing. Worse to assume standardized testing is the way to differentiate yourself.

A solid publication in a good journal is more important. Ph.D. programs teach scholarship. To demonstrate that skill before admittance is the highest currency possible.
Scribd seems unambiguously terrible (DRM fonts? That's a whole new level of garbage), but I find it really hard to say the same about Quora unless you're confirmation-bias-ing your way to portray them in a bad light.

So i've got this website. You have to log in to post things there. Other people have to log in to see the things you post there.

Someone please explain to me again how this arrangement is evil? Seems pretty straightforward and fair to me.

Spam emails? http://gyazo.com/f4752783f03276b654dd3f7044cb6766

Seems to me like they give you pretty comprehensive settings on what you can turn on and turn off. And it's not like this screen was hard to find. It's in an "Email preferences" link on the same general settings page you set your password on.
Good catch. We support Postgresql, MS SQL Server, and SOAP too.
I'm much happier since I've stopped lifting. I did Starting Strength until I could squat 1.5x my body weight, but I never enjoyed going to the gym, and realized I didn't really care much for the muscle I put on. If anything, it was annoying having such big thighs. I haven't been to the gym for a couple of years now and couldn't be happier. I do quite a bit of cardio (competitive table tennis), and that's it.
Lifting is something I'm pretty passionate about. I go 5 days a week and don't follow any specific program, just do my own thing. Honestly, if you're in the gym 5 days a week, you're going to see results. Plain and simple, no matter what you're doing. I've always felt the programs were basically saying "do these things in the gym this much then you'll see these results" and it's like yeah I can do almost anything in the gym for that amount of time and I'll see those results...

I feel like supplements are similar to personal trainers in terms of that "client confusion". I've taken a lot of different supplements and doing research online versus talking to someone at GNC will return offensively differing results in what you should take for which reasons.