skysight-inc/HackerNews huggingface dataset:
Why would you suggest to ignore me when I was aiming to promote discussion. I was primarily questioning the science behind the post as there's a lot of questionable reporting on topics like these and so if it looks dubious, then I'm set to promote clarification. As it turns out oliyoung does seem to know what he's talking about, so I guess I needn't have worried.

And the snark at the bottom of your reply is really quite unnecessary.
Interesting that you seem to associate bad with predictable for movie taste.
Sorry if it feels like that. Main link goes straight to IMDB, it's non-affiliated. I show general opt-out link in the sidebar. Other pages have both affiliated and non-affiliated links in the lists of items.
Securing PostgreSQL with SSL-certs and CA
There is one place in the US that has a tea culture, and it's an iced tea culture. Lipton would most likely sell tea that meets that demand and let's the rest of the tea drinkers cope than, even if it does make a cup of something not entirely unlike tea for people who were raised on the stuff.
Who is the best footballer according to you?
There are some best footballer in this world. Some of them are best striker or Some of best Forward or Some of best Goal keeper or Some of best defender or Some of best mid field player. But according to you Who is the best footballer in this Planet?
You know, you could've just directly mentioned SQLAlchemy earlier...
At this developer portal https://developer.yummly.com/contact, hosted by 3scale, we created the contact form with Wufoo, which is great for fast results:
http://www.wufoo.com/gallery/templates/forms/contact-form/

Of course it is a hosted solution just like squaresend, just another alternative to consider.
How to support a student entrepreneur
You should take a look at the ORMs that are considered a bit more at the top of their class. In the Python world SQL Alchemy in the Ruby world Sequel. While you can't judge all ORMs by looking at a few these do offer a better impression of what an ORM can do for you.
You must have a car with terrible ABS. Bad weather such as snow is the only time I prefer ABS. It makes controlled stops in bad conditions much easier and more controlled.
If it was inspected more regularly I'd imagine the chances of it exploding would have been reduced.
He's trying to avoid the situation where you enqueue a background job inside a transaction and the worker gets started on that job before the transaction is committed. If the job needs to hit the database for any reason your likely to get errors as the new data hasn't been committed yet.

It looks like the work around he used is to cache the job queue locally and only flush it to the real job queue after the database commit, so your guaranteed whatever data may be needed for the job has been committed to the database.
No. The milk industry is still a mess, only some scapegoats got executed. Officials don't care about face.

But at least we've moved on from bad milk to bad bottled water.
Pie charts in pure CSS3
Basically if you modify data in a transaction, add a task to the queue that relies on that data, and the worker pulls the task off the queue BEFORE the transaction is committed, then the task tries to access data that doesn't exist in the database yet.
There are still a lot of Django apps that work fine in this scenario. Plus I don't think the slides imply that they are just blindly replacing ORM calls with raw SQL, just that they have profiled and replaced the hot spots.

Also Flask is a micro-framework and Django is a full-stack framework. Flask can be used as the backbone of a full-stack framework but figuring out a good project structure and finding out what third-party apps to use can be daunting for a person without Flask experience. If you really want to get people to switch, package up a Flask-based framework with the features of Django.
fyi looks like this was released 90 minutes ago:

https://code.google.com/p/google-glass-kernel-source/
Macros are more for writing libraries than applications, so certainly what you are saying is correct. However, some people don't like that capability to exist at all - they are afraid it will be abused in code they support or rely on.
Middlewares, context processors, forms, (class based) views, and tons of third party applications.

The CTO of a startup where some friends are working thought the same you did, and 2 years ago rewrote everything to Flask. Now they're going back to Django.

Django is much more that an ORM and templates.
I love driving. I'd drive you to ND assuming you'd compensate me for the time it'd take from my work. That cost would make it extremely impractical for you to choose that option though. Just because someone loves driving doesn't mean they can't be practical about it.
Using python and ruby, Elixir looks much more "familiar" than the erlang syntax. Yet I was always curious about things like the actor model, lightweight processes and the high availability aspects of erlang.

Is it wise/advisable to start with Elixir without knowing erlang, or is it better to learn erlang first?
Musk: Tesla, SpaceX, and the Hyperloop at Khan Academy
The only problem I see, is we can't rewrite SQL.

I.e., in pseudocode:

query = SQL("SELECT * FROM entities WHERE owner = ?", owner=me)
...
if some_condition:
query = query + SQL.WHERE("OR public = TRUE")
...
if other_condition:
query = query + SQL("LEFT JOIN things AS t"
" ON t.entity_id = entities.id") \
+ SQL.WHERE("things.value > 0")
...
my_nice_list_of_results = run(query + SQL("LIMIT ?", count))

This should be technically possible, but I haven't seen any library that does it.
> I love the Haskell language and miss all its lovely features. But if the language requires me to change my OS to develop anything useful, that's a nonstarter.

Perhaps you may want to give https://github.com/organizations/Frege a try. It's a bit more powerfull than Haskell 2010, through support for higher rank types. OTOH, due to lack of supporters, the libraries available are far from complete.
But it compiles to Java, and so is interoperable with Java or any other JVM language.
If you're talking about the slide that says '87.91% of time spent rendering' then yes, I would like to know too.

Annoying that it doesnt have slide numbers to refer to.
The SQL generated appears correct, unless the underlying database can guarantee that all foreign key constraints are met. That is, I consider this a failure of the user of the ORM to appreciate that the two invocations of filter are not identical.

In the former case, the query is verifying that the object_id field cannot be used to find a foreign object--regardless of the value of object_id. This is exactly what it is asked to do.

In the latter case, the query is simply verifying that object_id is NULL, which is exactly what it's asked to do.
I would recommend to start learning Elixir and diving into Erlang as necessary (and yes, you will find it necessary)
"what advantage does Django provide at this point in this project anymore?"

Documentation. I use Django but without any ORM and with Jinja2, so it's basically just Flask but with more stack overflow threads and more third-party software.

Is there any actual advantage that I would be getting by using Flask instead?
No Glengarry Glen Ross?

https://www.hnsearch.com/search#request/all&q=glengarry
Taibbi's pieces are often brimming with excerpted interviews, specific names and places and trials, details of hearings and indictments. It may be that he is catastrophically misinterpreting these sources, but he obviously makes an attempt to get into the details of what he's talking about. Your criticism of him contains zero examples, and is basically just "trust me, this guy sucks".
Will it break the bank or just take up time to develop? If its just a matter of effort, I'd get started draft structures do sloppy wireframes, etc. Once you are into it again, think about how you can monetize it or get to money through it.

If you make a good product, it may or may not make money but you might make more money by having the experience of making something. It it's cool, it probably will enhance your portfolio.
Amazon uses Data warehouse for E-commerce. What's the role of Data warehousing to help Amazon to implement its strategies to achieve a competitive advantage? Such as price strategy, place strategy and so on.
I think the primary_key line should be:

t.primary_key :id, :type => :uuid
I have always wondered why people have an aversion to stored procedures. They are a programming language in themselves, so you could pass all of your parameters (owner, some_condition, other_condition) into a proc and, depending the logic, return a different cursor to a different query.
> It's 2013 and the fact that iOS is not a multi-user operating system is still coming as a shock to some people?

Wait…it’s 2013 and people still buy single-user operating systems?
Well, I don't want to sound like an evangelist, but foobar2000 plays FLAC just fine, with gapless playback and whatnot and the interface is quite the opposite of Winamp's.
When ORMs first started becoming popular during the 2000s, especially within the Java world, their proponents drummed up a lot of animosity toward SQL.

While a lot of us who had started working with SQL in the 1980s, if not earlier, were perfectly fine with using it, many younger developers were scared away from it by these claims.

So we've had a generation of software developers who were essentially raised to hate SQL, and to embrace ORMs, even after it became clear that ORMs do come with some pretty serious trade-offs, and do not necessarily increase productivity.

Not having a solid grasp of SQL, a lot of these developers just don't realize what they're missing out on. I've seen this first-hand many times before. These developers will spent hours upon hours trying to get their ORM to perform a moderately complex query that could be easily written by hand within a few minutes, including any code necessary to perform the query and to retrieve the result. The time and effort expended on these sorts of queries will very quickly negate any time and effort the ORM may have saved for simpler queries. And these moderately-complex or complex queries always arise in real-world software.

I think that education is the only way to really solve this problem, but a lot of developers are quite set against this. Learning SQL isn't that much of an investment, but the returns it offers can be huge.
Google Glass kernel GPL source
I don't disagree with the goal of preventing fragmentation, and I'd even be willing to play the flag game (i.e. have my version focus on SMP functionality in both senses of the latter, while observing the official spec with a different flag).

It's the long winded, says the same things at least 5 (!) different times and ways, and therefore subject to many interpretations license, which is then subject to whims of the author or an external board (compare to Java, where in theory passing a suite of tests allows you to offer a version of Java(TM)).

I'm not going to invest serious effort in something that might get killed simply for political reasons including different interpretations of the license; even if I trusted the good will of everyone involved, sooner or later the players will change.
He takes stuff, particularly hearings, trials, and indictments, wildly out of context. As in the example above, procedural and technical judgments (the law doesn't apply to this situation) become moral judgments (the people who lost money are undeserving of relief).
That's funny, because a few weeks ago somebody did the same exact thing but with books and no affiliate links. All the comments were about how he should add affiliate links, and that HN appreciates projects which make money.
In addition to the other replies I have to add - the goddamn Admin. The amount of time it saves me is beyond belief.
A Redis-backed generic timeline implementation
Satoshi‘s Fortune: a more accurate figure
1) Even if there are drugs(antidepressants, stimulants, etc) which can relieve depression by interacting with dopaminergic, serotoninergic or noradrenergic neuronal systems, it doesn't mean that depression was caused by lack of specific neurotransmitters.

It's like making implication that if reboot solves a problem with your laptop, than this problem was caused by infrequent reboots.

Simple lack of one(or even several) neurotransmitter is an old hypothesis. Modern "neuronal" theories are more complicated and elaborate.

2) I'm going to give advice other than exercising, sleeping and eating well. These things are great, typical HN depression thread contains lots of advice on that by more knowledgeable people than me.

So.

OP and other depressed or anxious people, there are self-help books by David Burns: "Feeling Good: The New Mood Therapy" and "When Panic Attacks". Both are available on amazon kindle: http://amzn.com/0380810336 and http://amzn.com/076792083X

What's good about them?

First, they contain various scales for deprssion and anxiety. If you like to quantify things like OP, get this book, and measure your score 1-2 times per week.

Second, Burns features cognitive model for depression. It is considered that depression(and anxiety) is caused by unrealistic distorted thoughts, which you often think automatically and may not even notice such thoughts. They have vast impact on your mood though. So, literally, you feel the way you think. Change your thoughts and your moods improves. (easier to say than done, I agree)

Third, these books describe a great amount of cognitive tools, which will help you to think rationaly and realisticaly(and consequently - feel better).
Even if you aren't depressed, you may find awesome tools which will help you to beat procrastination(Anti-procrastination sheet and daily activity schedule are my favourites).

Fourth, they are well-written and helpful on its own. The main power of these books is technics though. Reading + Using Tools > Just Reading.

3) If you're having difficulty fighting depression on your own - get professional help. Find a good CBT therapist, CBT shouldn't be very long, so you won't waste a lot of money.
I'm sometimes surprised at comments like this that fail to appreciate that people can (and should!) have an opinion on things. People can be "judgmental" -- it's called having an opinion and it is not a bad thing.

Requiring everyone to water down their opinions in order not to offend anyone (usually code for people with mainstream views) is truly offensive. In civil society we can all hold opinions and are able to express them. This is why democracies work so well -- at least better than all the alternatives!

I'm a bit older than the average reader here, so perhaps I'm biased. It seems to me that many people raised in the toxic and simplistic battles between left and right in the US media don't seem to have much of an intuitive sense of civil debate. I think the lack of good examples may be one reason.

In short: People have different opinions. If you don't agree, feel free to speak, but be civil.
Clearly this calls for a macro

(define-syntax naive-for
(syntax-rules ()
[(naive-for start end body ...)
(let ([op (if (< start end) + -)])
(let loop ([s start] [e end])
(begin body ...)
(cond [(not (eq? s e))
(loop (op s 1) e)])))]))

(naive-for 1 -2
(displayln "Lambda? What lambda?"))
CISPA is not me inviting police in to search my home. It's someone else coming into my home on behalf of the police, conducting a search the police couldn't legally do, and then reporting back on the results the police. And they're doing this with the encouragement of the police and with a promise of legal immunity from the police. But we're going to pretend that wasn't really a search and that the restrictions that apply to the police don't apply here.
Not completely true. I live in Sydney and my friend came from France hitchiking, except for boats between Malaysia and Perth. He did all the countries in *kstan.
How can you possibly say that you aren't willing to spend more than $200 dollars, but would wear it on your face every single day? People pay more than that for sunglasses which provide no functional utility above the $5 sunglasses.
Ask HN: Buy Galaxy S4 or HTC One?
My wife want to choose between Galaxy S4 and HTC One, which one do you think is better? Why? (She is not a programmer)
Thanks!
it looks like kcachegrind or pycallgraph (https://github.com/gak/pycallgraph).
Suggest adding Font section to checklist - e.g. CSS providing generic font fallback. Fontsize recommendation 16 px, line height 1.5 em, relative fontsize for Hx etc..
This video is funny because it's true.

Git is practically unusable for all but the simplest things without a good set of aliases or wrapper scripts.
I was expecting this slidedeck to be a bit more focused on defying Spolsky, and whether or not that was a good decision.

FWIW, I've never bought into Spolsky's vision that re-writing code is poor strategy. Steve Jobs never thought twice about ripping something apart and starting over. If anything, code re-write can be an advantageous position -- you often have a greater understanding of the problems you're intending to solve. When well-executed, it can take the form of heavy refactoring, even when switching languages/platforms.
I could make two node spam transactions between themselves to drive the rate up, or make non-relay nodes to poison the network and make it go down. There's no way of really knowing how many parties are using the blockchain.
http://ycombinator.com/newsguidelines.html

> Off-Topic: Most stories about politics, or crime, or sports, unless they're evidence of some interesting new phenomenon.
Completely replacing the template system with Jinja is silly (no idea if this is what they did) since it significantly reduces the value of the Django ecosystem. Far better it to use jinja for your work, but leave the Django templates for Django and all the other apps you integrate to use. I do with Django would reduce their stance on no expressions in the templates. Sometimes it saves a lot of work to just be able to call a function or add two numbers together without needing to build a filter or tag every time.

I've been happy with django-jinja[1] for that purpose. It replaces the context processors so it will load jinja templates if they have a .jinja extension and Django if they are .html. It also includes the django filters in jinja-land.

The ORM is more problematic. I just started a project a couple months ago and thought a lot about ditching the default ORM in favor of SqlAlchemy. I decided not to, for the reason of expedience and, as the TFA mentions, it already leaks. So, I stuck with the Django ORM and will drop to SQL directly if need be (need being defined by the ORM making the code confusing or there being performance hotspots).

1. https://github.com/niwibe/django-jinja
I think the Parent's comment could be taken either as a underhanded slander as you represent, or viewed that people can have naive perspectives while undermining their own interests.
IMO, at that price point, the real question is "is it worth it to wear them and look like one of those guys that walks around with a Bluetooth earpiece in at all times"?
I believe part of the reason that governments prefer big, "overpriced" software packages from mega-corporations is support and warranty. The White House does not want to create and manage a new in-house tech support team.
You also seem to follow a script when you veer away from technical topics.

If the topic is political or economic and likely to provide a runway for some sort of frustration-at-establishment chatter, I regularly expect you to appear and engage in some sort of character-assassination, poisoning-of-the-well job as you've done here.

That second para is especially representative of the in-character mode of your responses: one of a reasonable, empathetic, "hey, I don't like it either!" stance followed in short order by some content-free opinion shaping.

You're clearly capable of more insightful commentary in technical matters (a minor understatement) but beyond that the risk of your comments going tabloid editorial increases quite a bit.

All quite odd behaviour when you combine it with your tendency to guide others in appropriate commenting approaches (as you've done further down this thread.)
"other_id" and "other" here refer to two different ways of referring to a many-to-one reference between "somemodel" and "othermodel". Asking for rows of "somemodel" where "object_id" is None is the exact same thing as asking for rows from "somemodel" where its reference to "object" is None. Both should produce the same query, the simple one without the JOIN. The query with the JOIN is completely wasteful and not at all correct - it does a LEFT OUTER JOIN to the remote table, only to filter on those rows where the remote table has no match; but this is already obvious from whether or not "somemodel.other_id" is NULL.
Economies Of Scale As A Service
But when you wear glasses you get to choose the design and look that fits your personality. It's also a fashion accessory.

I love my glasses, but part of the reason I love them is because I have not (yet) met a single person with the same glasses as mine, and I've had them for 3 years now.

I wouldn't feel so happy wearing something every other person wears.
Right, vacations certainly. I overreacted :-/

Try linkedin - many groups are announced there. Most are "empty" (as in just full of spam), but some can provide you with links to an existing scene.

As usual, the odds are higher where you have a bigger population. From SXM I'd recommend you get in touch with groups in Guadeloupe. There's a good lug, and quite active wifi/HAM style project.

Get in touch by email (in my profile) if you want more details.
If you aren't using the ORM, what does the admin bring to the table? I agree with the value of the admin, and is one of the reasons in my latest project I kept the Django ORM, even though some coworkers felt it was limiting (it is, but it isn't all about a single component of the system).
This sounds like a situation where it'd just be better to use separate, yet similar, queries, with each handling a particular case or set of conditions.

Views, stored procedures and functions can be used to help isolate duplication, parameterize the queries, or otherwise hide the SQL.

Code like you've posted is the result of taking DRY too far, to the point where avoiding a small amount of repetition ends up bringing in far more complexity and problems than the repetition might cause.
Venture Capital World Summit 2013 Speakers April Update
I don't like making my posts look like plugs for my own stuff, though I guess it's unavoidable....
There's the gov't side to it and also after several more levels of gadgets that each give us a "new normal", we'll probably end up like this http://www.youtube.com/watch?v=SKrYHLE8mDc
And I think all you folks in a car are totally crazy :-) Riding is fun!
Thank you for your advice.

The acknowledging and showing imperfection part is very difficult for me, not for my family, who have been very supportive and understanding along the way.
The analogy doesn't really hold because ponds in the forest are going to be much more homogenous than planets. If every pond we looked was unique, we would probably be more interested in individuals.

Of course, there's no reason to assume that life on different planets is more diverse than different ponds, but it seems more likely.
Thanks. That is really useful.

Luckily, I've never faced legal action for... anything really, so it's good to have some insight here from someone who has.
I found these tools mentioned by the author really helpful, I compiled a list of them:

http://jinja.pocoo.org/
https://www.getsentry.com/welcome/
http://graphite.wikidot.com/start
https://opbeat.com/

is there a way though to use/test opbeat ?