SQLITEDB
application/octet-stream
Magic Bytes
Offset: 0
53 51 4C 69 74 65 20 66 6F 72 6D 61 74 20 33 00
SQLITEDB is a relational database file format based on the SQLite engine, which is maintained by the SQLite Consortium. It is commonly utilized for local storage in mobile applications, web browsers, and embedded systems because it provides a self-contained, serverless data structure. As a cross-platform binary format, it is generally considered safe; however, administrators should monitor for SQL injection vulnerabilities within the software layers that interact with the database files.
Validation Code
How to validate .sqlitedb files in Python
Python
def is_sqlitedb(file_path: str) -> bool:
"""Check if file is a valid SQLITEDB by magic bytes."""
signature = bytes([0x53, 0x51, 0x4C, 0x69, 0x74, 0x65, 0x20, 0x66, 0x6F, 0x72, 0x6D, 0x61, 0x74, 0x20, 0x33, 0x00])
with open(file_path, "rb") as f:
return f.read(16) == signature
How to validate .sqlitedb files in Node.js
Node.js
function isSQLITEDB(buffer: Buffer): boolean {
const signature = Buffer.from([0x53, 0x51, 0x4C, 0x69, 0x74, 0x65, 0x20, 0x66, 0x6F, 0x72, 0x6D, 0x61, 0x74, 0x20, 0x33, 0x00]);
return buffer.subarray(0, 16).equals(signature);
}
Go
func IsSQLITEDB(data []byte) bool {
signature := []byte{0x53, 0x51, 0x4C, 0x69, 0x74, 0x65, 0x20, 0x66, 0x6F, 0x72, 0x6D, 0x61, 0x74, 0x20, 0x33, 0x00}
if len(data) < 16 {
return false
}
return bytes.Equal(data[:16], signature)
}
API Endpoint
GET
/api/v1/sqlitedb
curl https://filesignature.org/api/v1/sqlitedb