{"id":15612,"date":"2024-02-02T02:48:58","date_gmt":"2024-02-02T10:48:58","guid":{"rendered":"https:\/\/www.pingcap.com\/?p=15612"},"modified":"2024-02-21T19:08:54","modified_gmt":"2024-02-22T03:08:54","slug":"building-a-data-driven-backend-with-data-service","status":"publish","type":"post","link":"https:\/\/www.pingcap.com\/ko\/blog\/building-a-data-driven-backend-with-data-service\/","title":{"rendered":"Mastering TiDB Cloud Data Service\u2013Your Ultimate Guide to Building a Data-Driven Backend"},"content":{"rendered":"

In our previous post<\/a>, we introduced TiDB Cloud Data Service (TCDS), a fully managed, low-code backend-as-a-service solution. By seamlessly integrating your data with any application or service through HTTPS, TCDS enables developers to rapidly construct secure and scalable data-driven applications. <\/p>\n\n\n\n

This blog guides you through building REST endpoints with TCDS while constructing a Task Tracker app.<\/a> Focused on backend development, the tutorial covers creating clusters and tables, inserting data, and crafting APIs. It also provides steps for integrating the React frontend hosted on Vercel<\/a> with the backend. By the end of this tutorial, you will gain a comprehensive understanding of TCDS and acquire a fully functional backend solution, catering to both beginners and seasoned developers.<\/p>\n\n\n\n

<\/span>Set up a TiDB Serverless Cluster<\/span><\/h2>\n\n\n\n

Take the steps below to create a free TiDB Serverless cluster: <\/p>\n\n\n\n

    \n
  1. Sign in<\/a> to your TiDB Cloud. Register a TiDB Cloud<\/a> account if you haven\u2019t got one.<\/li>\n\n\n\n
  2. Follow the on-screen instructions to create a free Serverless Tier cluster within seconds.<\/li>\n<\/ol>\n\n\n\n

    <\/span>Create a Data Model<\/span><\/h2>\n\n\n\n
      \n
    1. Navigate to the overview page of your cluster, and enter the Chat2Query<\/strong> interface on the left.
      \"\"<\/figure><\/li>\n\n\n\n
    2. Execute the SQL script provided below to create both the tasktracker<\/code> database and the todos<\/code> table within it. The script includes the insertion of sample data into the todos table. The Task Tracker application relies on this table to store individual tasks along with their related information, including title, description, status, and timestamps.
      \nCREATE DATABASE tasktracker;\n\nUSE tasktracker;\n\nCREATE TABLE todos (\n    `id`INT AUTO_INCREMENT NOT NULL PRIMARY KEY,\n    `task`VARCHAR(255) NOT NULL,\n    `description` TEXT,\n    `status`VARCHAR(50) NOT NULL,\n    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n    `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP\n)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;\n\nINSERT INTO todos (task, description, status) VALUES\n('Grocery Shopping', 'Buy groceries for the week including fruits, vegetables, and dairy products', 'Incomplete'),\n('Email Client', 'Send the revised project proposal to the client by EOD', 'Incomplete'),\n('Gym Session', 'Attend the 6 PM cardio fitness class at the local gym', 'Completed'),\n('Book Flight Tickets', 'Book tickets for the upcoming business trip to New York', 'Incomplete'),\n('Annual Health Checkup', 'Schedule an annual health checkup appointment with Dr. Smith', 'Completed');\n\nSELECT * FROM todos;\n<\/code><\/pre><\/li>\n\n\n\n
    3. Select all the statements in the script and execute them by clicking on the Run<\/strong> button.<\/li>\n<\/ol>\n\n\n\n
      <\/span>Create a Data App with GitHub Integration<\/span><\/h2>\n\n\n\n
      A Data App is a container that consists of a collection of objects like Endpoints. Creating a Data App<\/a> is the initial phase for generating REST Endpoints. To create a Data App:<\/p>\n\n\n\n
        \n
      1. Select Data Service <\/strong>from the left navigation menu, and click the Create Data App<\/strong> button.
        \"\"<\/figure><\/li>\n\n\n\n
      2. Create and configure a standard data app as below:\n