Yesterday, SDTimes published my article “Choosing the right database: Understanding your options” . As the name suggests, the article talks about understanding available options for selecting the right database, and explains attributes needs to be considered during the selection process. I hope you will check it out. Comments are welcome!
Earlier this week, we got an email from DonorsChoose.org with the need of “a serious Postgres expert” to solve the problem they have been experiencing and blocker for number of projects at hand. They heard good things about OmniTI from technology clubs and communities in NYC. DonorsChoose.org is an online charity that makes it easy for anyone to help students in need. […]
Last week, I deliverd a presentation on “Scaling Postgres” at PostgresOpen 2013. As I promised, here is the slides deck: Scaling postgres from Denish Patel
This week, I will be attending Surge (Scalability Conference) in Washington D.C. Next week, I will be speaking/attending PgOpen (Postgres conference) in Chicago. If you are planning to attend any of these conferences, it will be nice opportunity to meet in-person and catch up on technologies & stories specifically about databases ! See you soon!!
With other great new features, PostgreSQL 9.2 makes DBAs life easy by providing more metrics in statistics collector views. Out of those , pg_stat_database caught my eyes because it provides a lot more details compare to Postgres 9.1 and other previous versions. Postgres 9.1 postgres=# \d pg_stat_database View “pg_catalog.pg_stat_database” Column | Type | Modifiers —————+————————–+———– datid | oid […]
EDIT: Marcus(1st comment provider) helped me to write much cleaner and secure code. It doesn’t require CAST function and uses PGobject with jdbc’s setObject. You could download updated code from git-repo. Thanks Marcus !! One of the clients of OmniTI requested help to provide sample application to insert JSON data into Postgres using Java JDBC driver […]
I got opportunity to give talk on “Deploying PostgreSQL on Amazon EC2: A Case Study” at PGDay NYC and LOPSA-East . Here is the slides deck: Deploying postgre sql on amazon ec2 from Denish Patel
Continuous Integration (CI) using automated open source tools such as Jenkins and Hudson is getting adoption rapidly. These tools help developers to gain confidence for creating more robust code rapidly by improving testing and QA process. The flexibility of these softwares add other challenges for the DBAs! One of our client came across challenge to cleanup databases […]