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
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for pdsql-1.2.16-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6a14f115cbdbf7ef37fb6e4bd73f835774122f69a8b4d81185ef671eff1673c2 |
|
MD5 | 9c9b977683beaaa053aabeea70b102e5 |
|
BLAKE2b-256 | 90cee9d95bc054037cf792ecf2bf890b8301631e6776366dcb3b4966c16ecc3c |