.github/workflows/ci.yml

@@ -17,18 +17,19 @@ jobs:
     steps:
       - uses: actions/checkout@v4
 
-      - uses: pnpm/action-setup@v3.0.0
+      - name: Install pnpm
+        uses: pnpm/action-setup@v4
         with:
-          version: 8.x.x
+          run_install: false
 
-      - name: Set up Node
+      - name: Install Node.js
         uses: actions/setup-node@v4
         with:
           node-version: 20
-          cache: pnpm
+          cache: 'pnpm'
 
-      - name: Install Dependencies
-        run: pnpm install --frozen-lockfile
+      - name: Install dependencies
+        run: pnpm install
 
       - name: Start Supabase
         uses: nick-fields/retry@v3
@@ -51,37 +52,50 @@ jobs:
         run: pnpm turbo run test --concurrency=1
 
       - name: Upload postgrest-core coverage
-        uses: codecov/codecov-action@v4
+        uses: codecov/codecov-action@v5
         with:
-          files: ./packages/postgrest-core/coverage/coverage-final.json
+          token: ${{ secrets.CODECOV_TOKEN }}
+          file: ./packages/postgrest-core/coverage/coverage-final.json
           flags: postgrest-core
 
       - name: Upload postgrest-react-query coverage
-        uses: codecov/codecov-action@v4
+        uses: codecov/codecov-action@v5
         with:
-          files: ./packages/postgrest-react-query/coverage/coverage-final.json
+          token: ${{ secrets.CODECOV_TOKEN }}
+          file: ./packages/postgrest-react-query/coverage/coverage-final.json
           flags: postgrest-react-query
 
       - name: Upload postgrest-swr coverage
-        uses: codecov/codecov-action@v4
+        uses: codecov/codecov-action@v5
         with:
-          files: ./packages/postgrest-swr/coverage/coverage-final.json
+          token: ${{ secrets.CODECOV_TOKEN }}
+          file: ./packages/postgrest-swr/coverage/coverage-final.json
           flags: postgrest-swr
 
       - name: Upload storage-core coverage
-        uses: codecov/codecov-action@v4
+        uses: codecov/codecov-action@v5
         with:
-          files: ./packages/storage-core/coverage/coverage-final.json
+          token: ${{ secrets.CODECOV_TOKEN }}
+          file: ./packages/storage-core/coverage/coverage-final.json
           flags: storage-core
 
       - name: Upload storage-swr coverage
-        uses: codecov/codecov-action@v4
+        uses: codecov/codecov-action@v5
         with:
-          files: ./packages/storage-swr/coverage/coverage-final.json
+          token: ${{ secrets.CODECOV_TOKEN }}
+          file: ./packages/storage-swr/coverage/coverage-final.json
           flags: storage-swr
 
       - name: Upload storage-react-query coverage
-        uses: codecov/codecov-action@v4
+        uses: codecov/codecov-action@v5
         with:
-          files: ./packages/storage-react-query/coverage/coverage-final.json
+          token: ${{ secrets.CODECOV_TOKEN }}
+          file: ./packages/storage-react-query/coverage/coverage-final.json
           flags: storage-react-query
+
+      - name: Upload postgrest-server coverage
+        uses: codecov/codecov-action@v5
+        with:
+          token: ${{ secrets.CODECOV_TOKEN }}
+          file: ./packages/postgrest-server/coverage/coverage-final.json
+          flags: postgrest-server

.github/workflows/update-prs.yml

@@ -1,5 +1,8 @@
 name: Update stale PRs
-on: push
+on:
+  push:
+    branches:
+      - main
 
 jobs:
   update-prs:

.gitignore

@@ -27,4 +27,7 @@ yarn-error.log*
 .turbo
 
 # dist
-**/dist/
+**/dist/
+
+tsconfig.tsbuildinfo
+

.nvmrc

@@ -0,0 +1,2 @@
+22.14.0
+

README.md

@@ -10,13 +10,14 @@
 
 ## Introduction
 
-The cache helpers bridge the gap between popular frontend cache management solutions such as [SWR](https://swr.vercel.app) or [React Query](https://tanstack.com/query/latest), and the Supabase client libraries. All features of [`postgrest-js`](https://github.com/supabase/postgrest-js), [`storage-js`](https://github.com/supabase/storage-js) and [`realtime-js`](https://github.com/supabase/realtime-js) are supported. The cache helpers parse any query into a unique and definite query key, and automatically populates your query cache with every mutation using implicit knowledge of the schema. Check out the [demo](https://supabase-cache-helpers-swr.vercel.app) and find out how it feels like for your users.
+The cache helpers bridge the gap between popular frontend cache management solutions such as [SWR](https://swr.vercel.app) or [React Query](https://tanstack.com/query/latest), and the Supabase client libraries. All features of [`postgrest-js`](https://github.com/supabase/postgrest-js), [`storage-js`](https://github.com/supabase/storage-js) and [`realtime-js`](https://github.com/supabase/realtime-js) are supported. It also provides a simple server-side abstraction to cache queries to the `PostgREST` API. The cache helpers parse any query into a unique and definite query key, and automatically populates your query cache with every mutation using implicit knowledge of the schema. Check out the [demo](https://supabase-cache-helpers-swr.vercel.app) and find out how it feels like for your users.
 
 ## Features
 
 With just one single line of code, you can simplify the logic of **fetching, subscribing to updates, and mutating data as well as storage objects** in your project, and have all the amazing features of [SWR](https://swr.vercel.app) or [React Query](https://tanstack.com/query/latest) out-of-the-box.
 
 - **Seamless** integration with [SWR](https://swr.vercel.app) and [React Query](https://tanstack.com/query/latest)
+- Support for **Server-Side** queries
 - **Automatic** cache key generation
 - Easy **Pagination** and **Infinite Scroll** queries
 - **Insert**, **update**, **upsert** and **delete** mutations
@@ -42,12 +43,12 @@ The cache helpers are split up into reusable libraries.
 - [`storage-swr`](./packages/storage-swr/README.md): [SWR](https://swr.vercel.app) wrapper for storage [storage-js](https://github.com/supabase/storage-js)
 - [`postgrest-react-query`](./packages/postgrest-react-query/README.md): [React Query](https://tanstack.com/query/latest) wrapper for [postgrest-js](https://github.com/supabase/postgrest-js)
 - [`storage-react-query`](./packages/storage-react-query/README.md): [React Query](https://tanstack.com/query/latest) wrapper for storage [storage-js](https://github.com/supabase/storage-js)
+- [`postgrest-server`](./packages/postgrest-server/README.md): Server-side caching wrapper for [postgrest-js](https://github.com/supabase/postgrest-js).
 
 ### Shared Packages
 
 These are not meant for direct usage.
 
-- `jest-presets`: `jest` presets
 - `postgrest-core`: shared logic for [postgrest-js](https://github.com/supabase/postgrest-js)
 - `storage-core`: shared logic for [storage-js](https://github.com/supabase/storage-js) operations
 - `tsconfig`: `tsconfig.json`s used throughout the monorepo
@@ -67,25 +68,5 @@ Each package/app is 100% [TypeScript](https://www.typescriptlang.org/).
       <br />
       (we are <a href="https://twitter.com/psteinroe">hiring</a>!)
     </td>
-     <td align="center">
-      <a href="https://supabase.com/">
-        <img src="https://avatars.githubusercontent.com/u/54469796?s=200&v=4" style="width:100px;border-radius:50%" " alt="Supabase" />
-      </a>
-      <br />
-      <b>Supabase</b>
-      <br />
-      <a href="https://supabase.com">https://supabase.com</a>
-      <br />
-    </td>
-    <td align="center">
-      <a href="https://github.com/Marviel">
-        <img src="https://avatars.githubusercontent.com/u/2037165?v=4" style="width:100px;border-radius:50%" " alt="Marviel" />
-      </a>
-      <br />
-      <b>Luke Bechtel</b>
-      <br />
-      <a href="https://github.com/Marviel">@Marviel</a>
-      <br />
-    </td>
   </tr>
 </table>

docs/app/[[...mdxPath]]/page.jsx

@@ -0,0 +1,24 @@
+import { LinkedTabs } from '@/components/linked-tabs';
+import { generateStaticParamsFor, importPage } from 'nextra/pages';
+import { useMDXComponents as getMDXComponents } from '../../mdx-components';
+
+export const generateStaticParams = generateStaticParamsFor('mdxPath');
+
+export async function generateMetadata(props) {
+  const params = await props.params;
+  const { metadata } = await importPage(params.mdxPath);
+  return metadata;
+}
+
+const Wrapper = getMDXComponents({ LinkedTabs }).wrapper;
+
+export default async function Page(props) {
+  const params = await props.params;
+  const result = await importPage(params.mdxPath);
+  const { default: MDXContent, toc, metadata } = result;
+  return (
+    <Wrapper toc={toc} metadata={metadata}>
+      <MDXContent {...props} params={params} />
+    </Wrapper>
+  );
+}

docs/app/_meta.js

@@ -0,0 +1,8 @@
+export default {
+  index: {
+    title: 'Introduction',
+  },
+  configuration: 'Configuration',
+  postgrest: 'PostgREST',
+  storage: 'Storage',
+};

docs/app/layout.jsx

@@ -0,0 +1,101 @@
+import { Footer, Layout, Navbar } from 'nextra-theme-docs';
+import { Banner, Head } from 'nextra/components';
+import { getPageMap } from 'nextra/page-map';
+import 'nextra-theme-docs/style.css';
+
+import { TabProvider } from '../components/tab-context';
+
+export const metadata = {
+  metadataBase: new URL('https://supabase-cache-helpers.vercel.app'),
+  title: {
+    default: 'Supabase Cache Helpers',
+    template: '%s – Supabase Cache Helpers',
+  },
+  description:
+    'A collection of framework specific Cache utilities for working with Supabase.',
+  applicationName: 'Supabase Cache Helpers',
+  generator: 'Next.js',
+  appleWebApp: {
+    title: 'Supabase Cache Helpers',
+  },
+  other: {
+    'msapplication-TileImage': '/ms-icon-144x144.png',
+    'msapplication-TileColor': '#fff',
+  },
+  openGraph: {
+    title: 'Supabase Cache Helpers',
+    description:
+      'A collection of framework specific Cache utilities for working with Supabase.',
+    url: 'https://supabase-cache-helpers.vercel.app',
+    siteName: 'Supabase Cache Helpers',
+    images: [
+      {
+        url: 'https://supabase-cache-helpers.vercel.app/og-image.png',
+        width: 1200,
+        height: 630,
+      },
+    ],
+    locale: 'en_US',
+    type: 'website',
+  },
+  twitter: {
+    card: 'summary_large_image',
+    title: 'Supabase Cache Helpers',
+    description:
+      'A collection of framework specific Cache utilities for working with Supabase.',
+    images: ['https://supabase-cache-helpers.vercel.app/og-image.png'],
+    creator: '@psteinroe',
+    site: 'https://supabase-cache-helpers.vercel.app',
+  },
+};
+
+export const viewport = {
+  width: 'device-width',
+  initialScale: 1,
+};
+
+export default async function RootLayout({ children }) {
+  const navbar = <Navbar logo={<span>Supabase Cache Helpers</span>} />;
+  const pageMap = await getPageMap();
+  return (
+    <html lang="en" dir="ltr" suppressHydrationWarning>
+      <Head faviconGlyph="✦" />
+      <body>
+        <Layout
+          banner={
+            <Banner storageKey="hiring">
+              <a
+                href="https://twitter.com/psteinroe"
+                target="_blank"
+                rel="noreferrer"
+              >
+                🎉 We are hiring! You want to work on a large-scale Supabase
+                project? DM me →
+              </a>
+            </Banner>
+          }
+          navbar={navbar}
+          footer={
+            <Footer>
+              MIT {new Date().getFullYear()}
+              <a
+                href="https://supabase-cache-helpers.vercel.app"
+                target="_blank"
+                rel="noreferrer"
+              >
+                {': '}
+                Supabase Cache Helpers
+              </a>
+            </Footer>
+          }
+          editLink="Edit this page on GitHub"
+          docsRepositoryBase="https://github.com/psteinroe/supabase-cache-helpers/blob/core/docs"
+          sidebar={{ defaultMenuCollapseLevel: 1 }}
+          pageMap={pageMap}
+        >
+          <TabProvider>{children}</TabProvider>
+        </Layout>
+      </body>
+    </html>
+  );
+}

docs/components/linked-tabs.jsx

@@ -0,0 +1,23 @@
+'use client';
+
+import { Tabs } from 'nextra/components';
+import React from 'react';
+import { useTabContext } from './tab-context';
+
+export const LinkedTabs = ({ id, items, children }) => {
+  const { selectedTabs, setSelectedTab } = useTabContext();
+  const selectedTab = selectedTabs[id] || items[0];
+
+  const index = items.indexOf(selectedTab);
+  const selectedIndex = index !== -1 ? index : 0;
+
+  return (
+    <Tabs
+      items={items}
+      selectedIndex={selectedIndex}
+      onChange={(index) => setSelectedTab(id, items[index])}
+    >
+      {children}
+    </Tabs>
+  );
+};

docs/components/tab-context.jsx

@@ -0,0 +1,50 @@
+'use client';
+
+import { createContext, useContext, useEffect, useState } from 'react';
+
+const TabContext = createContext({
+  selectedTabs: {},
+  setSelectedTab: () => {},
+});
+
+export const useTabContext = () => useContext(TabContext);
+
+export const TabProvider = ({ children }) => {
+  const [selectedTabs, setSelectedTabs] = useState({});
+
+  useEffect(() => {
+    if (typeof window !== 'undefined') {
+      const storedTabs = localStorage.getItem('selectedTabs');
+      if (storedTabs) {
+        try {
+          const parsedTabs = JSON.parse(storedTabs);
+          setSelectedTabs(parsedTabs);
+        } catch (error) {
+          console.error(
+            'Failed to parse selectedTabs from localStorage',
+            error,
+          );
+        }
+      }
+    }
+  }, []);
+
+  useEffect(() => {
+    if (typeof window !== 'undefined') {
+      localStorage.setItem('selectedTabs', JSON.stringify(selectedTabs));
+    }
+  }, [selectedTabs]);
+
+  const setSelectedTab = (id, tab) => {
+    setSelectedTabs((prev) => ({
+      ...prev,
+      [id]: tab,
+    }));
+  };
+
+  return (
+    <TabContext.Provider value={{ selectedTabs, setSelectedTab }}>
+      {children}
+    </TabContext.Provider>
+  );
+};