新闻|2021 FOSDEM为期两天的活动成功举办,一大波学习资源来袭!

原创
2021/02/18 11:27
阅读数 101

作者:魏波、类延良

 

作者简介

魏波:中国PG分会培训认证执行总监、资深数据库工程师,十多年的数据库运维管理及培训经验,掌握PostgreSQL架构部署、性能优化等,致力于推动PostgreSQL在中国的发展。

 

类延良:类延良,任职于瀚高基础软件股份有限公司,PostgreSQL数据库技术爱好者,10g &11g OCM,OGG认证专家

 

关于FOSDEM

FOSDEM是由志愿者组织的为期两天的活动,旨在促进自由和开源软件的广泛使用。

FOSDEM通常在美丽的布鲁塞尔(比利时)城市举行,FOSDEM被公认为是欧洲最好的会议。

 

什么是FOSDEM? 

FOSDEM是由社区为社区组织的免费和非商业性活动。目标是为自由和开源软件开发人员和社区提供一个满足以下条件的场所:

  • 与其他开发人员和项目保持联系;
  • 被告知自由软件世界的最新发展;
  • 了解开源世界的最新动态;
  • 参加项目负责人和提交人关于各种主题的有趣的演讲和演示;
  • 促进免费软件和开源解决方案的发展并从中受益。

参与和出席完全免费的,组织者非常感谢捐赠和赞助。

 

开发室

FOSDEM团队认为,对于全球的自由和开源软件开发人员来说,能够在“现实生活中”见面非常重要。

为此,我们建立了具有网络/互联网连接的开发室(开发室)和投影仪,团队可以在此开会并展示他们的项目。开发室是团队讨论,破解和公开展示最新方向,闪电演讲,新闻和讨论的地方。我们相信开发人员可以从这些会议中受益匪浅。

为此,我们设立了带有网络/互联网连接和投影仪的开发者房间(devrooms),团队可以在那里会面并展示他们的项目。Devrooms是团队讨论、破解和公开展示最新方向、闪电对话、新闻和讨论的地方。我们相信开发人员可以从这些会议中获益良多。

 

一点历史

在2000年,比利时Linux运动的狂热者Raphael Bauduin决定为开源软件的开发者组织一次小型会议。他称其为“开源开发者欧洲会议”(OSDEM)。

拉斐尔(Raphael)创建了一个邮件列表,一个小型网站,并将其传播给了周围的人。仅仅几个星期后,很多人都在等待布鲁塞尔的精彩活动!邀请函发给了社区中的知名人物:Rasterman,Fyodor,Jeremy Allison等。他们都给予了非常积极的回应,OSDEM正走向成功。

第二年,OSDEM更名为FOSDEM。而现在,多年以后,它已经发展成为今天的规模。现在,我们尝试涵盖广泛的免费和开源软件项目,并为人们提供协作平台。每年,我们在ULB Solbosch校园接待超过5000名开发人员。

拉斐尔不再是FOSDEM背后动力。经过7年的努力,他离开了团队,制定了新的开源计划。现在,下面的人自豪地担任FOSDEM旗手:

 

团队

按字母顺序

Linda Calders

Quint Daenen

Gerry Demaret

Julien Detroz

Pieter De Praetere

Michael De Swert

Philippe De Swert

Egbert De Vries

Geert Goossens

Jan Gyselinck

Richard Hartmann

Alasdair Kergon

Vasil Kolev

Jan-Frederik Martens

Marthe Parada Delgado

Thomas Perale

Stella Rouzi

Sebastian Schauenburg

Jonas Scheers

Kristian Schuhmacher

Johan van Selst

Wouter Simons

Ieva Supjeva

Miguel Terol Espino

Emanuil Tolev

Johan Van de Wauw

Mark Van den Borre

Peter Van Eynde

Wouter Verhelst

Koen Vervloesem

 

学习资源

原文链接:https://fosdem.org/2021/schedule/track/postgresql/
主题课件链接整理,有需要的小伙伴快快去下载学习吧!

 

演讲主题:PostgreSQL Waffles

演讲者姓名:Lætitia Avrot

演讲资料链接:无

 

演讲主题:Foreign data wrapper study for schemaless databases

演讲者姓名:Hiroki Kumagai

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgresql_foreign_data_wrapper_study_for_schemaless_databases/attachments/slides/4411/export/events/attachments/postgresql_foreign_data_wrapper_study_for_schemaless_databases/slides/4411/fosdem2021_kumagai

 

演讲主题:Database schema management for lazybones: from chaos to heaven

演讲者姓名:Julien Riou

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgresql_database_schema_management_for_lazybones_from_chaos_to_heaven/attachments/slides/4317/export/events/attachments/postgresql_database_schema_management_for_lazybones_from_chaos_to_heaven/slides/4317/fosdem21.pdf

 

演讲主题:Caveats of replication in PostgreSQL HA clusters and CDC systems

演讲者姓名:Andrey Borodin Evgeny Dyukov

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgresql_caveats_of_replication/attachments/slides/4365/export/events/attachments/postgresql_caveats_of_replication/slides/4365/sides.pdf

 

演讲主题:The story about a challenging

演讲者姓名:Alicja Kucharczyk

演讲资料链接:https://speakerdeck.com/awdotiaromanowna/the-story-about-the-migration

 

演讲主题:PoC that proved that Postgres can achieve the same performance as Oracle Exadata

演讲者姓名:Sushant Pandey

演讲资料链接:无

 

演讲主题:A PostgreSQL development environment

演讲者姓名:Peter Eisentraut

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgres_development_environment/attachments/slides/4528/export/events/attachments/postgres_development_environment/slides/4528/A_PostgreSQL_development_environment.pdf

 

演讲主题:Adaptive Query Optimization in PostgreSQL: approaches and challenges

演讲者姓名:Oleg Ivanov Yerzhaisang Taskali

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgres_query_optimization/attachments/slides/4600/export/events/attachments/postgres_query_optimization/slides/4600/AQO_NN_slides.pdf

 

演讲主题:Performance improvements and new use scenarios for SPGiST access method

演讲者姓名:Pavel Borisov

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgresql_speed_improvements_and_new_use_scenarios_for_spgist_access_method/attachments/audio/4456/export/events/attachments/postgresql_speed_improvements_and_new_use_scenarios_for_spgist_access_method/audio/4456/spgist_fosdem2021.pdf

 

演讲主题:Postgres and the Artificial Intelligence Landscape

演讲者姓名:Bruce Momjian

演讲资料链接:https://momjian.us/main/writings/pgsql/AI.pdf

 

演讲主题:Database Performance at GitLab.com

演讲者姓名:Nikolay Samokhvalov Jose Finotto

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgresql_database_performance_at_gitlab_com/attachments/slides/4363/export/events/attachments/postgresql_database_performance_at_gitlab_com/slides/4363/Postgresql_at_Gitlab_com_FOSDEM2021.pdf

 

演讲主题:Some SQL Tricks of an Application DBA Non-trivial tips for database development

演讲者姓名:Haki Benita

演讲资料链接:https://hakibenita.com/sql-tricks-application-dba

 

演讲主题:Speed up the JSONB What we can do to improve performance

演讲者姓名:Oleg Bartunov Nikita Glukhov

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgresql_speed_up_the_jsonb/attachments/slides/4455/export/events/attachments/postgresql_speed_up_the_jsonb/slides/4455/jsonb_fosdem_2021.pdf

 

演讲主题:I use ENUM - Vindicating the Underdog of Data Types

演讲者姓名:Boriss Mejias

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgresql_i_use_enum_vindicating_the_underdog_of_data_types/attachments/slides/4755/export/events/attachments/postgresql_i_use_enum_vindicating_the_underdog_of_data_types/slides/4755/bmejias_ENUM_fosdem_2021.pdf

 

演讲主题:Getting on a hook or PostgreSQL extensibility

演讲者姓名:Alexey Kondratov

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgresql_extensibility/attachments/slides/4348/export/events/attachments/postgresql_extensibility/slides/4348/fosdem21_postgres_extensibility.pdf

 

演讲主题:Postgres Architectures in Production

演讲者姓名:Dimitri Fontaine

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgresql_postgres_architectures_in_production/attachments/slides/4301/export/events/attachments/postgresql_postgres_architectures_in_production/slides/4301/Postgres_Architectures_in_Production_FOSDEM_2021

 

演讲主题:PostgreSQL logical decoding

演讲者姓名:Amit Khandekar

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgresql_logical_decoding/attachments/slides/4674/export/events/attachments/postgresql_logical_decoding/slides/4674/LogicalDecodingFosdem2021.pdf

 

演讲主题:PostgreSQL and The SQL Standard

演讲者姓名:Simon Riggs

演讲资料链接:无

 

演讲主题:Improve your indexes

演讲者姓名:Tomasz Gintowt

演讲资料链接:无

 

演讲主题:PostgreSQL partitioning. Work In Progress

演讲者姓名:Anastasia Lubennikova

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgresql_postgresql_partitioning_work_in_progress/attachments/slides/4347/export/events/attachments/postgresql_postgresql_partitioning_work_in_progress/slides/4347/FOSDEM_2021_Partitioning.pdf

 

演讲主题:Changing your huge table's data types in production

演讲者姓名:Jimmy Angelakos

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgresql_changing_your_huge_tables_data_types_in_production/attachments/slides/4718/export/events/attachments/postgresql_changing_your_huge_tables_data_types_in_production/slides/4718/changing_data_types_in_prod.pdf

 

演讲主题:Stumbling Stones when migrating from Oracle The problems you can encounter and how to solve them

演讲者姓名:Laurenz Albe

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgres_migrating_from_oracle/attachments/slides/4235/export/events/attachments/postgres_migrating_from_oracle/slides/4235/oracle_stumbling_stones.pdf

 

演讲主题:Pg_stat_monitor - The new way to analyze query performance in PostgreSQL

演讲者姓名:Ibrar Ahmed, Peter Zaitsev

演讲资料链接:无

 

演讲主题:Database Disasters and How to Find Them

演讲者姓名:Christophe Pettus

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgresql_database_disasters_and_how_to_find_them/attachments/slides/4742/export/events/attachments/postgresql_database_disasters_and_how_to_find_them/slides/4742/db_disasters_fosdem.pdf

 

演讲主题:The story of the first PGDay How we started with the idea of having a barbecue and we ended in organising the first PostgreSQL conference in Europe

演讲者姓名:Federico Campoli

演讲资料链接:

https://fosdem.org/2021/schedule/event/postgresql_the_story_of_the_first_pgday/attachments/slides/4279/export/events/attachments/postgresql_the_story_of_the_first_pgday/slides/4279/pgday_story_handout.pdf

 

百度网盘下载全部链接链接地址:https://pan.baidu.com/s/1KUTKk82-qgq5KZQpwIbE-A

提取码:2ykr

 

了解更多PostgreSQL技术干货、热点文集、行业动态、新闻资讯、精彩活动,请访问中国PostgreSQL官方网站:www.postgresqlchina.com

展开阅读全文
加载中
点击引领话题📣 发布并加入讨论🔥
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部