从头构建SQL引擎

原文: PyCoder's Weekly - Issue #559

• 230111 Zoom.Quiet(大妈) 用时 13 分钟 完成快译
• 230111 Zoom.Quiet(大妈) 用时 37 分钟 完成格式转抄.

• 发现 bpython: 具有类似 IDE 功能的 Python REPL
  • REAL PYTHON

In this tutorial, you’ll learn about bpython, an alternative Python REPL that brings code suggestions and many other IDE-like features to the terminal. Once you discover how much bpython can improve your productivity, you’ll never want to return to using the vanilla Python REPL again.

(是也乎:

知道 bpython 也有小15年了... 没想到还在发展;

)

• Python 3.12 能用 perf 工程
  • PETER MCCONNELL

Python 3.12 can run in a special mode that allows Python functions to appear in the output of the Linux perf profiler. This article walks you through a dummy application and using the profiler to find the bad parts.

• 使用原生二进制文件打包
  • PYPACKAGING-NATIVE.GITHUB.IO

The pypackaging-native site is a collection of content about key Python packaging topics and issues for projects using native code, with a focus on scientific, data science, and ML/AI projects in the PyData ecosystem.

• Pillow 9.4.0 发布
  • PILLOW.READTHEDOCS.IO

(是也乎:

原名 PIL 现在是真的变成不可替代的核心常用模块了...

)

• Plone 6.0 发布
  • PLONE.ORG

(是也乎:

等等 Plone 还活着?

)

• Django Bugfix 发布: 4.1.5
  • DJANGO SOFTWARE FOUNDATION

探讨/吐糟

Discussions

• Debian 移除 Python 2
  • HACKER NEWS

The last remnants of Python 2.7 have been removed from the Debian builds. As with all discussions on the internet, this is both a celebration and a diatribe about how it was all done wrong. Enjoy!

(是也乎:

最保守的 Debian 都放弃了 Python 2 ...

)

文章/教程/嗯哼

Articles, Tutorials and Talks

• 我希望在更多语言中看到的微功能
  • HILLEL WAYNE

Some language features are intrinsic to the language, others are syntactic sugar that could easily be borrowed in other programming languages. This opinion piece from Hillel highlights some features from more obscure languages that should be stolen by the mainstream. Two Python features he’d like to see in more languages are chained evaluations (2 <= x < 10) and numbers with separators (1000000 == 1_000_000).

(是也乎:

开发语言也进入微创新时代了? 大家长的越来越像, 语糖也越来越类似, 都在追求开发体验... 可开发者都是从 C 时代训练下来的, 对友好的想象是相同的...

)

• 通过 Advent of Code 2022 学到了什么
  • DAN TURKEL

This opinion piece from Dan Turkel outlines the new things he learned as part of doing the Advent of Code at the end of 2022. Topics include revisiting some classic data structures, using the new match statements, the not so new walrus operator, and more.

• 如何使用 Doctest 在 Python 中编写测试
  • SNYK.IOS
  • PONSOR

Python’s doctest tool is useful to write tests for the code in the function by defining both the input and output values, saving time and effort while writing top quality code. Learn more about how to write tests using doctest using this step-by-step guide from Snyk →

(是也乎:

)

• 用 Kivy 构建跨平台 GUI 应用程序
  • REAL PYTHON COURSE

In this video course, you’ll learn how to build a cross-platform mobile application with Python and the Kivy GUI framework. You’ll discover how to develop an application that can run on your desktop as well as your phone. Then, you’ll package your app for Windows, Linux, and macOS.

(是也乎:

)

• Shapley 值的工作原理
  • AIDANCOOPER.CO.UK
  • • Shared by Aidan Cooper

Shapley values are machine learning explainability techniques that are easy to use and interpret. However, trying to make sense of their theory can be intimidating. This article explores how Shapley values work through code and simplified explanations.

• 用 Python 进行探索性空间数据分析
  • KYLE WALKER

Kyle Walker is the author of “Analyzing US Census Data: Methods, Maps, and Models, in R”. In this article he translates some of the book’s examples into Python.

(是也乎:

将自己写的R图书,转换为 Python 案例, 这说明...

)

• 从头开始编写 Python SQL 引擎
  • TOBY MAO

SQLGlot is a an SQL parser/translator written in Python. This accompanying article explains the motivation behind the work and highlights parts of the design.

(是也乎:

毛同学?

)

• 无限 AI 阵列
  • IANBICKING.ORG

Learn about an insane library containing special lists and dicts so that any missed calls automatically go to GPT3 and add a predictive value in its place.

• 30 个有用的 Python 片段
  • LARA BALDWIN

A collection of short Python snippets that can be helpful when you code. Includes uniqueness, anagrams, sizing info, chaining function calls, and more.

(是也乎:

小姐姐分享的...

)

• Find Your Next Tech Job Through Hired
  • HIRED
  • SPONSOR

Hired is home to thousands of companies, from startups to Fortune 500s, that are actively hiring the best engineers, designers, data scientists, and more. Create a profile to let hiring managers extend interview requests to you. Sign for free today!

• 将 Google 地图添加到 Jupyter Notebook
  • ALEXANDER TYLER

This article shows you how to integrate Google Maps into a Jupyter Notebook. Once embedded, you can programmatically manipulate the maps.

• 用递归 Python 生成器进行惰性求值
  • MARTIN HEINZ

Learn how to implement “lazy recursion” using recursive generators. Includes concrete examples where this technique is useful.

好物/妙品/...

Interesting Projects, Tools and Libraries, Projects & Code

• 基于 HTML/CSS 的跨平台 GUI 框架
  • GITHUB.COM/SCRIPTIOT
  • • Shared by dragondjf

(是也乎:

叕一个跨平台 GUI 框架, web 真的打通了一切...

EVUE 进化蜕变，下一代全平台UI开发利器 还是国产的...

)

• Loge Notebook: 交互式报告

  • LOGE.READTHEDOCS.IO
  • • Shared by Lukasz Laba

• Python 终端音乐播放器

  • GITHUB.COM/BMWANT
  • • Shared by Misha Behersky

(是也乎:

嗯哼?这可比俺之前用的 Moc 好安装的太多了...

pyaudio/_portaudio.cpython-39-darwin.so' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64'))

不过暂时还不兼容 ARM 芯片

)

• pyright: Python 的静态类型检查器

  • GITHUB.COM/MICROSOFT

• meltano: 用于 ELT+ 的 CLI

  • GITHUB.COM/MELTANO

📆🐍 活动/大会

Events, MeetUp 真的是全球线下活动组织中心

• Santa Cruz Python Meetup

  • January 11, 2023

• Heidelberg Python Meetup

  • January 11, 2023

• Weekly Real Python Office Hours Q&A (Virtual)

  • January 11, 2023

• Python Atlanta

  • January 12, 2023

• PyData Leeds Inaugural Event

  • January 24, 2023

DAMA

❤️ Happy Pythonic ;-(大妈私人无责任播报)

• Zoom.Quiet’s Chaos42 | Substack
  • 古早:新闻组式写作
  • 欢迎订阅

PS:

• 首发: Issue 559 ~蠎周刊 ~汇集全球蠎事儿 ;-)
• 修订: issue-559.md

Happy Pythoning!

Copyright © 2023 PyCoder’s Weekly, All rights reserved.

PPS:

不觉中蟒周刊快译已经到了第11个年头

开始有小伙伴加入承担 pythonisa 周刊的翻译, 从来没提醒过, 可就这么默默坚持下来了...

问为什么:

[皱眉]每周新闻资讯 怎么能错过 
看看有什么新东西 
当有新的发现时：
    what f**k 还能这样玩？ 还有这东西？
    每周开彩蛋[吃瓜]

无法同意更多... 很多社区贡献看起来辛苦, 其实受益最多的, 就是主动承担者也.

好文笔,感叹号年度配额: 0/3

投稿/反馈邮箱:

askdama@googlegroups.com

(邮件列表地址, 当成正常邮件发送邮件就好, 不用注册, 不用翻越...)

ZoomQuiet/大妈

就是四处 是也乎,(￣▽￣) 的那个大妈:

私自嗯哼: ZoomQuiet (订阅号: ZoomQuiet42)
公开课程: 蟒营 (订阅号: Mainium)
历史吐糟: Chaos42 (订阅号 PythoniCamp)

as 创始组织者:
    PyChina (订阅号: PyChinaOrg)
    本地社区: 
        GDG珠海 (订阅号: GDG-ZhuHai)
        TFUG珠海 (订阅号: ZH_TFUG)