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…
MANAGING SQL ADD-ON PROGRAMS
- 18 November 2022
- Database Performance ManagementSoftware Engineering
We all love and hate bonus cards, “Miles & more,” and bonus points at the same time, don’t we? Recently, we encountered an intriguing use case that go…
How to define table size in MS SQL database
- 17 November 2022
- Database Performance ManagementSoftware Engineering
To determine the size of tables in a database hosted on Microsoft SQL Server, you need to perform the following steps:
1. Connect to a database ser…
Oracle NULLIF function
- 14 November 2022
- Machine learningSoftware Engineering
Oracle/PLSQL NULLIF function compares expr1 and expr2. If expr1 and expr2 are equal, the function NULLIF returns NULL. Otherwise, it returns expr1….
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!