Skip to main content

Python/SQL Functions

Project description

The pdsql package contains convenience functions for adding, manipulating, and changing data in SQL servers with a emphasis on Pandas DataFrames for the handling of data in Python.

At the moment, the only supported SQL system is MSSQL, but other SQL systems can/will be added in the future. Priority will be given to PostgreSQL and SQLite/Spatialite.

Documentation

The primary documentation for the package can be found here.

Installation

pdsql can be installed via pip or conda:

pip install pdsql

or:

conda install -c mullenkamp pdsql

The core dependencies are Pandas, Sqlalchemy, and pyodbc.

Geometry data types in SQL are supported, but GeoPandas and pycrs >= 1.0 must also be installed.

To do

  • More documentation

  • Unit tests

  • Support for other SQL database programs (e.g. PostgreSQL and SQLite)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pdsql-1.2.14.tar.gz (16.3 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page