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.
Posted in database, design, programming, sql | Comments Off | permalink
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.
Posted in blob, database, design, development, filesystem, filesystems, fragmentaion, fragmentation, infomation, mssql, ntfs, research, shortcut:database, sql, storage, system | Comments Off | permalink
ODBC wrapper for sqlite libs, coss platform: binaries are available for win32, os x, linux
Posted in database, development, odbc, programming, sql, sqlite, tools, win32, windows | Comments Off | permalink
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
Posted in asp, asp.net, com_object, database, development, Microsoft, programming, session, sql, web, windows, windows_service | Comments Off | permalink
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)
Posted in database, pl/pgsql, postgresql, programming, sql | Comments Off | permalink
netsted sets (trees) in postgresql
Posted in database, development, postgresql, programming, sql | Comments Off | permalink
how to implement “replace” in postgres
Posted in database, development, postgresql, programming, sql | Comments Off | permalink
notes (somewhat interesting) about big OLTP system based on SQLserver
Posted in database, development, performance, scalability, sql, sqlserver | Comments Off | permalink
how to use “search by timerange” postgres and use index
Posted in pl/pgsql, postgresql, recipe, sql | Comments Off | permalink
some generic info about eternal “MySQL vs PostgreSQL” topic from postgres site
Posted in comparison, database, mysql, postgresql, 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).