ODBC driver for PostgreSQL Reviews & Product Details

The single most useful thing about ODBC driver is their ability to use the same driver for multiple languages. We have a bunch of app running in Python, Java and JS. Initially our app in Java used a JDBC driver, which only partially works in other languages. While using the same db for other languages, we migrated to the odbc option which had much better connectivity to other languages. It also had support for other programming paradigms which JDBC is exclusively an OOP mechanism Review collected by and hosted on G2.com.

Its a little tricky to install and even tricker to configure. The configuration setup is unintuitive and unhelpful in case of error, You can't combine the config file with config from code(not easily anyway) and that makes a mess while sharing across environments Review collected by and hosted on G2.com.

.NET Core is designed to be cross-platform, allowing me to develop applications that run on Windows, Linux, and macOS. The ODBC driver for PostgreSQL aligns well with this because it also supports multiple operating systems, ensuring my .NET Core applications can connect to PostgreSQL databases regardless of the underlying OS.

The ODBC driver provides a standardized way to connect to PostgreSQL, which fits into the .NET Core application we are building in our company through the "System.Data.Odbc" namespace. This means we can leverage a single codebase to access various databases, including PostgreSQL, without needing database-specific code. Review collected by and hosted on G2.com.

ODBC introduces an additional layer of abstraction, which can lead to performance overhead compared to using native drivers like Npgsql for PostgreSQL in .NET Core applications. This can result in slower query execution times and increased resource consumption.

Error messages from ODBC can sometimes be less informative or harder to debug compared to native drivers. This make troubleshooting more challenging and frustating , particularly when dealing with complex queries.

This are two major issue we in the company are facing and planning to migrate to npgsql in future Review collected by and hosted on G2.com.

The ODBC driver for PostgreSQL gives you solid and very robust connectivity, so your data can always be there without any problems. The ODBC driver for PostgreSQL works the same on every operating system you use. This driver gives you the highest level of security features that make your data transmission safe and encrypted, at this level unencrypted. PostgreSQL is, in my opinion, the most open-source and secure software around, and my main reason for choosing it over other options is largely due to this. This data sharing in transparency and speed has made our relationships stronger with the partners, leading to more pleasant design feedback cycles. Review collected by and hosted on G2.com.

There might be a time lag while executing new PostgreSQL features; otherwise, they take some time to be fully supported by the driver. Performance of the system could be a little slow under heavy loads, which may affect the speed of data retrieval. Review collected by and hosted on G2.com.

Easy to connect to PostgreSQL via ODBC driver, but you have to find the suitable version for your database. Review collected by and hosted on G2.com.

Actually, I don't find any difficulty when using it for my project Review collected by and hosted on G2.com.

ODBC provides a way to map data types between different database systems, which helps in ensuring that data is correctly interpreted regardless of the underlying database.

With ODBC, developers can switch between different databases with minimal changes to their application code. This flexibility is crucial for applications that may need to support multiple database systems. Review collected by and hosted on G2.com.

I installed psqlODBC and when I go to Control Panel -> Data Sources (ODBC) I don't see the Postgres driver installed.

I rebooted, still nothing.

I then noticed that if I launch this control panel applet from the file c:\WINDOWS\system32\odbccp32.cpl the drivers suddenly appear! Review collected by and hosted on G2.com.

The ODBC driver for PostgreSQL provides seamless connectivity between any ODBC compliant applications and a PostgreSQL database which allow users to access the data for manipulation from various tools like BI software, reporting applications and data analysis platforms without needing to install additional PostgreSQL clients or libraries Review collected by and hosted on G2.com.

I have mostly disliked the performance issues due to the extra abstraction layer of ODBC, complexity in setup and configuration, occasional connection instability and a lack of advanced features compared to native PostgreSQL drivers used directly within programming languages. Review collected by and hosted on G2.com.

Quick to install and supports configuration for all accounts on the device or unique configurations for individual accounts. It also follows account level permissions on the connected dataset ensuring security rules are followed. Review collected by and hosted on G2.com.

We have not identified any shortfalls with the product. Review collected by and hosted on G2.com.

The driver delivers excellent performance while ensuring robust security through TLS/SSL encryption. It is versatile and compatible with multiple platforms, including Windows and Linux, making it highly convenient. Review collected by and hosted on G2.com.

I believe the driver could benefit from more frequent updates to support the latest PostgreSQL versions seamlessly, which can sometimes be a limitation. Review collected by and hosted on G2.com.

This driver helped me a lot while visualising data from my postgres database into excel. I like this particular driver because it integrates seamlessly and all the setup instructions are provided on the Devart website. Its supports a lot of services, from which I used this driver for Office software such as Excel. It syncs well and does the job and I cant ask for any more perks.. Review collected by and hosted on G2.com.

Its a good driver and does a lot of things better than others but it comes with a 30 day trial. The pricing is too high for me to purchase as it is bundled with a lot of enterprise grade features. For users like me who want a good driver but not want anything that actually costs a fortune, its a hit or miss. Review collected by and hosted on G2.com.

I like that the ODBC driver for PostgreSQL makes it easy to connect apps like Excel or Power BI to PostgreSQL, supports secure connections, and handles large data efficiently. Simple and reliable! Review collected by and hosted on G2.com.

I dislike that setting up the ODBC driver for PostgreSQL can be tricky, especially with DSN configurations. Debugging connection issues and performance tuning can also be frustrating for beginners. Needs better documentation! Review collected by and hosted on G2.com.