ChatGPT GPTs Store, use Astro + Taiwindcss, and crawl the 6,876 GPTs SQL packet
Discover the GPTs Store by OpenAI | GPTsURL - Share and search GPTs url to use ChatGPT
Logo used from ChatGPT DALL·E Designs
🍿 Live preview: https://www.gptsurl.com
You'll see the following folders and files:
/
├── public/
│ └── favicon.png
| └── robot.txt
├── src/
│ ├── components/
│ │ └── Card.astro
│ ├── layouts/
│ │ └── Layout.astro
│ └── pages/
│ └── index.astro
└── package.json
Any static assets, like images, can be placed in the public/
directory.
Vercel: used for deploying website
Vercel Storage Postgres: used for storing data.
Clone project
git clone https://github.com/CH563/gtps-url.git
CREATE TABLE "public"."gpts_lists" (
"id" int8 NOT NULL,
"title" varchar,
"url" varchar,
"icon" varchar,
"author" varchar,
"description" text,
"content" text,
"twitter" varchar,
"youtube" varchar,
"category" varchar,
"weights" int4 DEFAULT 0,
"scores" int4 DEFAULT 0,
"created_titme" timestamptz DEFAULT now(),
"search_key" varchar,
PRIMARY KEY ("id")
);
-- Sequence and defined type
CREATE SEQUENCE IF NOT EXISTS categories_id_seq;
-- Table Definition
CREATE TABLE "public"."categories" (
"id" int4 NOT NULL DEFAULT nextval('categories_id_seq'::regclass),
"categories_name" varchar(255) NOT NULL,
PRIMARY KEY ("id")
);
CREATE TABLE "public"."list_categories" (
"list_id" int4 NOT NULL,
"category_id" int4 NOT NULL,
CONSTRAINT "list_categories_category_id_fkey" FOREIGN KEY ("category_id") REFERENCES "public"."categories"("id"),
CONSTRAINT "list_categories_list_id_fkey" FOREIGN KEY ("list_id") REFERENCES "public"."gpts_lists"("id"),
PRIMARY KEY ("list_id","category_id")
);
Data from "site:chat.openai.com/g/ {keyword|category}"
pnpm install
POSTGRES_URL="postgres://default:[email protected]/verceldb"
pnpm run dev
All commands are run from the root of the project, from a terminal:
Command | Action |
---|---|
npm install |
Installs dependencies |
npm run dev |
Starts local dev server at localhost:4321
|
npm run build |
Build your production site to ./dist/
|
npm run preview |
Preview your build locally, before deploying |
npm run astro ... |
Run CLI commands like astro add , astro check
|
npm run astro -- --help |
Get help using the Astro CLI |
Astro for deployment
inspired credit to GPTsHunter, AllGPTs