/shadcn-table

shadcn table component with server-side sorting, filtering, and pagination.

Primary LanguageTypeScriptMIT LicenseMIT

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

Shadcn Table

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

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

Tech Stack

Features

  • Server-side pagination, sorting, and filtering (useTable hook)
  • Customizable columns (dataTable and columns props)
  • Dynamic debounced search inputs (searchableColumns prop)
  • Dynamic faceted filters (filterableColumns prop)
  • Optional notion like advanced filtering (advancedFilter prop)
  • Optional floating bar on row selection, rendred at the bottom (floatingBarContent prop)
  • Action to delete rows (deleteRowsAction prop)

Running Locally

  1. Clone the repository

    git clone https://github.com/sadmann7/shadcn-table
  2. Install dependencies using pnpm

    pnpm install
  3. Copy the .env.example to .env and update the variables.

    cp .env.example .env
  4. Start the development server

    pnpm run dev
  5. Push the database schema

    pnpm run db:push

Codebase Overview

Watch the codebase overview video on YouTube.

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

How do I deploy this?

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

How to use the data-table component

  1. Clone the Repo

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

    OR

    git clone https://github.com/arvind-iyer-2001/shadcn-table
  2. 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 button badge checkbox command dialog dropdown-menu input popover select separator skeleton table toast
    
    pnpm add drizzle-orm @planetscale/database @tanstack/react-table zod drizzle-zod sonner @t3-oss/env-nextjs
    pnpm add -D drizzle-kit dotenv-cli tsx
  3. 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.

  4. 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 PlanetScale.

    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
  5. Setting up the Table

    • Start with creating a page.tsx file, and if necessary, a layout.tsx file in the app directory
    • Copy the contents of the ./_components and ./_lib directories into your project wherever needed.
    • Modify each of the files according to your database table.
    • Modify the required actions for querying and mutating data in the folder ./_lib/queries in the queries.ts and actions.ts.
    • Modify the ./_components/task-table-column-def.tsx file to define the column header, searchable columns, filterable columns, and the column based actions and the presentation of the data in each column.
    • Modify the ./_components/tasks-table-actions.tsx file to define the the selected rows based actions, like deleting and modifying a group of rows, and floating bar content (can be used in the floatingBarContent prop of the DataTable component as TasksTableFloatingBarContent(dataTable))
    • Modify the ./_components/task-table.tsx file to reference the schemas, types and database actions to be used in the table. The getTasksPromise is fetched here using the React.use hook. Components and Data that have to be memoized must be declared here, because it can not be done in a server component.
    • Modify the ./page.tsx file to define the getTasksPromise to be used in the TasksTableShell component.