Package index • entropiaR

Connection & administration

Open and close read-only connections to an EntropIA SQLite database, snapshot it, and read the schema version and compatibility state.

entropia_connect(): Connect to an EntropIA SQLite database (read-only)
entropia_disconnect(): Close an EntropIA connection
entropia_copy(): Snapshot a database to a new file (WAL-aware)
entropia_conn-class entropia_conn: entropia_conn class
entropia_schema_version(): Schema version of an EntropIA database
entropia_schema_info(): Tables, columns and typed contract of an EntropIA database
entropia_schema_compat(): Schema compatibility status of an EntropIA database

Entity access

One lazy tbl_sql accessor per readable table. Compose with dplyr/dbplyr; materialise with entropia_collect().

entropia_collections(): Collections (lazy)
entropia_items(): Items (lazy)
entropia_assets(): Assets (lazy)
entropia_extractions(): Extractions (lazy)
entropia_transcriptions(): Transcriptions (lazy)
entropia_layouts(): Layouts (lazy)
entropia_notes(): Notes (lazy)
entropia_annotations(): Annotations (lazy)
entropia_entities(): Entities (lazy)
entropia_triples(): Triples (lazy)
entropia_topics(): Topics (lazy)
entropia_item_topics(): Item-topic links (lazy)
entropia_llm_results(): LLM results (lazy)
entropia_rag_conversations(): RAG conversations (lazy)
entropia_rag_messages(): RAG messages (lazy)
entropia_embeddings(): Asset embedding vectors (lazy)
entropia_chunks(): RAG chunks (lazy)
entropia_search_index(): Items full-text index (lazy, raw)

Search

Parameter-safe FTS5 full-text search over the items and chunk indexes.

entropia_search(): Search the full-text index

Collection & typing

Materialise a lazy query with the column contract applied, and the pure timestamp-conversion helpers.

entropia_collect(): Collect and apply the column contract
entropia_datetime(): Convert epoch-millisecond timestamps to POSIXct
entropia_datetime_s(): Convert epoch-second timestamps to POSIXct
entropia_datetime_auto(): Convert timestamps to POSIXct with a magnitude guard

Domain layer

High-level, research-oriented views over the corpus: joined items/assets/ collections with best text, parsed metadata, and text helpers.

entropia_corpus(): Corpus (lazy)
entropia_text(): Per-asset best text (lazy)
entropia_metadata(): Item metadata (parsed)

Corpus quality & diagnostics

Coverage reports, orphaned-reference detection, connection validation and compact status.

entropia_ocr_coverage(): OCR coverage (lazy)
entropia_metadata_coverage(): Metadata coverage (lazy)
entropia_corpus_quality(): Combined corpus quality report
entropia_orphans(): Detect orphaned rows (broken conceptual foreign keys)
entropia_validate(): Validate the structure of an EntropIA database
entropia_status(): Compact status summary of an EntropIA database

Research layer

Entity relations, LLM result reconstruction, conversations with citations, and the sync-metadata surface.

entropia_entity_relations(): Entity relations (triples with item and collection context)
entropia_reconstruct_analysis(): Reconstruct LLM analyses against their targets
entropia_conversation(): One RAG conversation with its ordered messages
entropia_sync_info(): Whitelisted sync settings as a typed tibble
entropia_sync_versions(): Sync row versions (lazy)
entropia_conflicts(): Sync conflicts (lazy)

Analysis

Operate on collected tibbles: temporal profiles, document lengths, entity/topic frequency, collection comparison, and reproducible datasets with provenance.

entropia_temporal_profile() experimental: Temporal profile (counts by time bucket)
entropia_document_lengths() experimental: Document lengths (chars/words per row)
entropia_entity_frequency() experimental: Entity frequency (top entities by type)
entropia_topic_frequency() experimental: Topic frequency (items per topic)
entropia_compare_collections() experimental: Compare collections (per-collection summary)
entropia_analysis_dataset() experimental: Build a reproducible analysis dataset

Visualization

ggplot2 helpers on analysis summaries (Suggests).

entropia_plot_temporal(): Plot a temporal profile
entropia_plot_entities(): Plot entity frequencies
entropia_plot_coverage(): Plot corpus coverage

Export & provenance

Export tibbles or lazy queries to disk (streamed for delimited formats) and read/write provenance sidecars.

entropia_export(): Export data to a file
entropia_provenance(): Read the provenance stamp of a reproducible dataset
entropia_write_provenance(): Write a provenance sidecar (JSON)

Write API (v2 stubs)

v1 stubs for the v2 write API. All error with entropia_error_write_disabled and documented guidance.

entropia_insert(): Insert rows (v2 contract; errors in v1)
entropia_update(): Update rows (v2 contract; errors in v1)
entropia_upsert(): Upsert rows (v2 contract; errors in v1)
entropia_delete(): Delete rows (v2 contract; errors in v1)

Package

Package-level documentation.

entropiaR entropiaR-package: entropiaR: Tidy Interface to EntropIA SQLite Databases