Query Optimization in MariaDB
Query optimization is the elusive process of improving the efficiency and performance of SQL queries to reduce execution time, minimizes resource usage, and enhances overall database performance.
Tech
-
-
Deep Dive into Advanced SQL Techniques with Examples
Despite its origins in the 1970s, SQL continues to be a vital skill for data science professionals, with demand for it projected to grow even more in the job market. SQL excels as a versatile solution throughout the entire data lifecycle.
-
Parallel downloads using Threading in Python
ThreadPoolExecutor allows us to push tasks to a background thread without blocking execution of the calling thread, while still being able to retrieve their results when needed.
-
Asynchronous downloads using asyncio in Python
asyncio is especially useful for I/O-bound tasks like downloading or uploading files, where the primary bottleneck is neither CPU nor Memory but rather waiting for network responses.
-
Modern dashboard apps with Observable Framework
Observable Framework is a static site generator for building interactive dashboard apps. You give it a mixture of Markdown and JavaScript (and potentially other languages too) and it compiles them all together into fast loading interactive pages which can be shared with stakeholders
-
Unlock Lightning-Fast Data Insights with Observable Notebooks!
Observable notebooks can be used to create dynamic and interactive data visualizations that are easy to share and collaborate on, enhancing your ability to analyze and present data effectively.