skysight-inc/HackerNews huggingface dataset:
As for "show tables", there's a big difference here.

"show tables;" is a server-side command. \dt is a command you give psql to say "ask the server what tables there are and list them." \d stands for describe. If you use a graphical client, it will have to query the system catalogs itself which you can do if you want.

As for replication, the real challenge is that replication is not a one-size-fits-all thing. Slony, Bucardo, and the built-in streaming replication have different limitations. For example you can't replication from 9.0 to 9.1 with streaming replication but you can with Slony and I would expect you could with Bucardo too. So with the out of tree replication systems you can actually have a zero-downtime upgrade as long as you block writes during the upgrade of the master. With streaming replication, assuming pg_upgrade is supported for your upgrade, you only have a short downtime window, but it is downtime.

Also streaming replication is all or nothing. With Slony you can replicate different pieces of your database. On the other hand, with Slony, you can (accidentally) replicate only a piece of your database.

So the differences give you a lot of flexibility there, but you need to have a clear idea of what you need and why you need it before choosing a replication solution. Slony is perfect for what Affilias uses it for, while streaming replication wouldn't meat their needs.

Also I don't think that PostgreSQL suffers from a lack of mindshare. Ever since I have been building apps on open source db's, PostgreSQL has been regarded as the go-to database for complex business apps. The sorts of things people do with the database are different. There is consequently a huge "dark community" if you will (in the sense that you don't see them).

This was driven home to me when I went to the Malaysian Government Open Source Software convention last year. There were two booths (Oracle and one other) which had the MySQL logo, and a few more that were offering MySQL services, while I counted at least 5 that were using the PostgreSQl logo. Most of those were reselling EnterpriseDB's PostgreSQLPlus but it when I looked at the level of interest and the number of government deployments I was asked about, it was clear which people were usually choosing for complex work.

As for user-friendliness, MySQL used to be much more user-friendly than PostgreSQL but I don't think that's true anymore. The command-line tools are more full-featured and the in-app help is better on PostgreSQL. \? brings up a list of psql client-side commands and what they do for example, and \h [command] will give you a summary of the syntax of an SQL command. I use \h quite a bit when I am trying to remember the specific syntax of a new feature, or when I am doing something I rarely do (like ALTER TABLE). I think that since about PostgreSQL 7.3, PostgreSQL has been at least as easy to use as MySQL, and quite frankly far more robust.

Finally, the PostgreSQL planner is awesome. I have not had to rewrite a query to get around planner limitations since 8.1.
The $14 million was to make up for unvested options and such she gave up by leaving Google.
And I, also, disagree. I'm using the Developer Express ORM, XPO, and it provides 'drop-in portability' between a range of databases.
I've successfully run my small-mid scale app on three different backends - MS SQL, MySQl and Postgres - simply by changing the connection string.
Yes, it's .NET / Windows only, but drop-in portability is definitely not a myth.
$100 million dollars? Really? How could that be cost effective?
I have one customer who uses MySQL because they wrote their app around the query cache. The data is aggregated and then fed into PostgreSQL for real processing, and eventually reports generated and shipped back to MySQL....
While the internet was probably a good source of information I'd play it down to mentorship as the decisive factor. In all of these cases, the successful teenagers seem to be lucky enough to either have a good private mentor, be enrolled in a mentorship program, or be enrolled in a highschool famous for the encouragement and resources that it provides to it's enterprising students.

In contrast many of us would have been told to "aim for a simpler project" if we proposed something like that to our computer science teachers.
That's a great suggestion that's often overlooked.

At Quantcast we tried to use "//" without the protocol in our tags (to eliminate the need for a separate http: and https: tag), but we had a huge number of complaints about a bug in our tag (missing http:!). Users also tried to be helpful and add in the "http:" and then complained when it broke. In the end we went with two separate tags to reduce the support burden, despite the added complexity of having to explain the two tags.
SSL/TLS is not computationally expensive any more[1] but there are some things that can help/hurt discussed in the footnote.

[1] http://www.imperialviolet.org/2010/06/25/overclocking-ssl.ht...
Agree. However if I were to say anything bad about the interviewer I'd go with the line:

> "Good luck in the future and I have a feeling we're going to be seeing more of you in the (uhh..) future."

That's just bad interviewer.
Some of those are not protected classes under Federal law, specifically sexual orientation.
Roof Painting and Repairing Services
Home Style Roof Painters is roofing experts and Housing Industry Association endorsed offers all kinds of roofing services including roof painting, roof restoration, roof repairs, tile roof restoration and may more roofing services.
Yes, why not? It's selfish, whoever does it.

That said, the implication that a mother being close to a new born child is completely equal to a father being close to a new born child is PC ideology.

We're not inter-changeable thinking machines. He have cultures and we have bodies.

For example, distance from mother during early months has been shown to have negative effects on the child's development. The same for not breast-feeding. Distance from father, much less so. Hell, even negative feelings felt by the mother while the child is in the womb are shown to affect it.

So, no, just because some people have wishful thinking dogmas that "we are exactly the same", "interchangeable" etc, it doesn't mean it's true.
With MySQL (and Oracle before that) it was common to simply move different parts of the database data files to different disks. I don't use Mongo so I can't speak to that, but the concept works pretty much universally. See here for more information about spreading your database around multiple disks: http://www.mysqlperformanceblog.com/2010/12/25/spreading-ibd...
IMO if you are truly, actually, really serious about hiring the best of the best, you'll hire them wherever they live. Moving to the USA shouldn't be required or necessary, particularly in software development.

This is why the Internet was invented.

Otherwise you're just hiring "the best people we could convince to move to {location} for {competitive salary}".
I'm going to take a bit of a different tact than just saying "here's how to do it".
The important thing may be "are you sure you're ready"??

You've been working hard, you're excited, but where are you really at? Have you gone through beta? Have you got some users? Have you gotten the feedback, is your messaging set?

I think you'll have a real challenge getting into the major tech blogs before you've got a social network with activity, and the activity you get from the publicity might not help your business to grow in the long run.

Specifically for a social network, if you get on TC and you have a social network without activity and content, you're not going to get very far.

My advice, is get out there and build the base. Make sure you've got the right amount of activity (you define that), find out what parts of your business are really resonating with people, and figure out the message/soundbite that makes a difference. When a few pieces fall together, you'll know, because writing to the tech blogs will be a piece of cake when you say "[original angle that resonates with users] provides [x]% growth over the last [x] time period" or something along those lines. That actually isn't catchy enough.

Another tactic is to not go directly for the big blogs. I got covered by a bunch of smaller blogs, and that's where TC and TechRadar found out about my site.

Another way is for you to basically write the article for the blogs, and let them basically edit it for print. The more work you do for the writer, the more likely they are to just do a quick edit and then post it. I haven't done this myself ,but I've heard of it done.

If you want to get some PR, you can also write an article about your industry which is not directly about your business. You'll see lots of these articles on TC. This may drive some people to check out your site, and help it to grow, even though you won't have your name in lights.
Obviously it depends on what you are doing. However, if you are trying to keep everything in one consistent environment it does win out.

Also I expect that with 9.2 we will probably see a release of Postgres-XC which will kick the pants off any MySQL sharding solution out there.

Postgres-XC is a way to abstract database shards such that referential integrity etc. is enforced between shards. The best comparison to date would be to Teradata's clustering system. Better yet, Postgres-XC is just a set of patches on PostgreSQL, and is on-the-wire compatible, so you can swap it out when your database gets too big. This will also bring an ability to concurrently query different shards and aggregate the results without the application having to know anything about the sharding....
>But if you can continuously update the live site its not that big of a deal if a bug gets out. It will be noticed soon, often by your users, and then you fix it and that is it.

You consider this acceptable? "Don't worry, if there's a bug, our users will tell us, no need to test!"
basically the Joel Test is out of date in a few areas. It reflects a Microsoft Excel development-centric view of the world. The way Excel was built and shipped in 1993 no longer reflects the way most software is built and shipped today.
Cara mengetahui alamat RSS Feed Blog kita
Academic journals face a radical shake-up
Laptop repairs
Notebook and Laptop Repair and Troubleshooting Tips. Laptop repairs Laptop repair guy helps to find and fix the problem. Best sony laptop repair laptop repair service company in UK. We offer Chip Level repairing for HP Compaq Dell Acer Toshiba Sony Laptops. Our laptop repair services include LCD repair, motherboard, power jack repair, etc for Dell, HP, Sony, Toshiba, Lenovo and other laptop brands.
Search reed diffusers in a different manner through web.
Reed diffusers have an amazing fragrant smell while being flame-free. Definitely no warm is required. This makes them safe for workplaces, assisted living facilities, houses. For more info visit http://www.aromadiffusers1.com.au/
Brooklyn Math Tutoring | 718-223-0228, adminTutorState.com
Online Watch Store
Finest Watches carries a huge selection of top brand watches including Bovet, Cartier, Hublot, IWC, Panerai, Rolex. Buy finest watches for men and women with affordable prices at online Finest Watches watch store.
Your wife totally sounds like the story of Michael Ellsberg (www.ellsberg.com), while yours is similar to Joe Mihalic (www.nomoreharvarddebt.com).

What's your income situation right now? You can try to negotiate the interest rates down to minimize your monthly payments. Once you are able to handle the payments and workload with ease, I strongly suggest to start with freelancing on the side. Most successful entrepreneurs I know start off with consulting and freelancing before productizing their services or physical products.
Wow. The most wonkish think I remember from high school is learning about the Balmer series (atom
spectral emissions)
You jest, but what if she needs to get this done:

http://upload.wikimedia.org/wikipedia/commons/thumb/8/87/Man...
We publish a free weekly newsletter of the best articles and resources on mobile app development, curated from across the web.

Every week we have a section featuring tools for iOS and Android developers, as well as case studies from app entrepreneurs, advice on how to market your app, tutorials and resources on app development and inspiration and tips on mobile app design.

You can subscribe at: http://tinyletter.com/hackrocket
In my experience you don't want to provide X as a service based on a third party closed product (meaning: anything not open source & open community).
It is a protected class under NYC law: http://www.nyc.gov/html/cchr/html/aunderthelaw.html
Your vitriolic remarks detract from your objection. The level of discourse around here is tanking faster than my Aunt Bethany at Thanksgiving dinner.
Come on -- cut him a break. You cant literally analyze each and every word / sentence like that - unless its like a major goofup
Your post summarizes Malcolm Gladwell's book Outliers on extremely successful people quite well -

it's mostly being born to a) rich parents who can afford to pay for extra-curricular activity, good schools or who have the time to "improve" their kids or b) being around schools or universities that can recognise the talent and give talented kids the input and resources they need. Both a) and b) are based on pure luck.

For an example, check out Bill Gates' early life: https://en.wikipedia.org/wiki/Bill_Gates#Early_life

Rich parents, exclusive school (with their own computer! unheard of at the time) and local companies that let Gates and other kids screw around on their computers. Luck!
Tests are important, as are dedicated QA engineers.
A very misleading, alarmist article. The number of layoffs year over year may be up, but that says nothing about overall employment. Also a few big rounds of layoffs from some giant firms that have been on a downward trajectory for some time is skewing the numbers.
The fact that everybody uses a particular technology does not in fact answer the question of which scales better or which cannot scale.

The fact that many large companies and organizations have successfully scaled a particular technology is a useful yardstick, and while it does little to answer the question of which scales better, it does, by the process of elimination, help answer the question of which cannot scale.

I don't know about others here, but I would welcome actual objective information on this topic rather than sarcasm and an appeal to popularity.

I had hoped that others here would enjoy the sarcasm in the context of the full-throated yet fact-free advocacy of the parent, the text of which somehow still remains legible on an off-white background.
It seems like his case has been terribly mishandled. Those who caused that to happen should have their careers suffer.

But he's arguing that people who produce a product should be ok with him both profiting from that product instead of them.

There my sympathy ends.

He's not arguing "information wants to be free", he's arguing "I should be able to make money from your information."
Vitriolic - really ? Sorry but I just cant think of what else i would call ignorance.
No. Clojure is fine. I actually think that everyone's first functional language should be scheme, but Clojure is not too different.

Erlang, Haskell, and Scala all want to sell you on some broader paradigm of functional programming, but they're all still functional at their core and understanding the fundamentals is far more important.

Node.js isn't a language, it's just some libraries added on to Javascript.
Orthogonal problems. In my case, they wouldn't need to convince me to move. They just need to help me find a legal way to stay.

Yes, they could just as well try to have people working remotely, but then it's another set of arguments that need to be taken. Joel never wrote about how working remotely is "just as good" as working in a office environment geared towards developers - quite the opposite. So I could understand why FogCreek/SE would require people to work locally, but I still don't get why they can't put some effort to sponsor visas.
To build a business it takes someone who either understands the particular nuances of that particular business from their prior history or are capable of picking it up very quickly and effective on the fly. at im saying there's not value in testing a theory and not over analyzing, but an effective idea guy is necessary to truly disrupt a market.
To win at disrupting, you have to understand a market as its currently is, all of its inefficiencies and weaknesses combined with future changes in capabilities and technology. However usually an engineer as likely to be an effective idea guy, combined with their ability to build and ship it puts them at an advantage. Great idea guys are rare, but when they surround themselves with the proper technical talent its a thing to behold . Tarantino, Jobs, list is endless
I was instantly reminded of David Evans (from UVA and Udacity fame: http://www.cs.virginia.edu/~evans/) listening to this kid, both physically and in his manner of speech.

I really expect to... eeeh... see more of him in the future.
> That's only the salary.

Like I said, it's still very low for a CEO salary.
How the hell is a factual title "sensationalist"?

Please, enlighten me.
"Often the case for using custom data types, for example, is quite weak..."

Lots of people come to the postgres community because of PostGIS, which is (among other things) a custom type distributed separately from postgres.

Using custom types is not bad, the mistake is thinking that making a new type is easy. For a non-trivial custom data type, you need to tie it into the indexing system (GiST+KNN, GIN, SP-GiST, BTree, Hash) as well as the optimizer (have some good stats functions) -- not to mention the basics like a good representation and a well-thought out set of functions and operators.

Custom data types are really one aspect of an extension, albeit a crucial one. So don't think about it as "hey, I'll make a new phone number type because it sounds cool", think about it like "we need better support for genomic data in postgres, let's sit down and plan a serious extension".

If you want a special type for a phone number, use a domain over text with a check constraint. And that's SQL standard, too.
A very, very good business guy can call up his rolodex and sell your software X times for 6/7 figures a pop prior to a single line of code being written. To do this, you need a) a rolodex, b) personal credibility, and c) sales skills. That guy is richly worth the half of the company he's getting in a two-man founder scenario.

Sadly, really good business guys are rare like really good engineers, and totally incompetent business guys are (bare minimum) as prevalent as programmers who can't FizzBuzz. There are many people who can, by writing their best idea ever on a napkin, deprive the world of a perfectly serviceable napkin.

(Really good business guys are priced higher than really good engineers, principally because their skillset necessarily includes not being totally stupid about money, negotiation, leverage, or scarcity.)
I believe the visa issue is thorny, not just because of the money, but because of the logistics and lawyering and so forth.

It'd be easier for everyone involved to just acknowledge, like GitHub does, that remote devs can be extremely kick ass.

To be clear, Stack Exchange and Fog Creek are different animals in this area. But Joel is, at his heart, an "everyone must sit down to lunch at the same table or the entire company is doomed" kind of guy. Me, not so much.
> I challenge anyone to find any posts questioning any other CEO's parenting choices. (Bonus points if top voted for on a story).

Personally, when I become a father, I would like to either take time off, or take a job which isn't much stressful. I tend to overindulge. It would mean either I am too serious about my job, and my child is left out; or I am too engaged in my child to actually care about the job. I am not that good at little bit of everything. The public persona of the people you have named(Gates, Brin...) conveys they don't dip their toes in water, but like to dive in head first. I might be wrong, but to me it would look like they can't possibly handle the child and the job at the same time. So yes, I would question their fitness as a father when they take up a challenging job while their child is on the way.

> I challenge anyone to find any posts questioning any other CEO's parenting choices. (Bonus points if top voted for on a story).

Get out from under the rock, and you will see what kind of shitty attitude exists for Gates(who is doing more good than anyone and everyone talking about him), Jobs(who has ardent admirers and ardent haters), Ellison(seriously? People might be biased, but I have never heard good things about him)...

> But a woman steps up and suddenly HN cares about her child and votes up a comment questioning how her decision affects her child and second guessing her motherly quality.

I don't know. Why is it bad to ponder the child won't get the required attention if a stressful job takes most of your time. That holds true regardless of gender. Now, I might be totally wrong, and you can be a better at time and life management, but I don't see why you see the need to vilify me for saying so.
Yes. Not all bugs are the same in terms of end-user impact and how they affect the overall performance of the system. You can expend a lot of resources trying to track down every single last glitch in many cases you should. However, if you have the luxury to be able to push updates and fixes at any time and you a free non-critical service, its better to just have a culture of fixing things quickly and allocating resources to more high-priority things like adding new features.

More eloquently stated:
http://www.quora.com/Quality-Assurance-QA/When-is-not-having...

Ideally, most of the testing should be automated and engineers should be writing test cases as they build features.
How do you test that your gui works correctly when the user is running ie6? How do you write a test to ensure that animations are smooth?
Only Americans believe that 130 hours in the office constitutes a 130 hour working week. Which is why the French work 35 hours a week, yet Airbus is as productive as Boeing.
It wasn't an operating loss -- it was a writeoff of a bad investment. They took the loss right now, but their cash position didn't change. Just, their reported income and taxes due got lower.

Still significant a bit, but much less than an operating loss instead of a writeoff would've been.
Which just goes to show how old that is. Which tech company wants to be in ms shoes, without the pegacy cash cows?
I have to say, I'm not very fond of hyperbole-laden posts such as this one. People who devote the time and enthusiasm learn the details and hopefully enlighten themselves. People who lack that kind of enthusiasm will likely be confused throughout their lives across many of fronts. What is so surprising, interesting or new about this?

Things are often called what they are called for continuity and for legacy reasons. What does it matter if we call it "Functional" vs. "Expression-Oriented"? Will Haskell, ML, Clojure, etc. or their impression on people change overnight because we have a new cool name? I guess a bunch of new/experimental library now claim to be Functional, but so what if they do?

Maybe it's a bit too late here, but I don't see the point in this kind of sentiment.
With the exception of example 3 (which is possibly a bad example, see the discussion above), this is because of how much code is necessary to tell what's going on, rather than an increase in code size.

Example 1: 5->1: It did get shorter.

Example 2: 5->8: One of the lines is showing a line calling the check_for_overheating method, which wasn't shown in the first example. The other two are declaring the SystemMonitor class, which was declared "off-screen" before.

Example 4: 7->13: Five lines for declaring and defining User.address, which was off-screen before. So it did get a line longer.
Bunnies, Kitties, and... hackers? The shocking way they’re all alike