Features

• [x] mysql backend support. (production-ready)
• [x] RESTful HTTP API backend support. (production-ready)
• [x] pgsql backend support. (production-ready)
• [x] mssql backend support. (production-ready)
• [x] redis backend support.
• [x] Google Spreadsheet backend support.
• [x] MongoDB backend support. (production-ready)
• [ ] DynamoDB backend support.
• [ ] Firebase backend support.
• [x] JavaScript request/response transformation support.
• [x] User management.
• [x] Permission and access control with roles.
• [x] Customizable menus, groups and tabs.
• [x] Mulitple pages with URL to share.
• [x] Table UI
• [x] Local sort, pagination
• [x] Server-side pagination
• [x] Query block type
• [x] Modal(popup) block type
• [x] Markdown block type
• [x] Block-wide parameters
• [x] Page-wide parameters
• [x] Share and open saved search.
• [ ] Publishing API Endpoint
• [ ] SSH tunneling
• [x] VPC Peering
• [ ] OIDC support

Usage

CLI

• npm install -g selectfromuser
• selectfromuser

Others

selectfromuser login selectfromuser whoami selectfromuser logout selectfromuser link selectfromuser unlink selectfromuser init selectfromuser dev

Docker container image

https://hub.docker.com/r/selectfromuser/admin https://github.com/eces/select/blob/main/docker-compose.yml

Documentation

ko-KR

• Documentation 개발자 문서
• Official Website 공식웹사이트
• UI Components 컴포넌트
• Changelog 업데이트 내역
• Blog 블로그
• Discourse 포럼
• Slack Community 슬랙 커뮤니티

Sample Recipe

index.yml

title: 셀렉트어드민

layout:
  style:
    backgroundColor: "#19234B !important"

menus:
- group: 회원
  name: 고객 관리
  path: users
  placement: menu-only
  redirect: users/active
  icon: mdi-account
  
  menus:
  - name: 결제 관리
    path: payments
    placement: menu-only
    icon: mdi-timeline-check

- group: 회원
  name: 최근가입자 목록
  path: users/active
  placement: tab-only

- group: 회원
  name: 휴면회원 목록
  path: users/dormant
  placement: tab-only

- group: 회원
  name: 마케팅 수신동의
  path: users/promotion
  placement: tab-only

- group: 기타메뉴
  name: 공식 문서 
  path: https://docs.selectfromuser.com
  target: _blank
  icon: mdi-book-open-variant
  iconEnd: 링크

- group: 기타메뉴
  name: 클라우드 이용
  path: https://app.selectfromuser.com
  target: _blank
  icon: mdi-tab
  iconEnd: 링크

# resources:
# - name: mysql.dev
#   mode: local
#   type: mysql
#   host: aaaa.ap-northeast-2.rds.amazonaws.com
#   port: 3306
#   username: user_aaaa
#   password: aaaa
#   database: aaaa
#   timezone: '+00:00'
#   extra:
#     charset: utf8mb4_general_ci

# pages:
# - path: healthcheck/db
#   blocks:
#   - type: query
#     resource: mysql.dev
#     sql: SELECT NOW()

users/index.yml

pages:
- path: users/active
  blocks: 
  - type: markdown
    content: >
      ## 7일 가입자 조회
    
- path: users/dormant
  blocks:
  - type: markdown
    content: >
      ## 휴면회원 조회
    
- path: users/promotion
  blocks:
  - type: markdown
    content: >
      ## 동의/미동의 조회

users/payment.yml

pages:
- path: payments
  title: 결제 및 환불
  blocks:
  - type: markdown
    content: |
      > 최근 7일 대상자 목록
  
  # - type: query
  #   name: Data from Query
  #   resource: mysql.dev
  #   sql: |
  #     SELECT * 
  #     FROM chat 
  #     ORDER BY id DESC
  #     LIMIT 3
  #   tableOptions:
  #     cell: true

  - type: http
    axios:
      method: GET
      url: https://api.selectfromuser.com/sample-api/users
    rowsPath: rows
    columns:
      name:
        label: Name
      age:
        label: Engagement Point

    showDownload: csv

    viewModal:
      useColumn: id
      # mode: side
      blocks:
      - type: http
        axios:
          method: GET
          url: https://api.selectfromuser.com/sample-api/users/{{user_id}}
        rowsPath: rows
        
        params:
        - key: user_id
          valueFromRow: id

        display: col-2
        title: "ID: {{id}}"
        showSubmitButton: false
        

        tabOptions:
          autoload: 1
          tabs:
          - name: 최근거래내역
            blocks: 
            - type: markdown
              content: 거래내역 내용
          - name: 프로모션참여
            blocks: 
            - type: markdown
              content: 프로모션 내용

Tests

npm test -- --grep="auth"

npm test -- --grep="block"

npm test -- --grep="config"

Support

해당 프로젝트는 2020년부터 2023년까지 Free/Pro/Team/Enterprise Plan 제공을 위해 Selectfromuser Inc. 개발팀 포함 커뮤니티가 계속 기능추가, 유지보수, 보안패치, 문서화를 하고 있습니다.

직접 설치하여 비용없이 무료이용 가능합니다. 그외에 정책은 라이센스를 따릅니다. 기능제안, 기술지원은 해당 페이지로 문의바랍니다. https://www.selectfromuser.com