Skip to content

qst

Store Tables in SQL Database

v0.1.2 · Nov 20, 2020 · MIT + file LICENCE

Description

Provides functions for quickly writing (and reading back) a data.frame to file in 'SQLite' format. The name stands for *Store Tables using 'SQLite'*, or alternatively for *Quick Store Tables* (either way, it could be pronounced as *Quest*). For data.frames containing the supported data types it is intended to work as a drop-in replacement for the 'write_*()' and 'read_*()' functions provided by similar packages.

Downloads

CRAN

237

Last 30 days

21115th

590

Last 90 days

2.2K

Last year

Trend: +46.3% (30d vs prior 30d)

r2u CRAN

0

Last 30 days

24

Last 90 days

82

Last year

Trend: -100% (30d vs prior 30d)

autoCRAN

2

Last 7 days

10

Last 30 days

0

All-time

autoCRAN-only: this name is served only by autoCRAN, so the count is exact.

CRAN Check Status

2 NOTE
11 OK
Show all 13 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang NOTE
r-devel-linux-x86_64-debian-gcc NOTE
r-devel-linux-x86_64-fedora-clang OK
r-devel-linux-x86_64-fedora-gcc OK
r-devel-windows-x86_64 OK
r-oldrel-macos-arm64 OK
r-oldrel-macos-x86_64 OK
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK
Check details (2 non-OK)
NOTE r-devel-linux-x86_64-debian-clang

CRAN incoming feasibility

Maintainer: ‘Magnus Thor Torfason <m@zulutime.net>’

No Authors@R field in DESCRIPTION.
Please add one, modifying
  Authors@R: person(given = c("Magnus", "Thor"),
                    family = "Torfason",
                    role = c("aut", "cre"),
                    email = "m@zulutime.net")
as necessary.
NOTE r-devel-linux-x86_64-debian-gcc

CRAN incoming feasibility

Maintainer: ‘Magnus Thor Torfason <m@zulutime.net>’

No Authors@R field in DESCRIPTION.
Please add one, modifying
  Authors@R: person(given = c("Magnus", "Thor"),
                    family = "Torfason",
                    role = c("aut", "cre"),
                    email = "m@zulutime.net")
as necessary.

Check History

NOTE 11 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Jun 9, 2026
NOTE r-devel-linux-x86_64-debian-clang

CRAN incoming feasibility

Maintainer: ‘Magnus Thor Torfason <m@zulutime.net>’

No Authors@R field in DESCRIPTION.
Please add one, modifying
  Authors@R: person(given = c("Magnus", "Thor"),
                    family = "Torfason",
                    role = c("aut", "cre"),
                    email = "m@zulutime.net")
as necessary.
NOTE r-devel-linux-x86_64-debian-gcc

CRAN incoming feasibility

Maintainer: ‘Magnus Thor Torfason <m@zulutime.net>’

No Authors@R field in DESCRIPTION.
Please add one, modifying
  Authors@R: person(given = c("Magnus", "Thor"),
                    family = "Torfason",
                    role = c("aut", "cre"),
                    email = "m@zulutime.net")
as necessary.
ERROR 11 OK · 1 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Jun 8, 2026
NOTE r-devel-linux-x86_64-debian-clang

CRAN incoming feasibility

Maintainer: ‘Magnus Thor Torfason <m@zulutime.net>’

No Authors@R field in DESCRIPTION.
Please add one, modifying
  Authors@R: person(given = c("Magnus", "Thor"),
                    family = "Torfason",
                    role = c("aut", "cre"),
                    email = "m@zulutime.net")
as necessary.
ERROR r-devel-linux-x86_64-debian-gcc

CRAN incoming feasibility

Maintainer: ‘Magnus Thor Torfason <m@zulutime.net>’

No Authors@R field in DESCRIPTION.
Please add one, modifying
  Authors@R: person(given = c("Magnus", "Thor"),
                    family = "Torfason",
                    role = c("aut", "cre"),
                    email = "m@zulutime.net")
as necessary.
NOTE 9 OK · 5 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026
NOTE r-devel-linux-x86_64-debian-clang

CRAN incoming feasibility

Maintainer: ‘Magnus Thor Torfason <m@zulutime.net>’

No Authors@R field in DESCRIPTION.
Please add one, modifying
  Authors@R: person(given = c("Magnus", "Thor"),
                    family = "Torfason",
                    role = c("aut", "cre"),
                    email = "m@zulutime.net")
as necessary.
NOTE r-devel-linux-x86_64-debian-gcc

CRAN incoming feasibility

Maintainer: ‘Magnus Thor Torfason <m@zulutime.net>’

No Authors@R field in DESCRIPTION.
Please add one, modifying
  Authors@R: person(given = c("Magnus", "Thor"),
                    family = "Torfason",
                    role = c("aut", "cre"),
                    email = "m@zulutime.net")
as necessary.
NOTE r-oldrel-macos-arm64

LazyData

'LazyData' is specified without a 'data' directory
NOTE r-oldrel-macos-x86_64

LazyData

'LazyData' is specified without a 'data' directory
NOTE r-oldrel-windows-x86_64

LazyData

'LazyData' is specified without a 'data' directory

Line coverage

Expression

Tests / Examples

Functions

2 2 exported

Complexity

3 avg / 4 max

Call network

2 nodes / 0 edges

Test coverage has not been measured for this package yet; nodes fall back to a neutral fill.

Loading call graph…

Lowest coverage

Per-function coverage is not measured for this package yet.

Code

Structure

Lines of code

312

Files

16

Compiled share

0%

Has compiled src

No

Language breakdown

R 145 (46.5%)Tests 46 (14.7%)Docs 121 (38.8%)

API

Exported functions

4

Internal functions

0

Recent export changes

v0.1.2+4 %>%, read_qst, tibble +1 more

Testing & CI

Has tests

Yes

Test-to-code ratio

0.32

testthat edition

CI present

No

CI type

[]

PR gated

No

Docs

Return-value doc rate

66.7%

\dontrun example ratio

0%

Roxygen coverage

75%

Has pkgdown

No

NEWS present

Yes

Health & Security signals

Informational signals; not verdicts.

on.exit coverage

Unsafe pattern score

0

Dep constraint coverage

0%

Secret pattern count

0

Bundled 3rd-party code

2 items

Portability & License

Min R version

System requirements

C++ standard

License

MIT + file LICENCE

License flags

SPDX valid, OSI approved

History

Versions

1

First release

2020-11-20

Latest release

2020-11-20

Avg cadence

Cold removal rate

Dep drift

0

Per-file churn detail lives in the source pipeline: https://github.com/r-observatory/cran-code-metrics.

Dependency Network

Dependencies Reverse dependencies RSQLite DBI dplyr dbplyr tibble magrittr qst

Version History

1 tracked
new 0.1.2 Mar 10, 2026

R Observatory began tracking this package on Mar 10, 2026; it first appeared on CRAN Nov 20, 2020. Releases before tracking aren’t shown.