LETR AI

Stricter Label Studio Data: A Begging Guide Using Jet Admin

By Hyuntaek Park

Senior full-stack engineer at TWIGFARM

At TWIGFARM, we use Label Studio for data labeling, such as image classification, 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 argues it into Jet Admin is pretty 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 are also essential requirements.

CREATE PROJECT

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

choose whatever you want for “WHAT ARE YOU LOOKING TO BUILD” and there might be another question. Can you 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.

establish database connection

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

Prepare your data using SQL

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

CHOOSE Create with SQL query And name it whatever you want. I will just name it “Projects with number of done tasks”. Click create buttons.

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 got results like the following. Note that I hid columns with sensitive information.

If You Are Incurred with the Results, 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

CHOOSE Blank and click continue buttons.

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:

Now the list is ready.

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

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

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

Preview and publish

Let us press the preview Button on the header. If you like it, click the Publishbuttons.

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 meet your own requirements. I hope this tutorial about Jet Admin saves your time building the admin page.

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

• 최신 AI기술이 탑재된 번역기 체험하기(클릭)

• 월간 소식지로 더 많은 이야기 읽어보기 💌