Skip to main content

A simple and light DB package

Project description

# instadb

A simple a light DB python package

## Features
- query from postgres and reshift
- load data into pandas dataframe
- query from sql or filename
- automatically setup connections from env variables
- automatic query annotation
- connect timeout retry with exponential backoff

### Installation

`pip install instadb`

### Basic Usage

```python
import instadb
db = instadb.Connection(url=database_url)
df = db.dataframe("select * from users limit 10")
```

If you have env variables that match the pattern `<key>_DATABASE_URL` then you can directly do:

```python
import instadb
df = instadb.key.dataframe("select * from users limit 10")
```

### Query from file

```python
df = instadb.key.dataframe(filename='./users.sql')
```

### Query from file with arguments

users.sql
```
select * from users where limit={limit}
```

```python
df = instadb.key.dataframe(filename='./users.sql', limit=100)
```

## TODO
- [ ] load data to list
- [ ] insert and update queries
- [ ] caching


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

instadb-0.4.1.tar.gz (3.3 kB view hashes)

Uploaded Source

Built Distribution

instadb-0.4.1-py2.py3-none-any.whl (5.1 kB view hashes)

Uploaded Python 2 Python 3

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