Handy MySQL Date functions with examples.

Date information tracking and storage is integral to companies, services, and applications. Imagine if your employer did not keep up with how many hours you worked? Or which days? Neither party involved could benefit. I’m confident such a company would have vacancies abound. This blog post will visit many of the available date functions offered in MySQL, to assist managing this all-important data type.
(more…)

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

todd-quackenbush-701

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.


Note: All data, names or naming found within the database presented in this post, are strictly used for practice, learning, instruction, and testing purposes. It by no means depicts actual data belonging to or being used by any party or organization.

I will be using Xubuntu Linux 16.04.3 LTS (Xenial Xerus) and MySQL 5.7.21 for these exercises.

(more…)

Delete existing record from PostgreSQL database with Python and Psycopg2.

Today’s blog post will show an example of how to delete an existing record from a PostgreSQL database utilizing Psycopg2, a feature-rich Python library, that offers a tremendous amount of functionality for working with Python and PostgreSQL databases.

(more…)

“The Spirit Thief” by Rachel Aaron

Plot Summary: In the city of Allaze, the king is presumably missing from his ruling throne room. The renowned Eli Monpress has a way with words. In particular, words with the spirits of things. Would his desire for fortune and more importantly fame, jeopardize his freedom at the hands of the Spirit Court’s Miranda Lyonette? Or can Eli continue to utilize his skill, magic, and unmatched wit to evade the unfaltering Miranda in her bid to apprehend him and stifle his continued scheming once and for all? Moreover can Miranda and Eli both throttle the plans of a mutual enemy by combining their strengths to save themselves along with a city that despises them both?

(more…)