Data Science & PostgreSQL
CYBERTEC es su socio profesional en Ciencia de Datos y PostgreSQL. Desde Machine Learning, Inteligencia Artificial y Big Data hasta soporte PostgreSQL, consultoría y capacitaciones.
Servicios de CYBERTEC PostgreSQL
Capacitaciones y cursos de CYBERTEC PostgreSQL
Herramientas CYBERTEC PostgreSQL
Basados en nuestra vasta experiencia en PostgreSQL, hemos desarrollado una serie de aplicaciones que se integraron perfectamente en los sistemas nativos
La opinión de nuestros clientes
Noticias del Blog de CYBERTEC PostgreSQL
Abusing SECURITY DEFINER functions
Functions defined as SECURITY DEFINER are a powerful, but dangerous tool in PostgreSQL. The documentation warns of the dangers: Because a SECURITY DEFINER function is executed with the privileges of the user that owns it, care is needed to ensure that the function cannot be misused. For security, search_path should be set to exclude […]
PostgreSQL v12 new feature: optimizer support for functions
PostgreSQL commit 74dfe58a5927b22c744b29534e67bfdd203ac028 has added “support functions”. This exciting new functionality that allows the optimizer some insight into functions. This article will discuss how this will improve query planning for PostgreSQL v12. If you are willing to write C code, you can also use this functionality for your own functions. Functions as “black boxes” […]
PostgreSQL: Using CREATE USER with caution
PostgreSQL offers powerful means to manage users / roles and enables administrators to implement everything from simple to really complex security concepts. However, if the PostgreSQL security machinery is not used wisely, things might become a bit rough. This fairly short post will try to shed some light on to this topic. The golden rule: […]