Archive for the 'sql' Category

Understanding the StackOverflow Database Schema – SQLServerPedia

Tuesday, April 19th, 2011

Notes about schema used by StackOverflow.com and related websites. It is very simple, only several tables used. (most likely because there are performance problems with joins)

Google Translate "Again about SQL " — route costs lookup for telephony operator

Tuesday, November 23rd, 2010

Google translate of 2 posts in Russian section of LJ about route costs look up problem commonly faced by telephony operators

Recursion Ventures – Dan Kamisky on SQL Injections and XSS

Thursday, June 17th, 2010

in 3 lines Dan’s method is:

[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)

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

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

Friday, January 8th, 2010

PostgresSQL: how to count number of rows returned by a query and do it fast

MySQL vs PostgreSQL Benchmarks | Random Bugs

Sunday, December 13th, 2009

yet another mysql vs postgresql benchmark using “OSDB”. Small difference between the two, but consider that benchmark was done on 2-way SMP, 3GB ram, 1 SATA DISK and a small dataset.

Cache Performance Comparison | MySQL Performance Blog

Wednesday, November 19th, 2008

gives you an idea how different caching methods perform. Read it before implementing something

Prevent users from seeing SQL inside SP Postgersql ( from flames on sql.ru about MySQL vs PostgreSQL [russian] Выбор СУБД: MySQL или PostgreSQL / Сравнение СУБД : Форум на SQL.RU )

Wednesday, November 5th, 2008

example: REVOKE SELECT ON pg_catalog.pg_proc, information_schema.routines FROM public

[russian] Юзеры – Друзья. Какая связь? / Проектирование БД : Форум на SQL.RU || User – Friends relationship : Database design, forum SQL.ru

Friday, August 22nd, 2008

design pattern for friends/users, i.e. how to organize user-friend relationship. patters suggest that you need to make 2 tables, i.e freindship and friendship:user