blog.cloudneutral.seHandling Null Values Efficiently with Spring Named Parameter BindingIntroduction Using Spring’s NamedParameterJdbcTemplate and binding null values with a SQL type code and type name may lead to the pgJDBC driver performing costly metadata queries to infer internal types. This is by JDBC specification and pgJDBC desig...Nov 27, 2025·4 min read
blog.cloudneutral.seMulti-active systemsSome business drivers that could justify adopting a multi-active and multi-region deployment strategy: Securing business continuity in the event of regional data centre disruptions Deliver a good customer experience worldwide Deliver business adap...Jul 31, 2023·6 min read
blog.cloudneutral.seUser defined composite typesIn a previous article, we look at creating a simple distributed user-defined function (UDF) in CockroachDB. In this article, we'll revisit UDFs in the form of user-defined composite types, introduced in CockroachDB v23.1. Introduction A composite typ...Jun 30, 2023·4 min read
blog.cloudneutral.seTransaction timeouts in CockroachDBIn a previous article series on Spring Data JPA and CockroachDB, we look into different methods to avoid lengthy transaction execution times. Until recently, however, there's not been any way to specify the transaction execution timeout in CockroachD...Jun 30, 2023·4 min read
blog.cloudneutral.seOne-Phase Commit Transaction StrategyIntroduction A commonly adopted transaction strategy can be described as the best-efforts one-phase-commit (1PC) pattern. It's different from a global XA/2PC protocol where an external transaction manager ensures that all transaction properties are m...Apr 30, 2023·5 min read
