# Postgresql

## References
- [PostgreSQL Documentation](https://www.postgresql.org/docs/current/)

## 📕 Articles
- [PostgreSQL Vs. MongoDB](https://blog.panoply.io/postgresql-vs-mongodb)
- [Npgsql Entity Framework Core Provider](https://www.npgsql.org/efcore/index.html)
- [Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL](https://scalegrid.io/blog/using-jsonb-in-postgresql-how-to-effectively-store-index-json-data-in-postgresql/)
- [JSON Types](https://www.postgresql.org/docs/13/datatype-json.html)
- [Faster Operations with the JSONB Data Type in PostgreSQL](https://www.compose.com/articles/faster-operations-with-the-jsonb-data-type-in-postgresql/)
- [Querying JSON (JSONB) data types in PostgreSQL](http://www.silota.com/docs/recipes/sql-postgres-json-data-types.html)
- [Unlocking the Full Potential Of PostgreSQL® JSON](https://www.instaclustr.com/blog/postgresql-json/)
- [How to choose the right database for your service](https://medium.com/wix-engineering/how-to-choose-the-right-database-for-your-service-97b1670c5632)
- [5 Database technologies used by 2000 Wix microservices](https://medium.com/wix-engineering/5-database-technologies-used-by-2000-wix-microservices-e4769638b8c3)

## 📹 Videos
- [Integrating ASP.NET Core API with Postgres & OData in Azure](https://www.youtube.com/watch?v=MoDJnEwkYOE) 
- [ASP.NET Core, C#, EF Core, PostgreSQL, WSL2 - PostreSQL Setup - Tricking Library Ep62](https://www.youtube.com/watch?v=qWfavvrhrfk)
- [Comparison of PostgreSQL and MongoDB](https://www.youtube.com/watch?v=eM7hzKwvTq8)
- [Learn PostgreSQL Tutorial - Full Course for Beginners](https://www.youtube.com/watch?v=qw--VYLpxG4)
- [PostgresSQL Playlist - Hussein Nasser](https://www.youtube.com/playlist?list=PLQnljOFTspQWGrOqslniFlRcwxyY94cjj)
- [Scaling PostgreSQL: How to never shard again](https://www.youtube.com/watch?v=U60z_UTMjAk)
- [PostgreSQL Tutorial for Beginners](https://www.youtube.com/watch?v=SpfIwlAYaKk)

## 📦 Libraries
- [JasperFx/marten](https://github.com/JasperFx/marten) - .NET Transactional Document DB and Event Store on PostgreSQL
- [zombodb/zombodb](https://github.com/zombodb/zombodb) - Making Postgres and Elasticsearch work together like it's 2021
- [jbogard/Respawn](https://github.com/jbogard/Respawn) - Intelligent database cleaner for integration tests
- [npgsql/efcore.pg](https://github.com/npgsql/efcore.pg) - Entity Framework Core provider for PostgreSQL
- [efcore/EFCore.NamingConventions](https://github.com/efcore/EFCore.NamingConventions) - Entity Framework Core plugin to apply naming conventions to table and column names (e.g. snake_case)