从头构建SQL引擎

原文: PyCoder's Weekly - Issue #559

pycoder

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

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 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.

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.

(是也乎:

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

)

(是也乎:

等等 Plone 还活着?

)


探讨/吐糟

Discussions

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

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 时代训练下来的, 对友好的想象是相同的...

)

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.

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 →

(是也乎:

Snyk

)

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.

(是也乎:

Kivy )

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.

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 案例, 这说明...

)

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.

(是也乎:

毛同学?

)

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.

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

(是也乎:

小姐姐分享的...

)

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!

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

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


好物/妙品/...

Interesting Projects, Tools and Libraries, Projects & Code

(是也乎:

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

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

)

(是也乎:

Player

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

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

不过暂时还不兼容 ARM 芯片

)


📆🐍 活动/大会

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


DAMA

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


PS:

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)


Comments



自怼圈/年度番新

DU22.8
关于 ~ DebugUself with DAMA ;-)
点击注册~> 获得 100$ 体验券: DigitalOcean Referral Badge

订阅 substack 体验古早写作:


关注公众号, 持续获得相关各种嗯哼:
zoomquiet


蟒营®编程思维提高班Python版

**2021.01.11** 因大妈再次创业暂停定期开设, 转换为预约触发:
  • + 扫描预约入群, 学员每满 42 人即启动新一期训练营 ;-)
  • 101camp22.7
  • + 任何问题, 随时邮件提问可也:
    askdama@googlegroups.com
-->