Metadata-Version: 2.0
Name: instadb
Version: 0.4
Summary: A simple and light DB package
Home-page: https://github.com/mathieuripert/instadb
Author: Mathieu Ripert
Author-email: mathieu@instacart.com
License: BSD
Description-Content-Type: UNKNOWN
Platform: UNKNOWN
Requires-Dist: pandas
Requires-Dist: psycopg2

# instadb

A simple and light DB python package

### 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
```sql
select * from users where limit={limit}
```

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


