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
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
minipg-0.5.1.tar.gz
(124.9 kB
view details)
File details
Details for the file minipg-0.5.1.tar.gz.
File metadata
- Download URL: minipg-0.5.1.tar.gz
- Upload date:
- Size: 124.9 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
9eee553ced4cbb40397b46ee7f95ee0a41c78b2804ffb612a6dfc3f670ac49b1
|
|
| MD5 |
2f5ebef57a65861f426e42d3d231161d
|
|
| BLAKE2b-256 |
32ab1b6007356a9737d7dd68d13badbd875496e9eb0bf5246479b9a485e5ee60
|
