Database

SourceForge.net: BenchmarkSQL

http://sourceforge.net/projects/benchmarksql tool for testing database performance, jdbc-based, supports a lot of different DBs

Benchmarking Databases I. Volatile Storage. - Pon un sol en tu vida

http://blogs.nologin.es/slopez/archives/17-Benchmarking-Databases-I.-Volatile-Storage..html PostgreSQL, MySQL and Oracle are compared using reasonable hardware setup and TPC-C like test with BenchmarkSQL tool (JDBC ) . This post will probably disappear soon as the author clearly violates oracle license that does not permit publishing benchmark results w/out permissions

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

http://sql.ru/forum/actualthread.aspx?tid=606215&pg=3 example: REVOKE SELECT ON pg_catalog.pg_proc, information_schema.routines FROM public

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

http://sql.ru/forum/actualthread.aspx?bid=36&tid=552763&pg=2 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

BLOB, iBatis & PostgreSql 8.1 - dBforums [large objects vs bytea]

http://www.dbforums.com/showthread.php?t=1620377 sane notes about storing binary data in Postgres. Basically bytea is ASCII representaion of bynary data wich requires decoding / escaping (read: slow) and large objects a kind of ok, but not trigger-based replication compartable

[russian] Как гарантировать наличие атрибута (циклическая зависимость) / Проектирование БД : Форум на SQL.RU | about cyclic references / database design

http://sql.ru/forum/actualthread.aspx?tid=584799 good discussion about cyclic references. Basically the main point is that if you have a question “how do I implement cyclic fererence?” – then there is something wrong, 99% that it is so because ur understaning of problem domain is wrong.

To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem?

ftp://ftp.research.microsoft.com/pub/tr/TR-2006-45.pdf a paper from microsoft research comparing perfomance of 2 systems: metadata in db + files in fs vs. meatadata + files as blobs in db. Study uses MSSQL and NTFS. Datasets are in less than 1 GB size.

SQLite ODBC Driver

http://www.ch-werner.de/sqliteodbc/ ODBC wrapper for sqlite libs, coss platform: binaries are available for win32, os x, linux

How to Share Session State Between Classic ASP and ASP.NET

http://msdn.microsoft.com/en-us/library/aa479313.aspx the subj. soluton creates COM object in .net that then is used by classic ASP to store sessions. ASP.net object stores session in SQL database

Benchmark: Dell/Perc 6, 8 disk RAID 10 [postgresql-performance mailing list]

http://archives.postgresql.org/message-id/[email protected] Dell 2950