Overview
This guide explains how to perform server side operations on a table component in ToolJet. Most databases support server side operations, but the specific implementation may vary by database. This guide uses PostgreSQL as the data source to demonstrate the process.
Server Side v/s Client Side
Server side operations refer to tasks executed on the server, such as data fetching, filtering, sorting, and pagination. Server side operations use server resources, efficiently handling large datasets and ensuring faster load times for users. In contrast, client side operations are performed in the user's browser or application, which may lead to performance issues with large datasets as all data is first fetched and then processed locally. Server side operations offer better scalability and performance, especially for resource-intensive tasks.
When to Use Sever Side Operations?
- Handling Large Datasets
- Security and Data Integrity
- Complex Business Logic
When to Use Client Side Operations?
- Real-time Interactivity
- Reduced Server Load
- Offline Capabilities
