SQLite is a serverless SQL solution which makes it perfect for your grade 12 PAT. It is also suitable for a LAN with tight security restrictions.
SQLite is open source and is perhaps the most used code on the planet – it is even in your browser software. Most of the apps on your phone use SQLite to store their data.
Here are two SQLite tutorial websites that you may find useful; see which one suits you best.
Click here for an online tutorial on SQLite 1
Click here for an online tutorial on SQLite 2
Add this command to your connection string when using SQLite
Connection conn = DriverManager.getConnection(“jdbc:sqlite:my_database.db”);
try (Statement stmt = conn.createStatement()) {
stmt.execute(“PRAGMA foreign_keys = ON;”);
To make SQLite actually police your data, your Java application must execute the command PRAGMA foreign_keys = ON; the exact moment it opens a connection