npx supabase gen types typescript ...

ts
let { data } = await supabase
            .from('table')
            .select(`*, tool ( id, category, name )`);

data.tool

ts
tool: (number & {
        id: unknown;
        category: unknown;
        name: unknown;
    }) | (number & {
        id: unknown;
        category: unknown;
        name: unknown;
    }[]);

data.tool

js
{
  "error": {
    "code": "23505",
    "details": "Key (id)=(1) already exists.",
    "hint": null,
    "message": "duplicate key value violates unique constraint \"countries_pkey\""
  },
  "status": 409,
  "statusText": "Conflict"
}

details

column

value

error

const {
        data: transactionLineItemsData2,
        error: transactionLineItemsError2,
        status,
        statusText,
      } = await ctx.supabase
        .from("customer_transaction_line_item")
        .select(`id, ...product ( material )`)
        .eq("customer_transaction_id", id);

failed to parse select parameter (id,...product(material))

// Next.js API route support: https://nextjs.org/docs/api-routes/introduction
import type { NextApiRequest, NextApiResponse } from "next";
import { createClient } from "@supabase/supabase-js";

type Data = {
  name: string;
};

const supabase = createClient(
  process.env.NEXT_PUBLIC_SUPABASE_URL,
  process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY
);

export default async function handler(
  req: NextApiRequest,
  res: NextApiResponse
) {
  const authHeader = req.headers.authorization;
  if (!authHeader || !authHeader.startsWith("Bearer ")) {
    return res.status(401).json({ error: "Unauthorized" });
  }

  const token = authHeader.split(" ")[1];
  const { data: user, error } = await supabase.auth.getUser(token);
  if (error || !user) {
    return res.status(401).json({ error: "Unauthorized" });
  }

  let { data: user_jobs, errorFetch } = await supabase
    .from("user_jobs")
    .select("*");
  if (errorFetch) {
    console.log(errorFetch);
    return res.status(500).json({ error: "Internal server error" });
  }

  // Handle authenticated user
  return res.status(200).json({ user_jobs });
}

supabase/postgres:15.1.0.54-rc0

POSTGRES_HOST=/var/run/postgresql
PGPORT=5432
POSTGRES_PORT=5432
PGPASSWORD=verysecurepassword
POSTGRES_PASSWORD=verysecurepassword
PGDATABASE=postgres
POSTGRES_DB=postgres

/docker-entrypoint-initdb.d/99-realtime.sql

sql
\set pguser `echo "$POSTGRES_USER"`

create schema if not exists _realtime;
alter schema _realtime owner to :pguser;

/docker-entrypoint-initdb.d/98-webhooks.sql

/docker-entrypoint-initdb.d/99-roles.sql

sql
-- NOTE: change to your own passwords for production environments
\set pgpass `echo "$POSTGRES_PASSWORD"`

ALTER USER authenticator WITH PASSWORD :'pgpass';
ALTER USER pgbouncer WITH PASSWORD :'pgpass';
ALTER USER supabase_auth_admin WITH PASSWORD :'pgpass';
ALTER USER supabase_functions_admin WITH PASSWORD :'pgpass';
ALTER USER supabase_storage_admin WITH PASSWORD :'pgpass';

docker-entrypoint.sh -c config_file=/etc/postgresql/postgresql.conf -c log_min_messages=fatal

The database cluster will be initialized with this locale configuration:
  provider:    libc
  LC_COLLATE:  en_US.utf8
  LC_CTYPE:    C.UTF-8
  LC_MESSAGES: en_US.utf8
  LC_MONETARY: en_US.utf8
  LC_NUMERIC:  en_US.utf8
  LC_TIME:     en_US.utf8
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
initdb: warning: enabling "trust" authentication for local connections
syncing data to disk ... ok
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.


Success. You can now start the database server using:

    pg_ctl -D /var/lib/postgresql/data -l logfile start

waiting for server to start.... done
server started

/usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/98-webhooks.sql
BEGIN
psql:/docker-entrypoint-initdb.d/98-webhooks.sql:3: ERROR:  role "supabase_admin" does not exist

contentType

Blob

FormData

File

js
const { data, error } = await db.storage
  .from("gallery")
  .upload("qqqq-asdf", image, {
    contentType: "FormData",
   });

http://localhost:3000/#error=unauthorized_client&error_code=401&error_description=Email+link+is+invalid+or+has+expired

/

javascript
if (location.hash.includes("error")) {
  showErrorMessage()
}

/

typescript
export const RoomContext = React.createContext<RoomContextType | null>(null);

export const RoomContextWrapper = ({ children, currentUser }: RoomContextProps) => {
  const router = useRouter<{ roomCode: string }>();
  const { roomCode } = router.query;

  const [isSubscribed, setSubscribed] = useState(false);

  const { users, roomId } = useRoomSubscriber({ roomCode, userId: currentUser });
  const { roomChannel, roomState, onSetRoomStatus } = useRoomStatus({
    roomId: roomCode,
    isPlayingUser: true,
    username: currentUser,
  });

  useEffect(() => {
    console.log('MOUNT', { roomChannel, isSubscribed });

    if (roomChannel && !isSubscribed) {
      roomChannel.subscribe((status: `${REALTIME_SUBSCRIBE_STATES}`) => {
        if (status === REALTIME_SUBSCRIBE_STATES.SUBSCRIBED) {
          setSubscribed(true);
        }
      });
    }
  }, [roomChannel, isSubscribed]);

  useEffect(() => {
    return () => {
      console.log('UNMOUNT', { roomChannel });

      if (roomChannel) {
        setSubscribed(false);
        roomChannel.unsubscribe();
      }
    };
  }, [roomChannel]);

  const values = {
    roomState,
    onSetRoomStatus,
    isSubscribed,
    users,
    username: user?.name,
  };

  return <RoomContext.Provider value={values}>{children(values)}</RoomContext.Provider>;
};