Over at the Command Prompt blog, Joshua Drake makes a (probably deliberately) provocative point about “users” not wanting replication, as opposed to “customers” who do. I’ll confess I’m not 100% sure about his distinction between “users” and “customers,” so I’ll just make something up: Users are the people sitting in front of the application, entering data, buying shoes, or doing
What does this mean?
It clearly means something along the lines of, “Can handle lots of transactions per unit time,” but how many?
I mean, WordPress with WP-SuperCache is “web scale” if all that is meant is, “Can be used to implement a high volume site,” but I assume those who are touting something as “web scale” are
A well-known issue that can come up with Django sites running on PostgreSQL is that connections in “Idle in Transaction” state can pile up. There’s a relatively straight-forward fix, but ultimately, it’s due to a bug in Django’s transaction management, at least when PostgreSQL is the back-end.
Let’s run through it.
If you are having them, the fix is here.
Here are the slides for my talk at PGXPUG Day OSCON 2010.
The slides from my talk, Introduction to PostgreSQL are available here.
The archive video for the February 9, 2010 SFPUG meeting is now available:
For downloading, the direct link is here.
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.
Brent Simmons has a very good piece about switching away from using Core Data to using SQLite directly in his iPhone app. Substituting “any common ORM” for “Core Data” (which, after all, is all Core Data is) and “any SQL database” for SQLite, he encounters the most common problems that plague those trying to develop scalable solutions on top of
The archive video for the December 8, 2009 SFPUG meeting is now available:
For downloading, the direct link is here.
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.
The archive video for the November 10, 2009 SFPUG meeting is now available:
For downloading, the direct link is here.
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.