# baseURI: https://www.archives.gov/files/lod/dpframework/id/NF00886

@prefix : <https://www.archives.gov/files/lod/dpframework/schema> .
@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix nara: <https://www.archives.gov/data/lod/dpframework/def/> .
@prefix naraid: <https://www.archives.gov/data/lod/dpframework/id/> .
@prefix owl: <http://www.w3.org/2002/07/owl#> .
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix wikidata: <http://www.wikidata.org/entity/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .

naraid:NF00886
  a nara:FileFormat ;
  dcterms:description "SQLite 3 is an embedded SQL database format. The format was first released in 2000 as version 1. Version 3 was released in 2004 and introduced cross platform support, required UTF-8 or UTF-16, and stored the column data types. The format and software required to create or view the format are open source and the format is well supported with frequent updates. SQLite supports cross-platform use and is frequently used by other software or operating systems to locally store and retrieve relational data without the necessity of a database server. A SQLite file's contained database CREATE statements are plain text and can be viewed with a text editor. However, the structured data and indexes are stored in binary b-tree pages. The database structure supports fields for binary large objects (BLOB) which should be assessed for preservation actions separately. The data in a GeoPackage file (a preferred format per NARA Transfer Guidance) is stored in a SQLite3 database. NARA recommends to retain SQLite 3 files as-is, but to assess any contained BLOBs for potential format migration." ;
  dcterms:identifier "NF00886" ;
  rdfs:label "NF00886" ;
  wikidata:p1163 "application/vnd.sqlite3" ;
  wikidata:p1195 "db" ;
  wikidata:p1195 "db3" ;
  wikidata:p1195 "sqlite" ;
  wikidata:p1195 "sqlite3" ;
  wikidata:p2748 "https://www.nationalarchives.gov.uk/PRONOM/fmt/729" ;
  wikidata:p3266 "https://www.loc.gov/preservation/digital/formats/fdd/fdd000461.shtml" ;
  wikidata:p973 "https://docs.fileformat.com/database/sqlite/" ;
  wikidata:p973 "https://en.wikipedia.org/wiki/SQLite" ;
  wikidata:p973 "https://forensics.wiki/sqlite_database_format/" ;
  wikidata:p973 "https://sqlite.org/fileformat2.html" ;
  wikidata:p973 "https://www.iana.org/assignments/media-types/application/vnd.sqlite3" ;
  wikidata:p973 "https://www.wikidata.org/wiki/Q28600453" ;
  nara:category naraid:Databases ;
  nara:formatName "SQLite 3 Database" ;
  nara:preservationAction naraid:Retain ;
  nara:preservationPlan "Retain but assess contained data including whether or not the database contains binary large objects (BLOB) which may need to be extracted and transformed." ;
  nara:riskLevel naraid:Low ;
  nara:tools """FME; Python
""" ;
  <https://www.archives.gov/files/lod/dpframework/schemaArchiveTeamURL> "http://fileformats.archiveteam.org/wiki/SQLite" ;
.
<https://www.archives.gov/files/lod/dpframework/id/NF00886>
  a owl:Ontology ;
.