Shell scripting is a powerful and versatile tool for working with databases and SQL. It can help you automate tasks, manipulate data, […]
Read More
Generate a Random Timestamp Between Two Timestamps (Faster Method)
In the previous tip GENERATE A RANDOM TIMESTAMP BETWEEN TWO TIMESTAMPS, we learned how to create a function to do just that. […]
Read MoreGENERATE A RANDOM STRING (FASTER METHOD)
In the previous tip GENERATE A RANDOM STRING, we learned how to create a function to do just that. In that version […]
Read MoreUsing the WIDTH_BUCKET Function
In YugabyteDB’s YSQL API the WIDTH_BUCKET function constructs equal width histograms, in which the histogram range is divided into intervals (buckets) of […]
Read MoreCreate Your Own IS_DATE Function
YugabyteDB is a PostgreSQL-compatible distributed database that supports the majority of PostgreSQL syntax. YugabyteDB also inherits all of the awesome built-in function that […]
Read More