Server-Side CRUD operations

When a new row is added, removed or updated a request with CRUD data object is made via 'virtualDataSource' on the Server-Side Datasource. The server uses the SQL query sent by the Server-Side Datasource to get the rows. The type of query is stored in the request's action property.

This example uses a demo server with AlaSQL that generates SQL to show how a real server might use the requests sent by the Table. The Server-Side Table usage does not have any restrictions on the server-side technologies used.


SQL Query

SELECT * FROM Customers LIMIT 10 OFFSET 0


Data

CustomerIDCustomerNameContactNameAddressCityPostalCodeCountry
1Alfreds FutterkisteMaria AndersObere Str. 57Berlin12209Germany
2Ana Trujillo Emparedados y heladosAna TrujilloAvda. de la Constitución 2222México D.F.05021Mexico
3Antonio Moreno TaqueríaAntonio MorenoMataderos 2312México D.F.05023Mexico
4Around the HornThomas Hardy120 Hanover Sq.LondonWA1 1DPUK
5Berglunds snabbköpChristina BerglundBerguvsvägen 8LuleåS-958 22Sweden