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)
Posted in architecture, database, databases, dba, design, mssql, schema, sql, stackoverflow | Comments Off | permalink
Google translate of 2 posts in Russian section of LJ about route costs look up problem commonly faced by telephony operators
Posted in database, index, map_reduce, oracle, parallel, postgresql, programming, sql | Comments Off | permalink
in 3 lines Dan’s method is:
Posted in development, framework, infosec, injection, research, review, Security, sql, xss | Comments Off | permalink
Some comments on modeling friendlits user activity, for social media websites (or apps)
Posted in data, database, dba, friendlist, model, programming, socialnetworking, sql, useractivity | Comments Off | permalink
SQL-proxy/filtering software for MySQL and PostgreSQL databases, used to prevent SQL-injection-like attacks, filter-out dangerous SQL, etc
Posted in database, firewall, mysql, opensource, Security, sql, sysadmin, tools | Comments Off | permalink
PostgresSQL: how to count number of rows returned by a query and do it fast
Posted in count, cursors, database, dba, postgresql, programming, sql | Comments Off | permalink
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.
Posted in benchmark, database, dba, mysql, performance, postgres, postgresql, sql | Comments Off | permalink
gives you an idea how different caching methods perform. Read it before implementing something
Posted in development, for:collidr, memcached, mysql, performance, php, programming, scalability, speed, sql, web | Comments Off | permalink
example: REVOKE SELECT ON pg_catalog.pg_proc, information_schema.routines FROM public
Posted in database, for:charlesnw, postgresql, programming, shema, sql, stored_procedures | Comments Off | permalink
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
Posted in database, dba, design, sql | Comments Off | permalink
You are currently browsing the archives for the sql category.
Konstantin Antselovich (c) 2004-2011
powered by WordPress
Entries (RSS)
and Comments (RSS).