r-dbi / RPostgres

A DBI-compliant interface to PostgreSQL
https://rpostgres.r-dbi.org
Other
328 stars 78 forks source link

using databases.pacha.dev for testing #422

Open pachadotdev opened 1 year ago

pachadotdev commented 1 year ago

Hi @hadley @krlmlr I have the website databases.pacha.dev where I host access free PSQL databases. How can we use it for testing? I also had MySQL and SQL Server databases but that was too much headache for limited server resources.

krlmlr commented 3 months ago

Thanks. I'm not sure how to use a publicly accessible database for testing. Perhaps this is useful for vignettes, as example datasets that can be accessed without setting up a database server and that are more contrived than using RSQLite or duckdb?

pachadotdev commented 3 months ago

Thanks. I'm not sure how to use a publicly accessible database for testing. Perhaps this is useful for vignettes, as example datasets that can be accessed without setting up a database server and that are more contrived than using RSQLite or duckdb?

good idea! I just wonder how to reconfigure sql server

krlmlr commented 3 months ago

Why is SQL Server important?

pachadotdev commented 3 months ago

Why is SQL Server important?

my idea was to provide different database backends to test edge cases