Embedded postgres support?

[atrauzzi]

Taking a look over here: https://github.com/mysticmind/mysticmind-postgresembed

It would be super cool if postgres was another option alongside sqlite and in-memory!

:heart:

[aivascu]

Hello @atrauzzi, Thank you for the suggestion, I think this is an awesome idea. I'll investigate the possibility to create an integration library, though I'm not sure though if will make it into this package. I am currently working on a library that will expand current features and will allow more room for extensions, including more database adapters (like Postgres).

[atrauzzi]

Sounds great. FWIW, I also opened this: https://github.com/npgsql/npgsql/issues/4266

I'm not sure they're gonna take it on, but I think embedded postgres is something the community and MS really should talk about, so I'm getting the conversations started! :wink:

[atrauzzi]

@aivascu - I've been busy over the last couple of weekends putting this together: https://github.com/atrauzzi/protoculture-dotnet-postgres

I would love to know what you think and to get any input you might have. Think any of your projects could benefit from it? :slightly_smiling_face:

[aivascu]

@atrauzzi the repository looks promising. I'm planning to publish the new library around next weekend. The first beta version will only have the in-memory and SQLite providers. I'll start working on the Postgres integration right after that.

[atrauzzi]

Thank you! :heart: I just got the nuget package published up on nuget.org.

I'm dealing with one issue regarding restore speed and contentFiles, feel free to give it an upvote: https://github.com/NuGet/Home/issues/11543 if interested.

:wink: