'Does SQLAlchemy support Pervasive PSQL? connection string for it?

I googled and found this sqlalchemy-pervasive dialect. I pipped it, but I have no idea how to use it.

What is connection string to pass to create_engine(.....) for sqlalchemy to connect to pervasive psql? is there any other third party driver or dialect?



Solution 1:[1]

After I did a:

pip install sqlalchemy-pervasive

This worked for me:

server='localhost'
database='TEST6'
params = urllib.parse.quote_plus(f'DRIVER=Pervasive ODBC Interface;SERVERNAME={server};DBQ={database}')
engine = create_engine("pervasive:///?odbc_connect=%s" % params)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 brant oliphant