2022 04 10

2022-04-10

SQLite

• 참고: https://www.hostinger.com/tutorials/sqlite-vs-mysql-whats-the-difference/
• SQLite vs MySQL
  • SQLite
    • 오픈소스 in public domain
    • Blob, Integer, Null, Text, Real 지원
    • The SQLite library is about 250 KB in size
    • not suitable for multiple user access
  • MySQL
    • 오라클 + 서버 아키텍쳐
    • Tinyint, Smallint, Mediumint, Int, Bigint, Double, Float, Real, Decimal, Double precision, Numeric, Timestamp, Date, Datetime, Char, Varchar, Year, Tinytext, Tinyblob, Blob, Text, MediumBlob, MediumText, Enum, Set, Longblob, Longtext.
    • MySQL server is about 600 MB
    • can handle multiple users and grant various levels of permission

• 이때 SQLite 쓰세요
  • 작은 앱을 만들때
  • 스케일러빌리티가 작은 앱을 만들때
  • Basic Development

SQLite with SpringBoot

• 참고: https://www.baeldung.com/spring-boot-sqlite
• 참고: https://skagh.tistory.com/59
• 의존성 추가

  <dependency>
      <groupId>org.xerial</groupId>
      <artifactId>sqlite-jdbc</artifactId>
      <version>3.25.2</version>
  </dependency>
  

• SQLite Dialect 생성
  • Hibernate는 SQLite의 Dialect를 기본제공하지 않음
  • 따라서 직접 정의해줘야하는 형식