Skip to content

nakagami/micropg

master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
 
 
 
 
 
 
 
 

micropg

A MicroPython PostgreSQL database driver.

Installation

use upip

$ micropython -m upip install micropg

or

copy a module file.

$ cd $(HOME)/.micropython/lib
$ wget https://github.com/nakagami/micropg/raw/master/micropg.py

Example

Query:

import micropg
conn = micropg.connect(host='127.0.0.1',
                    user='postgres',
                    password='secret',
                    database='database_name',
                    use_ssl=False)
cur = conn.cursor()

cur.execute('select foo, bar from baz')
for r in cur.fetchall():
   print(r[0], r[1])

# execute with parameter
cur.execute('select foo, bar from baz where name=%s ', ['nakagami'])
for r in cur.fetchall():
   print(r[0], r[1])

conn.close()

Restrictions and Unsupported Features

  • Supported Authentication METHOD are only 'trust', 'md5' and 'scram-sha-256'.
  • Not support for array data types.
  • Not support for prepared statements.

If you use md5 authentication METHOD, you may need a patch #2

For CPython

I also wrote a pure Python driver. https://github.com/nakagami/minipg

About

PostgreSQL database driver for MicroPython

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages