Product
개요영상그래픽문서
Enterprise
Story
레터/테크 노트소식/공지
Pricing
Ko
한국어English日本語日本語
이용 가이드
레터웍스 시작 
한국어English日本語
한국어English日本語
Integrating Label Studio Data: A Step-by-Step Guide Using Jet Admin
2023-03-14

‍

‍By Hyuntaek Park

Senior full-stack engineer at TWIGFARM

‍

At TWIGFARM, we use Label Studio extensively for data labeling, such as image classifications, object detection, and text labeling from images. One of the pain points we faced was that there were many tedious tasks just to view who did which tasks in projects.

‍

Label Studio uses Postgres as its database, and integrating it into Jet Admin is quite simple.

‍

Requirements

‍

We needed an admin tool to achieve the above goals, but all of our developers are busy building other products. We wanted to minimize our efforts to build a tool that could show the list with the following columns:

  • Project ID
  • Title
  • Description
  • Done tasks
  • Total tasks
  • Names of contributors

‍

Pagination of the list and filtering features is also essential requirements.

‍

Create Project

‍

Assume that you have an account at jetadmin.io. Go to https://app.jetadmin.io and choose New App.

image

‍

Choose whatever you want for “WHAT ARE YOU LOOKING TO BUILD” and there might be another questions. You can fill them out or choose Skip.

‍

Choose Resource

‍

The next part is important. Since Label Studio uses PostgreSQL, choose “PostgreSQL,” as shown in the following screenshot.

image

‍

Establish database connection

‍

Enter your database connection information then click on the Test Connectionto check if the connection is successfully established. Make sure your PostgreSQL is accessible from the Jet Admin IP shown on the screen. If the connection is successful, click Add resource button.

image

‍

Prepare your data using SQL

‍

Choose Blank layout. Then, hover over the database icon and choose PostgreSQL

image

‍

Choose Create with SQL query and name it whatever you want. I will just name it “Projects with number of done tasks”. Click Create button.

‍

I have the following SQL query. Some optimizations can be done, but itfulfills the requirements for now.

‍

Press the Play symbol to run the query. Validate if this is the data you would like to see.

‍

I get results like the following. Note that I hid columns with sensitive information.

image

If you are satisfied with the result, then press Save button, or play more with the SQL query until you get the result that you desire.

‍

Page layouts

‍

Now the recipe is prepared. It is time to configure the list screen with a search feature.

‍

List

image

Choose Blank and click Continue button.

‍

Drag and drop Container and then a Table component from the right-hand side of the screen to the center of the screen. Choose data sources as the following:

image

‍

Now the list is ready.

‍

Search Box

‍

Let’s add a search box. Drag and drop Filter from the Lists section on the right-hand side of the screen.

image

‍

Click Bind to Component button, then select Projects with number of done tasks or whatever you named the data source.

image

‍

Choose + Add a Filter. I want my filter to be used to display a list containing the substring of the title that the user entered. So it looks like the following screenshot.

image

‍

Preview and publish

‍

Let us press the Preview button on the header. If you like it, click the Publishbutton.

‍

There might be a few things that you might want to change to make it more intuitive and fancy. It is your time to navigate the rest of Jet Admin and refine as much as you want. Then publish your work.

‍

You might also want to modify the SQL query to fulfill your own requirements. I hope this tutorial about Jet Admin saves your time building the admin page.

‍

‍

✏️콘텐츠 번역&현지화, 한 곳에서 해결하세요.

• 최신 AI기술이 탑재된 번역기 체험하기(클릭)
• 월간 소식지로 더 많은 이야기 읽어보기 💌

‍

‍

전체 목록 보기

다음 노트 살펴보기

WORKS note
월간 인공지능 2호 영상 기반 음성-텍스트 변환 솔루션 비교하기(4편_생성 결과물 비교)
2025-04-28
WORKS note
월간 인공지능 2호 영상 기반 음성-텍스트 변환 솔루션 비교하기(3편_생성 결과물 비교)
2025-04-25
WORKS note
월간 인공지능 2호 영상 기반 음성-텍스트 변환 솔루션 비교하기(2편_인터페이스 비교)
2025-04-23
이용 가이드
문의하기
(주) 트위그팜
사업자등록번호 : 556-81-00254  |  통신판매번호 : 2021-서울종로-1929
대표 : 백선호  |  개인정보관리책임자 : 박현택
서울 본사 : (03187) 서울 종로구 6(서린동) 6층
광주 지사 : (61472) 광주광역시 동구 금남로 193-22
싱가폴 아시아 지사 : (048581) 16 RAFFLES QUAY #33-07 HONG LEONG BUILDING SINGAPORE
Family site
TwigfarmLETR LABSheybunny
이용약관
|
개인정보처리방침
ⓒ 2024 LETR WORKS. All rights reserved.