JdbcSchema.java

public class JdbcSchema {
    public static void createTables(Connection connection) throws SQLException, URISyntaxException, IOException {
        // Stupid Scanner trick: https://community.oracle.com/blogs/pat/2004/10/23/stupid-scanner-tricks
        String sql = new Scanner(JdbcSchema.class.getResourceAsStream("sqlite.sql"), "UTF-8").useDelimiter("\\A").next();
        for (String stmt : sql.split("-- 8< --")) {
            connection.createStatement().executeUpdate(stmt);
        }
    }
}