ng-postgrest's Introduction

Angular Postgrest

The goal of this project is to build a simple Angular UI client (CRUD) for Postgrest (Postgrest is a REST wrapper for PostgresSQL. See https://postgrest.com).

Development

To install the node dependencies the project run npm i from within the root directory.

Run ng serve --open for a dev server. Navigate to http://localhost:4200/.

The app will automatically reload if you change any of the source files.

Build

Run ./build.sh to build the project

Run ng build --prod --aot=false .

Features

Completed

Managing Postgrest endpoints
Table selection
Table pagination
Table pagination size
Update row (currently testing for non-text fields)
Delete row (with confirmation)

Next to be implemented

Insert new row
Simple queries (AND only)

Planned

Complex queries (Support for AND, OR)
Security headers
Persisting defaults
Saving & loading settings (Google drive)
Host latest release on Github pages
Docker image (Alpine, Nginx)
Heroku button
Clear exception communication

Stack

Angular 4
Bootstrap 4
Sweet Alert 2
Karma
Postgrest

ng-postgrest's People

Contributors

Stargazers

Watchers

ng-postgrest's Issues

Add authentication header

Add the ability to authenticate using JWT

"Authorization: Bearer $TOKEN"

SaveEdit is filtering by "id" is hard codded

  public saveEdit(): void {
    this._postgrestService.doPatch(this.currentUrl + this.table + "?id=eq." + this.tableRowToEdit['id'], this.tableRowToEdit)
      .catch(error => console.log(error))
      .then(res => this.cancelEdit())

  }

Also the delete function

  public deleteRow(row: any) {
    var t = this;
    this._postgrestService.doDelete(this.currentUrl + this.table + "?id=eq." + row['id'])
      .catch(error => console.log(error))
      .then(v => t.refreshTable()
      )

  }