Stop Using Python to Aggregate Data - Use SQL Instead | Better Data Science

Описание: Are you using Python to extract raw data from the database? It could be a huge bottleneck in your apps. Use SQL instead.
ARTICLE: https://betterdatascience.com/python-...

00:00 Introduction
00:57 Create a synthetic dataset with Python
06:13 Load the dataset into Postgres database
08:10 Option #1 - Load the entire table with Python
12:05 Option #2 - Load the prepared views with Python
15:37 Outro

FOLLOW BETTER DATA SCIENCE
Website: https://betterdatascience.com
Medium:   / radecicdario  
LinkedIn:   / darioradecic  

FREE “LEARN DATA SCIENCE MASTERPLAN” EBOOK
http://eepurl.com/g7Ot3L

GEAR I USE
M1 Pro MacBook Pro 16”: https://amzn.to/3flD5wb
LG 27UL850 4K (Monitor): https://amzn.to/34QYVpq
Logitech MX Keys (Keyboard): https://amzn.to/3tH2V6r
Logitech MX Master 3 (Mouse): https://amzn.to/3Kd2Vk2
Rode NT-USB (Microphone): https://amzn.to/3FmIgq9
Audio Technica ATH-M40X (Headphones): https://amzn.to/3Fqj4iM