PostGreSql and EFcore: Cheatsheet
Rather then writing a separate article on Postgresql and another one with Efcore, I'll place my notes here. I currently only seem myself using it with EFcore and instead using mongodb with nodejs. Redis is still on my list of things to use more extensively in the future.
- https://wiki.postgresql.org/wiki/First_steps
- https://stackoverflow.com/questions/10845998/i-forgot-the-password-i-entered-during-postgres-installation
- https://stackoverflow.com/questions/40614466/postgresql-9-5-allow-remote-connections-without-editing-pg-hba-conf-file
- https://www.thegeekstuff.com/2014/02/enable-remote-postgresql-connection/
- https://stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge
- http://www.postgresqltutorial.com/postgresql-insert/
- https://stackoverflow.com/questions/10335561/use-database-name-command-in-postgresql
- https://dba.stackexchange.com/questions/1285/how-do-i-list-all-databases-and-tables-using-psql
- https://stackoverflow.com/questions/695289/cannot-simply-use-postgresql-table-name-relation-does-not-exist
EFcore
- https://stackoverflow.com/questions/787722/postgresql-autoincrement
- https://stackoverflow.com/questions/48625023/microsoft-entityframeworkcore-tools-dotnet-v2-0-1
- https://stackoverflow.com/questions/11679385/reset-entity-framework-migrations
- https://stackoverflow.com/questions/9703810/how-to-disable-migration-in-entity-framework-4-3-1/9709407#9709407
- https://stackoverflow.com/questions/18929546/how-to-update-database-on-remote-ms-sql-server-ef-code-first
Issues
- https://github.com/npgsql/npgsql/issues/647
- https://github.com/aspnet/EntityFrameworkCore/issues/10576