Archive for the 'sql' Category
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.
Posted in database, design, programming, sql | Comments Off | permalink
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.
Posted in blob, database, design, development, filesystem, filesystems, fragmentaion, fragmentation, infomation, mssql, ntfs, research, shortcut:database, sql, storage, system | Comments Off | permalink
Tuesday, August 5th, 2008
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
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
Posted in asp, asp.net, com_object, database, development, Microsoft, programming, session, sql, web, windows, windows_service | Comments Off | permalink
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)
Posted in database, pl/pgsql, postgresql, programming, sql | Comments Off | permalink
Saturday, March 1st, 2008
netsted sets (trees) in postgresql
Posted in database, development, postgresql, programming, sql | Comments Off | permalink
Wednesday, February 13th, 2008
how to implement “replace” in postgres
Posted in database, development, postgresql, programming, sql | Comments Off | permalink
Thursday, December 27th, 2007
notes (somewhat interesting) about big OLTP system based on SQLserver
Posted in database, development, performance, scalability, sql, sqlserver | Comments Off | permalink
Saturday, December 1st, 2007
how to use “search by timerange” postgres and use index
Posted in pl/pgsql, postgresql, recipe, sql | Comments Off | permalink
Thursday, November 8th, 2007
some generic info about eternal “MySQL vs PostgreSQL” topic from postgres site
Posted in comparison, database, mysql, postgresql, sql | Comments Off | permalink