search

npgsql / efcore.pg

Entity Framework Core provider for PostgreSQL
PostgreSQL License
1.54k stars 226 forks source link

Guidance for NodaTime postgres data types #3234

Closed mwpowellhtx closed 3 months ago

mwpowellhtx commented 3 months ago

Perhaps I am missing something, I'm just reading through this article on postgres mappings, but I am not seeing per se, what do we specify for the various NodaTime constructs on the backend table creation? I see a lot of formulas and functions and so forth, but nothing like a table or column data type. Specifically of course interested in Instant I think... but also Duration, etc. I need to know so I can do the SQL migrations and such.

mwpowellhtx commented 3 months ago

Finding the Storage Internal mappings may be insightful... for Duration, Period, not sure about Instant, per se.

mwpowellhtx commented 3 months ago

This reference seems like a winner, NodaTime Type Plugin. But if there are other insights 💡 , by all means... 👀

mwpowellhtx commented 3 months ago

Closing. Unless there are any other nugets I missed.