Philémon Comments - Answer Overflow

Philémon

Posts Comments

CC#

•Created by Philémon on 8/20/2024 in #help

✅ PostgreSQL in docker container

Thanks again for your answers 🙏 I will close the thread now, see you soon on the server 👋

10 replies

CC#

•Created by Philémon on 8/20/2024 in #help

✅ PostgreSQL in docker container

Oh that's really nice, I didn't know it was a thing, at least for production databases 😮 But maybe it will require from me a better knowledge of how docker works, to manage well the DB, I don't think I will have the time to learn it enough, before my internship starts 😞

10 replies

CC#

•Created by Philémon on 8/20/2024 in #help

✅ PostgreSQL in docker container

Oh right, thank you very much, it's much clearer now ❤️ So if I understand correctly, the data is saved between a stop and a relaunch of the container, but it's a bit fragile in the sense that deleting the container will also delete all the data saved in it. I've chosen to use a docker container for my PostgreSQL database solely for the development of my application. So if I've understood correctly, as long as I'm still in development, there's no problem in doing it this way 😄 And in the future, I hope to deploy my application using an Azure database-style service. I won't need docker for my database at this stage. Once again, thank you very much for your answers!! 😁

10 replies

CC#

•Created by Philémon on 8/20/2024 in #help

✅ PostgreSQL in docker container

A word of clarification: I have access to my data. It's not really a problem, it's a question of understanding what I actually do.

10 replies

CC#

•Created by Philémon on 3/5/2024 in #help

✅ My API returns 500 internal server error with the SQL exception text, why?

Ok, thank you very much! I will try to make my own middleware, I never made one, it is a good idea to try it myself

7 replies

CC#

•Created by Philémon on 3/5/2024 in #help

✅ My API returns 500 internal server error with the SQL exception text, why?

Yes I run it in development! The only middleware related to dev env that I see is this :

if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI();
}

if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI();
}

Is this the middleware that add the dev exceptions? In any case, I guess I should not be bothered by these dev exceptions if it only appears in a dev environment?

7 replies

CC#

•Created by Philémon on 2/9/2024 in #help

✅ How to properly set a default value as UtcNow with EF Core and PostgreSQL

Ok, I see. Really cool. Thank you!!!

9 replies

CC#

•Created by Philémon on 2/9/2024 in #help

✅ How to properly set a default value as UtcNow with EF Core and PostgreSQL

Oh nice, I will try this too, thanksssss

9 replies

CC#

•Created by Philémon on 2/9/2024 in #help

✅ How to properly set a default value as UtcNow with EF Core and PostgreSQL

I tought about it! but I didn't find any postgres function that gives the UtcNow. For example, the function now() gives you the datetime according to your server timezone unfortunately. What do you think would be the benefits of having my datetime generated on the DB Side? If i find something that works?

9 replies

CC#

•Created by Philémon on 2/9/2024 in #help

✅ How to properly set a default value as UtcNow with EF Core and PostgreSQL

Super cool, thanks a lot!

9 replies

CC#

•Created by Philémon on 12/30/2023 in #help

String : Immutable reference type

Ok, I see

37 replies

CC#

•Created by Philémon on 12/30/2023 in #help

String : Immutable reference type

How can it be? I pass it as an argument and i don't declare a new variable in the method, and yet they are still not the same variable? Or is the parameter declaration considered as a variable declaration?

37 replies

CC#

•Created by Philémon on 12/30/2023 in #help

String : Immutable reference type

Ok thank you 😄

37 replies

CC#

•Created by Philémon on 12/30/2023 in #help

String : Immutable reference type

Its just a local variable?

37 replies

CC#