CPGH Database
CPGH includes a file-based database system with SQL-like operations, record management, and table creation.
Add a new record to a table
Query records with conditions
Modify existing records
Delete records by ID
{`// In HSX HSX: "database.db" HSX: "CREATE TABLE users (id INTEGER, name TEXT)" HSX: "INSERT INTO users (name) VALUES ('Alice')" HSX: "INSERT INTO users (name) VALUES ('Bob')" HSX: "SELECT * FROM users WHERE name = 'Alice'" HSX: "UPDATE users SET name = 'Alicia' WHERE id = 1" HSX: "DELETE FROM users WHERE id = 1"`} ๐ Database Storage CPGH databases are stored as files in the .CPGH/DB/ directory. Each table is a folder with individual .db files per record.