skysight-inc/HackerNews huggingface dataset:
Most of our stored procedures are currently in PL/PGSQL. I don't know that I would say the language sucks. In fact where one is doing set operations, the language is wonderfully expressive and flexible, and one can get more done in it faster than any alternative, again where the operations are set operations.

SQL has some very serious downsides and these are persent in PL/PGSQL, but these aren't that hard to avoid with good db design. Don't get me wrong, I have seen some really horrible PL/PGSQL stored procs in my day, but it doesn't have to be bad code.

As for an additional API layer, yes there is one but it is pretty thin and most of it is pretty heavily automated. I would say that at least 75% of perl module code is just identifying methods to map to stored procedures, so there isn't a lot of code there (figure three lines to map, a sub name, a sproc name, and closing the sub).

What this allows us to do is support multiple applications in multiple languages while offering consistent security and database functionality to these applications. The DB isn't just a data store, it's essentially a meeting point potentially of a larger number of applications.

We have considered adding PL/Perl and PL/Python stored procedures but since most of these are set operations and so they are things that belong in db queries.

As for source control I don't know what really would separate this from a compiled language. You can think of loading stored procedures into the database as essentially like compiling a program. As we move to future versions this will become an even closer comparison, as we start bundling these using PostgreSQL 9.1's extension framework.

Edit: Our stored procs are defined in text files that are checked into a source repository. They are also designed to be rebuildable, and there are utilities for rebuilding stored procs included in the software.
The Tab 2 10.1 has speakers facing forward, the same design they used in Germany to thwart that injunction.
Northwestern University Lab Crowdfunds a Publication About ... Crowdfunding
satu,
I agree with you, if the American support for dictatorships had ended then it would have been futile to mention the past. The problem is that this is how the situation is today and it's the same as it was 10 or 20 or 50 years ago.

The Bush's WMD charade surely was indirectly responsible for killing far more than 100k Iraqi civilians, perhaps more than a million. The infamous leaks showed us that the US gov and military were lying about the numbers, the actual number of Iraqis they directly killed was close to 109k back then (no minutes of silence for them on any September day).

http://abcnews.go.com/Politics/wikileaks-109000-deaths-iraq-...

Since you mentioned that, what is even less well-known is that Bill Clinton's administration "saved" 500k Iraqi infants from the Saddam regime between 1991 and 1996 by sanctions that refused everything including life-saving drugs into Iraq. What's reported even less frequently is that Secy of State Madeline Albright thought about it:
http://www.fair.org/index.php?page=1084/
Lesley Stahl on U.S. sanctions against Iraq: We have heard that a half million children have died. I mean, that's more children than died in Hiroshima. And, you know, is the price worth it?

Secretary of State Madeleine Albright: I think this is a very hard choice, but the price--we think the price is worth it.

--60 Minutes (5/12/96)

Remember who was in Iraq shaking hands with Saddam and delivering killing machines in 1980s?
https://www.google.com/search?q=saddam+rumsfeld

I'm not blaming fellow Americans for it, we're too busy watching celebrity gossip, who cares whether our tax money goes to kill thousands of protesters via dictators or to kill millions of civilians through our own machines.
Actually "no poach" aka "non-compete" clauses are void in California:

http://en.wikipedia.org/wiki/Non-compete_clause#Exceptions_-...

So she really had no grounds to demand and expect it.
Divided Kingdom: Scotland to Leave Great Britain?
Who is going to glue all these pieces together?
I think overhead of managing all these small steps would exceed time savings you get from outsourcing.

Overhead would be in:

1) Teaching ALL participants about job to fill.

2) Dealing with job seeker's frustration when he would need to answer the same questions to different people in the process.

3) Restricting access to potentially sensitive personal information.
happy flashing
Ideally, most of this would be on a provider's website. Unfortunately, the NAPs of the world rely on multi-level sales staffing that present what they think is important(or differentiates them). The smaller colos who envision themselves the equivalent of the NAPs refrain from sharing much info as well and then the consumer ends up in a dim corner of "kinda/sorta generally acceptable commodity(service and quality) level colocation." It is then your burden to translate that to a customer why their LOLcats website is loading slowly for Uncle Bob. SLAs are hard and most providers treat them like a joke. If you're a startup and want to pass the buck, then just go with AWS. There is a solution for everyone.
Using NASA satellites to track hurricaines
quod erat expectandum.
Kind of sounds a bit like lucid dreaming, or astral projection.
HFT is just another area where everybody knows that it is broken, it does not serve any useful purpose for society, and everybody knows that eventually it will lead to a huge crash. And nobody does anything, because there is just too much quick money to be made. Humans...
I agree with your premise but your post is a case in point. There are as many words inside parenthesis as outside making it incredibly confusing to read. Even worse, you have a reference '[2]' nested inside parenthesis.

Using parenthesis like this indicates that it should be either a footnote or worded differently. Nesting it just makes my brain shut off.

I fall victim to using parenthesis in this manor myself quite often, its a hard habit to get out of.
Umm what? Yes they do and that is a pretty terrible analogy even if they didn't. Why do you feel the need to pollute a release thread with your VIM elitism?
Let us please not have this kind of comments on HN _every_ single time a css3 animation demo makes it to the front page...
Yes, this is a requirement of the NEC. Branch circuits need to be rated at 125% of the continuous load. In general, wires are sized not only on their overcurrent protection, but also (overbuilt) for the planned load. Unplanned "noncontinuous" loads get a free pass as the only thing that really keeps them in check is the overcurrent protection.

But kika's downthread comment is most on the mark - of course data centers would rather advertise the less relevant "circuit rating" as the number is higher. The load calculations are the same either way.

(btw speaking of the NEC, http://bulk.resource.org/codes.gov/ is a fantastic resource)
If there is anything I'd tell a new college grad it would be build a financial cushion as fast as humanly possible. I don't care if you are in debt from your loans... build one - immediately. And yes it is hard when you start out.

Why? You will hate your job one day and probably sooner than later. It just happens, its part of the learning curve. I don't mean that you are always going to hate your job but you inevitably will end up in a situation with a crappy boss doing something you didn't realize you signed up for.

Your cushion will give you perspective. Instead of looking at your crappy job as your life raft and clinging on for dear life, you will be better equipped to realize you have options. If you really don't want to go to that job anymore, you can reasonably wake up and stop the next morning.

Another thing that nobody talks about is that having a cushion can inadvertently gain you more respect in your workplace. I used to work for a group where one of my work buddies was pretty financially independent (this doesn't mean fabulously rich) and unlike everyone else who was desperate to keep their job my work buddy would speak his mind to management. When projects were unreasonable he would tell them to take a hike. Well guess who got all the interesting work and respect.

Seriously build a cushion if you are new to the work world - it only makes your life better.
Oddly enough, I was originally expecting that same thing.

Still, I think it's reasonable to ask the question: where does the boundary between good, useful hacking and evil, insidious hacking lie? And I think it's reasonable to not assume that the boundary lies at what is legal or that the boundary lies at what is "interesting".

I mean, how you produce and profit from spam is a hard, interesting problem. Flame and Stuxnet might, in some courts, be legal. In fact, a lot of "Black hats" satisfy many if not all of your list items.

The argument that HFT is working with a nearly zero-sum situation needs to be addressed. A "normal" startup is usually trying to create "new usefulness". Where do "props" fit in to this question?
I'm also having problems, but in Chrome on Arch. It hangs for a while telling me my git repository is being cloned, eventually telling me that [repository name] workspace already exists. Upon choosing a new name and continuing, it just keeps hanging indefinitely.
So who is this author and where can I read more about her? I think her name is Hazel Phillips?
I for one would say this about HFT, Facebook, twitter, and google. Though to a lesser extent for google as they have lots of other impressive projects such as self driving cars that could have a good impact.
Everything would need to be vetted and approved manually.

There would be a sort of self-selection that would come in to play - the only companies that would advertise there would be companies that are comfortable being public with that sort of specific information.

The salary one would probably need to be a range - $60k-$75k, for example. This sets expectations on both sides, although it might not stop a lot of misfit submissions, but those aren't generally stopped now anyway.
Your private API key, not your private SSH key.
This might be the one you're remembering: http://blog.jitbit.com/2011/05/what-if-drivers-were-hired-li...
If I understand you correctly, ST2 has both of these things already.

edit: Sublime has a CLI, but can't be run inside terminal.
The best one I have looked at was DBIx::Class
Panguite, a new ultra-refractory titania mineral from the Allende meteorite
I don't think the line is fine.

If I ask someone to implement a linked list during 1hr interview, it's clear that it's not because I need a linked list implementation in my company.

If I ask someone to stay for a week to work on the company's code base, that's clearly a work that should be paid for at a market rate.

Similarly, I'm pretty sure that you, as a designer, know without a doubt when company's request crosses the line from "I need to make sure you know what you're doing" to "I need you to do free work for me".
I completely agree that companies shouldn't do this, but I don't think that most people on HackerNews do. A while back a co-worker of mine wrote a blog post about how a patent troll signed up for our service, and we decided to let them use it even though we really didn't want to. That seems like the same story with the opposite outcome.

Nearly all of the comments on HackerNews said that the decision showed a lack of conviction and that we should have denied service to the patent troll. I don't think that's appropriate for all the reasons you listed, but it would seem that we're in the minority.

Note: I agree with you that companies should not be allowed by their users to get away with this, I don't agree there should be a law prohibiting it.
Honestly, I found that page (http://prgmr.com/san-jose-co-location.html) fascinating. Way better than the linked article.
I disagree. SEO serves a purpose. It makes web sites more accessible to users, by correctly using HTML (title, h1, alt="", etc.) and it makes the web more machine readable and thus easier to find useful things. But I guess you mainly refer to the spammer SEOs that try to trick Google.

HTF otoh does not serve any purpose whatsoever. On the contrary, it brings instability into the market and makes the market less useful. But my guess it that it will need a major market crash before HFT gets banned.
The thing is that "good" SEO isn't gaming the system but rather working to make sure that your site is a "notable authority" in whatever niche you're targeting. If the article is the counter-argument, what is the argument that HFT provides some similar kind of usefulness.
Callaway FT-I Draw Driver
Callaway FT-I Draw Driver
Nice write-up - thanks for this!
Exactly. $1.6 billion lost from customer accounts that were not supposed to be touched, and no one is arrested? It just evaporated into thin air? The entire thing is disgusting, and I pulled out most of my money from my futures trading account exactly because of this, because I didn't have confidence that I would see my money again. Hedging through futures is something that many commodities producers do in order to have predictable revenues, and they just lost their shirts because of criminal fraud, and nothing is going to be done.
> Why should our best hackers and mathematical minds be wasted on something so shallow as gaming the market?

The reason why these shops can employ the "best hackers and mathematical minds" is because they're willing to pay for them.

Everyone wants to hire 10-to-1s but nobody wants to pay them even 1.5x the salary of a blub hack. These days people say "We pay market rate!" and wear it like a badge of honor.
The site manages the entire process. It's both workflow manager and marketplace in one. The process of filling a position is pretty generic - you could satisfy something like 90% of hirings with a standard process. Think of it like a series of boxes on a page. The choices are 'Do this myself' and 'outsource' this.

As the tasks get completed the next step happens, and the site manages the whole process.

The job seeker would not have to answer questions at each step of the way. The information would be saved in the system so that each person managing the step (whether internal or outsourced) can see the output from the previous step.

The steps are something like : write ad, sort responses, initial screening, organise interviews, interview, negotiate offers. The company would choose which of these they want to handle in-house, and which they want to outsource. You could come up with a few templates to cover a large proportion of hiring in industries.

Restricting access is just done with the same types of legal terms that existing recruitment agents use. The site would include a reputational factor, the same as any other online marketplace. So someone who wants to have a at-home job sorting through CVs isn't going to start leaking the information if they want to get more work from a client.

Ideally the jobs would be listed on the site itself, but there's no reason it can't be used to manage jobs that are listed on existing (and popular) sites. The idea would be to leverage the network effect of other sites while building a base of clients for the site itself. So initially listings would be on the site as well as other popular sites. Over time, a strategy would be devised to drive the popularity of the site itself as a place for jobseekers to find work.
Clincher Carbon Wheels
So now suppose we refactor your database a bit, since all cakes are deserts and we don't really need to store that the fruit cake is both a cake and a dessert.

Suppose we make category have a self-join (add a parent_id field that references category(id)).

Now we want to make sure that when we want to list all deserts, all subcategories are listed too. Assume the possibility of arbitrary depth.

How easy is tht to do in your ORM?
I almost did this. My post began with this:

>>We have found that we are able to hire great writer

>I see.

And was only going downhill from there.

Don't worry about it, we're all there.
Trading is a zero-sum game, but investing is not, and trading exists to make markets and snipe inefficiencies. The amount of money that can be made here can be surprising, until you consider that they're oiling the gears for manifold trillions of dollars in commerce and wealth. Some of that is gambling, but most of it isn't. Stuff like institutional hedgers and investment funds are huge sources of market activity.
That's clever and might work. Of course, I'm no expert on German patent law (nor on US, either, but I'm betting few to none on HN are), but perhaps there's a different standard? I'm wondering if the large encompassing "... embodies any design ..." will be a gotcha.
4) waiting on the right bids when you just need to hire someone.

5) Outsourcing the DNA of the company to the lowest bidder.

If your idea or your management team suck a recruiter can only do so much. Once you are worth your salt you can hire one full time recruiter and be done with it.

Recruiting is more important, not less important. Commoditizing it means you don't know how to build a company.
well, that's the fun of specifics, innit?
That is a very good point.

I know the exchange can automatically put a halt to the trading of an asset, and that seems (to me) like a good tool in this case. e.g. if there is a certain pre-defined amount of volatility in a certain time. Do you think that would address this concern?
In the same vein, I think it's irrelevant even if affects the Tab 2 10.1. In terms of sales, none of the Tabs are significant to Samsung, relative to phone sales. I know someone can quote great sales numbers, but those tend to be the result of stuffing the channel. Out of every 1000 iPads I see in the wild, I see may 2 or 3 Tabs (though that number rises a bit when I'm at a tech conference. However, I see TONS of Samsung phones everyday.
Sure, it's not as flexible, especially the totalitarian systems, though co-ops aren't as simply structured in their mature forms.

Look up "Mondragon" for what a modern form of distributist co-ops look like. Not the same share of profits, equity investment is the rule (limited to workers or co-op friendly orgs), and there are many other interesting aspects.
The problem of HFT is two.

First, HFT is very difficult. It requires the talents of extremely intelligent individuals. These individuals are a scarce resource. Now, being as they are near the generation and handling of money, HFT firms are best placed to outbid all others for these people. So R&D and other such lose out on top minds. Additionally, if much of the money of high net people is being invested in funds without finding its way into risky high tech research, this too can be a drag on the economy in the long term. http://sirc.rbi.org.in/downloads/4Cecchetti.pdf

The second is a problem of misaligned priorities. It's one thing to suck in all the best minds and it's another to have them all expending a massive amount of effort trying to shave down microseconds so their order goes in first. Chris Stucchio here http://www.chrisstucchio.com/blog/2012/hft_whats_broken.html argues very well that the so called sub-penny rule (abs(changeinprice) >= 0.01) is antiquated and from a time when humans reigned. This rule is a source of friction for the bots and is very likely a key player in the current misallocation of talent. It's removal would make HFTing cheap enough that not so many people would be needed. Some would leave to cure cancer or mine asteroids. The rest could then work on more sophisticated pricing techniques - which is a net boon, maybe those techniques could make prices more stable or be reused for optimal donor matching or something.
Project Moonwatch: Relationship between moon cycle & person’s emotional states
I missed out on the whole story, what happened?
How C trace functions really work
Level 4: You realize all abstractions are leaky. Yet, you feel comfortable using appropriate abstractions based on the use cases.
Software Giveaway at WinXDVD.com: Antivirus, PC Speedup & Partition Manager
These days, winxdvd.com is giving away considerable numbers of Advanced SystemCare Pro 5, Ad-Aware Personal Security, EaseUs Partition Master Pro, Kingsoft Writer Std 2012, etc for this summer holiday. Complete but free PC security and speedup solutions are provided, with the permission and support of the respective software owners.
Chris, MemSQL utilizes versioning to implement READ COMMITTED. In this implementation readers are never blocked.

It is addressed in this FAQ: http://developers.memsql.com/docs/1b/faq.html#c1-q4.
Ask HN: Any YC or other start ups looking for a college hacker?
Greetings all,

I am a regular here on hacker news and see all these people doing amazing things and was wondering if anyone would be willing to work with a college student remotely ( for now). I want to work for a start up (remotely at first, but willing to move after graduation). I currently attend the University of South Carolina, here is some information about me:

I have a 4.0 GPA and I am apart of the honors college, and have 2 semesters left until I graduate with a computer engineering degree and a math minor. I am currently interning with Intel doing software development(mostly). Before that, I worked as the main back end developer for a startup for 8 months(did mostly PHP and MySQL). Before that I did 2 years of research experience including DNA sample analysis(new algorithms), Protein folding on GPUs, and soon work with FPGAs. I love programming and software development as a whole. I have all the usual skills C,PHP,MySQL, Python, Erlang(some), Java, and w.e. else you might need. The largest application was a program called JASPER that I wrote for the South Carolina Law Enforcement department for matching DNA repeat segments. It was about 20 k lines, in java, multi-threaded, and feature rich. I am willing to learn anything and would love to work on scale (yeap scale)!

So if anyone is willing to take a shot at me, email me at ahmedkhawaja91@gmail.com
Or you could save money and just buy a lower bin.
Show HN: Jekyll SEO script
Reading this, one gets the impression that she's part of the problem that she describes. Living in the Bay Area, I loathed that SF culture enough to not spend any more time there than necessary. Which doesn't mean I thought more of San Jose, merely was able to easily ignore it.
Hey Everyone,

I recently rotated my blog from wordpress to jekyll and missed the functionality of the SEO plugin. So, I decided to write a simple script to replicate the functionality. Hoping a few others can benefit.
I suspect it's referring to per-volume density, not per-area density.
So this guy is an employed PhD (at the job he "wanted most") and writes a blog post about how emotionally traumatic receiving rejection notices at normal (if not below normal) rates was. I don't get it.
I suppose it is somewhat related to physical security and the general mistrust of TSA agents by some HN readers. I agree with you though - not quite HN worthy.
Have you guys checked out recruitloop.com.au? They're on the same road: ie. changing the industry by changing the incentives (their's is an hourly pay model).