# Change Log

Find all notable changes of this project in this file.

## v2.6.0 - 2026-10-02
### Fixes
- [#208](https://github.com/raphiniert-com/ra-data-postgrest/pull/208) Fix nested filter arrays when a column receives 3+ values @[fzaninotto](https://github.com/fzaninotto)

### Improvements
- updated dependencies

## v2.5.1 - 2025-04-29
### Fixes
- [#182](https://github.com/raphiniert-com/ra-data-postgrest/issues/182) Fix the need for workaround by switching to [dequal](https://www.npmjs.com/package/dequal)

## v2.5.0 - 2025-04-23
### Improvements
- [#181](https://github.com/raphiniert-com/ra-data-postgrest/pull/181) Add support for embed and prefetch @[djhi](https://github.com/djhi)
- updated dependencies

## v2.4.1 - 2024-09-04
### Improvements
- updated/fixed README.md

## v2.4.0 - 2024-09-04
### Fixes
- [#166](https://github.com/raphiniert-com/ra-data-postgrest/pull/166) Fix update fails when nothing is changed @[fzaninotto](https://github.com/fzaninotto)
- [#165](https://github.com/raphiniert-com/ra-data-postgrest/pull/165) Fix getMany fails when called with an empty array of ids @[fzaninotto](https://github.com/fzaninotto)

### Improvements
- [#164](https://github.com/raphiniert-com/ra-data-postgrest/pull/164) Add nullslast and nullsfirst support to getList @[fzaninotto](https://github.com/fzaninotto)
- updated dependencies
- updated README.md: added section "Citation"

## v2.3.0 - 2024-06-28
### Improvements
- [#142](https://github.com/raphiniert-com/ra-data-postgrest/pull/142) Add support for React Admin v5 @[slax57](https://github.com/slax57)
- updated dependencies

## v2.2.0 - 2024-06-28
### Improvements
- [#123](https://github.com/raphiniert-com/ra-data-postgrest/pull/125) Adding global sort order options @[kav](https://github.com/kav)

## v2.1.0 - 2024-02-27
### Improvements
- updated dependencies

### Fixes
- [#123](https://github.com/raphiniert-com/ra-data-postgrest/pull/123) Modifying update call to only update changed fields @[kav](https://github.com/kav)


## v2.0.0 - 2023-12-29
### Improvements
- updated dependencies

### Fixes
- [#113](https://github.com/raphiniert-com/ra-data-postgrest/pull/113) remove {} value wrapping for cs/cd @[ruslantalpa](https://github.com/ruslantalpa)

### Breaking changes
- the fix in this version might break old versions, as the {} are removed. Thus, one needs to manually add the {} for cs/cd.


## v2.0.0-alpha.4 - 2023-10-23
### Improvements
- updated dependencies

### New feature
- [#100](https://github.com/raphiniert-com/ra-data-postgrest/pull/100) support "meta.columns" on all code paths (useful when the user does not have permissions on all the columns in which case doing select=* gives permissions errors) - @[ruslantalpa](https://github.com/ruslantalpa)

### Fixes
- [#50](https://github.com/raphiniert-com/ra-data-postgrest/issues/50) and [#88](https://github.com/raphiniert-com/ra-data-postgrest/issues/88) solved by [#100](https://github.com/raphiniert-com/ra-data-postgrest/pull/100) including other fixes - @[ruslantalpa](https://github.com/ruslantalpa)


## v2.0.0-alpha.3 - 2023-06-16
### Improvements
- updated dependencies

### New feature
- [#82](https://github.com/raphiniert-com/ra-data-postgrest/pull/82), add logical operator filter parsing - @[jordiyapz](https://github.com/jordiyapz)

### Fixes
- [#81](https://github.com/raphiniert-com/ra-data-postgrest/pull/81), use {} with cs and cd operators url - @[YannBeauxis](https://github.com/YannBeauxis)

### Breaking changes
- Changed from from regular parameters to instantiate the dataProvider to a configuration interface/class. Thus, in future initalize the dataProvider by creating a structure which implements the interface:

```jsx
import { fetchUtils } from 'react-admin';
import postgrestRestProvider, 
    { IDataProviderConfig, 
      defaultPrimaryKeys, 
      defaultSchema } from '@raphiniert/ra-data-postgrest';

const config: IDataProviderConfig = {
    apiUrl: 'http://path.to.my.api/',
    httpClient: fetchUtils.fetchJson,
    defaultListOp: 'eq',
    primaryKeys: defaultPrimaryKeys,
    schema: defaultSchema
}

dp = postgrestRestProvider(config);
```

## v2.0.0-alpha.2 - 2023-04-24
### Improvements
- updated dependencies

### New feature
- [#49](https://github.com/raphiniert-com/ra-data-postgrest/issues/49), custom schema name can be used

## v2.0.0-alpha.1 - 2023-04-09
### Improvements
- updated dependencies
- updated `urlBuilder` and integrated URL encoding

### New feature
- [#48](https://github.com/raphiniert-com/ra-data-postgrest/issues/48) solved by pull request [#55](https://github.com/raphiniert-com/ra-data-postgrest/pull/55), the create method should return the data returned by postgrest and not the posted data - @[christiaanwesterbeek](https://github.com/christiaanwesterbeek)
- [#39](https://github.com/raphiniert-com/ra-data-postgrest/pull/39), allow passing extra headers via meta for react-admin hooks - @[christiaanwesterbeek](https://github.com/christiaanwesterbeek)
- [#41](https://github.com/raphiniert-com/ra-data-postgrest/pull/41), allow columns filtering for getList and getManyReference - @[christiaanwesterbeek](https://github.com/christiaanwesterbeek)
- added support of [#41](https://github.com/raphiniert-com/ra-data-postgrest/pull/41) for other functions, but `create` and `updateMany`
- [#38](https://github.com/raphiniert-com/ra-data-postgrest/pull/38), Let the sort param in getList be optional - @[christiaanwesterbeek](https://github.com/christiaanwesterbeek)


## v1.2.1 - 2023-04-07
- small fix in condition
- fixed package name

## v2.0.0-alpha.0 - 2022-11-23

-   [#42](https://github.com/raphiniert-com/ra-data-postgrest/issues/42), started adding some unit tests - @[christiaanwesterbeek](https://github.com/christiaanwesterbeek)
-   dropped authProvider
-   code cleanup & restructuring
-   minor bugfixes - @[christiaanwesterbeek](https://github.com/christiaanwesterbeek)
-   added some notes to README.md

### Breaking changes

-   dropped authProvider as this should rather be an own package in case of a generic piece of software or application specific.

## v1.2.0 - 2022-08-23

-   [#33](https://github.com/raphiniert-com/ra-data-postgrest/pull/33), adding dependabot - @[promitheus7](https://github.com/promitheus7)
-   [#30](https://github.com/raphiniert-com/ra-data-postgrest/pull/30) and [#33](https://github.com/raphiniert-com/ra-data-postgrest/pull/33), updated dependency to compatible starting from `ra-core` 4.1.x - @[corrideat](https://github.com/corrideat), @[promitheus7](https://github.com/promitheus7)

## v1.1.9 - 2022-08-23

-   [#30](https://github.com/raphiniert-com/ra-data-postgrest/pull/30), updated ts and modified code, such that some package dependencies became unrequired - @[corrideat](https://github.com/corrideat)

## v1.1.8 - 2022-01-07

-   required re-release as I missed to transpile all and upload the features of 1.1.7 to npm.

## v1.1.7 - 2022-01-07

### Fixes

-   fixed bad behaivor with compound keys while using field named `id` [issue #27](https://github.com/raphiniert-com/ra-data-postgrest/issues/27) and [issue #19](https://github.com/raphiniert-com/ra-data-postgrest/pull/19) - @[kenfehling](https://github.com/kenfehling)

### New feature

-   [#26](https://github.com/raphiniert-com/ra-data-postgrest/pull/26), added rpc filter support, which is explained [here](https://github.com/raphiniert-com/ra-data-postgrest#special-filter-feature-rpc-functions) - @[TheRealAstroboy](https://github.com/TheRealAstroboy)

## v1.1.6 - 2021-01-16

### Fixes

-   [#24](https://github.com/raphiniert-com/ra-data-postgrest/pull/24), fixed eq. prefix for non-compound keys [issue #23](https://github.com/raphiniert-com/ra-data-postgrest/issues/23) - @[andymed-jlp](https://github.com/andymed-jlp)

## v1.1.5 - 2021-01-16

### Fixes

-   fixed query string generation of rpc endpoints [issue #22](https://github.com/raphiniert-com/ra-data-postgrest/issues/22)

### Breaking changes

-   Support was dropped for generating the query string given many ids in case of an rpc endpoint. If your application has some psql functions which parse the standard input, I recommend to rework your db design. If this change causes strong damage to your application, please contact me in order to find a proper generic solution. Query strings of single rpc calls now drop the operator (`eq.`) and are generated properly.

## v1.1.4 - 2021-01-16

-   deployment error

## v1.1.3 - 2020-11-30

### Fixes

-   [#20](https://github.com/raphiniert-com/ra-data-postgrest/pull/20), fixed small bug in update - @[mkkane](https://github.com/mkkane)
-   removed console log

## v1.1.2 - 2020-10-05

### Fixes

-   fixed the last fix of getMany and getManyReferecnce for compound keys :)

## v1.1.1 - 2020-09-28

### Fixes

-   fixed getMany and getManyReferecnce for compound keys

## v1.1.0 - 2020-09-16

### Fixes

-   removed requirement to define order key in react admin, when using compound keys: default was `id`, now it's the compound key

### Breaking changes

-   refactored compound primary keys:
    For single custom keys wrap an array as follows:
    ```jsx
    const dataProvider = postgrestRestProvider(
        API_URL,
        fetchUtils.fetchJson,
        'eq',
        new Map([
            ['some_table', ['custom_id']], // <- instead of ['some_table','custom_id']
            ['another_table', ['first_column', 'second_column']],
        ])
    );
    ```

## v1.0.7 - 2020-08-23

### New feature

-   [#14](https://github.com/raphiniert-com/ra-data-postgrest/pull/14), added compound primary keys (see [README.md](https://github.com/raphiniert-com/ra-data-postgrest/blob/master/README.md#compound-primary-keys)) - @[programmarchy](https://github.com/programmarchy)

### Maintenance

-   `import React from 'react';` -> `import * as React from 'react';`
-   Some minor code cleanup

## v1.0.6 - 2020-06-15

### Fixes

-   Fixed wrong support statement concerning [postgrest starter kit](https://github.com/subzerocloud/postgrest-starter-kit) in readme

## v1.0.5 - 2020-06-15

### Fixes

-   [#13](https://github.com/raphiniert-com/ra-data-postgrest/pull/13), Remove console.log - @[jpagex](https://github.com/jpagex)
-   [#12](https://github.com/raphiniert-com/ra-data-postgrest/pull/12), Fixed limit parameter - @[jpagex](https://github.com/jpagex)

## v1.0.4 - 2020-06-08

### Fixes

-   Fixed missing js files in npm package [#8](https://github.com/raphiniert-com/ra-data-postgrest/issues/8)
-   [#9](https://github.com/raphiniert-com/ra-data-postgrest/pull/9), Fixed typo in readme - @[seclace](https://github.com/seclace)

## v1.0.3 - 2020-05-17

### Fixes

-   Fixed bug when multidelete - @[colonist4096](https://github.com/colonist4096)
-   [#5](https://github.com/raphiniert-com/ra-data-postgrest/pull/6), Fixed bug while using multiple filters on the same attribute - @[olivierdalang](https://github.com/olivierdalang)

## v1.0.2 - 2020-03-10

### Fixes

-   [#4](https://github.com/raphiniert-com/ra-data-postgrest/pull/4), Fixed bug while using ReferenceField with UUID - @[xero88](https://github.com/xero88)

## v1.0.1 - 2020-02-01

-   initial release