Project

General

Profile

Actions

Non-Function #947

closed

[DB] CUBRID -> sqlite 변경

Added by Jisoo Choi 25 days ago. Updated 18 days ago.

Status:
Closed
Priority:
Normal
Assignee:
Start date:
05/21/2025
Due date:
% Done:

0%

Estimated time:

Description

 

 

DB 서버 제공이 불가하다고 해서 변경이 필요한 상태입니다.

현재 cubrid 사용을 sqlite로 변경 부탁드립니다.

 

 

 


Files

step 1.png (255 KB) step 1.png Toby Pham, 05/28/2025 01:13 PM
step 2.png (240 KB) step 2.png Toby Pham, 05/28/2025 01:13 PM
Actions #1

Updated by Deca Park 25 days ago

  • Assignee changed from Deca Park to Toby Pham

[DB change]

  • CUBRID -> sqlite
Actions #2

Updated by Toby Pham 25 days ago

  • Status changed from New to In Progress
Actions #3

Updated by Toby Pham 25 days ago

  • Status changed from In Progress to Resolved
  • Assignee changed from Toby Pham to Deca Park
Actions #4

Updated by Deca Park 24 days ago

  • Assignee changed from Deca Park to Jisoo Choi
Actions #5

Updated by Deca Park 24 days ago

[dev DB]

1.sqlite DB

  • jdbc.driverClassName=org.sqlite.JDBC
  • jdbc.url=jdbc:sqlite:/home/sqlite/korean_archive.db

2.dev ssh

  • IP: 210.123.124.139
  • port : 29923
  • ID/Pw : dev01 / tmxhs2022!@#

3.Client Tool (DB Browser for SQLite) (to-do)

  • connect dev DB using ssh terneling
Actions #6

Updated by Jisoo Choi 24 days ago

  • Status changed from Resolved to Closed
Actions #7

Updated by Toby Pham 18 days ago

1. Download and install

URL: https://dbeaver.com/download/enterprise/

2. Connect to a database

1) Select SQLite

2) Main Tab

- Connect by: Host

- Path: /home/sqlite/korean_archive.db

- Database is remote: checked

refer: step 1.png

3) SSH Tab

- Use SSH Tunnel: checked

refer: step 2.png

Actions

Also available in: Atom PDF