### Setup Local Development Environment

Source: https://github.com/ethanniser/nextfaster/blob/main/README.md

Sequence of commands to set up the local development environment. This includes linking the project to Vercel, pulling environment variables (like database credentials), installing project dependencies, and starting the development server.

```Shell
vc link
```

```Shell
vc env pull
```

```Shell
pnpm install
```

```Shell
pnpm dev
```

--------------------------------

### Apply Database Schema/Migrations

Source: https://github.com/ethanniser/nextfaster/blob/main/README.md

Command to apply the Drizzle ORM schema to the connected database. Used for initial setup during deployment and for applying subsequent schema migrations during development. Requires the database connection string to be configured.

```Shell
pnpm db:push
```

--------------------------------

### Seed Database with SQL File

Source: https://github.com/ethanniser/nextfaster/blob/main/README.md

Command using the psql client to execute a large SQL file against the specified database connection string. This is used to seed the database with initial data, such as a large product catalog.

```Shell
psql "YOUR_CONNECTION_STRING" -f data/data.sql
```

--------------------------------

### Allow LinkedInBot Access to /products and Homepage

Source: https://github.com/ethanniser/nextfaster/blob/main/src/app/robots.txt

This rule set is for 'LinkedInBot'. It allows this specific bot access to both the '/products' path and the root path '/', enabling it to retrieve necessary data for LinkedIn shares and previews.

```robots.txt
User-agent: LinkedInBot
Allow: /products
Allow: /
```

--------------------------------

### Allow Twitterbot Access to /products and Homepage

Source: https://github.com/ethanniser/nextfaster/blob/main/src/app/robots.txt

This block specifically targets the 'Twitterbot' user agent. It explicitly allows this bot to access both the '/products' path and the root path '/', typically used to fetch Open Graph data for link previews.

```robots.txt
User-agent: Twitterbot
Allow: /products
Allow: /
```

--------------------------------

### Create Default Database Roles

Source: https://github.com/ethanniser/nextfaster/blob/main/README.md

SQL commands to create necessary roles ('default' and 'cloud_admin') within the database. These commands are executed after connecting to the database using a client like psql.

```SQL
CREATE ROLE default;
```

```SQL
CREATE ROLE cloud_admin;
```

--------------------------------

### Block /products for All Crawlers

Source: https://github.com/ethanniser/nextfaster/blob/main/src/app/robots.txt

This rule set uses the wildcard user agent '*' to apply the directive to all web crawlers. It disallows access to the '/products' path, preventing general bots from indexing content within that directory.

```robots.txt
User-agent: *
Disallow: /products
```

--------------------------------

### Allow Facebook External Hit Access to /products and Homepage

Source: https://github.com/ethanniser/nextfaster/blob/main/src/app/robots.txt

Similar to the Twitterbot rule, this section targets 'facebookexternalhit'. It grants permission for this bot to access '/products' and the root path '/', primarily for fetching Open Graph information for Facebook shares.

```robots.txt
User-agent: facebookexternalhit
Allow: /products
Allow: /
```

--------------------------------

### Allow All Crawlers Access to Homepage

Source: https://github.com/ethanniser/nextfaster/blob/main/src/app/robots.txt

This general rule, applied to all user agents ('*'), explicitly allows access to the root path ('/'). This ensures that all standard web crawlers are permitted to index the website's homepage.

```robots.txt
User-agent: *
Allow: /
```

=== COMPLETE CONTENT === This response contains all available snippets from this library. No additional content exists. Do not make further requests.