3.4.0

What's Changed

• Fix for multiple possible .pgpass locations on Windows by @ThomasMConnors in #64

Full Changelog: 3.3.0...3.4.0

3.3.0

What's Changed

• Add PyArrow support by @jaschaeff in #50
• Add dtype argument support by @rchu4 in #51
• Proper escaping of colons by @FlipperPA, fixes #58
• Removes unnecessary dependencies by @FlipperPA, fixes #57

Full Changelog: 3.2.0...3.3.0

3.2.0

What's Changed

• SQLAlchemy 2.0 support by @seidelma. Please use version 3.1.6 if you want to use SQLAlchemy 1.x.
• Pandas 2.2 support
• Support for rows parameter by @FlipperPA
• Documentation updated with simplified installations by @FlipperPA

Full Changelog: 3.1.6...3.2.0

3.1.6

What's Changed

• The connection will try to use the PGHOST environment variable if it exists.
• Connection now can take an optional verbose=True. This will output the exact connection string being used.

Full Changelog: 3.1.5...3.1.6

3.1.5

What's Changed

• Rename default branch to main
• Publish package to PyPI when we draft a new release tag through GitHub.

Full Changelog: 3.1.4...3.1.5

3.1.4

What's Changed

• Complete change to using pyproject.toml exclusively
• Begin switching to use git tags as version numbers.

Full Changelog: 3.1.3...3.1.4

Have tag match version number of package

Merge pull request #38 from wharton/patch/pin-sqlalchemy-version-202302

Pin SQLAlchemy Package to <v2.0.0
Needed at least until Pandas is updated to handle SQLAlchemy 2

Pin SQLAlchemy < 2

Current release of Pandas does not yet handle api changes in SQLAlchemy 2

Password Structure

We now quote passwords appropriately to avoid login errors due to special characters.

Data Chunking

This version adds the chunksize and return_iter arguments to raw_sql. This will improve resource usage.