README.md

REST Layer PostgreSQL Backend

This REST Layer resource storage backend stores data in a PostgreSQL Database using database/sql and pq.

UNDER HEAVY DEVELOPMENT BEWARE TO NOT BE USED ONLY UNDER HEAVY TESTING

Usage

import "github.com/safad/rest-layer-pgsql"

Open an SQL connection to PostgreSQL using database/sql:

const (
        DB_USER     = "postgres"
        DB_PASSWORD = "postgres"
        DB_NAME     = "test"
    )
dbinfo := fmt.Sprintf("user=%s password=%s dbname=%s sslmode=disable",
            DB_USER, DB_PASSWORD, DB_NAME)
        db, err := sql.Open("postgres", dbinfo)

Create a resource storage handler with a given DB/collection:

users_handler := pgsql.NewHandler(db, "users")

Use this handler with a resource:

index.Bind("users", users, users_handler, resource.DefaultConf)