Konstantin Antselovich

Open Source Database Magazine

Thursday, July 23rd, 2009

pdf magazine that covers open-source databases, MySQL, PostgreSQL and alike.

Posted in CouchDB, database, db, drizzle, hadoop, magazine, mysql, opensource, pdf, postgresql | Comments Off | permalink

[RUS ]Массив? Или как лучше? / PostgreSQL : Форум на SQL.RU | Array? or how to do it better? – A way to deal with serializable objects in PostgreSQL

Wednesday, July 1st, 2009

this is a discussion from russian database forum SQL.RU that describes 2 common ways of storing serializable objects in RDBMS.

Posted in database, dba, development, object-relational, orm, postgresql, programming, serialization | Comments Off | permalink

[RUS] PostgreSQL vs MySQL

Wednesday, June 10th, 2009

test uses db schema and usage pattern from popular blog-hosting site. Benchmark uses optimized queries

Posted in benchmark, database, db, for:collidr, mysql, performance, postgresql | Comments Off | permalink

PGQ Tutorial – PostgreSQL Wiki

Tuesday, May 19th, 2009

http://sql.ru/forum/actualthread.aspx?tid=665075 Examples how to use PgQ queue in postgres

Posted in database, dba, development, pgq, postgresql, programming, queue, skytools | Comments Off | permalink

What happened to Hot Standby?

Saturday, March 21st, 2009

Josh Berkus explaing why hot-standby replication did not make it into postgresql 8.4

Posted in database, db, dba, postgres, postgresql, replication | Comments Off | permalink

Pitrtools – Trac /set of tools for setting up PITR on PostgreSQL/

Thursday, February 26th, 2009

PITRTools is a set of wrapper scripts that provide warm standby functionality to PostgreSQL. The software is essentially two scripts, cmd_archiver.py and cmd_standby.py. The project is under the BSD license.

Posted in backup, data, database, dba, PITR, postgres, postgresql, python, recovery, replication | Comments Off | permalink

SourceForge.net: BenchmarkSQL

Friday, February 20th, 2009

tool for testing database performance, jdbc-based, supports a lot of different DBs

Posted in benchmark, database, dba, java, jdbc, performance, postgresql, testing | Comments Off | permalink

Benchmarking Databases I. Volatile Storage. – Pon un sol en tu vida

Friday, February 20th, 2009

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

Prevent users from seeing SQL inside SP Postgersql ( from flames on sql.ru about MySQL vs PostgreSQL [russian] Выбор СУБД: MySQL или PostgreSQL / Сравнение СУБД : Форум на SQL.RU )

Wednesday, November 5th, 2008

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

BLOB, iBatis & PostgreSql 8.1 – dBforums [large objects vs bytea]

Sunday, August 17th, 2008

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