TLS: UNDERSTANDING POSTGRESQL’S COMMUNICATION ENCRYPTION
- 6 December 2022
- Software EngineeringTechnology Business
In order to encrypt client-server connections, PostgreSQL is frequently used in conjunction with TLS (Transport Layer Security), which we will briefly…
POSTGRESQL GAPS IN SEQUENCES
- 29 November 2022
- Software EngineeringTechnology Business
Most database tables have a primary key that is a made-up number, and that number is usually made by a sequence. In a previous article, I went into so…
MULTIRANGES POSTGRESQL 14
- 24 November 2022
- Machine learningSoftware Engineering
The ability to store different types of intervals with upper and lower bounds using range types has been a feature of PostgreSQL for quite some time. …
Better PostgreSQl performance on slow networks with pipeline mode
- 23 November 2022
- Database Performance ManagementSoftware Engineering
It is well known that poor database performance results from high network latency. For the libpq C API, PostgreSQL v14 introduced “pipeline mode,” whi…
POSTGRESQL CASE-INSENSITIVE PATTERN MATCHING
- 19 November 2022
- Machine learningSoftware Engineering
Case-insensitive search is a highly requested feature, in part to keep Microsoft SQL Server compatibility. Using case-insensitive ICU collations is on…
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!