postgrest 1.4.0

postgrest: ^1.4.0 copied to clipboard

• FIX: maybeSingle no longer logs error on Postgrest API (#564). (f6854e1d)
• FEAT(postgrest): updates for postgREST 11 (#550). (64d8eb59)

• FIX(postgrest): update docs to mention views (#543). (22eb68f2)

• REFACTOR: bump minimum Dart SDK version to 2.17.0 (#510). (ed927ee0)

• FIX: Update http dependency constraints (#491). (825d0737)

• FIX(postgrest): Remove qoutations on foreign table transforms on 'or' (#477). (c2c6982a)
• FIX: Format the files to adjust to Flutter 3.10.1 (#475). (eb0bcd95)
• FEAT: update dependency constraints to sdk < 4.0.0 (#474). (7894bc70)

• chore: move the repo into supabase-flutter monorepo

• fix: deprecate auth(), use setAuth() instead #107
• fix: requests don't affect client's headers #107

• fix: deprecate returning parameter of .delete() #105
• chore: improve comment docs #105

• fix: remove the breaking change that was introduced in v1.2.0 #103

• BREAKING: use isolates only for huge JSON and reuse isolates #90
  • This breaking chnge has been removed in v1.2.1

• fix: keep custom http client with converter #100

• fix: implement catchError #97
• feat: add generic types to .select() #94

  // data is `List<Map<String, dynamic>>`
  final data = await supabase.from<List<Map<String, dynamic>>>('users').select();
  
  // data is `Map<String, dynamic>`
  final data = await supabase.from<Map<String, dynamic>>('users').select().eq('id', myId).single();
  

• fix: calling .select() multiple times will override the previous .select() #95

• chore: v1.0.0 release 🚀
• BREAKING: set minimum Dart SDK version to 2.15.0 #92

• fix: update insert documentation to reflect new returning behavior #88

• fix: maybeSingle #84
• fix: List as value in any filter #85

• BREAKING: rename PostgrestError to PostgrestException

• BREAKING: data is returned directly and error is thrown instead of being returned within a response

try {
  final data = await client.from('countries').select();
  print(data);
} on PostgrestError catch (error, stacktrace) {
  // handle a PostgrestError
  print('$error \n $stacktrace');
} catch (error, stacktrace) {
  // handle other errors
  print('$error \n $stracktrace');
}

• count and head can be specified within FetchOptions() in .select()

final response = await client.from('countries').select('*', FetchOptions(count: CountOption.exact));
print(response.data);
print(response.count);

• BREAKING: returning option in .insert(), .upsert(), .update() and .delete() have been removed. .select() should be appended on the query to return the result of those operations.

final data = await client.from('countries').insert({'name': 'France'}).select();

• DEPRECATED: .execute() is now deprecated
• chore: all deprecated filter methods have been removed
• chore: using lints package for linting
• fix: Added typesafe HTTP Methods (METHOD_GET, METHOD_HEAD, METHOD_POST, METHOD_PUT, METHOD_PATCH, METHOD_DELETE)

• fix: order() and limit() not working as expected with foreign table bug
• feat: add foreignTable arg to or filter

• fix: bug where using multiple filters on the same field with order will wipe out the filters except the last one.

• feat: allow custom http client
• fix: bug where multiple order does not reorder the result

• feat: added withConverter to PostgrestBuilder

  final res = await postgrest
    .from('users')
    .select()
    .withConverter<List>((data) => [data])
    .execute();
  

• fix: allow multiple filters on the same column
• fix: List passed to filter, eq or neq will correctly be formatted

• fix: bug where filter is not available on rpc()

• feat: added X-Client-Info header

• fix: bug where List of num is passes as filter parameter

• fix: bug when using not filter with in

• feat: implement ReturningOption
• feat: add ignoreDuplicates option to upsert
• feat: create maybeSingle() function
• feat: sorting by multiple columns
• fix: export TextSearchType

• chore: added count_option export

• feat: Add CSV response
• chore: remove unnecessary new keyword on docs

• fix: PostgrestError parsing

• deprecated: cs() in filter. Use contains() instead.
• deprecated: cd() in filter. Use containedBy() instead.
• deprecated: sl() in filter. Use rangeLt() instead.
• deprecated: sr() in filter. Use rangeGt() instead.
• deprecated: nxl() in filter. Use rangeGte() instead.
• deprecated: nxr() in filter. Use rangeLte() instead.
• deprecated: adj() in filter. Use rangeAdjacent() instead.
• deprecated: ov() in filter. Use overlaps() instead.
• deprecated: fts() in filter. Use textSearch() instead.
• deprecated: plfts() in filter. Use textSearch() instead.
• deprecated: phfts() in filter. Use textSearch() instead.
• deprecated: wfts() in filter. Use textSearch() instead.

• feat: Migrate to null-safe dart

• feat: allow postgrest.rpc() filtering
• refactor: builder into separate classes
• chore: update stored procedure unit tests

• fix: error json parsing
• fix: unit tests
• refactor: remove PostgrestResponse.statusText
• refactor: clean up PostgrestError, PostgrestResponse
• chore: export PostgrestError class
• chore: update example with try/catch

• chore: export builder class

• feat: support head request and row count option

• fix: lint errors

• Remove pre-release verion notice

• refactor: improve code style
• Initial Release

• chore: replace end() with execute()
• refactor: options param (map type) into named parameters

• refactor: rename response.body to response.data

• chore: return PostgrestResponse and PostgrestError instead of a Map obj

• fix: lint errors

• Refactor code structure by following postgrest-js TypeScript update.
• Update documents.

• Fixes examples + typo.

• Remove Flutter package dependency.
• Clean up + refactor.

• Initial pre-release.