davidpaquetteUsing the CUBE grouping in SQLData analysis is the cornerstone of informed decision-making in today’s data-driven world. As datasets grow in size and complexity, the…Jun 17Jun 17
davidpaquetteRollup grouping with PostgresPostgreSQL offers a variety of powerful SQL functions to simplify data analysis and reporting. One such function is ROLLUP, a part of the…Jun 7Jun 7
davidpaquetteNavigating Nested JSON Objects with Ease: A Guide to SQLite’s json_tree FunctionIn the realm of data management, JSON (JavaScript Object Notation) has emerged as a popular format for structuring and exchanging…May 1May 1
davidpaquetteExcel vlookup and sql joins are very similarIn the world of data analysis and database management, the quest for insights often revolves around connecting disparate pieces of…Apr 28Apr 28
davidpaquetteVirtual environments with python and macosIf you develop python projects for a long time, eventually you will run into the need to use a different version of python (be it 3.12 or…Apr 5Apr 5
davidpaquetteUsing selenium on AWS lambdaRecently I had a job request to make a scraper for the google reverse image search (lens) webpage. The found images were to be categorized…Mar 21Mar 21
davidpaquetteSetting up Anaconda and Jupyter on MacOsRecently I made a big effort to install the necessary python libraries and IDE setup to pursue jupyter notebook development and other data…Mar 13Mar 13
davidpaquetteSometimes you are not stuck (programming)We have all been there, trying to solve a coding problem from LeetCode or Hacker Rank. You may have hit the run button 50 times and that…Sep 6, 2023Sep 6, 2023