Feldera

Added

- API: Generalized upsert operation that allows partial modifications to table records ([1296](https://github.com/feldera/feldera/pull/1296))
- SQL: Functions on binary string (octet_length, position, overlay, substring) ([1264](https://github.com/feldera/feldera/pull/1264))
- pipeline-manager: add PUT endpoints for Programs, Pipelines, and Connectors (1248)
- Documentation: Adding a markdown page for videos (1126)
- SQL: Add hyperbolic functions ([1280](https://github.com/feldera/feldera/pull/1280))

Fixed

- pipeline-manager: fix a resource usage problem with http streaming under high load ([1257](https://github.com/feldera/feldera/pull/1257))
- SQL: Changed the semantics of integer arithmetic to match SQL standard ([1247](https://github.com/feldera/feldera/pull/1247))
- WebConsole: Connector name change doesn't reflect in the pipeline builder (1238)
- WebConsole: UI sends HTTP request in an infinite loop (1085)
- pipeline-manager: allow docs website to CORS allowed origins (1285)

Changed

- Python demo and test scripts are standalone as they no longer depend on dbsp python library ([1230](https://github.com/feldera/feldera/pull/1230))
- pipeline-manager: update service endpoints to use names instead of IDs in URLs, and add PUT endpoint ([1263](https://github.com/feldera/feldera/pull/1263))
- SQL: Changed the semantics of integer arithmetic to match SQL standard ([1247](https://github.com/feldera/feldera/pull/1247))
- pipeline-manager: use names instead of IDs in API endpoints (1214)
- WebConsole: use names instead of IDs as an API entity identifier (1214)
- WebConsole: Bearer token expiration now triggers a background token refresh or redirects to a login page (1100)
- Minimal rust version required to build feldera increased to 1.75 (was 1.73).

Added
- WebConsole: Add ability to edit connector configuration as JSON
- SQL: Preliminary support for computations with bounded memory on unbounded
streams ([1197](https://github.com/feldera/feldera/pull/1197))

Fixed
- SQL: Changed semantics of division to match SQL standard
([1201](https://github.com/feldera/feldera/pull/1201))
- WebConsole: display AWS Cognito username in user profile dropdown (1077)

Fixed
- WebConsole: Vendor logos now change color when in dark mode

Added
- SQL: support for trigonometric functions `sin` and `cos` ([1118](https://github.com/feldera/feldera/pull/1118))
- SQL: support for mathematical constant `PI` ([1123](https://github.com/feldera/feldera/pull/1123))
- WebConsole: 'Inspect connector' button in the connector list in Pipeline Builder that opens a non-editable popup (1128)
- SQL: Support for user-defined functions, declared in SQL and implemented in Rust ([1129](https://github.com/feldera/feldera/pull/1129))
- SQL: support for other trigonometric functions supported by Calcite ([1127](https://github.com/feldera/feldera/pull/1127))
- WebConsole: Add Settings page, add a view to manage API keys (1136)

Fixed

- WebConsole: Add "Queued" status for pipelines whose programs are enqueued to be compiled (1032)
- WebConsole: Random input generator doesn't work for a decimal column (1006)
- pipeline-manager: do not allow pipelines to be started mid-compilation (1081)

Added

- WebConsole: Support big numeric SQL types in Data Browser, Data Import and Data Generator (851)
- WebConsole: Display SQL types in Data inspect and insert tables
- SQL: parser support for 'DEFAULT' column values in DDL (1061)
- pipeline-manager: add Service to database and API ([1074](https://github.com/feldera/feldera/pull/1074))

Fixed

- [SQL] Fix bugs in parsing of KEY and FOREIGN KEY constraints
- Use better defaults for running the pipeline-manager (994) ([1011](https://github.com/feldera/feldera/pull/1011))
- WebConsole: Fix unable to delete orphaned output connectors,
SQL views in Pipeline Builder do not get removed when removed from the program ([854](https://github.com/feldera/feldera/issues/854))
- WebConsole: Replace youtube link on Webconsole UI home page ([935](https://github.com/feldera/feldera/issues/935))
- WebConsole: Kafka authentication protocol security.protocol field ([963](https://github.com/feldera/feldera/issues/963))
- WebConsole: Differentiate compiling and pending in web-console editor ([695](https://github.com/feldera/feldera/issues/695))
- WebConsole: Report number of parsing errors per connector ([776](https://github.com/feldera/feldera/issues/776))
- WebConsole: Table browser doesn't always correctly apply updates - no longer reproduces ([635](https://github.com/feldera/feldera/issues/635))
- WebConsole: MUI DataGridPro fails to load data on Next.js > 13.4.8-canary.9 - no longer reproduces ([494](https://github.com/feldera/feldera/issues/494))
- WebConsole: Spacing for SQL icon is off in pipeline view ([932](https://github.com/feldera/feldera/issues/932))
- WebConsole: Pipeline failure state in Pipeline Management isn't cleared immediately - no longer reproduces ([1012](https://github.com/feldera/feldera/issues/1012))
- REST API: Fold ResourceConfig into RuntimeConfig to allow users to configure resources ([1035](https://github.com/feldera/feldera/pull/1035))

Added

- [SQL] New aggregation functions: `BIT_AND`, `BIT_OR`, `BIT_XOR`. Concatenation for `BINARY values`. `TO_HEX` function. ([996](https://github.com/feldera/feldera/pull/996))
- pipeline-manager now exposes a scrape endpoint for metrics, starting with the compiler service ([1031](https://github.com/feldera/feldera/pull/1031))

Fixed
- Fix a bug in Pipeline Management table where sometimes pipeline action buttons do not send requests ([1008](https://github.com/feldera/feldera/pull/1008))