SQL — UPDATE INTO another table

SQL — update into another table Update records from one table and insert the updated records into another table in ONE statement “Why would I need a query like that?” An update into statement is advantageous for two main reasons: * The statement is Atomic; either both occur or nothing occurs, i.

SQL — DELETE INTO another table

Delete records from one table and insert them into another table in ONE statement “Why would I need a query like that?” A delete into statement is advantageous for two main reasons: * The statement is Atomic; either both occur or nothing occurs, i.e. if either the delete or the

Version control your database Part 1: creating migrations and seeding

Easily plan, validate, and safely apply changes to your database If you are not working with migrations in your database you’re missing out. Like Git manages changes to source code, you can use migrations to keep track of changes to your database. Execute and revert changes and get your

Create a fully fledged, professional API with Flask in Python — Part 1

Professionally and securely allow access to your Python programs in 6 steps

Log errors in SQL Server that would otherwise go unnoticed (+ examples)

Detecting, analyzing and logging errors in my queries

Dramatically improve your database insert speed with a simple upgrade

4 levels of creating blazingly fast database connections in Python