Search packages, repositories and app categories

Package detailsv2.9.1

postgrest

PostgREST client for Dart. This library provides an ORM interface to PostgREST.

AndroidiOSWebmacOSWindowsLinux
30-day downloads
1.3M
Likes
137
Pub points
150

Install package

flutter pub add postgrest

Package Overview

Package selection guidance compiled from public package information, community data, and project usage.

PostgREST is a Dart client library that provides an ORM-like interface for interacting with PostgREST, a RESTful API server for PostgreSQL databases. It enables developers to perform database operations using HTTP requests, abstracting SQL queries into intuitive method calls. Designed for use with Supabase, it simplifies data retrieval, insertion, updates, and deletion across multiple platforms. The library supports all major platforms including Android, iOS, Web, macOS, Windows, and Linux, making it ideal for full-stack Dart applications.

Use cases

  • Building real-time apps with Supabase
  • Performing CRUD operations on PostgreSQL
  • Integrating backend logic without custom APIs
  • Creating cross-platform database-driven apps
  • Simplifying database interactions in Flutter
  • Enabling secure, scalable data access

Key features

  • ORM-style interface for PostgREST
  • Supports all major platforms
  • Seamless integration with Supabase
  • Type-safe query building
  • Automatic JSON serialization
  • Flexible filtering and sorting

Suitable for

  • Flutter developers using Supabase
  • Apps requiring direct PostgreSQL access
  • Teams avoiding custom backend services
  • Projects needing rapid prototyping
  • Developers seeking lightweight database clients

Considerations

  • Requires a running PostgREST server
  • Dependent on Supabase ecosystem
  • Limited to PostgreSQL-backed APIs
  • Authentication must be handled externally
  • Not suitable for complex SQL scenarios without customization

Original README

Original README snapshot from the linked source repository. Visit the repository for the latest content.


Supabase Logo

Supabase Flutter

Flutter client library for Supabase.

Guides · Reference Docs · Migration Guides

Build Package License: MIT

Run locally

This repo is a monorepo powered by Melos containing supabase_flutter and its sub-libraries. All packages are located in the packages directory.

To install on a locally developed app:

  • Clone this repo
  • Install Melos globally if you haven't already: dart pub global activate melos
  • Run melos bootstrap or melos bs at the root of the cloned directory to install dependencies
  • Add the target package to your pubspec.yaml file specifying the path.
    supabase_flutter:
      path: <your-path-to-the-local-supabase-flutter-repo>/packages/supabase_flutter
    

Testing your app

The helpers the test suites of these packages run on are published in package:supabase_test, so your tests can build on the same primitives: mock HTTP clients, JWT builders, auth session fixtures and realtime frames. Add the package as a dev dependency:

dev_dependencies:
  supabase_test: ^0.1.0

Then stub the endpoints the code under test talks to and run it against a real SupabaseClient, with no running stack required:

final httpClient = MockSupabaseHttpClient()
  ..stubTable('todos', rows: [
    {'id': 1, 'task': 'Ship it', 'status': false},
  ]);
final supabase = testSupabaseClient(httpClient: httpClient);
addTearDown(supabase.dispose);

final todos = await supabase.from('todos').select();
expect(todos, hasLength(1));

See the supabase_test README for the full guide: stubbing database, rpc, edge function and auth endpoints, asserting on recorded requests, running tests as a signed-in user, and wiring Supabase.initialize in Flutter widget tests.

Testing this repo

The tests for the packages postgrest, supabase_auth, supabase_realtime and supabase_storage run against a local Supabase stack. To run these tests locally you need docker and the Supabase CLI installed.

The single configuration for the stack lives in the supabase directory at the repository root. Start it with:

supabase start

Run the Dart tests within the package directory in packages/<package> with the following command. The -j 1 flag runs the tests not concurrently, which works better since the tests run against the same services.

dart test -j 1

To stop the stack run the following command from the repository root:

supabase stop

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 licensed under MIT.

Resources

Categories

Dependencies

Dependency list 5 items

Source repository

Projects using this package

No data available yet.