{
  "_id": "6a116d15acfb0bcc41cf4fae",
  "Package": "supabaseR",
  "Title": "'CRUD' Utils in 'R' for 'Supabase'",
  "Version": "1.0.1",
  "Authors@R": "c(\nperson(\"Deepansh\", \"Khurana\", , \"deepanshkhurana@outlook.com\", role = c(\"aut\", \"cre\")),\nperson(\"Maciej\", \"Banas\", , \"banasmaciek@gmail.com\", role = \"aut\")\n)",
  "Description": "An dual-paradigm interface to 'Supabase'\n(<https://supabase.com/>), an open-source backend-as-a-service\nplatform. Provides comprehensive database operations including\nCreate, Read, Update, Delete ('CRUD') functionality through\nboth REST API endpoints and direct 'PostgreSQL' database\nconnections. Simplifies authentication, data management, and\nschema operations for 'Supabase' projects.",
  "License": "MIT + file LICENSE",
  "URL": "https://deepanshkhurana.github.io/supabaseR/,\nhttps://github.com/DeepanshKhurana/supabaseR",
  "BugReports": "https://github.com/DeepanshKhurana/supabaseR/issues",
  "Encoding": "UTF-8",
  "Language": "en-US",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.3",
  "Config/testthat/edition": "3",
  "Config/pak/sysreqs": "libssl-dev libpq-dev",
  "Repository": "https://deepanshkhurana.r-universe.dev",
  "Date/Publication": "2026-04-23 08:32:30 UTC",
  "RemoteUrl": "https://github.com/deepanshkhurana/supabaser",
  "RemoteRef": "HEAD",
  "RemoteSha": "d9754ce7399bae3f66f9520c06143673b02ea2ba",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-23 08:59:23 UTC",
    "User": "root"
  },
  "Author": "Deepansh Khurana [aut, cre],\nMaciej Banas [aut]",
  "Maintainer": "Deepansh Khurana <deepanshkhurana@outlook.com>",
  "MD5sum": "f07081c1cc6b2c5fda63b3018e7987a2",
  "_user": "deepanshkhurana",
  "_type": "src",
  "_file": "supabaseR_1.0.1.tar.gz",
  "_fileid": "9e0519e87ec5687eeb1a67e4f8898b9c9eb4aecb2b6206b4a8084878bbccc6d4",
  "_filesize": 190484,
  "_sha256": "9e0519e87ec5687eeb1a67e4f8898b9c9eb4aecb2b6206b4a8084878bbccc6d4",
  "_created": "2026-05-23T08:59:23.000Z",
  "_published": "2026-05-23T09:02:13.486Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77510956440,
      "time": 133,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7175815494"
    },
    {
      "job": 77510956442,
      "time": 130,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7175815212"
    },
    {
      "job": 77510956433,
      "time": 122,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7175813133"
    },
    {
      "job": 77510956434,
      "time": 129,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7175813354"
    },
    {
      "job": 77510776395,
      "time": 219,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7175802871"
    },
    {
      "job": 77510956437,
      "time": 99,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7175812578"
    },
    {
      "job": 77510956455,
      "time": 74,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7175809925"
    },
    {
      "job": 77510956454,
      "time": 80,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7175810586"
    },
    {
      "job": 77510956450,
      "time": 100,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7175812638"
    }
  ],
  "_buildurl": "https://github.com/r-universe/deepanshkhurana/actions/runs/26328638983",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/deepanshkhurana/supabaser",
  "_commit": {
    "id": "d9754ce7399bae3f66f9520c06143673b02ea2ba",
    "author": "deepanshkhurana <deepanshkhurana@outlook.com>",
    "committer": "deepanshkhurana <deepanshkhurana@outlook.com>",
    "message": "docs(r-universe): add R-universe badge to README\n",
    "time": 1776933150
  },
  "_maintainer": {
    "name": "Deepansh Khurana",
    "email": "deepanshkhurana@outlook.com",
    "login": "deepanshkhurana",
    "linkedin": "in/deepanshkhurana",
    "description": "Writer, generalist, maker of things",
    "uuid": 26517718
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "checkmate",
      "role": "Imports"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "glue",
      "role": "Imports"
    },
    {
      "package": "httr2",
      "role": "Imports"
    },
    {
      "package": "RPostgres",
      "role": "Imports"
    },
    {
      "package": "jsonlite",
      "role": "Suggests"
    },
    {
      "package": "mockery",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    }
  ],
  "_owner": "deepanshkhurana",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-13",
      "n": 21
    },
    {
      "week": "2026-14",
      "n": 2
    },
    {
      "week": "2026-15",
      "n": 4
    },
    {
      "week": "2026-16",
      "n": 1
    },
    {
      "week": "2026-17",
      "n": 2
    }
  ],
  "_tags": [
    {
      "name": "v1.0.0",
      "date": "2026-04-14"
    },
    {
      "name": "1.0.0",
      "date": "2026-04-15"
    },
    {
      "name": "v1.0.1",
      "date": "2026-04-22"
    }
  ],
  "_topics": [
    "postgresql",
    "rshiny",
    "supabase",
    "supabase-db",
    "supabaser"
  ],
  "_stars": 7,
  "_contributors": [
    {
      "user": "deepanshkhurana",
      "count": 35,
      "uuid": 26517718
    },
    {
      "user": "maciekbanas",
      "count": 1,
      "uuid": 74212933
    }
  ],
  "_userbio": {
    "uuid": 26517718,
    "type": "user",
    "name": "Deepansh Khurana",
    "description": "Writer, generalist, maker of things"
  },
  "_downloads": {
    "count": 528,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/supabaseR"
  },
  "_devurl": "https://github.com/deepanshkhurana/supabaser",
  "_pkgdown": "https://deepanshkhurana.github.io/supabaseR/",
  "_searchresults": 6,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/supabaseR.html",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/deepanshkhurana/supabaser",
  "_realowner": "deepanshkhurana",
  "_cranurl": true,
  "_releases": [
    {
      "version": "1.0.0",
      "date": "2026-04-21"
    }
  ],
  "_exports": [
    "sb_api_connect",
    "sb_api_delete",
    "sb_api_disconnect",
    "sb_api_insert",
    "sb_api_query",
    "sb_api_read",
    "sb_api_schema",
    "sb_api_status",
    "sb_api_table_exists",
    "sb_api_tables",
    "sb_api_truncate",
    "sb_api_update",
    "sb_api_upsert",
    "sb_connect",
    "sb_db_connect",
    "sb_db_delete",
    "sb_db_disconnect",
    "sb_db_insert",
    "sb_db_query",
    "sb_db_read",
    "sb_db_schema",
    "sb_db_status",
    "sb_db_table_exists",
    "sb_db_tables",
    "sb_db_truncate",
    "sb_db_update",
    "sb_db_upsert",
    "sb_delete",
    "sb_disconnect",
    "sb_insert",
    "sb_query",
    "sb_read",
    "sb_schema",
    "sb_status",
    "sb_table_exists",
    "sb_tables",
    "sb_truncate",
    "sb_update",
    "sb_upsert"
  ],
  "_help": [
    {
      "page": "sb_api_connect",
      "title": "Connect to Supabase via REST API",
      "topics": [
        "sb_api_connect"
      ]
    },
    {
      "page": "sb_api_delete",
      "title": "Delete rows from a table via API",
      "topics": [
        "sb_api_delete"
      ]
    },
    {
      "page": "sb_api_disconnect",
      "title": "Disconnect from Supabase API",
      "topics": [
        "sb_api_disconnect"
      ]
    },
    {
      "page": "sb_api_insert",
      "title": "Insert rows into a table via API",
      "topics": [
        "sb_api_insert"
      ]
    },
    {
      "page": "sb_api_query",
      "title": "Query a table via API",
      "topics": [
        "sb_api_query"
      ]
    },
    {
      "page": "sb_api_read",
      "title": "Read table data via API",
      "topics": [
        "sb_api_read"
      ]
    },
    {
      "page": "sb_api_schema",
      "title": "Get table schema via API",
      "topics": [
        "sb_api_schema"
      ]
    },
    {
      "page": "sb_api_status",
      "title": "Check API backend status",
      "topics": [
        "sb_api_status"
      ]
    },
    {
      "page": "sb_api_table_exists",
      "title": "Check if a table exists via API",
      "topics": [
        "sb_api_table_exists"
      ]
    },
    {
      "page": "sb_api_tables",
      "title": "List tables via API",
      "topics": [
        "sb_api_tables"
      ]
    },
    {
      "page": "sb_api_truncate",
      "title": "Truncate a table via API",
      "topics": [
        "sb_api_truncate"
      ]
    },
    {
      "page": "sb_api_update",
      "title": "Update rows in a table via API",
      "topics": [
        "sb_api_update"
      ]
    },
    {
      "page": "sb_api_upsert",
      "title": "Upsert rows into a table via API",
      "topics": [
        "sb_api_upsert"
      ]
    },
    {
      "page": "sb_connect",
      "title": "Connect to Supabase",
      "topics": [
        "sb_connect"
      ]
    },
    {
      "page": "sb_db_connect",
      "title": "Connect to Supabase",
      "topics": [
        "sb_db_connect"
      ]
    },
    {
      "page": "sb_db_creds",
      "title": "Read Supabase credentials from environment variables",
      "topics": [
        "sb_db_creds"
      ]
    },
    {
      "page": "sb_db_delete",
      "title": "Delete rows from a table",
      "topics": [
        "sb_db_delete"
      ]
    },
    {
      "page": "sb_db_disconnect",
      "title": "Disconnect from Supabase",
      "topics": [
        "sb_db_disconnect"
      ]
    },
    {
      "page": "sb_db_insert",
      "title": "Insert rows into a table",
      "topics": [
        "sb_db_insert"
      ]
    },
    {
      "page": "sb_db_query",
      "title": "Query a table",
      "topics": [
        "sb_db_query"
      ]
    },
    {
      "page": "sb_db_read",
      "title": "Read table data",
      "topics": [
        "sb_db_read"
      ]
    },
    {
      "page": "sb_db_schema",
      "title": "Get table schema",
      "topics": [
        "sb_db_schema"
      ]
    },
    {
      "page": "sb_db_status",
      "title": "Check DBI backend status",
      "topics": [
        "sb_db_status"
      ]
    },
    {
      "page": "sb_db_table_exists",
      "title": "Check if table exists",
      "topics": [
        "sb_db_table_exists"
      ]
    },
    {
      "page": "sb_db_tables",
      "title": "List tables in schema",
      "topics": [
        "sb_db_tables"
      ]
    },
    {
      "page": "sb_db_truncate",
      "title": "Truncate a table",
      "topics": [
        "sb_db_truncate"
      ]
    },
    {
      "page": "sb_db_update",
      "title": "Update rows in a table",
      "topics": [
        "sb_db_update"
      ]
    },
    {
      "page": "sb_db_upsert",
      "title": "Upsert rows into a table",
      "topics": [
        "sb_db_upsert"
      ]
    },
    {
      "page": "sb_delete",
      "title": "Delete rows from a table",
      "topics": [
        "sb_delete"
      ]
    },
    {
      "page": "sb_disconnect",
      "title": "Disconnect from Supabase",
      "topics": [
        "sb_disconnect"
      ]
    },
    {
      "page": "sb_insert",
      "title": "Insert rows into a table",
      "topics": [
        "sb_insert"
      ]
    },
    {
      "page": "sb_query",
      "title": "Query a table",
      "topics": [
        "sb_query"
      ]
    },
    {
      "page": "sb_read",
      "title": "Read table data",
      "topics": [
        "sb_read"
      ]
    },
    {
      "page": "sb_schema",
      "title": "Get table schema",
      "topics": [
        "sb_schema"
      ]
    },
    {
      "page": "sb_status",
      "title": "Get connection status",
      "topics": [
        "sb_status"
      ]
    },
    {
      "page": "sb_table_exists",
      "title": "Check if table exists",
      "topics": [
        "sb_table_exists"
      ]
    },
    {
      "page": "sb_tables",
      "title": "List tables",
      "topics": [
        "sb_tables"
      ]
    },
    {
      "page": "sb_truncate",
      "title": "Truncate a table",
      "topics": [
        "sb_truncate"
      ]
    },
    {
      "page": "sb_update",
      "title": "Update rows in a table",
      "topics": [
        "sb_update"
      ]
    },
    {
      "page": "sb_upsert",
      "title": "Upsert rows into a table",
      "topics": [
        "sb_upsert"
      ]
    }
  ],
  "_pkglogo": "https://github.com/deepanshkhurana/supabaser/raw/HEAD/man/figures/logo.svg",
  "_readme": "https://github.com/deepanshkhurana/supabaser/raw/HEAD/README.md",
  "_rundeps": [
    "askpass",
    "backports",
    "bit",
    "bit64",
    "blob",
    "checkmate",
    "cli",
    "cpp11",
    "curl",
    "DBI",
    "dplyr",
    "generics",
    "glue",
    "hms",
    "httr2",
    "lifecycle",
    "lubridate",
    "magrittr",
    "openssl",
    "pillar",
    "pkgconfig",
    "R6",
    "rappdirs",
    "rlang",
    "RPostgres",
    "sys",
    "tibble",
    "tidyselect",
    "timechange",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_score": 4.243038048686294,
  "_indexed": true,
  "_nocasepkg": "supabaser",
  "_universes": [
    "deepanshkhurana"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.0.1",
      "date": "2026-05-23T09:01:37.000Z",
      "distro": "noble",
      "commit": "d9754ce7399bae3f66f9520c06143673b02ea2ba",
      "fileid": "c29b73fb6c68a334d84c2876439390cc02beb7a77030164b99abed77cb454888",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/deepanshkhurana/actions/runs/26328638983"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.0.1",
      "date": "2026-05-23T09:01:34.000Z",
      "distro": "noble",
      "commit": "d9754ce7399bae3f66f9520c06143673b02ea2ba",
      "fileid": "c63418354d6c5c03be4c22bef4063ea45bbd5442e5c4372a442bd1ec007b80f0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/deepanshkhurana/actions/runs/26328638983"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.0.1",
      "date": "2026-05-23T09:01:18.000Z",
      "commit": "d9754ce7399bae3f66f9520c06143673b02ea2ba",
      "fileid": "3f798a37268eac07d5276e865683596290bd36554b2aa2e05d732439d1906609",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/deepanshkhurana/actions/runs/26328638983"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.0.1",
      "date": "2026-05-23T09:01:18.000Z",
      "commit": "d9754ce7399bae3f66f9520c06143673b02ea2ba",
      "fileid": "d684b190e34318e1df53d5e6f6113f28c84ac34e57acf6b83acf13474b37a7a9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/deepanshkhurana/actions/runs/26328638983"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.0.1",
      "date": "2026-05-23T09:01:23.000Z",
      "commit": "d9754ce7399bae3f66f9520c06143673b02ea2ba",
      "fileid": "8910ec8f237de4bad9d41ad8a482b99b69a5000e2cc4f6748adc844d7e335521",
      "status": "success",
      "buildurl": "https://github.com/r-universe/deepanshkhurana/actions/runs/26328638983"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.0.1",
      "date": "2026-05-23T09:00:32.000Z",
      "commit": "d9754ce7399bae3f66f9520c06143673b02ea2ba",
      "fileid": "56482bc49bb6c94560e9b591a855eeb8239aa22e8c0965deaf6173f58783d7f7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/deepanshkhurana/actions/runs/26328638983"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.0.1",
      "date": "2026-05-23T09:00:38.000Z",
      "commit": "d9754ce7399bae3f66f9520c06143673b02ea2ba",
      "fileid": "18a9093cbb2c3db6cc8f934b7362c4112b30cec72b4298b818da88e2cb9d8784",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/deepanshkhurana/actions/runs/26328638983"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.0.1",
      "date": "2026-05-23T09:00:55.000Z",
      "commit": "d9754ce7399bae3f66f9520c06143673b02ea2ba",
      "fileid": "eb3237f86a32ee358a8f8fda99a85c46f8b91b1ec0dbba84cc647e69650ab50b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/deepanshkhurana/actions/runs/26328638983"
    }
  ]
}