Over the last decade, open source databases have won the hearts and minds of developers and database operators across the globe. When you double-click on the open source trends, you will clearly see that PostgreSQL has become the database of choice. The reasons are obvious: innovation, reliability, cost, and support of a wide range of platforms.
A 2020 survey of EDB’s enterprise customers tells us that they use PostgreSQL for systems of record, for example customer relationship management or e-commerce transactions (54%), systems of analysis, such as data marts or reporting systems (63%), and systems of engagement, such as websites or IoT applications (17%). It is important to understand how to integrate PostgreSQL with all facets of the enterprise stack.
In this first blog post of our new series, Integrating PostgreSQL, we'll look at the integration of PostgreSQL with the enterprise tech stack to help accelerate development and the move to production. Let's zoom in on the first area of importance in this landscape: PostgreSQL integration with applications that create and consume data.
PostgreSQL provides a C-based API called libpq, which is the recommended way to connect for applications written in C. Java-based applications leverage the PostgreSQL JDBC driver. ODBC and .NET drivers are also available from the PostgreSQL project. EDB provides Oracle-compatible versions of JDBC, ODBC, and .NET drivers, and OCI compatible drivers that make PostgreSQL look like Oracle to the application. These drivers can to be used in conjunction with EDB’s Postgre Advanced Server.
An analysis of Stackoverflow’s PostgreSQL-related traffic in 2020 provides information about what programming languages are popular with PostgreSQL developers. Python is by far the most popular tool. Ruby on Rails appears to be declining in popularity with Java holding steady.
What programming languages are popular with PostgreSQL developers? Stackoverflow analysis of development languages mentioned in the PostgreSQL context provides this information.
Django is an extremely popular framework for Python applications that do not rely on the psycopg2 database driver. Java, often used with Hibernate or Spring, is found largely in mature in-house developed applications. Node.js, especially React and Vue.js, is increasingly used in microservices type architectures and for web frameworks.
In the next blog in this series, we'll cover Data Integration and Migration, another key piece of how PostgreSQL integrates with your tech stack.