Data

Tools

Indexes

Applications

Experiments

Open Source Science

RSQLite

R interface for SQLite

https://github.com/r-dbi/rsqlite

Science Score: 36.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • ○
    CITATION.cff file
  • ✓
    codemeta.json file
    Found codemeta.json file
  • ✓
    .zenodo.json file
    Found .zenodo.json file
  • ○
    DOI references
  • ○
    Academic publication links
  • ✓
    Committers with academic emails
    2 of 52 committers (3.8%) from academic institutions
  • ○
    Institutional organization owner
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (14.5%) to scientific vocabulary

Keywords

database r sqlite3

Keywords from Contributors

data-manipulation tidy-data grammar interface visualisation rmarkdown parsing package-creation fwf csv
Last synced: 6 months ago · JSON representation

Repository

R interface for SQLite

Basic Info
  • Host: GitHub
  • Owner: r-dbi
  • License: lgpl-2.1
  • Language: R
  • Default Branch: main
  • Homepage: https://rsqlite.r-dbi.org
  • Size: 58.3 MB
Statistics
  • Stars: 332
  • Watchers: 19
  • Forks: 78
  • Open Issues: 27
  • Releases: 47
Topics
database r sqlite3
Created over 12 years ago · Last pushed 6 months ago
Metadata Files
Readme Changelog Contributing License Code of conduct Security

README.Rmd 

---
output: downlit::readme_document
---



```{r setup, include = FALSE}
pkgload::load_all()
```


# RSQLite


[![Lifecycle: stable](https://img.shields.io/badge/lifecycle-stable-brightgreen.svg)](https://lifecycle.r-lib.org/articles/stages.html)
[![rcc](https://github.com/r-dbi/RSQLite/workflows/rcc/badge.svg)](https://github.com/r-dbi/RSQLite/actions)
[![Coverage Status](https://codecov.io/gh/r-dbi/RSQLite/branch/main/graph/badge.svg)](https://app.codecov.io/github/r-dbi/RSQLite?branch=main)
[![CRAN status](https://www.r-pkg.org/badges/version/RSQLite)](https://cran.r-project.org/package=RSQLite)
[![CII Best Practices](https://bestpractices.coreinfrastructure.org/projects/3234/badge)](https://bestpractices.coreinfrastructure.org/projects/3234)


Embeds the SQLite database engine in R, providing a DBI-compliant interface. [SQLite](https://www.sqlite.org/index.html) is a public-domain, single-user, very light-weight database engine that implements a decent subset of the SQL 92 standard, including the core table creation, updating, insertion, and selection operations, plus transaction management.

You can install the latest released version from CRAN with:

```R
install.packages("RSQLite")
```

Or install the latest development version from GitHub with:

```R
# install.packages("devtools")
devtools::install_github("r-dbi/RSQLite")
```

Discussions associated with DBI and related database packages take place on [R-SIG-DB](https://stat.ethz.ch/mailman/listinfo/r-sig-db).
The website [Databases using R](https://db.rstudio.com/) describes the tools and best practices in this ecosystem.

## Basic usage

```{r}
library(DBI)
# Create an ephemeral in-memory RSQLite database
con <- dbConnect(RSQLite::SQLite(), ":memory:")

dbListTables(con)
dbWriteTable(con, "mtcars", mtcars)
dbListTables(con)

dbListFields(con, "mtcars")
dbReadTable(con, "mtcars")

# You can fetch all results:
res <- dbSendQuery(con, "SELECT * FROM mtcars WHERE cyl = 4")
dbFetch(res)
dbClearResult(res)

# Or a chunk at a time
res <- dbSendQuery(con, "SELECT * FROM mtcars WHERE cyl = 4")
while (!dbHasCompleted(res)) {
  chunk <- dbFetch(res, n = 5)
  print(nrow(chunk))
}
# Clear the result
dbClearResult(res)

# Disconnect from the database
dbDisconnect(con)
```

## Acknowledgements

Many thanks to Doug Bates, Seth Falcon, Detlef Groth, Ronggui Huang, Kurt Hornik, Uwe Ligges, Charles Loboz, Duncan Murdoch, and Brian D. Ripley for comments, suggestions, bug reports, and/or patches.

---

Please note that the 'RSQLite' project is released with a
[Contributor Code of Conduct](https://rsqlite.r-dbi.org/code_of_conduct).
By contributing to this project, you agree to abide by its terms.

Owner

  • Name: r-dbi
  • Login: r-dbi
  • Kind: organization

R + databases

GitHub Events

Total
  • Create event: 135
  • Release event: 7
  • Issues event: 9
  • Watch event: 10
  • Delete event: 84
  • Issue comment event: 35
  • Push event: 299
  • Pull request review event: 1
  • Pull request review comment event: 1
  • Pull request event: 174
  • Fork event: 3
Last Year
  • Create event: 135
  • Release event: 7
  • Issues event: 9
  • Watch event: 10
  • Delete event: 84
  • Issue comment event: 35
  • Push event: 299
  • Pull request review event: 1
  • Pull request review comment event: 1
  • Pull request event: 174
  • Fork event: 3

Committers

Last synced: 8 months ago

All Time
  • Total Commits: 2,885
  • Total Committers: 52
  • Avg Commits per committer: 55.481
  • Development Distribution Score (DDS): 0.365
Past Year
  • Commits: 140
  • Committers: 6
  • Avg Commits per committer: 23.333
  • Development Distribution Score (DDS): 0.35
Top Committers
Name Email Commits
Kirill Müller k****r@m****g 1,833
hadley h****m@g****m 370
sethf s****f@d****5 222
Kirill Müller k****r@i****h 168
upgrade s****e@g****l 49
github-actions[bot] 4****] 35
Maximilian Girlich m****h@m****m 22
Bruno Gonçalves b****s 20
Will Beasley w****y@h****m 18
Eric Anderson a****1@g****m 15
antonov548 a****8@g****m 14
Gábor Csárdi c****r@g****m 13
Tobias t****s@c****m 12
Wush Wu w****8@g****m 9
Indrajeet Patil p****e@g****m 8
Jeanette Clark j****k@n****u 8
Ralf Herold r****d@g****t 7
JJ Allaire jj@r****g 5
Raphael Winkelmann r****n@r****l 5
upgrade p****h@g****l 4
Jeroen Ooms j****s@g****m 3
Maëlle Salmon m****n@y****e 3
Michael Chirico c****m@g****m 3
Kirill Müller m****r@o****e 3
Adam Black a****k@o****m 3
Michael Kuhn m****n@g****m 2
shrektan s****n@1****m 2
Seth Falcon s****h@u****t 2
Seth Falcon s****h@o****m 2
arib a****b@a****m 2
and 22 more...
Committer Domains (Top 20 + Academic)
fhcrc.org: 2 mailbox.org: 1 ivt.baug.ethz.ch: 1 metoda.com: 1 gmx.com: 1 cynkra.com: 1 nceas.ucsb.edu: 1 gmx.net: 1 rstudio.org: 1 google.com: 1 organice.de: 1 odysseusinc.com: 1 126.com: 1 userprimary.net: 1 opscode.com: 1 abfriedman.com: 1 genomicsplc.com: 1 rkingdc.com: 1 freebsd.org: 1 lundbeck.com: 1

Issues and Pull Requests

Last synced: 6 months ago

All Time
  • Total issues: 53
  • Total pull requests: 301
  • Average time to close issues: 8 months
  • Average time to close pull requests: 6 days
  • Total issue authors: 45
  • Total pull request authors: 15
  • Average comments per issue: 3.68
  • Average comments per pull request: 0.69
  • Merged pull requests: 258
  • Bot issues: 0
  • Bot pull requests: 144
Past Year
  • Issues: 5
  • Pull requests: 172
  • Average time to close issues: 16 days
  • Average time to close pull requests: 1 day
  • Issue authors: 5
  • Pull request authors: 3
  • Average comments per issue: 1.6
  • Average comments per pull request: 0.06
  • Merged pull requests: 140
  • Bot issues: 0
  • Bot pull requests: 94
View more stats
Top Authors
Issue Authors
  • krlmlr (7)
  • mgirlich (2)
  • ggrothendieck (2)
  • IdoBar (1)
  • ankane (1)
  • malcook (1)
  • nunotexbsd (1)
  • rattei (1)
  • gaospecial (1)
  • chodarq (1)
  • gavril0 (1)
  • joethorley (1)
  • giocomai (1)
  • Jeff-Gui (1)
  • DavorJ (1)
Pull Request Authors
  • github-actions[bot] (143)
  • krlmlr (133)
  • maelle (4)
  • rfhb (4)
  • mgirlich (2)
  • jeanetteclark (2)
  • kjellpk (2)
  • bpvgoncalves (2)
  • mikmart (2)
  • MichaelChirico (2)
  • nunotexbsd (1)
  • aviator-app[bot] (1)
  • lolow (1)
  • Antonov548 (1)
  • tschoonj (1)
Top Labels
Issue Labels
feature (11) help wanted (9) bug (5)
Pull Request Labels
CRAN release :station: (34) mergequeue (17) blocked (2)

Packages

  • Total packages: 4
  • Total downloads:
    • cran 218,395 last-month
  • Total docker downloads: 47,185,784
  • Total dependent packages: 265
    (may contain duplicates)
  • Total dependent repositories: 1,491
    (may contain duplicates)
  • Total versions: 234
  • Total maintainers: 1
cran.r-project.org: RSQLite

SQLite Interface for R

  • Versions: 96
  • Dependent Packages: 250
  • Dependent Repositories: 1,447
  • Downloads: 218,395 Last month
  • Docker Downloads: 47,185,784
Rankings
Dependent repos count: 0.3%
Dependent packages count: 0.5%
Forks count: 0.9%
Downloads: 0.9%
Stargazers count: 1.2%
Average: 3.5%
Docker downloads count: 17.3%
Maintainers (1)
kirill@cynkra.com
Last synced: 6 months ago
proxy.golang.org: github.com/r-dbi/rsqlite
  • Versions: 62
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent packages count: 5.5%
Average: 5.6%
Dependent repos count: 5.8%
Last synced: 6 months ago
proxy.golang.org: github.com/r-dbi/RSQLite
  • Versions: 62
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent packages count: 5.5%
Average: 5.6%
Dependent repos count: 5.8%
Last synced: 6 months ago
conda-forge.org: r-rsqlite
  • Versions: 14
  • Dependent Packages: 15
  • Dependent Repositories: 44
Rankings
Dependent packages count: 4.2%
Dependent repos count: 5.4%
Average: 13.2%
Forks count: 20.9%
Stargazers count: 22.1%
Last synced: 6 months ago

Dependencies

DESCRIPTION cran
  • R >= 3.1.0 depends
  • DBI >= 1.1.0 imports
  • Rcpp >= 1.0.7 imports
  • bit64 * imports
  • blob >= 1.2.0 imports
  • memoise * imports
  • methods * imports
  • pkgconfig * imports
  • DBItest >= 1.7.0 suggests
  • callr * suggests
  • gert * suggests
  • gh * suggests
  • hms * suggests
  • knitr * suggests
  • rmarkdown * suggests
  • rvest * suggests
  • testthat * suggests
  • xml2 * suggests
.github/workflows/R-CMD-check-dev.yaml actions
  • ./.github/workflows/check * composite
  • ./.github/workflows/custom/after-install * composite
  • ./.github/workflows/custom/before-install * composite
  • ./.github/workflows/dep-matrix * composite
  • ./.github/workflows/install * composite
  • ./.github/workflows/rate-limit * composite
  • ./.github/workflows/update-snapshots * composite
  • actions/checkout v3 composite
  • r-lib/actions/setup-r v2 composite
.github/workflows/R-CMD-check.yaml actions
  • ./.github/workflows/check * composite
  • ./.github/workflows/commit * composite
  • ./.github/workflows/custom/after-install * composite
  • ./.github/workflows/custom/before-install * composite
  • ./.github/workflows/git-identity * composite
  • ./.github/workflows/install * composite
  • ./.github/workflows/pkgdown-build * composite
  • ./.github/workflows/pkgdown-deploy * composite
  • ./.github/workflows/rate-limit * composite
  • ./.github/workflows/roxygenize * composite
  • ./.github/workflows/style * composite
  • ./.github/workflows/update-snapshots * composite
  • actions/checkout v3 composite
.github/workflows/check/action.yml actions
  • actions/upload-artifact main composite
  • r-lib/actions/check-r-package v2 composite
.github/workflows/fledge.yaml actions
  • ./.github/workflows/git-identity * composite
  • ./.github/workflows/install * composite
  • actions/checkout v2 composite
.github/workflows/install/action.yml actions
  • ./.github/workflows/get-extra * composite
  • r-lib/actions/setup-pandoc v2 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
.github/workflows/lock.yaml actions
  • dessant/lock-threads v2 composite
.github/workflows/pkgdown-deploy/action.yml actions
  • nick-fields/retry v2 composite
.github/workflows/pkgdown.yaml actions
  • ./.github/workflows/custom/after-install * composite
  • ./.github/workflows/custom/before-install * composite
  • ./.github/workflows/git-identity * composite
  • ./.github/workflows/install * composite
  • ./.github/workflows/pkgdown-build * composite
  • ./.github/workflows/pkgdown-deploy * composite
  • ./.github/workflows/rate-limit * composite
  • actions/checkout v3 composite
.github/workflows/pr-commands.yaml actions
  • actions/checkout v3 composite
  • r-lib/actions/pr-fetch master composite
  • r-lib/actions/pr-push master composite
  • r-lib/actions/setup-r master composite
.github/workflows/revdep.yaml actions
  • actions/checkout v3 composite
  • actions/upload-artifact main composite
  • r-lib/actions/setup-pandoc v2 composite
.github/workflows/style/action.yml actions
  • actions/cache v3 composite
.github/workflows/update-snapshots/action.yml actions
  • peter-evans/create-pull-request v4 composite
.github/workflows/upgrade.yaml actions
  • actions/cache v2 composite
  • actions/checkout v2 composite
  • r-lib/actions/setup-r v2 composite
.github/workflows/commit/action.yml actions
.github/workflows/custom/before-install/action.yml actions
.github/workflows/dep-matrix/action.yml actions
.github/workflows/dep-matrix-suggests/action.yml actions
.github/workflows/get-extra/action.yml actions
.github/workflows/git-identity/action.yml actions
.github/workflows/pkgdown-build/action.yml actions
.github/workflows/rate-limit/action.yml actions
.github/workflows/roxygenize/action.yml actions