A Shiny app for working with a SeaTable base without writing code:
open a local .dtable export or connect to a server, browse the
tables, read the schema, run SQL, and download the result as
.dtable, Excel or CSV.
Arguments
- x
Optional
harbour_clientorharbour_dtableto open with.- ...
Passed to
shiny::runApp().- host
Host to bind. Default
"127.0.0.1", this computer only. The app has no login: bound to an address others can reach, it hands them a client passed to it - its token, and a SQL box that can change the base - and whatever file is open.- port
Port. Default
NULL, letting Shiny choose.
Details
Pass a connected hb_client() or a base read with hb_read_dtable()
to start there. With no argument the app opens on its source panel,
which offers a bundled example base that needs no credentials and no
network.
The UI packages (shiny, bslib, reactable) are in Suggests, so
the client itself stays headless. A missing one, or a bslib older
than 0.6.0, produces a single informative error rather than a stack
trace. The Excel download also needs writexl; without it the app
says so when you ask for one.
Shiny refuses uploads over 5 MB by default, and a .dtable with
attachments is often larger, so while the app runs it accepts files up
to 1 GB. To choose another limit, set the shiny.maxRequestSize
option, in bytes, before calling hb_run_explorer(); a value you have
set is left as it is.
Examples
if (FALSE) { # interactive()
# the bundled example base, no credentials needed
hb_run_explorer()
# or start from a file, with its attachments, so that a .dtable
# download keeps them
path <- system.file("extdata", "example.dtable", package = "harbouR")
hb_run_explorer(hb_read_dtable(path, assets = "extract"))
}