ZH

原文: PyCoder’s Weekly - Issue #363 PEP 570 (仅位参数)已被接受 PYTHON.ORG This PEP introduces a new syntax, /, for specifying positional-only parameters in Python function definitions. Looks useful for getting tighter control over how a library API can be called (i.e. preventing positional params from being called as keyword arguments). This will also allow for some function call speed optimizations in the future. (是也乎: 严格参数传输,以便优化…反正就是越来越 C++ 呗… 老爹一退休就乱来. ) 惯用式 Pandas: 你可能不知道的技巧和特征 REAL PYTHON video In this series you’ll see how to use some lesser-used but idiomatic Pandas capabilities that lend your code better readability, versatility, and speed. (是也乎: 忘记的就是不重要的 不知道的就是不必要 当然世界并不是这样 (￣▽￣) ) 用 PyCharm 成为 Python 大狮 JETBRAINS sponsor PyCharm is the Python IDE for Professional Developers by JetBrains providing a complete set of tools for productive Python, Web and scientific development. Be more productive and save time while PyCharm takes care of the routine. (是也乎: 通过 IDE 变成 guru ? 喝多了… ) 本地 LRU 缓存 MOSHE ZADKA How to avoid shared global state when using the functools.lru_cache decorator from the standard library. Python 3.7 使用慢加载 INADA NAOKI CPython 3.7 has a new feature (-X importtime) for profiling import time and this article gives you a good overview on how to use this to reduce application startup time. AvantPy: 友好的追溯 ANDRÉ ROBERGE AvantPy provides friendlier Python tracebacks, translated into various languages, to help beginners learn programming. Right now the project is still in its early stages and the maintainer is looking for contributors. (是也乎: 早期…寻求志愿者… 只是, 这种追踪代码运行状态, 对于初学有什么帮助? ) 讨论 Discussions ...

原文: Postgres Weekly Issue 299: April 3, 2019 Postgres 获得 ‘Generated Column’ 支持 Peter Eisentraut It’s always great to see Postgres gaining support for an SQL-standard feature and this commit begins with a simple example of how one type of generated column will work in the future. MySQL 5.7 introduced a similar feature and SQL Server calls them computed columns. 用 pg_dump / pg_restore 进行 Postgres 升级 Jobin Augustine, Vallarapu, et al. Last time they looked at using pg_dumpall, now it’s pg_dump and pg_restore’s turn under the spotlight. 在 PostgreSQL 数据库中监控的度量标准 InfluxData sponsor There are several key metrics you’ll want to keep track of when it comes to database performance, and they’re not all database-specific. (是也乎: 这种很搭的赞助商才对味儿 ) 2019 年 PostgreSQL 趋势报告 ScaleGrid A multi-cloud DBaaS provider surveyed users at last month’s PostgresConf and shares the results here. AWS comes in as the most popular cloud platform to host Postgres on and cost is the biggest reason to choose Postgres. 就等 PostgreSQL 12: REINDEX CONCURRENTLY Hubert depesz Lubaczewski In Postgres 12, the REINDEX command (which rebuilds an index from a table’s current data) gains an option to have it build the index in the background and switch it into play upon completion. 用 TimescaleDB 为 PostgreSQL 的 Azure 数据库就物联网和时间序列工作负载提供动力 Sunil Kamath (Microsoft) A new partnership with Timescale that introduces support for TimescaleDB (a Postgres extension that focuses on time-series support) on Azure for customers building IoT and time-series workloads. 如何将大规模并行 Postgres 数据库迁移进 Kubernetes Oz Basarir (Pivotal) Pgpool-II 4.1 中的语句级负载平衡 PgPool Migra: Like diff But For Postgres Schemas Robert Lechte Written in Python and can be used from your own Python scripts or the command line. (是也乎: 哈, Python 喜欢干的事儿… ) ActiveRecordExtended 1.0: Adds Additional Postgres Functionality to Ruby’s Active Record George Protacio-Karaszi Active Record, as commonly used in Ruby on Rails apps to interact with databases, is naturally database agnostic but Postgres has so many extra querying features it’s a shame not to be able to use them. This gem adds things like array and JSON querying, CTEs, and unions to the mix. repmgr 4.3 发布 2ndQuadrant A popular tool for replication and failover management that includes several usability improvements in this release. 社区/活动 🗓 Upcoming Postgres Events ...

原文: PyCoder’s Weekly - Issue #362 如何在 Python 编码面试中脱颖而出 REAL PYTHON Take your Python coding interview skills to the next level and use Python’s built-in functions and modules to solve problems faster and more easily. (是也乎: 面经在国外也是显学哪… ) 看看 Python, 参数化 LUKE PLANT • Shared by Luke Plant Detailed article that explores the application of parameterization in Python and how it relates to mainstream design patterns such as dependency injection, strategy, template method, and others. Django 教程:建立自己项目组合网站 REAL PYTHON In this step-by-step tutorial, you’ll learn the basics of creating powerful web applications with Django, a Python web framework. You’ll build a portfolio application to showcase your web development projects, complete with a fully functioning blog. Django 2.2 LTS 发布 DJANGOPROJECT.COM What’s new? HttpRequest.headers to easily access request headers, database-level constraints on models, improved runserver performance when watching large project folders. Also, this is a long-term support (LTS) release, which means that security and data loss fixes will be applied for at least the next three years. (是也乎: LTS <== Ubuntu 制造出来的品牌… ) 有关过度使用 Comprehensions 以及 Generator Expressions TREY HUNNER • Shared by Ricky White Comprehensions are lovely, but they can easily be overused. In this article Trey shows you helpful examples and tips on sensible comprehension use in your own code. (是也乎: 代码简洁可读, 永远是代码第一原则. ) 六种简便方法在云中运行 Jupyter 笔记本 KEVIN MARKHAM A comparison of free services for running an interactive Jupyter Notebook in the cloud: Binder, Kaggle Kernels, Google Colab, Azure Notebooks, CoCalc, Datalore. (是也乎: Binder, Kaggle, Google, Microsoft, CoCalc, and Datalore… 简单的说, 简单但述求不同, 对于墙内的, 抱 M$ 的粗腿吧… ) ...

原文: ElixirWeekly - Elixir Community Newsletter, one email every Thursday. Every Thursday: No frills, no click-through, no spam. 当周 不老药 This week in Elixir Phoenix LiveView 蚂蚁农场 .. Holy cow! Ricardo created this small experiment consisting of a bunch of old school ants running around (using Phoenix LiveView). 5 个原因 Elixir 可成就您的竞争优势 … Inspired by a recent discussion about the topic, Elvio wrote a blog post with some of the reasons that might make Elixir your competitive advantage. (是也乎: 不老, 万能, 炼金, OTP, FP ) benchee 1.0 终于来了 … Congrats to Tobias, Devon and everbody who helped to make 1.0 happen! 🎉 (是也乎: 压力测试工具… ) 如何使用 OTP 进行多源数据废弃和聚合 .. Just like in the documentary series “Big, Bigger, Biggest” we are going to show the different versions we developed on a real project, alongside the pitfalls and breakthroughs of each version. Event Sourcing in Practice Screencast … In this Event sourcing in practice screencast Ben demonstrates how you can apply event sourcing to an Elixir application. 编写 Elixir 微服务的经验 … Jean-Phillipe just published our blog post about writing Elixir microservices in their polyglot environment. (是也乎: 不同其它语言纷纷回到巨型应用守护, Elixir 基于 OTP -> 天然万能巨型守护, 微服务可能是 Elixir 开发原有体验的最先进描述. ) Elixir Streams 和大型 HTTP 响应: 处理文本 … This is a second part of the article of last week. This time we are going to process on the fly a 30 million lines remote file, summing the numbers of each line. (是也乎: 简单说, 就是切切切切切切切…切到合适的嗯哼 ) 📆🐍 社区 Even more from around the Elixir community ...