Shadcn Table

This is a shadcn table component with server-side sorting, filtering, and pagination. It is bootstrapped with create-t3-app.

Warning This project is still in development and is not ready for production use.

It uses new technologies (ppr, and drizzle ORM) which are subject to change and may break your application.

Tech Stack

Framework: Next.js
Styling: Tailwind CSS
UI Components: shadcn/ui
Table package: TanStack/react-table
Database: Neon
ORM: Drizzle ORM
Validation: Zod

Features

Server-side pagination, sorting, and filtering (via useDataTable hook)
Customizable columns (dataTable and columns props)
Dynamic debounced search filters, and faceted filters (filterFields prop)
Dynamic Data-Table-Toolbar with search, filters, and actions
Optional Notion like advanced filtering (enableAdvancedFilter prop)
Optional Linear like floating bar on row selection (floatingBar prop)

Running Locally

Clone the repository

git clone https://github.com/sadmann7/shadcn-table

Install dependencies using pnpm
```
pnpm install
```
Copy the .env.example to .env and update the variables.
```
cp .env.example .env
```
Start the development server
```
pnpm run dev
```
Push the database schema
```
pnpm run db:push
```

Build your own Table

Copy the following folders and files into your project (configured with ) at the exact specific locations

src/components/data-table
src/db/index.ts
src/hooks
src/lib
src/types

Also install the required shadcn components and other required packages with the following commands:

pnpm dlx shadcn-ui@latest init

pnpm dlx shadcn-ui@latest add badge button calendar checkbox command dialog dropdown-menu form input label popover select separator skeleton sonner table toggle-group tooltip

pnpm add drizzle-orm postgres @tanstack/react-table zod @t3-oss/env-nextjs
pnpm add -D drizzle-kit dotenv-cli pg tsx

Configure your Environment Variables Then set up the Database URL, for this example, we're using PlanetScale MySQL2 Database. Our schemas will also be made using this.
Database Actions: For this you can use any ORM of your choice, but for the sake of this particular example, we're using Drizzle ORM and Neon.

As an example, lets use the tasks table.
- Create the Table Schema at @/db/schema.ts
- Create the associated zod validations @/lib/validations/tasks.ts file
Setting up the Table
- Create Files: Create page.tsx and, if needed, layout.tsx in your app directory.
- Copy Directories: Copy ./_components and ./_lib directories into your project.
- Update Queries/Mutations: Modify ./_lib/queries.ts, and ./_lib/actions.ts to match your database operations.
- Update Floating Bar: Update ./_components/tasks-table-floating-bar.tsx to match your table's actions (optional).
- Define Table Columns: Update ./_components/tasks-table-columns.tsx to define column headers, actions, searchable and filterable columns.
- Setup Data Fetching: In ./page.tsx, define getTasksPromise, getTaskCountByStatus, and getTaskCountByPriority.
- Fetch Data: In ./_components/tasks-table.tsx, consume the getTasksPromise promise using the React.use hook. The promise is passed to trigger the suspense boundary.
- Memoize Table Columns: In ./_components/tasks-table.tsx, memoize columns defined in ./_components/tasks-table-columns.tsx using React.useMemo hook to prevent unnecessary re-renders.
- Use Data Table Hook: In ./_components/tasks-table.tsx, call ./hooks/useTasksTable.tsx hook to handle server-side pagination, sorting, and filtering.
- Remove Tasks Table Provider: Make sure to remove the provider from ./components/tasks-table-provider.tsx. The provider is used to showcase some additional features like floating bar and advanced filters.

Codebase Overview

Watch the codebase overview video on YouTube.

Consider subscribing to Kavin Desi Valli's YouTube channel for more videos.

How do I deploy this?

Follow the deployment guides for Vercel, Netlify and Docker for more information.

pnpm dlx shadcn-ui@latest init pnpm dlx shadcn-ui@latest add badge button calendar checkbox command dialog dropdown-menu form input label popover select separator skeleton sonner table toggle-group tooltip pnpm add drizzle-orm postgres @tanstack/react-table zod @t3-oss/env-nextjs pnpm add -D drizzle-kit dotenv-cli pg tsx