Categories database-development

4 posts

Auto Added by WPeMatico

MySQL Triggers for Data Integrity — In lieu of Check Constraints Part 1.

Photo by Delano Balten on Unsplash Want to automate a process and ensure an operation is carried out for your database tables? Perhaps data integrity checks? Beginning with this blog post, I will present a two-part series leveraging MySQL triggers to ensure data integrity for mock pipeline pipe asset data. Note: All […]

MySQL Triggers for Data Integrity — In lieu of Check Constraints Part 2.

Photo by Todd Quackenbush on Unsplash Part 1 of this two-part series, discussed the requirements for implementing data integrity checks using a TRIGGER. With the success of that TRIGGER, this second blog post will dive into its workings, gaining an understanding of how the checks are performed, along with the TRIGGER itself. […]

Utility psql command for saving query output to a file.

Ever needed or wanted to save particular query results for later? Perhaps you need to really study something for better understanding. Scrutinize a dataset with a hawk’s eye while having a coffee? Or just list out all of the tables in the database you are working in? The psql o […]