{ "_id": "6a12bbf5acfb0bcc41d1c439", "Package": "mfdb", "Type": "Package", "Title": "MareFrame DB Querying Library", "Encoding": "UTF-8", "Version": "7.4-0", "Date": "2026-01-24", "Authors@R": "c(person(\"Jamie\", \"Lentin\", email=\"lentinj@shuttlethread.com\",role = c(\"aut\", \"cre\", \"cph\")),\nperson(\"Bjarki Thor\", \"Elvarsson\", email=\"bjarki.elvarsson@hafogvatn.is\",role = c(\"aut\")))", "Maintainer": "Jamie Lentin ", "Description": "Creates and manages a PostgreSQL database suitable for\nstoring fisheries data and aggregating ready for use within a\nGadget model. See\n for more information.", "License": "GPL-3", "VignetteBuilder": "knitr", "LazyData": "true", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-24 08:46:35 UTC", "User": "root" }, "Author": "Jamie Lentin [aut, cre, cph], Bjarki Thor Elvarsson [aut]", "Config/pak/sysreqs": "xz-utils", "Repository": "https://lentinj.r-universe.dev", "Date/Publication": "2026-01-24 13:03:54 UTC", "RemoteUrl": "https://github.com/cran/mfdb", "RemoteRef": "HEAD", "RemoteSha": "385d164e34798fab0937b54bbdae323fb666a8d7", "MD5sum": "4042417fb4328310eb28b49abed81153", "_user": "lentinj", "_type": "src", "_file": "mfdb_7.4-0.tar.gz", "_fileid": "6e138c743d9ae7918d1fc6b4e7e878224d3377e01eca50f27283ece2cbfcac31", "_filesize": 470296, "_sha256": "6e138c743d9ae7918d1fc6b4e7e878224d3377e01eca50f27283ece2cbfcac31", "_created": "2026-05-24T08:46:35.000Z", "_published": "2026-05-24T08:51:01.897Z", "_distro": "noble", "_jobs": [ { "job": 77584691554, "time": 151, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7183777873" }, { "job": 77584691556, "time": 147, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7183777407" }, { "job": 77584691568, "time": 135, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7183774342" }, { "job": 77584691551, "time": 128, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7183773660" }, { "job": 77584527097, "time": 186, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7183761060" }, { "job": 77584691549, "time": 103, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7183772866" }, { "job": 77584691567, "time": 141, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7183778123" }, { "job": 77584691562, "time": 105, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7183772995" }, { "job": 77584691561, "time": 235, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7183787059" } ], "_buildurl": "https://github.com/r-universe/lentinj/actions/runs/26356658053", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/mfdb", "_commit": { "id": "385d164e34798fab0937b54bbdae323fb666a8d7", "author": "Jamie Lentin ", "committer": "cran-robot ", "message": "version 7.4-0\n", "time": 1769259834 }, "_maintainer": { "name": "Jamie Lentin", "email": "lentinj@shuttlethread.com", "login": "lentinj", "description": "", "uuid": 586911 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.2.0", "role": "Depends" }, { "package": "logging", "version": ">= 0.7-103", "role": "Imports" }, { "package": "DBI", "version": ">= 0.3.1", "role": "Imports" }, { "package": "duckdb", "version": ">= 0.2.5", "role": "Imports" }, { "package": "getPass", "version": ">= 0.1-1", "role": "Imports" }, { "package": "rlang", "version": ">= 0.4.0", "role": "Imports" }, { "package": "dplyr", "version": ">= 0.8.3", "role": "Suggests" }, { "package": "dbplyr", "version": ">= 2.0.0", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "RPostgres", "version": ">= 1.3.0", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "unittest", "version": ">= 1.5-0", "role": "Suggests" } ], "_owner": "cran", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-04", "n": 1 } ], "_tags": [ { "name": "7.4-0", "date": "2026-01-24" } ], "_stars": 0, "_contributors": [ { "user": "lentinj", "count": 7, "uuid": 586911 } ], "_userbio": { "uuid": 586911, "type": "user", "name": "Jamie Lentin" }, "_downloads": { "count": 239, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/mfdb" }, "_searchresults": 252, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/mfdb.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_realowner": "lentinj", "_cranurl": false, "_releases": [ { "version": "6.2-0", "date": "2020-04-14" }, { "version": "7.1-0", "date": "2021-08-18" }, { "version": "7.1-1", "date": "2021-10-09" }, { "version": "7.2-0", "date": "2021-11-21" }, { "version": "7.3-0", "date": "2022-06-07" }, { "version": "7.3-1", "date": "2022-06-21" }, { "version": "7.4-0", "date": "2026-01-24" } ], "_exports": [ "gadget_areafile", "gadget_dir_read", "gadget_dir_write", "gadget_directory", "gadget_file", "gadget_fleet_component", "gadget_likelihood_component", "gadget_stockfile_extremes", "gadget_stockfile_initialconditions", "gadget_stockfile_recruitment", "gadget_stockfile_refweight", "mfdb", "mfdb_area_size", "mfdb_area_size_depth", "mfdb_bootstrap_group", "mfdb_concatenate_results", "mfdb_cs_dump", "mfdb_cs_restore", "mfdb_disconnect", "mfdb_dplyr_division", "mfdb_dplyr_predator", "mfdb_dplyr_prey", "mfdb_dplyr_sample", "mfdb_dplyr_survey_index", "mfdb_dplyr_table", "mfdb_empty_taxonomy", "mfdb_find_species", "mfdb_group", "mfdb_group_numbered", "mfdb_import_area", "mfdb_import_bait_type_taxonomy", "mfdb_import_cs_taxonomy", "mfdb_import_division", "mfdb_import_gear_taxonomy", "mfdb_import_net_type_taxonomy", "mfdb_import_population_taxonomy", "mfdb_import_port_taxonomy", "mfdb_import_sampling_type", "mfdb_import_species_taxonomy", "mfdb_import_stomach", "mfdb_import_survey", "mfdb_import_survey_index", "mfdb_import_temperature", "mfdb_import_tow_taxonomy", "mfdb_import_trip_taxonomy", "mfdb_import_vessel_owner_taxonomy", "mfdb_import_vessel_taxonomy", "mfdb_interval", "mfdb_na_group", "mfdb_rpath_params", "mfdb_sample_count", "mfdb_sample_meanlength", "mfdb_sample_meanlength_stddev", "mfdb_sample_meanweight", "mfdb_sample_meanweight_stddev", "mfdb_sample_rawdata", "mfdb_sample_scaled", "mfdb_sample_totalweight", "mfdb_share_with", "mfdb_step_interval", "mfdb_stomach_presenceratio", "mfdb_stomach_preycount", "mfdb_stomach_preymeanlength", "mfdb_stomach_preymeanweight", "mfdb_stomach_preyweightratio", "mfdb_survey_index_mean", "mfdb_survey_index_total", "mfdb_temperature", "mfdb_timestep_biannually", "mfdb_timestep_quarterly", "mfdb_timestep_yearly", "mfdb_unaggregated", "read.gadget_file" ], "_datasets": [ { "name": "case_study", "title": "MareFrame DB Datasets", "object": "case_study", "class": [ "data.frame" ], "fields": [ "id", "name", "description" ], "rows": 12, "table": true, "tojson": true }, { "name": "digestion_stage", "title": "MareFrame DB Datasets", "object": "digestion_stage", "class": [ "data.frame" ], "fields": [ "id", "name", "description" ], "rows": 5, "table": true, "tojson": true }, { "name": "gear", "title": "MareFrame DB Datasets", "object": "gear", "class": [ "data.frame" ], "fields": [ "id", "name", "description", "t_group" ], "rows": 147, "table": true, "tojson": true }, { "name": "institute", "title": "MareFrame DB Datasets", "object": "institute", "class": [ "data.frame" ], "fields": [ "id", "name", "t_group", "description" ], "rows": 41, "table": true, "tojson": true }, { "name": "market_category", "title": "MareFrame DB Datasets", "object": "market_category", "class": [ "data.frame" ], "fields": [ "id", "name", "description" ], "rows": 0, "table": true, "tojson": true }, { "name": "maturity_stage", "title": "MareFrame DB Datasets", "object": "maturity_stage", "class": [ "data.frame" ], "fields": [ "id", "name", "description" ], "rows": 5, "table": true, "tojson": true }, { "name": "sex", "title": "MareFrame DB Datasets", "object": "sex", "class": [ "data.frame" ], "fields": [ "id", "name", "description" ], "rows": 5, "table": true, "tojson": true }, { "name": "species", "title": "MareFrame DB Datasets", "object": "species", "class": [ "data.frame" ], "fields": [ "id", "name", "description" ], "rows": 1483, "table": true, "tojson": true }, { "name": "stomach_state", "title": "MareFrame DB Datasets", "object": "stomach_state", "class": [ "data.frame" ], "fields": [ "id", "name", "description" ], "rows": 6, "table": true, "tojson": true }, { "name": "vessel_type", "title": "MareFrame DB Datasets", "object": "vessel_type", "class": [ "data.frame" ], "fields": [ "id", "name", "t_group", "description" ], "rows": 21, "table": true, "tojson": true } ], "_help": [ { "page": "mfdb-package", "title": "MareFrame DB querying library", "topics": [ "mfdb-package" ] }, { "page": "ewe_model", "title": "MareFrame DB Rpath interface", "topics": [ "mfdb_rpath_params" ] }, { "page": "gadget_areafile", "title": "Gadget area files", "topics": [ "gadget_areafile" ] }, { "page": "gadget_directory", "title": "Gadget directory objects", "topics": [ "gadget_directory", "gadget_dir_read", "gadget_dir_write" ] }, { "page": "gadget_file", "title": "Gadget file objects", "topics": [ "as.character.gadget_file", "gadget_file", "print.gadget_file", "read.gadget_file" ] }, { "page": "gadget_fleetfile", "title": "Gadget fleet files", "topics": [ "gadget_fleet_component" ] }, { "page": "gadget_likelihood_component", "title": "Gadget likelihood components", "topics": [ "gadget_likelihood_component" ] }, { "page": "gadget_stockfile", "title": "Gadget stock files", "topics": [ "gadget_stockfile_extremes", "gadget_stockfile_initialconditions", "gadget_stockfile_recruitment", "gadget_stockfile_refweight" ] }, { "page": "mfdb", "title": "MareFrame DB class", "topics": [ "mfdb", "mfdb_disconnect" ] }, { "page": "mfdb_aggregate_group", "title": "MareFrame DB groups", "topics": [ "mfdb_bootstrap_group", "mfdb_group", "mfdb_group_numbered", "mfdb_timestep_biannually", "mfdb_timestep_quarterly", "mfdb_timestep_yearly" ] }, { "page": "mfdb_aggregate_interval", "title": "MareFrame DB intervals", "topics": [ "mfdb_interval" ] }, { "page": "mfdb_aggregate_na_group", "title": "MareFrame DB aggregate NAs", "topics": [ "mfdb_na_group" ] }, { "page": "mfdb_aggregate_step_interval", "title": "MareFrame DB intervals", "topics": [ "mfdb_step_interval" ] }, { "page": "mfdb_aggregate_unaggregated", "title": "MareFrame DB unaggregated data", "topics": [ "mfdb_unaggregated" ] }, { "page": "mfdb_bulk", "title": "MareFrame DB Dump / Restore", "topics": [ "mfdb_cs_dump", "mfdb_cs_restore" ] }, { "page": "mfdb_dplyr", "title": "MareFrame DB dplyr interface", "topics": [ "mfdb_dplyr_division", "mfdb_dplyr_predator", "mfdb_dplyr_prey", "mfdb_dplyr_sample", "mfdb_dplyr_survey_index", "mfdb_dplyr_table" ] }, { "page": "mfdb_helpers", "title": "MareFrame tools & helpers", "topics": [ "mfdb_find_species" ] }, { "page": "mfdb_helpers_mfdb_combine_results", "title": "MareFrame Query Utilities", "topics": [ "mfdb_concatenate_results" ] }, { "page": "mfdb_import_data", "title": "MareFrame Data Import functions", "topics": [ "mfdb_import_stomach", "mfdb_import_survey", "mfdb_import_survey_index", "mfdb_import_temperature" ] }, { "page": "mfdb_import_taxonomy", "title": "MareFrame Taxonomy import functions", "topics": [ "mfdb_empty_taxonomy", "mfdb_import_area", "mfdb_import_bait_type_taxonomy", "mfdb_import_cs_taxonomy", "mfdb_import_division", "mfdb_import_gear_taxonomy", "mfdb_import_net_type_taxonomy", "mfdb_import_population_taxonomy", "mfdb_import_port_taxonomy", "mfdb_import_sampling_type", "mfdb_import_species_taxonomy", "mfdb_import_tow_taxonomy", "mfdb_import_trip_taxonomy", "mfdb_import_vessel_owner_taxonomy", "mfdb_import_vessel_taxonomy" ] }, { "page": "mfdb_queries", "title": "MareFrame DB queries", "topics": [ "mfdb_area_size", "mfdb_area_size_depth", "mfdb_sample_count", "mfdb_sample_meanlength", "mfdb_sample_meanlength_stddev", "mfdb_sample_meanweight", "mfdb_sample_meanweight_stddev", "mfdb_sample_rawdata", "mfdb_sample_scaled", "mfdb_sample_totalweight", "mfdb_stomach_presenceratio", "mfdb_stomach_preycount", "mfdb_stomach_preymeanlength", "mfdb_stomach_preymeanweight", "mfdb_stomach_preyweightratio", "mfdb_survey_index_mean", "mfdb_survey_index_total", "mfdb_temperature" ] }, { "page": "mfdb_sharing", "title": "MareFrame DB sharing options", "topics": [ "mfdb_share_with" ] }, { "page": "mfdb-data", "title": "MareFrame DB Datasets", "topics": [ "case_study", "digestion_stage", "gear", "institute", "market_category", "maturity_stage", "mfdb-data", "sex", "species", "stomach_state", "vessel_type" ] } ], "_readme": "https://github.com/cran/mfdb/raw/HEAD/README.md", "_rundeps": [ "DBI", "duckdb", "getPass", "logging", "rlang", "rstudioapi" ], "_vignettes": [ { "source": "weightmeasurements.Rmd", "filename": "weightmeasurements.html", "title": "Storing & grouping other weight measurements", "engine": "knitr::rmarkdown", "headings": [ "Importing data", "Querying data" ], "created": "2021-08-18 16:30:02", "modified": "2026-01-24 13:03:54", "commits": 2 }, { "source": "import_hydrography_cmems.Rmd", "filename": "import_hydrography_cmems.html", "title": "Import hydrographic data into MFDB", "engine": "knitr::rmarkdown", "headings": [ "Download monthly hydrographic data", "Download ICES rectangles", "Aggregate hydrographic data by ICES rectangles", "Import bottom temperature into mfdb" ], "created": "2021-08-18 16:30:02", "modified": "2026-01-24 13:03:54", "commits": 3 }, { "source": "population.Rmd", "filename": "population.html", "title": "Storing & grouping by arbitrary populations", "engine": "knitr::rmarkdown", "headings": [ "Importing data", "Querying data" ], "created": "2021-08-18 16:30:02", "modified": "2026-01-24 13:03:54", "commits": 2 }, { "source": "tow_data.Rmd", "filename": "tow_data.html", "title": "Storing & grouping by tow metadata", "engine": "knitr::rmarkdown", "headings": [ "Importing Data", "Importing Data: Longlines", "Importing Data: Gillnets", "Querying data" ], "created": "2021-08-18 16:30:02", "modified": "2026-01-24 13:03:54", "commits": 4 }, { "source": "trip.Rmd", "filename": "trip.html", "title": "Storing & grouping by vessel trips", "engine": "knitr::rmarkdown", "headings": [ "Importing data", "Querying data" ], "created": "2021-08-18 16:30:02", "modified": "2026-01-24 13:03:54", "commits": 3 } ], "_score": 4.799340549453582, "_indexed": true, "_nocasepkg": "mfdb", "_universes": [ "lentinj" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "7.4-0", "date": "2026-05-24T08:48:47.000Z", "distro": "noble", "commit": "385d164e34798fab0937b54bbdae323fb666a8d7", "fileid": "b327d1824847eeb702aa1ee11c06123fe5534ca237387ac92da370bfe70e7457", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/lentinj/actions/runs/26356658053" }, { "r": "4.6.0", "os": "linux", "version": "7.4-0", "date": "2026-05-24T08:48:45.000Z", "distro": "noble", "commit": "385d164e34798fab0937b54bbdae323fb666a8d7", "fileid": "9bf8e5fe308f5de5ae07419e84f46a73ce83015e15044abce4baa9620050ed5c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/lentinj/actions/runs/26356658053" }, { "r": "4.5.3", "os": "mac", "version": "7.4-0", "date": "2026-05-24T08:48:32.000Z", "commit": "385d164e34798fab0937b54bbdae323fb666a8d7", "fileid": "d21e46007214954d4d0b01673d4275e284b43aab5ce8b905f250c6cef7154fdb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/lentinj/actions/runs/26356658053" }, { "r": "4.6.0", "os": "mac", "version": "7.4-0", "date": "2026-05-24T08:48:22.000Z", "commit": "385d164e34798fab0937b54bbdae323fb666a8d7", "fileid": "554f2e83d1503cc24f892979acfd62525899359deb4f6dc93de842d5afc54f4b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/lentinj/actions/runs/26356658053" }, { "r": "4.6.0", "os": "wasm", "version": "7.4-0", "date": "2026-05-24T08:48:38.000Z", "commit": "385d164e34798fab0937b54bbdae323fb666a8d7", "fileid": "c46281ccfc85061280d9f75389ef2cf609867df525961e73633d474777f2d92e", "status": "success", "buildurl": "https://github.com/r-universe/lentinj/actions/runs/26356658053" }, { "r": "4.7.0", "os": "win", "version": "7.4-0", "date": "2026-05-24T08:48:37.000Z", "commit": "385d164e34798fab0937b54bbdae323fb666a8d7", "fileid": "bab9e90a027e2fce26239dccaa38a2f7b0933deac6901b9b435c1d0bdec6855e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/lentinj/actions/runs/26356658053" }, { "r": "4.5.3", "os": "win", "version": "7.4-0", "date": "2026-05-24T08:47:51.000Z", "commit": "385d164e34798fab0937b54bbdae323fb666a8d7", "fileid": "7b66e0ca2b36ced4f1fe95bdeefba5fea1c76d6f7da44f76337c1df289a220ab", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/lentinj/actions/runs/26356658053" }, { "r": "4.6.0", "os": "win", "version": "7.4-0", "date": "2026-05-24T08:49:59.000Z", "commit": "385d164e34798fab0937b54bbdae323fb666a8d7", "fileid": "6c113c3f808f007d212bfbc53de395dc570774cd10782a3d32f1a0ec2dda6615", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/lentinj/actions/runs/26356658053" } ] }