--- title: Best strongdm posts — December 2024 | daily.dev description: The most upvoted strongdm posts from December 2024, curated by the daily.dev community. canonical: https://daily.dev/sources/strongdm/best-of/2024/12 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/sources/strongdm/best-of/2024/12 og:type: website og:site_name: daily.dev og:title: Best strongdm posts — December 2024 | daily.dev og:description: The most upvoted strongdm posts from December 2024, curated by the daily.dev community. og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph --- # Best of strongdm — December 2024 1. 1 [](https://daily.dev/posts/how-to-list-all-databases-in-postgresql-6-methods--mkjbryule "How to List All Databases in PostgreSQL (6 Methods)") Article strongdm · 2y How to List All Databases in PostgreSQL (6 Methods) Learn six different methods to list all databases in PostgreSQL: using the psql command-line interface, SQL queries, pgAdmin, third-party tools like DBeaver, automation with scripts, and Docker containers. The guide provides step-by-step instructions and troubleshooting tips for common issues. 21 2. 2 [](https://daily.dev/posts/how-to-create-a-database-in-postgresql-y936vts7w "How to Create a Database in PostgreSQL") Article strongdm · 2y How to Create a Database in PostgreSQL Managing large datasets efficiently can be challenging. PostgreSQL is an advanced database system known for its reliability and performance. This guide covers installing PostgreSQL, connecting via psql or pgAdmin, creating databases, and managing permissions. Common issues such as permission errors and encoding conflicts are also addressed. Additionally, StrongDM enhances database security and management through centralized dashboards, audit logging, tool integration, and role-based access control. 18 1 [See all strongdm archives](/sources/strongdm/best-of) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/sources/strongdm/best-of/2024/12#page","url":"https://daily.dev/sources/strongdm/best-of/2024/12","name":"Best strongdm Posts — December 2024","description":"The most upvoted strongdm posts from December 2024, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/sources/strongdm/best-of/2024/12#items","numberOfItems":2,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/how-to-list-all-databases-in-postgresql-6-methods--mkjbryule","name":"How to List All Databases in PostgreSQL (6 Methods)"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/how-to-create-a-database-in-postgresql-y936vts7w","name":"How to Create a Database in PostgreSQL"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Sources","item":"https://daily.dev/sources"},{"@type":"ListItem","position":3,"name":"strongdm","item":"https://daily.dev/sources/strongdm"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/sources/strongdm/best-of"},{"@type":"ListItem","position":5,"name":"December 2024"}]}]} ```