Set search_path for all database functions, as this is recommended
by the Supabase security advisor
Fix items_delete functions: The function was never working, which
caused that we saved to many items for a source, which slowed down our
performance
Revoke execution rights for users for the sources_delete_files and items_delete functions
Add E2E test, to check if users can call the database functions
🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.
## 📋 Pull Request Information
**Original PR:** https://github.com/feeddeck/feeddeck/pull/259
**Author:** [@ricoberger](https://github.com/ricoberger)
**Created:** 5/2/2025
**Status:** ✅ Merged
**Merged:** 5/2/2025
**Merged by:** [@ricoberger](https://github.com/ricoberger)
**Base:** `main` ← **Head:** `adjust-database-functions`
---
### 📝 Commits (1)
- [`0ef6500`](https://github.com/feeddeck/feeddeck/commit/0ef6500e407127856a6a844f17f749efa51e226d) Adjust Database Functions
### 📊 Changes
**2 files changed** (+174 additions, -0 deletions)
<details>
<summary>View changed files</summary>
📝 `supabase/functions/_e2e/e2e_test.ts` (+8 -0)
➕ `supabase/migrations/20250502162957_adjust_database_functions.sql` (+166 -0)
</details>
### 📄 Description
- Set `search_path` for all database functions, as this is recommended
by the Supabase security advisor
- Fix `items_delete` functions: The function was never working, which
caused that we saved to many items for a source, which slowed down our
performance
- Revoke execution rights for users for the `sources_delete_files` and
`items_delete` functions
- Add E2E test, to check if users can call the database functions
<!--
Keep PR title verbose enough and add prefix telling about what source it touches e.g "[rss] Add feature xyz" or if the
the PR is not realated to a source use "[core]", e.g. "[core] Fix xyz".
If you add a breaking change within your PR you should add ":warning:" to the title,
e.g. ":warning: [core] My breaking change"
-->
<!--
Description of what have been changed. Please also reference an issue, when available.
-->
---
<sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
📋 Pull Request Information
Original PR: https://github.com/feeddeck/feeddeck/pull/259
Author: @ricoberger
Created: 5/2/2025
Status: ✅ Merged
Merged: 5/2/2025
Merged by: @ricoberger
Base:
main← Head:adjust-database-functions📝 Commits (1)
0ef6500Adjust Database Functions📊 Changes
2 files changed (+174 additions, -0 deletions)
View changed files
📝
supabase/functions/_e2e/e2e_test.ts(+8 -0)➕
supabase/migrations/20250502162957_adjust_database_functions.sql(+166 -0)📄 Description
search_pathfor all database functions, as this is recommendedby the Supabase security advisor
items_deletefunctions: The function was never working, whichcaused that we saved to many items for a source, which slowed down our
performance
sources_delete_filesanditems_deletefunctions🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.