If you need to run remote commands on servers with #Python, then Fabric is your friend.

You can use it to do remote installs, run docker commands, cleanup scripts and so much more.

Source

𝟭𝟮 𝗠𝘂𝘀𝘁 𝗞𝗻𝗼𝘄 𝗖𝗼𝗱𝗶𝗻𝗴 𝗣𝗮𝘁𝘁𝗲𝗿𝗻𝘀 & 𝗧𝗵𝗲𝗶𝗿 𝗔𝗽𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝗶𝗻 𝗦𝘆𝘀𝘁𝗲𝗺 𝗗𝗲𝘀𝗶𝗴𝗻 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄

Here are 8 proven tips to improve your SQL query performance:

- Use the correct index

- Reduce network hops

- SELECT fewer columns

- Avoid table/index scans

- Use EXISTS instead of IN

- Use INNER JOIN instead of WHERE

- Avoid using subqueries when possible

- Examine execution plans on a realistic dataset

Source

The diagram below shows typical API designs with a shopping cart example.

𝟭𝟮 𝗠𝗶𝗰𝗿𝗼𝘀𝗲𝗿𝘃𝗶𝗰𝗲𝘀 𝗣𝗮𝘁𝘁𝗲𝗿𝗻𝘀 𝘁𝗼 𝗞𝗻𝗼𝘄 𝗕𝗲𝗳𝗼𝗿𝗲 𝘁𝗵𝗲 𝗦𝘆𝘀𝘁𝗲𝗺 𝗗𝗲𝘀𝗶𝗴𝗻 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄

Creating classes at runtime using "type()" function