sqlite

• https://www.sqlite.org/index.html

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world.

DjangoREST also supports sqlite.

There is also a JDBC driver for it (Github source code) and it's JPA compliant.

A JDBC sample URL for a DB stored in sample.db file is

jdbc:sqlite:sample.db

• apt install sqlite3
• sqlite3 test.db

sqlite> CREATE TABLE IF NOT EXISTS PushNotificationsTable (push text);
sqlite> insert into PushNotificationsTable values('aaa');
sqlite> select * from PushNotificationsTable;
sqlite> .help
sqlite> .databases
sqlite> .tables
sqlite> .dbinfo
sqlite> .output out.txt
sqlite> .dump PushNotificationsTable
sqlite> .quit

Spring notes

pom.xml

                <dependency>
                        <groupId>com.zsoltfabok</groupId>
                        <artifactId>sqlite-dialect</artifactId>
                        <version>1.0</version>
                </dependency>
                <dependency>
                        <groupId>org.xerial</groupId>
                        <artifactId>sqlite-jdbc</artifactId>
                        <version>3.28.0</version>
                </dependency>

application.properties

spring.datasource.url=jdbc:sqlite:/tmp/test.db
spring.datasource.driverClassName=org.sqlite.JDBC
spring.datasource.username=sa
spring.datasource.password=????????
spring.jpa.database-platform=org.hibernate.dialect.SQLiteDialect
spring.jpa.hibernate.ddl-auto=create-drop
spring.jpa.show-sql=true

application.yaml

   1 spring:
   2   datasource:
   3     url: jdbc:sqlite:/tmp/test.db
   4     driverClassName: org.sqlite.JDBC
   5     username: sa
   6     password: ????????
   7   jpa:
   8     database-platform: org.hibernate.dialect.SQLiteDialect
   9     hibernate:
  10       ddl-auto: create-drop
  11     show-sql: true