Yet another Python PostgreSQL database driver.
Pure python or Cython http://cython.org/ accelaleted.
Requirements
Python 2.7, 3.3+, PyPy, jython 2.7, IronPython 2.7
Cython 0.22.x or higher optinally.
Installation
It can install as package or module.
Install as a package
$ pip install minipg
Install as a module
$ cd $(PROJECT_HOME) $ wget https://github.com/nakagami/minipg/raw/master/minipg/minipg.py
Example
Query:
import minipg
conn = minipg.connect(host='localhost',
user='postgres',
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()
COPY TO:
import minipg
conn = minipg.connect(host='localhost',
user='postgres',
password='secret',
database='database_name')
f = open('foo.txt', 'bw')
conn.execute('COPY foo_table TO stdout', f)
f.close()
conn.close()
COPY FROM:
import minipg
conn = minipg.connect(host='localhost',
user='postgres',
password='secret',
database='database_name')
f = open('foo.txt', 'br')
conn.execute('COPY foo_table FROM stdin', f)
f.close()
conn.close()
Execute Query from a command line
$ python -m minipg -H pg_server -U user -W pass -D db_name <<EOS > SELECT * FROM FOO > EOS
or
$ python -m minipg -H pg_server -U user -W pass -D db_name -Q 'SELECT * FROM FOO'
Restrictions and Unsupported Features
Authentication METHOD only can ‘trust’ or ‘md5’ in pg_hba.conf.
Not full support for array data types.
Not support for prepared statements.
1 maintainer
Metadata
1 maintainer
Release files for minipg 0.5.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| minipg-0.5.1.tar.gz | 124.9 kB | Details |
Release files / minipg-0.5.1.tar.gz
| Download URL | minipg-0.5.1.tar.gz |
|---|---|
| Size | 124.9 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
9eee553ced4cbb40397b46ee7f95ee0a41c78b2804ffb612a6dfc3f670ac49b1
|
|
BLAKE2b-256 checksum How to use checksums |
32ab1b6007356a9737d7dd68d13badbd875496e9eb0bf5246479b9a485e5ee60
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
