周刊

原文: 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 ...

原文: ElixirWeekly - Elixir Community Newsletter, one email every Thursday. Visual Programming with Elixir: Learning to Write Binary Parsers by @elixirstatus 这周不老药 This week in Elixir Function/Method 查找在 Elixir/Ruby Edison thought GenServer function injections were done through inheritance and discovered the inner workings of defoverridable! (是也乎: 这还用比较嘛? 海量 end 堆起来比括号要恶心多了… ) 使用Elixir进行可视化编程：学习编写二进制解析器 Kyle writes about what makes Elixir an unexpected front-runner for learning and prototyping binary protocols. Teamweek正在寻找远程Elixir后端开发人员 It’s a fully remote job and 100% Elixir even though the title says Ruby as well. According to Teamweek, it’s simply easier to find Ruby devs that want to learn Elixir ;-) (是也乎: 倾向找到在学 Elixir 的 Rubista .. ) More Readable Repos with the Ecto Filter Pattern Tyler writes about a great pattern for Ecto query composition he’s come across at work. 构建小型分布式 Elixir 应用程序 Keeping state consistency while running an Elixir application on many servers. (是也乎: 日常技巧… +——————–+ | APP SUPERVISOR | +———+———-+ | | +———v———-+ +———–+ +———–+ | WORKER SUPERVISOR +———> WORKERS | + <——–> DATABASE | +——————–+ +———–+ | | +———–+ +————+ | +————-+ ) TIL Ecto 约束 vs. 验证 ElixirSchool shows us how Ecto can put validations and constraints onto specific fields to ensure data integrity. 📆🐍 社区 Even more from around the Elixir community ...