Akshay Joshi



Tags:   postgresql    edb    pgadmin    code    committer    india    opensource    python    psycopg2   
Category:   Interviews   
Interviewed by: Andreas Scherbaum

PostgreSQL is the World’s most advanced Open Source Relational Database. The interview series “PostgreSQL Person of the Week” presents the people who make the project what it is today. Read all interviews here.

Please tell us about yourself, and where you are from.

I am from India, born and brought up in Indore, but living in Pune (MH) since I joined EDB. I graduated with a Bachelor of Science in Computers, and post graduated with a Master of Computer Applications. I am married and have 2 kids - a 13 year old son and an 8 year old daughter.

I work at EDB in the CTO team under Dave Page. I am the committer, developer, and release manager for pgAdmin 4, and was the developer for pgAdmin III.

Akshay Joshi

Akshay Joshi

How do you spend your free time? What are your hobbies?

I love to play outdoor sports, especially Cricket. I love to travel with family and friends.

Any Social Media channels of yours we should be aware of?

LinkedIn

How would your ideal weekend look like?

Playing Cricket, Going out with family for dinner.

What’s still on your bucket list?

I would like to visit Australia, New Zealand, Europe, and many more countries with my family.

What is the best advice you ever got?

I got the best advice from my manager Dave Page: “Keep faith in yourself, you can do it.”

When did you start using PostgreSQL, and why?

I started using PostgreSQL in 2010 when I joined EDB. This is my first exposure to the database field.

Do you remember which version of PostgreSQL you started with?

PostgreSQL 9.0

Yes I have completed my graduation and post graduation at the university. I think it does somewhat help that I studied courses about computer architecture, algorithms, data structures, C, C++ etc.

What other databases are you using? Which one is your favorite?

I use EDB Postgres Advanced Server.

I am working on pgAdmin 4, which is developed from scratch by using web development technologies. I also contributed to pgAdmin III.

How do you contribute to PostgreSQL?

pgAdmin project development, patch review, commits and managing monthly release of pgAdmin 4.

What is your favorite PostgreSQL extension?

edb_wait_states, but that’s a non-free EDB extension to support wait state analysis in Postgres Enterprise Manager. It is awesome though.

Could you describe your PostgreSQL development toolbox?

For pgAdmin4 development I mainly use PyCharm and VSCode.

Which skills are a must have for a PostgreSQL developer/user?

My opinion is that the developer must have strong debugging skill and code analyzing skill. Users should always read the documentation thoroughly to understand the feature.

Do you use any git best practices, which makes working with PostgreSQL easier?

I like patches, because it is easy to apply using the “git apply” command to the source tree.

Which PostgreSQL conferences do you visit? Do you submit talks?

I have attended PGConf.EU in the beautiful city of Vienna, Austria.

Do you think PostgreSQL will be here for many years in the future?

Yes, definitely as it is a powerful open source database. Community keeps on adding excellent features, and they are working on Performance improvement as well.

Would you recommend Postgres for business, or for side projects?

Yes, definitely for business and side projects both. PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

Are you reading the -hackers mailing list? Any other list?

Yes I read -hackers , pgadmin-hackers as well as the pgAdmin lists.

What other places do you hang out?

I usually log into Slack and Mailing Lists, but that is used for our internal discussions.