Database

PGCon2010: Perspectives on NoSQL [Gavin M. Roy, CTO of MyYearBook.com]

http://www.pgcon.org/2010/schedule/events/219.en.html http://www.pgcon.org/2010/schedule/attachments/141_PostgreSQL-and-NoSQL.pdf

[RUS]Проектирование френдленты и рейтингов / Проектирование БД : Форум на SQL.RU | [Forum SQL.ru] Modeling frendlist, ratings

http://sql.ru/forum/actualthread.aspx?tid=754989 Some comments on modeling friendlits user activity, for social media websites (or apps)

InsideBufferCache.pdf (application/pdf Object)

http://www.westnet.com/~gsmith/content/postgresql/InsideBufferCache.pdf “There’s very little information about PostgreSQL buffer cache

Try Redis -- Reddis Database online demo

http://try.redis-db.com/ very cool demo. Reddis command prompt in AJAX

GreenSQL | Open Source Database Security, SQL Injection Prevention

http://www.greensql.net/ SQL-proxy/filtering software for MySQL and PostgreSQL databases, used to prevent SQL-injection-like attacks, filter-out dangerous SQL, etc

Checkpoints and the Background Writer: PostgreSQL 8.3 Improvements and Migration

http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm improvements to PostgreSQL that could be made by tuning wal/background writer processes

Tuning PostgreSQL WAL Synchronization

http://www.westnet.com/~gsmith/content/postgresql/TuningPGWAL.htm Notes about PostgreSQL WAL synchronizations methods

[RUS] Подсчет количества найденных записей в PostgreSQL / Хабрахабр

http://m.habrahabr.ru/post/30046/ PostgresSQL: how to count number of rows returned by a query and do it fast

[RUS] Оптимизация AUTOVACUUM 8.3 / PostgreSQL : Форум на SQL.RU / PostgreSQL Autovacuum Optimizations

http://sql.ru/forum/actualthread.aspx?tid=685680 some notes on how to optimize autovacuum on Postgres

[RUS] Доступ к PostgreSQL из ASP. / PostgreSQL : Форум на SQL.RU

http://sql.ru/forum/actualthread.aspx?tid=548788 DSN-less connection for VB/Classic ASP to PostgreSQL/ODBC on windows