search

ironmansoftware / powershell-universal

Issue tracker for PowerShell Universal
https://powershelluniversal.com
37 stars 4 forks source link

Spanner Support #3314

Open Omzig opened 6 months ago

Omzig commented 6 months ago

Summary of the new feature / enhancement

As a developer, I want to use spanner in gcp so that i can be cloud friendly.

Proposed technical implementation details (optional)

No response

Omzig commented 5 months ago

@adamdriscoll, how hard would it get this into v5? Google SQL would be preferred.

Omzig commented 5 months ago

i think we just need to make sure we have the PostgresSQL Spanner driver and all the Postgres stuff should work:

https://www.cdata.com/kb/tech/googlespanner-jdbc-postgresql-fdw.rst https://www.infoq.com/news/2022/07/google-cloud-spanner-postgresql/

adamdriscoll commented 5 months ago

This won't make it in v5. I don't want to introduce another DB at this time. If the PostgreSQL driver works, that'd be great. Spanner does have an EF provider but adding another database adds a lot of overhead.

Omzig commented 5 months ago

This won't make it in v5. I don't want to introduce another DB at this time. If the PostgreSQL driver works, that'd be great. Spanner does have an EF provider but adding another database adds a lot of overhead.

can we add whatever the whateverSpanner.PostgreSQL plugin to psu v5?

adamdriscoll commented 5 months ago

Yeah. It would be possible to produce this plugin yourself. We can make sure that gets documented. We are looking at making a NuGet package for this kind of this. The other database providers are plugins already using the classes that will be part of the package.