Kemal ÖzRemoving the public Schema from search_pathIn PostgreSQL, the search_path is a key feature that defines which schemas the database should search for objects like tables and…2h ago
Laurin HeilmeyerinTowards Data ScienceExploring the Right Fit: Choosing Primary Keys for Your DatabaseA practical example of navigating key selection trade-offs in a real-world scenarioJul 166
Raphael De LioinRedis with Raphael De LioCan Postgres replace Redis as a cache?I wanted to understand: Is Postgres as a cache a really good idea? Can it indeed replace Redis? That’s what I want to find out today.Jul 1421Jul 1421
ckitgeekHow to connect a PostgreSQL database to an Oracle DatabaseWe are connecting a PostgreSQL 16 database on an Oracle Linux 8 VM to a schema in an Oracle 19c database1d ago1d ago
Martin HodgesHow to set up dynamic secrets for Postgres using Vault and Spring Boot on KubernetesIn this article I look at how to add dynamic Postgres credentials to a Spring Boot application using the Hashicorp Vault secrets manager.May 51May 51
Kemal ÖzRemoving the public Schema from search_pathIn PostgreSQL, the search_path is a key feature that defines which schemas the database should search for objects like tables and…2h ago
Laurin HeilmeyerinTowards Data ScienceExploring the Right Fit: Choosing Primary Keys for Your DatabaseA practical example of navigating key selection trade-offs in a real-world scenarioJul 166
Raphael De LioinRedis with Raphael De LioCan Postgres replace Redis as a cache?I wanted to understand: Is Postgres as a cache a really good idea? Can it indeed replace Redis? That’s what I want to find out today.Jul 1421
ckitgeekHow to connect a PostgreSQL database to an Oracle DatabaseWe are connecting a PostgreSQL 16 database on an Oracle Linux 8 VM to a schema in an Oracle 19c database1d ago
Martin HodgesHow to set up dynamic secrets for Postgres using Vault and Spring Boot on KubernetesIn this article I look at how to add dynamic Postgres credentials to a Spring Boot application using the Hashicorp Vault secrets manager.May 51
Peter BunyaninPython in Plain EnglishNew Python Tools That Deserve Your AttentionThings seem to be accelerating. That means I’m either getting older, or that there are more people on the planet and they’re coding. Here…Apr 2910
BatCatWhy I Vacuum My Tables Regularly Part 2Improve performance and prevent data clutter with proactive maintenance2d ago
Evgeniy IvanovinYDB.tech blogWhen Postgres is not enough: performance evaluation of PostgreSQL vs. Distributed DBMSsThis post presents an empirical study based on TPC-C, the industry-standard On-Line Transaction Processing (OLTP) benchmark.Mar 192