Archive for the 'database' Category

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

Wednesday, May 5th, 2010

Some comments on modeling friendlits user activity, for social media websites (or apps)

InsideBufferCache.pdf (application/pdf Object)

Monday, March 29th, 2010

“There’s very little information about PostgreSQL buffer cache

Try Redis — Reddis Database online demo

Monday, March 29th, 2010

very cool demo. Reddis command prompt in AJAX

GreenSQL | Open Source Database Security, SQL Injection Prevention

Tuesday, March 9th, 2010

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

Wednesday, February 10th, 2010

improvements to PostgreSQL that could be made by tuning wal/background writer processes

Tuning PostgreSQL WAL Synchronization

Tuesday, February 9th, 2010

Notes about PostgreSQL WAL synchronizations methods

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

Friday, January 8th, 2010

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

Monday, December 28th, 2009

some notes on how to optimize autovacuum on Postgres

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

Saturday, December 19th, 2009

DSN-less connection for VB/Classic ASP to PostgreSQL/ODBC on windows

PostgreSQL on Vimeo

Friday, December 18th, 2009

collections of videos of PostgreSQL-related presentation from Vimeo.com