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.
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.
http://www.ch-werner.de/sqliteodbc/ ODBC wrapper for sqlite libs, coss platform: binaries are available for win32, os x, linux
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
http://sql.ru/forum/actualthread.aspx?tid=549868 Say we have a table with a lot of boolean columns. One row in that table defines an “event” entity, so basically event 1 can look like 00001 and event 2 can look like 01001. Post discusses a ways to define similarities between events (XOR)
http://sql.ru/forum/actualthread.aspx?tid=211296 netsted sets (trees) in postgresql
http://archives.postgresql.org/pgsql-general/2007-08/msg00702.php how to implement “replace” in postgres
http://sqlblog.com/blogs/paul_nielsen/archive/2007/12/12/10-lessons-from-35k-tps.aspx notes (somewhat interesting) about big OLTP system based on SQLserver
http://www.depesz.com/index.php/2007/11/21/find-overlapping-time-ranges/ how to use “search by timerange” postgres and use index
http://www.postgresql.org/docs/techdocs.83 some generic info about eternal “MySQL vs PostgreSQL” topic from postgres site