We're sunsetting PodQuest on 2025-07-28. Thank you for your support!
Export Podcast Subscriptions
cover of episode #405 Oh Really?

#405 Oh Really?

2024/10/14
logo of podcast Python Bytes

Python Bytes

AI Deep Dive AI Chapters Transcript
People
B
Brian
Python 开发者和播客主持人,专注于测试和软件开发教育。
M
Michael
帮助医生和高收入专业人士管理财务的金融教育者和播客主持人。
Topics
Briefer是一个结合了数据探索型笔记本和仪表盘功能的工具,它使用Python、SQL和原生可视化技术,并具有代码生成、调度等功能,比传统BI工具更快速灵活。它允许用户连接数据库,编写Python和SQL查询,并将查询结果转换为数据框,用于创建可视化图表和仪表盘。Briefer还支持交互式数据应用程序,例如滑块和日期选择器,以及定期运行和更新的调度功能。此外,Briefer的开源特性使其更具灵活性和可扩展性,用户可以根据自身需求进行定制和修改。 Briefer是一个新兴的工具,它将数据探索和仪表盘功能结合在一个平台上,为用户提供了更便捷高效的数据分析体验。与传统的BI工具相比,Briefer更灵活,因为它使用了Python,这使得用户可以更轻松地进行数据处理和分析。与传统的笔记本相比,Briefer允许用户直接在笔记本中运行SQL查询,并将结果自动转换为数据框,方便用户进行后续的Python代码处理。Briefer还支持多种功能,例如代码生成、调度、交互式数据应用程序等,可以满足用户不同的数据分析需求。

Deep Dive

Chapters
This chapter explores Briefer, an open-source tool combining dashboards and notebooks. It leverages Python for flexibility and speed, offering features like SQL query integration, AI-powered code generation, and interactive data apps. Briefer's unique approach simplifies data exploration and dashboard creation.
  • Combines dashboards and notebooks in one place
  • Uses Python, SQL, and native visualizations
  • Allows interactive data apps with inputs and dropdowns
  • AI-powered code and query generation
  • Supports scheduling notebooks and dashboards

Shownotes Transcript

Topics covered in this episode:

- **[Briefer: Dashboards and notebooks in a single place](https://github.com/briefercloud/briefer?featured_on=pythonbytes))**

Watch on YouTube)

About the show

Sponsored by ScoutAPM: pythonbytes.fm/scout)

Connect with the hosts

Join us on YouTube at pythonbytes.fm/live) to be part of the audience. Usually Monday 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: Briefer: Dashboards and notebooks in a single place)

  • Notebooks and dashboards with Python, SQL, scheduling, native visualizations, code generation, and more.

  • In Briefer, you can:

  • booksbar chart Create notebooks and dashboards using Markdown, Python, SQL, and native visualizations.

  • selfie Build interactive data apps using inputs, dropdowns, and date pickers.

  • robot Generate code and queries using an AI that understands your database schema and your notebook's context.

  • mantelpiece clock Schedule notebooks and dashboards to run and update periodically.

  • gear Create and test ad-hoc pipelines using writebacks.

  • Briefer vs. Traditional BI Tools: Briefer is better than traditional BI tools because it's faster and more flexible, thanks to Python.

  • Briefer vs. Traditional Notebooks: In Briefer, you can run SQL queries against connected data sources directly in your notebook. Then, Briefer will automatically turn your query into a data frame and store it in a variable that you can use in your Python blocks.

Brian #2: Introduction to programming with Python)

  • Jose Blanca

  • “Python intro aimed at students with no prior programming experience.”

  • “Relies mainly on examples and exercises.”

  • “Does not try to cover every detail of the Python language, but just what a beginner might need to start the journey.”

  • Tech: “… built with the quarto) publishing system complemented by the quarto live) extension that allows Python to run in the web browser by using pyodide).”

  • Runs on anything, since it doesn’t require a local install of Python

  • Running 3.12.1, looks like. Although that’s a bit hidden. Seems like it should be more visible.

Michael #3: setup-uv)

  • Set up your GitHub Actions workflow with a specific version of uv

  • Install a version of uv and add it to PATH

  • Cache the installed version of uv to speed up consecutive runs on self-hosted runners

  • Register problem matchers for error output

  • (Optional) Persist the uv's cache in the GitHub Actions Cache

  • (Optional) Verify the checksum of the downloaded uv executable

Brian #4: HTML for people)

  • Teaching HTML in a rather fun way.

  • Includes basic CSS

Extras

Michael:

Joke: So much O’Really)