NOTIFY/LISTEN: POSTGRESQL AUTOMATIC CLIENT NOTIFICATION
- 25 October 2022
- Machine learningSoftware Engineering
Users can listen in on database activity using the LISTEN/NOTIFY capability. It is still one of PostgreSQL’s most used features despite being one of t…
SEQUENCES VS. INVOICE NUMBERS IN POSTGRESQL
In SQL, sequences are a fundamental characteristic. Some users, however, are inclined to employ sequences to produce bills. That is risky and ought to…
Why are my postgresql update times getting less timely?
A customer recently questioned me about why a bulk load into a PostgreSQL table continued slowing down over time. They saw that the trigger on the tab…
Oracle REPLACE function.
The Oracle/PLSQL REPLACE function replaces a sequence of characters in a string with another character set….
Oracle SUBSTR function.
- 20 October 2022
- Deep learningMachine learningSoftware Engineering
The Oracle/PLSQL SUBSTR function allows extracting a substring from a string….
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!