• #387 Heralding in a new era of database queries

  • Jun 11 2024
  • Length: 28 mins
  • Podcast

#387 Heralding in a new era of database queries By cover art

#387 Heralding in a new era of database queries

Listen for free

View show details

  • Summary

  • Topics covered in this episode: DataheraldPython's many command-line utilitiesDistroless Pythonfunctools.cache, cachetools, and cacheboxExtrasJokeExtrasJokeWatch on YouTube About the show Sponsored by ScoutAPM: pythonbytes.fm/scout Connect with the hosts Michael: @mkennedy@fosstodon.orgBrian: @brianokken@fosstodon.orgShow: @pythonbytes@fosstodon.org Join us on YouTube at pythonbytes.fm/live to be part of the audience. Usually Tuesdays at 10am PT. Older video versions available there too. Finally, if you want an artisanal, hand-crafted digest of every week of the show notes in email form? Add your name and email to our friends of the show list, we'll never share it. Michael #1: Dataherald Interact with your SQL database, Natural Language to SQL using LLMs.Allows you to set up an API from your database that can answer questions in plain EnglishUses include Allow business users to get insights from the data warehouse without going through a data analystEnable Q+A from your production DBs inside your SaaS applicationCreate a ChatGPT plug-in from your proprietary data Brian #2: Python's many command-line utilities Trey HunnerToo many to list, but here’s some fun ones json.tool - nicely format json datacalendar - print the calendar current by default, but you can pass in year and monthgzip, ftplib, tarfile, and other unixy things handy on WindowscProfile & pstats Michael #3: Distroless Python via Patrick SmythWhat is distroless anyway? These are container images without package managers or shells included.Debugging these images presents some wrinkles (can't just exec into a shell inside the image), but they're a lot more secure.Chainguard, creates low/no CVE distroless images based on our FOSS distroless OS, Wolfi.Some Python use-cases: docker run -it cgr.dev/chainguard/python:latest # The entrypoint is a Python REPL, since no b/a/sh is included docker run -it cgr.dev/chainguard/python:latest-dev # This is their dev version and has pip, bash, apk, etc. Brian #4: functools.cache, cachetools, and cachebox functools cache and lru_cache - built in cachetools - “This module provides various memoizing collections and decorators, including variants of the Python Standard Library's @lru_cache function decorator.”cachebox - “The fastest caching Python library written in Rust” Extras Brian: Python 3.12.4 is outVSCode has some pytest improvements Michael: Time for a bartender alternative, I’ve switched to Ice.Rocket.chat as an alternative to Slack Joke: CSS Cartoons
    Show more Show less
activate_primeday_promo_in_buybox_DT
Show more Show less

What listeners say about #387 Heralding in a new era of database queries

Average customer ratings

Reviews - Please select the tabs below to change the source of reviews.

Audible.com reviews

Amazon reviews
No Reviews are Available