Skip to main content

Yet another MS SQLServer database driver

Project description

Yet another Python MS SQLServer database driver.

Support platform

  • Python 3.5+

Support database

We test with MS SQLServer 2019 on Ubuntu. But we think it works with the following versions.

  • MS SQLServer 2012, 2014, 2016, 2017, 2019

  • Microsoft Azure SQL Database

Installation

$ pip install minitds

Example

Query:

import minitds
conn = minitds.connect(host='localhost',
                    user='sa',
                    password='secret',
                    database='database_name')
cur = conn.cursor()
cur.execute('select foo, bar from baz')
for r in cur.fetchall():
   print(r[0], r[1])
conn.close()

Execute Procedure:

import minitds
conn = minitds.connect(host='localhost',
                    user='sa',
                    password='secret',
                    database='database_name')
cur = conn.cursor()
cur.callproc('something_proc', [123, 'ABC'])
conn.close()

Restrictions

  • Support connecting through SQL Server Authentication only.

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

minitds-0.5.3.tar.gz (12.2 kB view details)

Uploaded Source

File details

Details for the file minitds-0.5.3.tar.gz.

File metadata

  • Download URL: minitds-0.5.3.tar.gz
  • Upload date:
  • Size: 12.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.1.1 pkginfo/1.4.2 requests/2.22.0 setuptools/45.2.0 requests-toolbelt/0.8.0 tqdm/4.30.0 CPython/3.8.10

File hashes

Hashes for minitds-0.5.3.tar.gz
Algorithm Hash digest
SHA256 6382e5bf172a89964f42fa86d58d23755ced038f57ec057fb456873cbc33463d
MD5 787ffcbbdf1717c464509d7ca1f8fc0b
BLAKE2b-256 8754e84ff8cfb59ebaaf005bdb53986c1a68afdb762fb8bcb33c064fc509c66c

See more details on using hashes here.

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