Ensuring high availability for our clients’ PostgreSQL databases is our primary business objective. We are able to achieve that by ensuring availability of our PostgreSQL experts round the clock and around the world. Just like we plan failover and switchover contingencies for our clients, we plan for backups and backups-of-backups for business continuity so our services are delivered unhindered...

2ndQuadrant’s training courses are very popular amongst PostgreSQL professionals and enthusiasts, and have hosted more than 500 trainees in the last 10 years. Our current Public and On-Site training options, however, have their limitations. We are often asked: “ When are you going to offer a training course in my region?“ It’s disheartening to tell people that we don’t yet have plans to offer...

When I wrote about Reason #3: No Vendor Lock-in , I leaned on the liberal PostgreSQL License and the fact that there are many vendors that can Support PostgreSQL in production . Another aspect that deserves its own mention is the fact that PostgreSQL can not be bought. Let me explain the significance of that statement. MySQL. MySQL used to be the single most popular database among developers. It...

PostgreSQL is packed with features. What may not be part of the core is available as extensions. What are extensions – you ask? PostgreSQL exposes APIs that are designed to easily allow external programs to load into the database and function just like core features. So if you find that you need a feature in the database and you don’t have the skills to enhance the core engine or if the change...

Break free from vendor lock in with Postgres You buy a cool new technology for your organization in order to cut operational costs. It works really well for you, and incrementally, your entire business starts to rely on this tech for its day to day operations. You have successfully made it an essential component of your business. There are some issues now and then, but what you are increasingly...

Legal documents = SCARY!! That’s the typical equation, and it’s true – except when it comes to PostgreSQL. Let me explain… I have been told by both prospects and clients, that when they sit down to negotiate terms with Oracle, they are faced with more lawyers than they have engineers. No wonder one shudders at the thought of evaluating a database’s license. If only all databases were as simple...

PostgreSQL has been my livelihood since 2004 – so I am naturally biased in its favor. I think it is the coolest piece of software on the planet, and I am not alone. DB-Engines See those 2 badges up there? That’s 2 years in a row. DB-Engines monitors a total of 343 databases and their trends. For each of 2017 and 2018, DB-Engines states that PostgreSQL gained more popularity in their rankings than...

jDBI is designed to be the middle ground between high level ORMs like JPA & Hibernate on one hand and raw JDBC on the other. You can think of it as a layer of convenience on top of JDBC that is still at a lower level than ORMs. When working with JDBC, you are exposed to the raw workings of the SQL language and that of the database you are connecting to. jDBI tries to expose API that encapsulates...

Last week saw the 3rd event in as many years in Singapore, and yet this time something was very different. For the last 2 years, we had been conducting the conference as a PostgreSQL track with FOSSASIA. This year, we were able to pull off an entirely independent, 2-day event completely focused on PostgreSQL! The event kicked off with a keynote from Joe Conway (flying in all the way from USA!)...

1. Introduction EclipseLink was announced in 2008 as the JPA 2.0 implementation from the Eclipse Foundation. It is based on the TopLink project from which then Oracle contributed code to the EclipseLink project. The project delivers an open source runtime framework supporting the Java Persistence API standards. The EclipseLink project provides a proven, commercial quality persistence solution that...