News for hackers. Stuff that matters.
Re:Why doesn't Quora use PostgreSQL by code_duck on Monday July 26, 2010 @01:00AM (#1547184)
That's why database abstraction is so nice. If I ever get sick of MySQL - or say, decided I didn't want to use Postgres - it's not hard to switch!
Re:Why doesn't Quora use PostgreSQL by scg on Monday July 26, 2010 @02:21AM (#1547304)
Database abstraction isn't, or at least isn't practical.

Small projects don't need an interchangeable database. Bigger projects won't let you get away without making assumptions about the database. Nothing but the basics work the same between SQLite and ORACLE.

Re:Why doesn't Quora use PostgreSQL by code_duck on Tuesday July 27, 2010 @06:34PM (#1552966)
SQLite... Oracle? never used either one, but I believe it.

I'm talking about MySQL vs. Postgres.

Re:Why doesn't Quora use PostgreSQL by mhd on Monday July 26, 2010 @03:01AM (#1547363)
Depends on your abstraction system. If we're talking about SQL, the incompatibilities abound. And ORM's or other libraries tend to be either very, very complex or tend to implement everything in the most simple way. Both not very good for performance. Never mind that most frameworks don't have the same level of support for every DB (open source libraries tend to have very limited Oracle/SQL Server support)

And this is only talking about queries, once we get to triggers, constraints or even stored procedures…

Re:Why doesn't Quora use PostgreSQL by code_duck on Tuesday July 27, 2010 @06:37PM (#1552978)
I'm thinking on a fairly medium scale, I guess, and mainly just about PG/MySQL. (You mean other databases exist?? Never even seen such a thing!).
Re:Why doesn't Quora use PostgreSQL by drivingmenuts on Monday July 26, 2010 @01:59AM (#1547275)
It's very helpful to know what's going on behind the scenes of that pretty little database abstraction, though.
Re:Why doesn't Quora use PostgreSQL by code_duck on Tuesday July 27, 2010 @06:34PM (#1552969)
If I ever have to care, hopefully I'll be hiring some guy with a beard to think about that for me.