Hacker Newsnew | past | comments | ask | show | jobs | submit | 2007-03-18login
Stories from March 18, 2007
Go back a day or month. Go forward a day, month, or year.
1.How to be creative (gapingvoid.com)
13 points by sofus on March 18, 2007 | 3 comments
2.Creating Passionate Users: Is Twitter TOO good? (headrush.typepad.com)
11 points by noisemaker on March 18, 2007 | 5 comments
3.Who wants to discuss about MySQL vs PostgreSQL?
9 points by volida on March 18, 2007 | 11 comments
4.O'Reilly Radar The Web 2.0 Address Book May Have Arrived (oreilly.com)
8 points by brett on March 18, 2007 | 4 comments
5.Secret of Google's simple design: founders didn't know HTML (blog-city.com)
6 points by jcwentz on March 18, 2007 | 4 comments
6.20 Smartest Companies to Start (cnn.com)
6 points by domp on March 18, 2007 | 1 comment
7.New ted talks are up. tech/entertain/design (ted.com)
5 points by socmoth on March 18, 2007
8.Make Way for Copyright Chaos - Lessig on Viacom vs Google (nytimes.com)
4 points by brett on March 18, 2007 | 1 comment
9.University lecture notes in math, computer science and physics (lecturefox.com)
5 points by sharpshoot on March 18, 2007
10.2007 Web Predictions (readwriteweb.com)
5 points by jamiequint on March 18, 2007
11.Mobile 2.0 (blueflavor.com)
4 points by jamongkad on March 18, 2007

I had been reading numerous articles comparing MySQL and PostgreSQL and ran across this one. I wish they had mentioned some information about the configuration of the DBMS itself, such as the size of database buffers and query optimization settings.

Also, for their MySQL test procedures, I could not find any information regarding which storage engine they were using. InnoDB is fully ACID-compliant, whereas MyISAM has reduced overhead since it does support transactions and foreign key constraints, for example. I found a good article, http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1/ , comparing the two storage engines, and the results were pretty surprising to me.

It ultimately comes down to your individual usage patterns. Using a database abstraction layer will allow you to test your application against different databases so you can see how your application performs first hand.

13.Jason Fried - web apps, cash flow and pricing (thinkvitamin.com)
4 points by arasakik on March 18, 2007
14.GigaOM: Fox executive new TechCrunch CEO (gigaom.com)
4 points by carefreeliving on March 18, 2007
15.X/HTML 5 Versus XHTML 2 (xhtml.com)
4 points by pg on March 18, 2007 | 1 comment
16.Hackers promise to begin disclosing security bugs in MySpace every day next month (momby.livejournal.com)
3 points by danielha on March 18, 2007 | 2 comments
17.Thanks to Bryan Kennedy of Likebetter for most of the new look (aboutbryan.com)
3 points by pg on March 18, 2007 | 3 comments
18.Creating Passionate Users: Seven Blog Virtues (for a Global Microbrand) (headrush.typepad.com)
3 points by noisemaker on March 18, 2007
19.Ex-Livedoor chief gets 2.5-year jail term (ft.com)
3 points by sszhou on March 18, 2007

I've used both and prefer Postgresql. Mysql with MyISAM is "faster" in the same way that bicycling down a hill with no brakes is faster. Mysql 5 with InnoDB is a little bit more serious and is worth considering.

Sounds exactly like what I would expect from a VC and exactly the opposite of what someone like Larry Page would do. I think my energy is better spent fixing valid critiques and requesting a follow-up review once you have.

Better to build something that can stand up to the harshest of reviews than run around spraying perfume on dung.


Anecdotally:

I used to work for "Grand Central Communications". It was really a vision of what not to do with a startup: Enormous development cycle, bleeding money (Hasley Minor, the principle investor and CEO, used to compare it do driving an Audi off the roof of the building every day), way too many people, sales team constantly selling functionality we did not support.

In late 2005 after multiple rounds of layoffs they cut their losses and folded. Existing team members willing to stick around formed Swivel (http://swivel.com) based on what we were working on at the time (which had nothing to do with what Grand Central was doing a year earlier). The name (and I guess trademark) "Grand Central Communications" got inherited by a VOIP company that was also funded by Minor Ventures (http://minorventures.com/) and that's the company O'Reilly is talking about. Good to hear they're turning the name around.


Becoming an SMS spammer is among the 20 smartest startup ideas? That would be pretty sad if it were true.

Our Ruby on Rails app uses PostgreSQL (for now but that will change). We started off with MySQL but after growing quickly, we were forced to look into partitioning of the data. PostgreSQL was made to be easy for advanced stuff like that. We tried to do it with MySQL and failed because we're not MySQL experts and we managed to get it working with Postgres. Postgres has better documentation than MySQL so that might be the factor if you don't have a DBA you can readily ask for help. Here's a write-up by someone who went through similar process:

http://enfranchisedmind.com/blog/archive/2006/11/04/166

Also, if you use Postgres on multi-CPU machines, it's faster than MySQL. But, make sure you read this:

http://www.suite101.com/article.cfm/oracle/115560 (comparison of Oracle/MySQL/PostgreSQL)

One last word of advice if you end up using PostgreSQL, learn and use this:

http://pgreplicator.sourceforge.net/

Finally, we are moving back to MySQL because we found a really fast replacement for the MyISAM storage engine (a lot faster than Postgres) and our part-time DBA knows MySQL and this new storage engine a lot better than Postgres. We are also moving to VPS architecture and Postgres' performance advantage over MySQL on a VPS doesn't really exist.

In the end, go with what your staff/friends know and what your hosting place recommends. If they have an optimized DB stack and provide some kind of a support for it, stick with that DB because you can always go to them for help!

25.Are Mobile Operators stifling Mobile Innovation? at ExperienceCurve (experiencecurve.com)
3 points by jamiequint on March 18, 2007
26.The Penny Gap - In-Depth (darrenherman.com)
3 points by python_kiss on March 18, 2007

This article is spot-on! As an angel investor, I routinely hear pitches about different mobile apps. My answer is always a big NO and I try everything to persuade small startups that have not spent any money yet on the idea, not to pursue it. If you have an idea for mobile handset market, read about "walled gardens" (google for more links): http://en.wikipedia.org/wiki/Walled_garden_(media)

Unless you have some extremely strong connections (i.e. you have an ex telco exec on the board or as a CEO), stay clear of ALL closed platforms. (Incidentally, and that also includes Windows/MSOffice/Exchange etc).Startups need to be agile and startups have a higher chance of becoming successful if there are less barriers that you need to jump over, not more. This is why Internet is a perfect platform for startups... there are virtually no barriers (unless net-neutrality is defeated)!


What he said really struck home with me, too.

"If you're interested in startups, don't sit around waiting for the perfect opportunity, just go find one that sounds interesting [...] The startup will probably fail, but you will succeed because you have learned a lot more than you otherwise would have."

It's exactly what I've heard so many successful people say.

The startup path is a scary one for me, but spending my life as a "worker bee" is even more scary somehow...

29.Where Old and New Media Collide (sfgate.com)
2 points by danielha on March 18, 2007

good initiative. well done.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: