Non-blocking Database Queries within app$get() about ambiorix HOT 3 CLOSED

Finally I used the psql command line tool as a workaround to access the Postgres DB from within a future. There is some overhead obviously (open/close connection for each request), but speed is excellent and memory usage acceptable. data.table::fread allows to read psqloutput directly into a data.table (via cmd argument). Working example: https://myweather.ch/map

Minimal example:

library(future)
library(ambiorix)
library(data.table)
plan(multisession)

app <- Ambiorix$new()

app$get("/async", function(req, res){
  future({
    q <- "SELECT something FROM somewhere;"
    cmd <- sprintf("psql -h somehost -d somedb -U someuser -w -c %s -AF,", shQuote(q))
    dat <- data.table::fread(cmd = cmd))
    # Fix column types if necessary
    res$send(dat)
  })
})
app$start()

from ambiorix.

@m-saenger I'm sorry I never came back to you on this issue. I've setup my company last year and it left me very little time for all open-source projects.

Has this been resolved? Have you found a solution?

from ambiorix.

No worries. I found a workaround and closed this issues a couple of days ago. See #41 (comment).

from ambiorix.