Store created elements in a local SQLite database

Closes #41 (closed)

tests/test_cache.py

@@ -75,7 +75,8 @@ def test_create_tables():
     with open(db_path, "rb") as generated_file:
         generated = generated_file.read()
 
-    assert expected == generated
+    # Skipping one byte (related to SQLite version) differing only in CI
+    assert expected[:97] == generated[:97] and expected[99:] == generated[99:]
 
 
 def test_insert_empty_lines():
@@ -90,7 +91,8 @@ def test_insert_empty_lines():
     with open(db_path, "rb") as generated_file:
         generated = generated_file.read()
 
-    assert expected == generated
+    # Skipping one byte (related to SQLite version) differing only in CI
+    assert expected[:97] == generated[:97] and expected[99:] == generated[99:]
 
 
 def test_insert_existing_lines():
@@ -108,7 +110,8 @@ def test_insert_existing_lines():
     with open(db_path, "rb") as after_file:
         after = after_file.read()
 
-    assert before == after
+    # Skipping one byte (related to SQLite version) differing only in CI
+    assert before[:97] == after[:97] and before[99:] == after[99:]
 
 
 def test_insert():