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 benchma…
Posted in benchmark, database, dba, for:charlesnw, for:collidr, mysql, oracle, performance, postgresql, tpc-c | Comments Off | permalink
example: REVOKE SELECT ON pg_catalog.pg_proc, information_schema.routines FROM public
Posted in database, for:charlesnw, postgresql, programming, shema, sql, stored_procedures | Comments Off | permalink
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
Posted in database, dba, design, sql | Comments Off | permalink
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
Posted in binary, database, dba, development, postgresql, programming | Comments Off | permalink
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
Dell 2950
Posted in 2950, benchmark, database, dba, dell, for:collidr, hadrware, Linux, performance, postgresql, raid, raid_harware, sysadmin | Comments Off | permalink
You are currently browsing the archives for the database category.
Konstantin Antselovich (c) 2004-2011
powered by WordPress
Entries (RSS)
and Comments (RSS).