close

Menu

Contact Info

Folow us on social

Achieving PCI Compliance with PostgreSQL

Today, I gave Security talk on Achieving PCI Compliance at PgWest 2010, San Francisco. Slides are available to download. http://static.slidesharecdn.com/swf/ssplayer2.swf?doc=achievingpcicompliace-12888219148022-phpapp02&stripped_title=achieving-pci-compliace-5659979

Security & PgWest2010

Open Source databases still needs solid presence in enterprise world. One of the myths about open source databases is that they aren’t secure. To eliminate this myth we have to share our experience related to security aspect of PostgreSQL database. At OmniTi , we help businesses to achieve PCI compliance or provide payment processor:PayPI . […]

Outlining Surge Conference Sessions

OmniTi’s Surge conference is around the corner (Sept 30th) and there are plenty of industry leading speakers and most advance technology sessions to choose from list. Most probably I will be attending second day of two days conference. I spent a lot of time to decide on most interesting sessions to attend from wide variety […]

PostgreSQL Recovery Manager – PG_RMAN

During PgEast, I heard a lot about making PostgreSQL acceptable at more enterprise shops. I firmly believe that PostgreSQL has potential but lack of marketing perspective during the promotion of product and tools. Anyways, let’s start creating/testing/using and telling new tools those can be attracted by C-Level people!! If you have Oracle background , you […]

RubyRep Presentation Slides

Guys, Today I gave presentation @ PgEast2010 in Philadelphia. You can download slides Here Thanks for attending or following it!! http://static.slidesharecdn.com/swf/ssplayer2.swf?doc=rubyrepv2-100326211120-phpapp01&stripped_title=yet-another-replication-tool-rubyrep

Heading to PgEast

Guys, I will be in Philadelphia on 25th and 26th March 2010 to attend PgEast PostgreSQL conference. Moreover, I will be speaking on RubyRep on 26th March 2010. If you are attending this conference , see you there!

Secure your web from SQL Injections

Last couple of months, I came across two incidents of SQL injections due to most common errors by IT professionals. How To Hack A Brazilian Power Company SQL Injection discovered on Wall Street Journal Both incidents are stunning and they were exploited by hackers with minimal effort. Little care during web application development could avoid […]

Postgres 8.4 – Replace regular index with Text Based Index

I came across a nice post by Peter Eisentraut that shows how text based index can be used to do direct lookup on the text fields. Quick test proves that.. postgres=# d employees Table “public.employees”Column | Type | Modifiers——–+———+———–emp_id | integer | not nullname | text |Indexes: “employees_pkey” PRIMARY KEY, btree (emp_id)postgres=# create index idx_employees_name […]

Yet Another PostgreSQL Replication Tool – RubyRep

One of the key features any enterprise considers when choosing a database technology for their architecture solution stack is that of replication. Oracle and MySQL both have built in replication solutions, but as of yet PostgreSQL doesn’t support a built in replication solution. There are many replication solutions available however, and different companies are using […]

pg_migrator beta-1 released

pg_migrator ———– Version 8.4, Beta 1 What it Does ———— pg_migrator allows data stored in Postgres data files to be migrated to a later Postgres major version without the dump/reload of data typically required for major version upgrades, e.g. 8.3.7 -> 8.4.1. It is not required for minor version upgrades, e.g. 8.4.1 -> 8.4.5. Limitations […]