PostgreSQL provides a means for creating locks that have application-defined meanings. These are called advisory locks, because the system does not enforce their use […]
Read More
Simulate Synonyms in YSQL
If you’ve worked with the Oracle database you know that a synonym is an alias for a schema object such as the tables, […]
Read MoreStoring Pictures (i.e. JPGs) in YugabyteDB
There’s an age old question asking is it better to store images offline in a file system or online inside a database […]
Read MoreExecute a Bash script (Shell Script) from YugabyteDB
Shell scripting is a powerful and versatile tool for working with databases and SQL. It can help you automate tasks, manipulate data, […]
Read MoreAutomatically Create PG Extensions in all new Databases
PostgreSQL extensions provide a way to extend the functionality of a database by bundling SQL objects into a package and using them […]
Read More