= 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 [[https://mvnrepository.com/artifact/org.xerial/sqlite-jdbc/3.28.0|JDBC driver]] for it ([[https://github.com/xerial/sqlite-jdbc|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
{{{#!highlight yaml
spring:
  datasource:
    url: jdbc:sqlite:/tmp/test.db
    driverClassName: org.sqlite.JDBC
    username: sa
    password: ????????
  jpa:
    database-platform: org.hibernate.dialect.SQLiteDialect
    hibernate:
      ddl-auto: create-drop
    show-sql: true
}}}