Archive for the 'sql' Category

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

Monday, August 11th, 2008

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?

Tuesday, August 5th, 2008

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

Tuesday, August 5th, 2008

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

Wednesday, July 2nd, 2008

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

[Russian] PostgreSQL forum on SQL.RU: Boolean events and a query to define similarity // как лучше сделать запрос для определения похожести событий? / PostgreSQL : Форум на SQL.RU

Tuesday, April 22nd, 2008

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)

[russian]Готовое решение для работы с деревьями. / PostgreSQL : Форум на SQL.RU

Saturday, March 1st, 2008

netsted sets (trees) in postgresql

[postgreSQL] Insert or Replace or \copy (bulkload)

Wednesday, February 13th, 2008

how to implement “replace” in postgres

Paul Nielsen : 10 lessons from 35K tps

Thursday, December 27th, 2007

notes (somewhat interesting) about big OLTP system based on SQLserver

» Blog Archive » find overlapping time ranges

Saturday, December 1st, 2007

how to use “search by timerange” postgres and use index

PostgreSQL: Why PostgreSQL Instead of MySQL: Comparing Reliability and Speed in 2007

Thursday, November 8th, 2007

some generic info about eternal “MySQL vs PostgreSQL” topic from postgres site