Useful tips for everyday
How to enforce the FOREIGN KEY constraint in MySQL? This index might be silently dropped later if you create another index that can be used…
What to do if database is stuck in restore state? Script the DB drop, recreate and then restore. By default, every RESTORE DATABASE comes with…
What is the benefit of intent locks? Intent locks serve two purposes: To prevent other transactions from modifying the higher-level resource in a way that…
Is used to create a new table? The SQL CREATE TABLE statement is used to create a new table. When should we create a table?…
How do I get distinct only on one column? Adding the DISTINCT keyword to a SELECT query causes it to return only unique values for…
When to use multicolumn indexes in PostgreSQL? Multicolumn indexes should be used sparingly. In most situations, an index on a single column is sufficient and…
How do I restore a PostgreSQL database? Restore a PostgreSQL database To restore the entire PostgreSQL database, run this command. ./db.py -a restore -f /tmp/backup/…
Can we use and condition in CASE? CASE must include the following components: WHEN , THEN , and END . ELSE is an optional component.…
What is self-learning chatbot? Self-learning chatbots are simply the ones that rely on Machine Learning and other AI services to make conversations. The conversational solutions…
How is deep learning used in practice? Deep learning has delivered super-human accuracy for image classification, object detection, image restoration and image segmentation—even handwritten digits…