Daniel Possenriede

The first example works for me now (with tidygeocoder v1.0.5 from CRAN), i.e. OpenCage returns `components.building` as a string for both coordinates. `annotations:timezone:offset_string` (sic!) sometimes returns a number though. ```...

> Thanks. I now disentangled and merged most preparatory PRs. Should we take another stab here? 🥳 I'll look into it, but again, it might take a couple of days...

FWIW this seems to be "fixed" for the ucrt builds of R 4.3 (and probably 4.2?) on Windows, because that has UTF-8 as native encoding. ``` r library(fs) library(testthat) twd...

@krlmlr I don't know anything about it right now, but I can take a look. Well, I will, because now I'm intrigued. It may take a couple of days until...

{sf} does not have MariaDB-specific `dbWriteTable()` methods, yet. ``` r library(sf) #> Linking to GEOS 3.11.2, GDAL 3.8.2, PROJ 9.3.1; sf_use_s2() is TRUE methods(dbWriteTable) #> [1] dbWriteTable,DBIConnection,Id,ANY-method #> [2] dbWriteTable,DBIObject,character,sf-method...

There used be a [Package Development CTV](https://github.com/ropensci-archive/PackageDevelopment/blob/master/README-NOT.md) (via @maelle) from 2018 which has been archived. This might still be helpful re structure and some packages/resources not yet mentioned (and not...

IIUC Postgres (sometimes) automatically casts untyped NULLs (i.e. those of `unknown` type) to `text`, e.g. in a `VALUE` statement. This is leads to problems with non-`text`-ish types, see [this answer](https://dba.stackexchange.com/a/228058)...

Fixes #453 too. You may want to adjust the title and description, @krlmlr (since you're the PR owner).

Closing this in favour of #414

Yeah, watch out for https://github.com/ropensci/opencage/blob/main/R/zzz.R and https://github.com/ropensci/opencage/blob/9b57eefa9725822d00e1e48417f5948eeeb15db1/R/oc_config.R#L122-L126 Though I am sure you've seen that.