Download the PHP package campoint/postgrest-php without Composer

On this page you can find all versions of the php package campoint/postgrest-php. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of campoint/postgrest-php

Informations about the package postgrest-php

postgrest-php

License PHP version Code coverage Release Commit activity Documentation

PostgREST client for PHP. This library provides a synchronous and asynchronous interface to PostgREST.

Table of Contents

Installation

Requirements

Instructions

composer require campoint/postgrest-php

Basic usage

Create a client

This library provides both an async and sync client. Under the hood we use ReactPHP to dispatch requests and the only difference between the sync and async client is, that the sync client calls await() on the Promise for you. You can optionally pass a configured Browser object to the client, but the baseUrl and timeout parameters will be overwritten.

Sync

Create a client for synchronous environments:

Select

Select data from any table, in any schema and apply arbitrary filters:

Insert

Insert data into any table, in any schema:

Upsert

Upsert data into any table, in any schema:

Update

Update any row in any table, in any schema with arbitrary filters:

Delete

Delete any row in any table, in any schema with arbitrary filters:

Call stored procedure

Call any stored procedure with arbitrary arguments:

Advanced usage

If you need further documentation on how to use this library, refer to the documentation located here.

Creating an issue

When encountering a bug with this library, feel free to open a new issue. To improve the understanding of your problem, you should fork this repository and append a new failing test case which represents the bug. If needed, create new testing databases in the testing_db/initdb path. Reference your new test in the issue. Issues which report bugs but have no test cases attached to it, will be probably ignored. Please also supply the used PostgREST and PostgreSQL versions to bug reports, to ease the task of reproducing your issue. Create feature request issues only if you have the intent to implement them yourself.

Local development & testing

When developing or testing the client, you can use the pre-configured docker-compose environment to run both PostgreSQL and PostgREST. The docker-compose.yml file contains the services to start PostgreSQL versions 12 to 15 and PostgREST at version 9 to 11. To start the local environment, simply run:

docker-compose up postgresql14 postgrest11

Once the environment started, you can access PostgREST at port 8080 and PostgreSQL at port 5432.

Local development

The repository provides a devcontainer which you can use for developing the client. Development happens only over PR's because we want to keep master stable and always usable for new, unreleased features. When opening a PR against master all necessary checks and tests are executed, to ensure nothing breaks. To ensure your PR does not fail due to linter or static analyzer checks, run the following commands before opening the PR:

composer ci-ready

Testing

This client is integration tested using docker-compose to run the needed dependencies. To run the tests locally, run these steps:

docker-compose up -d postgresql14 postgrest11
composer test

All versions of postgrest-php with dependencies

PHP Build Version
Package Version
Requires php Version ^8.1
react/http Version ^1.5
react/async Version ^4.0
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package campoint/postgrest-php contains the following files

Loading the files please wait ....