postgrest 0.0.1-dev.6 postgrest: ^0.0.1-dev.6 copied to clipboard
PostgREST client for Dart. This library provides an ORM interface to PostgREST.
Postgrest Dart #
Dart client for PostgREST. The goal of this library is to make an "ORM-like" restful interface.
Pre-release verion! This repo is still under heavy development and the documentation is evolving. You're welcome to try it, but expect some breaking changes.
Using #
The usage should be the same as postgrest-js except:
- You need to call
end()
to finish your query chain. is_
andin_
filter methods are prefixed with_
sign to avoid collisions with reserved keywords.
You can find detail documentation from here.
Reading your data
import 'package:postgrest/postgrest.dart';
var url = 'https://example.com/postgrest/endpoint';
var client = PostgrestClient(url);
var response = await client.from('users').select().end();
Insert records
import 'package:postgrest/postgrest.dart';
var url = 'https://example.com/postgrest/endpoint';
var client = PostgrestClient(url);
var response = await client.from('users')
.insert([
{ 'username': 'supabot', 'status': 'ONLINE'}
])
.end();
Update a record
import 'package:postgrest/postgrest.dart';
var url = 'https://example.com/postgrest/endpoint';
var client = PostgrestClient(url);
var response = await client.from('users')
.update({ 'status': 'OFFLINE' })
.eq('username', 'dragarcia')
.end();
Delete records
import 'package:postgrest/postgrest.dart';
var url = 'https://example.com/postgrest/endpoint';
var client = PostgrestClient(url);
var response = await client.from('users')
.delete()
.eq('username', 'supabot')
.end();
Contributing #
- Fork the repo on GitHub
- Clone the project to your own machine
- Commit changes to your own branch
- Push your work back up to your fork
- Submit a Pull request so that we can review your changes and merge
License #
This repo is liscenced under MIT.
Credits #
- https://github.com/supabase/postgrest-js - ported from postgrest-js library
Sponsors #
We are building the features of Firebase using enterprise-grade, open source products. We support existing communities wherever possible, and if the products don’t exist we build them and open source them ourselves. Thanks to these sponsors who are making the OSS ecosystem better for everyone.