Using Liquibase with SQLite

SQLite is a single-file database which follows the zero-configuration approach. It is furthermore easy to use and is thus perfect for your first experiments with Liquibase.

There is a jdbc driver available here:

To use sqlite with Liquibase you will need the following information:

jars for the classpath:

  • sqlitejdbc-v<version>.jar

jdbc driver name:

  • org.sqlite.JDBC

jdbc url:

  • jdbc:sqlite:<database-name>

There is no need to create a database before you can use sqlite, as I said: it follows the zero-configuration approach.

A run of Liquibase with sqlite, having the sqlite.jar and the in the current directory (and the liquibase.jar at hand as well), could look like this:

    java -jar liquibase.jar