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.

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

A JDBC sample URL for a BD 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> .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