uk: Комп'ютерні науки

description: I'll walk you through all the problems and difficulties that can occur when you migrate an Oracle database to PostgreSQL, from the conceptual phase and general architectural differences to the specific problems that you are likely to encounter. I'll suggest solutions or promising ways to tackle these problems and give you a brief overview over some of the existing tools that facilitate Oracle migration.

uk: вхід без авторизації

name: Stumbling Stones when migrating from Oracle: The problems you can encounter and how to solve them


Oleg Ivanov

type: Person

cs: Informatika

de: Informatik

fi: tietojenkäsittelytiede

uk: Комп'ютерні науки

en: Computer Science

fr: Informatique

da: Datalogi

es: Ciencias de la Computación

nl: Informatica

cs: Technické vědy

de: Ingenieurwissenschaften

fi: tekniikka

uk: Інженерія

en: Engineering Sciences

fr: Ingénierie

da: Ingeniørvidenskab

es: Ingeniería

nl: Engineering

description: Query optimizer is one of the key components which determines DBMS performance under OLAP workload. Nevertheless, it was shown that query optimizer often fails to find a good execution plan because of incorrect cardinality estimations. The perspective approach to improve cardinality estimation quality is adaptive query optimization. In contrast with classical approaches, which rely on the precomputed histograms, it utilizes the execution statistics of the previously executed queries to refine cardinality estimations. However, the original AQO uses a modification of kNN machine learning method, which implies a number of limitations on the AQO applicability. In the current lecture we will make an introduction to the kNN-based AQO. Afterwards, we will present you our novel neural network-based AQO which can potentially overcome the limitations of the kNN-based AQO, and will demonstrate the first experimental results.

TIB AV-Portal

type: Service

type: WebContent

type: MediaObject

@language: en

cs: přihlášení není vyžadováno

de: keine Anmeldung erforderlich

uk: вхід без авторизації

en: no login required

nl: geen login vereist

name: Adaptive Query Optimization: Approaches and Challenges

FOSDEM VZW

type: Organization

cs: Video

de: Video

fi: Video

uk: Відео

en: Video

fr: Vidéo

da: Video

nl: Video

es: Video


PostgreSQL and The SQL Standard

uk: Комп'ютерні науки

description: PostgreSQL follows the SQL Standard. What's that mean? Why do we care? Covers the history of the SQL Standard, the complex and interesting bits and how it is implemented in PostgreSQL, plus current in-progress patches and details for PG14.

uk: вхід без авторизації


uk: Комп'ютерні науки

description: Synchronous or quorum replication is the basis of the modern HA cluster. At Yandex.Cloud we are using replication-based HA PostgreSQL clusters for many years. In this talk, we want to introduce basic concepts and highlight caveats that seem important to us.

uk: вхід без авторизації

name: Caveats of replication: in PostgreSQL HA clusters and CDC systems


uk: Комп'ютерні науки

description: You have a huge table, and it is necessary to change a column's data type, but your database has to keep running with no downtime. What do you do? Here's one way to perform this change, in as unobtrusive a manner as possible while your table keeps serving users, by avoiding long DDL table locks and leveraging procedural transaction control.

uk: вхід без авторизації

name: Changing your huge table's data types in production


Database Disasters and How to Find Them

uk: Комп'ютерні науки

description: You get the call at three in the morning: "The application is throwing 500 errors. We think the database is down." What do you do? Database problems can come in a nearly-infinite range of types. We don't have infinite time, but we can talk about the most common ones, and go through a step-by-step process in how to diagnose them, repair them, and bring the system back up in record time. A careful and methodical approach is essential to not making a bad situation worse, and getting the database back on all four feet quickly. We'll cover different kinds of service unavailability, data corruption, underlying host failures, and how to react to different scenarios. Use this advice to help build your run-book of how to react to those early-morning texts.

uk: вхід без авторизації


Database Performance at GitLab.com

uk: Комп'ютерні науки

description: GitLab has an aggressive SLA, that made us research and develop solutions to improve our performance in all directions, on one of the most important components in our architecture, the PostgreSQL relational database. During this talk, we would like to invite you to explore the details about how we improve the performance of the main PostgreSQL relational database of GitLab.com in a high demanding environment with a load between 40k to 60k transactions per sec. We would share with you our projects, processes, and tools, and all tools being developed by our partner Postgres, including the main one, Database Lab.

uk: вхід без авторизації


uk: Комп'ютерні науки

description: Performing schema changes on a live system is challenging because it often involves high level of locks leading to downtime. It becomes harder and harder when the number of databases to manage raise continuously. At OVHcloud, a major cloud computing provider in Europe, we used to manage such changes approximately. With our startup mindset, we used to yell "Who can ALTER my database?" and hope for someone sitting next to you to answer. Database engineers were used to copy paste bunch of SQL statements on production databases directly. What happens if a bad character is inserted? What if there is no transaction in the script? What if you run the migration on the wrong database? It works, sometimes. Lots of tasks are boring. This one was on top of our list. In this talk, you will discover our feedback on how we have reduced efforts, time and human errors by automating databases schema migrations using git, code reviews, CI/CD, migration tools, service discovery and automation systems at the OVHcloud scale.

uk: вхід без авторизації

name: Database schema management for lazybones: from chaos to heaven


uk: Комп'ютерні науки

description: PostgreSQL is well-known for its extensibility. One can create their own types, operators, access methods, etc. or use powerful PL/pgSQL language to write functions, extensions, and so on and so on. Everything is thoroughly documented, supported and ready to use. However, there is also a very intimate extensibility layer, which allows external developers to peek right into the PostgreSQL core — hooks. For some reason this topic is not covered enough by official documentation. First, this talk will focus on which core hooks do exist, which options they provide for potential developers, and which PostgreSQL extensions get use of them to achieve an additional out-of-core functionality.

uk: вхід без авторизації

name: Getting on a hook or PostgreSQL extensibility


uk: Комп'ютерні науки

description: In order to connect to external databases, PostgreSQL supports Foreign Data Wrappers (FDW), and there are already many FDWs. However, among of FDWs have various restrictions preventing utilization of external databases features. As such a restriction, FDWs for schemaless databases need to change the foreign table definition, when some columns are added in remote database. This restriction can not take full advantage of the schemaless feature. In this time, we considered implementing FDW that does not require changing the external table when columns are added on external database. I would like to introduce this study based on the time-series database InfluxDB as schemaless database.

uk: вхід без авторизації

name: Foreign data wrapper study for schemaless databases


uk: Комп'ютерні науки

description: The ENUM data type is extremely good to define constraints to column values. It adds descriptiveness to your database schema. In this talk you'll learn the advantages and disadvantages of the ENUM data type, and how to use it in your database schema design. The enumerated data type, ENUM, is rarely considered in the design of database schemas. This is either because ENUM is unknown, or because one or two drawbacks have created a wrong impression of it, hiding is major advantages. I use ENUM, because I consider it extremely good to define constraints to column values, providing a very descriptive design to match the business logic. This presentation attempts to vindicate the value of ENUM, the underdog of the data types. On this talk you'll learn: - Advantages and disadvantages of the ENUM types - How to use ENUM in your database schema design - Using ordering of ENUM values - Casting ENUM data types - Manipulating ENUM data types

uk: вхід без авторизації

name: I use ENUM - Vindicating the Underdog of Data Types


Improve your indexes

uk: Комп'ютерні науки

description: In this talk, I would like to share the successful experience how to improve index search performance. All of us uses indexes, it's one of the first features that we learns starting our journey with databases. Index on the right column can significantly improve query. Can we do anything more than just run CREATE INDEX ? This talk will explain how in easy way we can improve exists indexes, we will look into pg_stat and EXPLAIN output.

uk: вхід без авторизації


PostgreSQL logical decoding

uk: Комп'ютерні науки

description: PostgreSQL built-in replication is known to many. But the term PostgreSQL logical decoding or logical replication makes many curious to know what it is. This talk will make the audience aware of the concept and why is it needed, and compare it with physical replication.

uk: вхід без авторизації


uk: Комп'ютерні науки

description: If you're tasked with optimizing PostgreSQL performance, chances are you're relying on pgstatstatements extension to capture information about query performance. While this extension provides a lot of great insights, PostgreSQL allows to go even further! In this presentation we introduce pgstatmonitor - Open Source extension, based on pgstatstatements which provides such advanced query performance details. We talk about additional design goals we had and why those are important, additional information we capture and how you can use it to get your PostgreSQL running even faster.

uk: вхід без авторизації

name: Pg_stat_monitor - The new way to analyze query performance in PostgreSQL


uk: Комп'ютерні науки

description: Artificial intelligence, machine learning, and deep learning are intertwined capabilities that attempt to solve problems that defy traditional computational solutions — problems include fraud detection, voice recognition, and search result recommendations. While they defy simple computation, they are computationally expensive, involving computation of perhaps millions of probabilities and weights. While these computations can be done outside of the database, there are specific advantages of doing machine learning inside the database, close to where the data is stored. This presentation explains how to do machine learning inside the Postgres database.

uk: вхід без авторизації

name: Postgres and the Artificial Intelligence Landscape


PostgreSQL Architectures in Production

uk: Комп'ютерні науки

description: When using PostgreSQL in production it is important to implement a strategy for High Availability. With a database service, the HA properties apply to both the service itself and of course to the data set. In this talk we learn how to think about specific HA needs of your production environment and how to achieve your requirements with Open Source tooling when it comes to your database of choice, PostgreSQL. In particular, we dive in many options that could be implemented for Postgres to evolve its offering from being a toolset to being “batteries included”. What does it mean in the context of HA? How to achieve it?

uk: вхід без авторизації


uk: Комп'ютерні науки

description: Native partitioning was introduced in PostgreSQL 10, and every new release comes with more features and optimizations to this area. Yet, there is still room for improvement. This talk briefly compares the built-in PostgreSQL partitioning with third-party extensions (pgpathman and pgpartman), to understand what we still don't have in the core. This talk also includes an overview of partitioning-related features that are currently being developed and aimed for PostgreSQL 14.

uk: вхід без авторизації

name: PostgreSQL partitioning. Work In Progress.


uk: Комп'ютерні науки

description: Databases are the backbone of most modern systems, and taking some time to understand how they work is a good investment for any developer! In this article I share some non-trivial tips about database development! Rules of thumb has been passed on from DBA to DBA for many years. Some of these rules may seem weird while others makes perfect sense. In this talk I present some of the "rules" I accumulated over the years, such as why you should always load sorted data into tables, how to make indexes invisible, and why you should always schedule long running processes in odd hours...

uk: вхід без авторизації

name: Some SQL Tricks of an Application DBA: Non-trivial tips for database development


uk: Комп'ютерні науки

description: In the PostgreSQL core, we have the SPGiST index, which is more lightweight and significantly faster than GiST for the supported data types. In many cases, it is the most suitable option for geometric data like points, boxes, etc. An easy way to increase the selection speed is to eliminate the need for the results recheck by a table. But with the index being single-column by design we could not enjoy index-only scans for multicolumn queries. The talk covers my improvement of the SPGiST access method. Non-key columns can now be included in a single key-column index in a way, similar to that have in GiST and B-tree. This adds the ability to make fast index-only scans for multicolumn queries. Also, non-key columns with data types without SPGiST opclass can be added, which creates an opportunity for the new use cases. In my presentation, I will justify the modification, discuss new use cases of GiST and SPGiST indexes, and share some performance benchmarks.

uk: вхід без авторизації

name: Performance improvements and new use scenarios for SPGiST access method


uk: Комп'ютерні науки

description: Jsonb is popular data type in postgres and there is demand from users to improve its performance. In particular, we want to optimise a typical pattern of using jsonb as a storage for relatively short metadata and big blobs, which is currently highly inefficient. We will discuss several approaches to improve jsonb and present results of experiments.

uk: вхід без авторизації

name: Speed up the JSONB.: What we can do to improve performance.


uk: Комп'ютерні науки

description: In this talk we want to present how Microsoft team composed of people from two different teams approached the project and solved the migration issues using ora2pg and was able to prove that Postgres Single Server can perform equally well as Oracle Exadata. We will present our ways of working and also some main technical challenges that we faced including migration of BULK COLLECT’s, hierarchical queries, refcursors and others more complicated Oracle constructs. The story about a challenging PoC that proved that Postgres can achieve the same performance as Oracle Exadata. The schema that was migrated wasn’t the simplest one you might see. It was quite the opposite. The code was loaded with dynamic queries, BULK COLLECT’s, nested loops, CONNECT BY statements, global variables and lot of dependencies. Ora2pg did a great job converting the schema but left a lot of work to do manually. Also estimates produced by the tool were highly inaccurate since the logic required not the migration but total re-architecture of the code. In this talk we want to present how Microsoft team composed of people from two different teams approached the project and solved the migration issues using ora2pg and was able to prove that Postgres Single Server can perform equally well as Oracle Exadata. We will present our ways of working and also some main technical challenges that we faced including: • How estimates do (not) work • How we handled BULK COLLECT’s • Why we got rid of refcursors • How we got stuck with testing of one the packages and how the help from a friend solved the problem • How we handled hierarchical queries and drilling down the hierarchy.

uk: вхід без авторизації

name: The Story About The Migration: The story about a challenging PoC that proved that Postgres can achieve the same performance as Oracle Exadata


uk: Комп'ютерні науки

description: The talk tells the untold story of how we started with the idea of having a barbecue and we ended in organising the first PostgreSQL conference in Europe. Nowadays there is a PGDay or a PostgreSQL conference almost every month all around the world. But back in 2007 there were only two or three conferences in the Americas and in Japan. The talk will tell the story of the PGDay 2007, how it started and how the initial idea of having a conference between friends to advocate PostgreSQL evolved into the first PostgreSQL in Europe. Federico Campoli, who had the original Idea and was actively involved in organising the conference will walk the audience through the adventure of organising the PGDay 2007 from scratch and how this sparked the birth of PostgreSQL Europe.

uk: вхід без авторизації

name: 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


PostgreSQL Waffles

uk: Комп'ютерні науки

description: FOSDEM would not be FOSDEM without waffles... What if we coud use Postgres to make waffles ? During this talk we will use the excuse of FOSDEM and Brussels to create an extension that will look for the best waffle recipe and use Postgres to display it. During this journey, on top of making delicious waffles, we will : - understand what an extension is - find the steps needed to create an extension - make this work all together - install our extension - display the best Waffle recipe.

uk: вхід без авторизації


uk: Комп'ютерні науки

description: The LibreSOC Project is a hybrid 3D CPU, GPU and VPU, designed for use in mass-volume products such as smartphones netbooks tablets and Industrial SBC IoT. As such, user trust and reduced product development costs are both equally important. Both these goal are achieved by providing full source right to the bedrock (Hardware HDL, bootloader, drivers, everything) and deploying strict transparent "Libre" development criteria. The project has EUR 350,000 funding from NLnet under their PET Programme and is actively seeking developers. Analysis of SoCs (system-on-a-chip) used for embedded, mobile and IoT shows a decade-long disturbing persistent trend that is almost 100% without exception across hundreds of integrated processors: not a single recent SoC with modern performance in the past 10 years can be used 100% effectively without at least one closed source driver. The choices for developers and end-users alike is very stark: go without the GPU, or without the VPU, or without some key critical functionality that would penalise performance or business effectiveness entirely, or compromise on integrity and end-user trust, and reduce product reliability by delivering closed source binary-only drivers. Even the highly-regarded Freescale/NXP iMX.6 which uses Etnaviv for the GPU, and has a 19-year Long-Term Supply committment, is still burdened by closed source 3rd party binary-only drivers for the VPU. Huge multi-man-year efforts consuming precious FOSS engineer resources that could be productively deployed elsewhere are wasted on reverse-engineering these closed SoCs.

uk: вхід без авторизації

name: The Libre-SOC Hybrid 3D CPU: Augmenting the OpenPOWER ISAto provide 3D and Video instructions(properly and officially) and make a GPU


Microwatt grows up

uk: Комп'ютерні науки

description: Microwatt is an open-source POWER CPU implementation which can run on cheap FPGAs, bringing new level of accessibility to POWER. In the last year, we have added to Microwatt features such as a memory management unit, privilege modes, interrupts, a floating-point unit, an interrupt controller and a level-2 cache, so that now it can boot Linux. This presentation will outline these new additions to Microwatt and talk about some interesting applications for Microwatt. Microwatt is an open-source POWER CPU implementation which can run on cheap FPGAs, bringing new level of accessibility to POWER. In the last year, we have added to Microwatt features such as a memory management unit, privilege modes, interrupts, a floating-point unit, an interrupt controller and a level-2 cache, so that now it can boot Linux. This presentation will outline these new additions to Microwatt and talk about some interesting applications for Microwatt.

uk: вхід без авторизації


uk: Комп'ютерні науки

description: Open-CE the community driven software distribution of machine learning tools that is built on standard Linux platforms across different architectures. Open-CE provides a quick easy pathway to using NVIDIA GPU technologies with tools like Tensorflow, Pytorch, XGBoost, and other related packages and dependencies.These tools are built using the standard conda environment to ensure easy access and deployment. The Open Source Lab (OSUOSL) and Center for Genome Research and Biocomputing (CGRB) partner with IBM and OpenPOWER in order to provide a download resources around Open-CE supporting both x86 and PPC64LE machines.

uk: вхід без авторизації


OpenPOWER Foundation Community Intro

uk: Комп'ютерні науки

description: James Kulina, Executive Director of OpenPOWER Foundation will be giving introduction to the Foundation and outlook for 2021 and beyond.

uk: вхід без авторизації


Status of OpenPOWER support in coreboot

uk: Комп'ютерні науки

description: The presentation describes efforts of porting OpenPOWER architecture firmware to open source firmware framework - coreboot. Although OpenPOWER firmware has been open-sourced some time ago, it may still benefit by implementing the support in coreboot. The differences and benefits of the OpenPOWER firmware and coreboot will be mentioned as well as current progress of work and challenges faced during development. The IBM POWERPC architecture exists since early 90. Many may also know that the POWER processors were used in Apple Macintosh between 1994-2006. Today the IBM goes forward with their POWER processors releasing newer and newer processor families like POWER9 and even POWER10 recently. Modern POWER architecture features very high computing performance with multi-core processors which makes them ideal for servers and computing clusters. They also are great as a workstation, for example Raptor Computing Systems Talos II (POWER9), which is the reference platform used during the coreboot port. A huge advantage of OpenPOWER architecture is its openness. Compared to modern x86 architecture which is full of binary blobs, POWER can easily rival with x86 domination and dethrone it from the most common used processors architecture in modern computers. Although the OpenPOWER firmware and documentation is open-source the development of coreboot for POWER9 is very challenging and full of unknowns. In this presentation you will hear about the current progress of the work on coreboot POWER9 support, what problems we face and how much effort it takes to enable new architecture in coreboot.

uk: вхід без авторизації


uk: Комп'ютерні науки

description: The game has changed, FOSS OS and software is everywhere running on every CPU architectures and devices. Even mass consumer computer manufactures are producing with "new" CPU architectures. In 2020 thanks to the Open Power ISA have opened Power Architecture new Chips. It's the right time to have (back) Power Architecture for Open Source Hardware lovers, in educations, makers, hobbyists, consumers and gaming electronics. We will see concretes present projects and future options. This year IBM released the A2I,A20 POWER processor cores design (softcore) licensed with Creative Common CC-BY 4.0 and associated FPGA environment. In 2019 IBM opened the POWER Instruction Set Architecture (ISA) so now others chip manufactures could produce Power Architecture royalty-free chips . We discover how the FOSS have permitted to manufacturers to adopt newer CPU Architectures and how will be redesigned electronic adopting Open Source Hardware for motherboard and CPU design. We will focus on Open Hardware concretes projects around Power Architecture like the Power Architecture Notebook project, Libre-SOC project ( aims to deliver a physical POWER compliant SOC with a CPU, GPU, VPU, and DDR controller and others projects of cheap Power Architecture motherboards.

uk: вхід без авторизації

name: It's the right time to switch computing to Open Hardware Power Architecture


uk: Комп'ютерні науки

description: The LibreSOC hybrid 3D CPU-VPU-GPU is intended to provide a significant reduction in both hardware complexity, software (driver) complexity and systems integration primarily initially for embedded and mobile environments. Larrabee or more specifically Nyuzi showed that a software-only "Traditional Vector Processor" architecture makes for a fantastic High Performance Compute Engine that, unfortunately, also turns out to have only 25% the performance/watt of current competitive embedded mobile GPUs. Not only that but SIMD, despite being (seductively) easy to implement by hardware engineers, has been shown to have harmful consequences at the software level (setup and loop end cleanup). A recent patch to glibc6 to add POWER9 VSX strncpy was a whopping 250 hand-crafted assembly instructions, where its equivalent using Cray Vector principles is around 14. All of this was solved decades ago by Cray Vector designs, and then forgotten. Only now is variable-length Vectorisation being rediscovered and deployed in modern architectures: RISC-V RVV, ARM SVE2 and also Simple-V. This talk therefore goes through the background and concepts behind Simple-V. Thanks to a grant from NLnet, SV will be formally documented and proposed formally as an extension to OpenPOWER, for review by the OpenPOWER Foundation.

uk: вхід без авторизації

name: The LibreSOC Project: Simple-V Vectorisation: why we decided to invent a new Vector system on top of OpenPOWER


uk: Комп'ютерні науки

description: Void's POWER architecture port has been progressing steadily since the last OpenPOWER Summit EU talk in 2019. Recently we introduced a completely new 32-bit little endian port, which will be a big part of this talk's focus, and is a first among Linux distributions. I will not stay there though - we have more to cover, including stuff like Chromium and Electron applications in repos, faster POWER crypto in LibreSSL, reworked crosstoolchains, stable support for newest AMD GPUs, and our big endian variants are also receiving attention, including properly clearing up the 64-bit ABI situation. Void Linux is an independent, rolling release, general purpose Linux distribution (leaning towards desktop/workstation focus) originally created in 2008 on the x86_64 architecture as a testbed for its own XBPS package manager. Over time, it has received a variety of ports, including 32-bit and 64-bit ARM, MIPS, and eventually POWER and PowerPC. It has variants for 64 and 32 bits, little and big endian, and glibc and musl C standard libraries. Most recently it has received an experimental 32-bit little endian port, which is a first among Linux distributions. I will be focusing partially on the new port, and partially on other news in the distribution since my last talk I gave at OpenPOWER Summit EU 2019. I will explain our goals with the new port, as well as our plans. Additionally, the future of the distribution will also be covered, as well as currently remaining issues and blockers that prevent us from achieving that.

uk: вхід без авторизації

name: Void Linux: we heard you like little endian


AlekSIS

uk: Комп'ютерні науки

description: As part of the schul-frei project of Teckids e.V. we curate free software and offer it to educational institutions. Besides the general equipment of schools with free software, an equal involvement of students in the development is for us important. One of the solutions presented by the project schul-frei is AlekSIS, a web-based school information system that is being developed jointly by Teckids e.V. and students of the Katharineum in Lübeck. The django-based platform provides data structures that can be used by separately developed apps. The special feature of this project compared to other information systems is that apps can be developed that cover specific application areas of a school. AlekSIS is a framework for apps that can be developed together with students in computer science classes, for example, because the development of such apps with python is easy to follow. Since AlekSIS is just a part of the free software curation, it can be excellently combined with other services or network accounts that are used in school. In our talk we will show, how this framework concretely looks like and how people can contribute to this project or use this system, for example at schools.

uk: вхід без авторизації


uk: Комп'ютерні науки

description: Everybody hates mundane tasks, they are boring, repetitive and time-consuming. That’s why I love building bots, they can finish my tasks for me by working 24/7. But to build a bot to interact with the users, you have to write in async. If you are afraid of async, don’t worry! Today I am telling you how I learn using async and how I avoid checking in 500+ people in a conference by building a bot with Discord.py. In the first part of the talk, there will be a short introduction to Discord. As more and more conference goes online, it’s become a more and more popular tool among the Python community. I will also introduce Discord.py, a python library that offered an async API to let you build a Discord bot. This will give the audiences a background about the following quick demo and explanation of a simple bot that I built. In the second part of the talk, I will walk through how to build a bot for registering attendees for EuroPython. Following a quick demo, I will also give a walkthrough about some of the async coroutines available in Discord.py: event listener like on_ready and commands. I will also explain how the async code is different from the sync code and the danger of mixing them together. Hopefully, audiences will be inspired to build their own bot and learn a little bit about writing async code in Python and using Discord.py. This talk is suitable for attendees who got basic knowledge in Python but not necessarily know about Discord or async.

uk: вхід без авторизації

name: Don't be Afraid of Async: Automate Mundane Tasks with a bot by using Discord.py


uk: Комп'ютерні науки

description: If you develop web apps with Python and want to take your project to a cloud platform like Heroku, using a continuous integration tool can help you with this process and optimize time and resources. Running tests and deploying your app are some tasks that this tool can help you with. Through this talk you will know how to use GitLab CI on your Python projects.

uk: вхід без авторизації

name: How to get started with Python and GitLab CI: A GitLab CI Introduction


CubicWeb as a Linked Open Data server

uk: Комп'ютерні науки

description: We made the Web accessible to human. What about making the web (of data) accessible to computers? Publish open data could be struggling. Deposit a CSV file on a web server is not enough. The data model used should be explicitly defined. The Linked Open Data solves this with: * standardized implementation format (RDF) * standardized data access (Content negociation, SPARQL endpoint) * standardized data indentification (URI, data model as data). For example all the data from the Bibliothèque National de France (national library of France) are widely accessible by using these standards. This allowed the development of data federation initiatives, such as Europeana. CubicWeb is a semantic web application framework, licensed under the LGPL, that follows Linked Open Data best practices. During this presentation we will discuss about Linked Open Data benefits, and how CubicWeb could be used as a "on shelve" framework to do so.

uk: вхід без авторизації


uk: Комп'ютерні науки

description: This talk will provide practical insights on high performance GPU computing in Python using the Vulkan Kompute framework. We will cover the trends in GPU processing, the architecture of Vulkan Kompute, we will implement a simple parallel multiplication example, and we will then dive into a machine learning example building a logistic regression model from scratch which will run in the GPU.

uk: вхід без авторизації

name: Beyond CUDA: GPU Accelerated Python on Cross-Vendor Graphics Cards with Vulkan Kompute


uk: Комп'ютерні науки

description: Structuring a Python project is often non-trivial. We pick up pieces of different patterns and techniques, blindly applying them without understanding their implications, in an attempt to ship software. Testing and packaging become significant pain points for many developers, and this need not be so. In this talk, Jason C. McDonald breaks down the best way to structure a Python project for maximum portability and maintainability...and more important, explain WHY these patterns exist.

uk: вхід без авторизації

name: Escaping the Cargo Cult: How to structure your project without losing your mind.


uk: Комп'ютерні науки

description: Are you an educator who wants to design teach an industry-aligned curriculum? Then you have come to the right place. In this talk, we will show how to design a better curriculum using natural language processing libraries in python, i.e., spaCy and Textacy. The curriculum in the general and undergraduate curriculum, in particular, is one of the most important pillars of an education system. The undergraduate curriculum has two main objectives i.e. employability and higher education. The greatest challenge in designing an undergraduate curriculum is achieving a balance between employability skills and laying the foundation for higher education. Generally, the curriculum is a combination of core technical subjects, professional electives, humanities, and skill-oriented subjects. We used natural language processing and machine learning packages in Python to build a curriculum design system. The steps to build a curriculum design system are described below: 1. The dataset was built from the job profiles from different job listing websites like stackoverflow.com, indeed.com, linkedin.com, and monster.com. Also from the syllabus of competitive exams and qualifying exams for higher education. 2. On the dataset, we applied natural language processing techniques to identify the subjects and subject content. For natural language processing, we used spaCy an industrial-strength Natural Language Processing package in Python. 3. To generate syllabus content for a particular subject, a pointer-generator network was used. The pointer generator network is a text summarization technique that combines extractive and abstractive summarization techniques. The extractive summarization technique extracts keywords from the dataset, whereas the abstractive summarization technique generates new text from the existing text. The pointer-generator network was implemented using the scikit-learn machine learning package in Python. 4. The generated curriculum was then compared with the existing curriculum to get insights like, how much percent of the curriculum is industry oriented, how much percent of the curriculum is aimed at higher education and job-oriented skills. At this step, we used the ROGUE (Recall-Oriented Understudy Gisting Evaluation) metric to compare the generated curriculum against the reference/proposed curriculum 5. The above steps can be repeated with modified parameters to get better insights and curriculum. This also gives us an idea of how we can have an evolving curriculum that can help us bridge the gap between industry and academia.

uk: вхід без авторизації

name: Inventing Curriculum using Python and spaCy


uk: Комп'ютерні науки

description: Have you ever had issues to share your Jupyter Notebooks? Ever had troubles with code that "works on my machine" only? Do you consider your Research and Development smooth and straightforward? Is your code scalable? Tough questions, I know. But if you've mentally answered 'no' to any of those you could use a tool to help with some of the pain-points of your workflow. Kedro is an open-source Python library that helps data scientists write data pipelines following software engineering best practices from the start. Known as the Django of ML/DS projects, Kedro is an opinionated framework based on cookiecutter data science that allows for modularity and scalability on data science projects. In this talk, I will explore the workflow of a Kedro project, introduce some of the most outstanding features of the framework, such as the Data Catalog and show how to convert a Jupyter Notebook into a Kedro project, allowing for scalability and team collaboration.

uk: вхід без авторизації

name: From Jupyter Notebook to production code: a Kedro introduction


uk: Комп'ютерні науки

description: Mypy has been around since 2012, and in recent years its gaining wide spread adoption. As the framework continues to evolve and improve, more and more useful features are being added. In this talk I'm presenting some hidden gems in the type system you can use to make your code better and safer! The Mypy typing system, and the complementary extensions module, includes some powerful but lesser known features such immutable types and exhaustiveness checking. Using these advanced features, developers can declare more accurate types, get better warnings, produce better code and be more productive.

uk: вхід без авторизації

name: Practical advice for using Mypy: Hidden gems in the typing system!


Bringing Pinax Back to Life

uk: Комп'ютерні науки

description: Pinax is an open-source ecosystem of reusable Django starter projects, apps, and themes for building websites. When developers began building Pinax in 2007, they had fun adding to it, but eventually Pinax had grown to become around 80 projects and apps. Without a strategy in place to make Pinax as easy as possible to maintain, the maintainers began to suffer burnout. I was hired to work on Pinax in the fall of 2017. In my talk, I'll outline the critical problems I've discovered and the solutions I'm implementing to make Pinax healthier and easier to maintain today and in the future. Pinax is a work in progress and I'm interested in sharing what I've learned.

uk: вхід без авторизації


uk: Комп'ютерні науки

description: In 2020, with funding from Mozilla and CZI, the pip packaging team improved pip for all users. These focused on improving the depedenecy resolution for Python packages, and the user experience for all Python users. We carried out usability testing, user research and improved error and information messages for pip. This talk will be about these improvements - we'll explain how the new dependency resolver works, what it can (and can't do!), how we improved the user experience of pip, the challenges we faced, and why improving user experience is important for open source software.

uk: вхід без авторизації

name: Making pip better for all users: How we improved pip's dependency resolver


uk: Комп'ютерні науки

description: While iterating rapidly on Python code, we want to see the result of our changes rapidly. In this talk, we will review the different techniques available to reload Python code. We will see how they work and when each is the best fit. The talk will cover both cold and hot reload techniques: Cold reload techniques reset the application state between each reload. Examples include Django and Flask's autoreload tools. Hot reload techniques keep the application state despite the code changing. These include Jupyter kernels and 'reloadr' [1], an open-source module developed by the speaker to allow stateful hot code reloading.

uk: вхід без авторизації

name: Code reloading techniques in Python: Cold and hot code reloading, the different options, how they work and when to use them.


uk: Комп'ютерні науки

description: When someone starts learning about classes in Python, one of the first things they'll come across is "self" in the parameter list of a method. To keep it simple, it's usually explained that Python will automatically pass the current instance as the first argument to the method: "self" will refer to the instance the method was called on. This high-level explanation really helps with keeping the focus on learning the basics of classes, but it also side-steps what is really going on: It makes it sound like process of inserting "self" is something automagical that the language just does for you. In reality, the mechanism behind inserting self isn't magical at all and it's something you can very much play with yourself. In this intermediate level talk, Sebastiaan Zeeff will take you down into the heart of the Python data model to explain how the mechanism behind inserting "self" works. He will talk about the descriptor protocol and how it allows you to modify how attributes are accessed, assigned, or deleted in Python. He hopes that understanding how descriptors work will demystify "self" in Python.

uk: вхід без авторизації

name: How Python inserts 'self' into methods: An accessible introduction to descriptors


uk: Комп'ютерні науки

description: Have you always wanted a flexible & interactive visualization that is easy for others to work with without handling all the Javascript libraries? Or do you want to build a user interface for your Machine Learning Model? This talk has you covered with building data apps in Python using Streamlit with examples of a Travel Visualization App using Google Maps Data & an UI for the ImageNet Model. In this talk, I showcase couple of different use cases where you can build your data focussed applications using Streamlit, an open source library in pure Python. In the first use case, I cover how you can build interactive dashboards using different Streamlit components. These dashboards can be easily deployed & the consumers can easily work with the interactive dashboards without worrying about all the dependencies that need to be installed to run the Jupyter notebooks. In the showcase, I will go over how you can build a dashboard of your historical travels using Google Maps Location History including some memories from them from Flickr. In the second showcase, I will describe how users can create a quick interface for their machine learning model using Streamlit. These interfaces are much faster to develop than building a custom frontend interface for machine learning models with the help of Javascript libraries. In the demo, I showcase how I built an UI for the ImageNet Model. The showcases will showcase how these data based web apps can be built using Python functions & Streamlit components.

uk: вхід без авторизації

name: Creating Data Apps using Pure Python: Building Custom Apps using Streamlit


uk: Комп'ютерні науки

description: We will talk about different approaches in teaching Data Science with the Python programming language. As a case study, we will use our own experience in providing Data Science education with Python across different audiences in the Asia Pacific region and share approaches and principles that worked for us. The lecture will serve as an anchor for more conversations and discussions for adapting pedagogy that is most effective for various contexts and settings. Programming is a fairly new human skill. Unlike natural languages and problem solving that have progressed throughout our evolution, we do not yet have neurological learning pathways dedicated for it. As such, effective pedagogies are still experimental. We will share results of experiments in curriculum and conduct that we did and highlight factors such as project-based learning, purpose-driven education, communal philosophies, applications of Agile principles, relevance to industry, and the unique circumstances of our students.

uk: вхід без авторизації

name: Different Approches in Pedagogy in Teaching Data Science with Python


uk: Комп'ютерні науки

description: How many seasons does a tropical country like Singapore have? Is global warming real, and is rainfall getting heavier? To answer these questions, I will show how we could use Requests and Pandas to build a data pipeline that extracts Singapore weather station data for a user-defined time period and explore the weather trends and seasons over the past few years. Most of the world experience the four seasons, but how many seasons does a tropical country like Singapore have? Is rainfall getting heavier? We can get such insights from publicly-available weather data; however, we need to write scripts to make API requests to retrieve the data. In this talk, I will be sharing about my approach in building a data pipeline that extracts Singapore weather station data from Data.gov.sg APIs for a user-defined time period using pandas. Based on the extracted data, I will also be using a data-driven approach to gain a better understanding on the weather trends and seasons over the past few years, and explore different approaches in forecasting future weather trends based on these insights.

uk: вхід без авторизації

name: Is Rainfall Getting Heavier? Building a Weather Forecasting Pipeline with Singapore Weather Station Data: Using data-driven approaches for weather forecasting in the tropics


uk: Комп'ютерні науки

description: Signal processing of Sentinel1 spaceborne RADAR datasets freely available from the European Space Agency web site, followed by the deployment of a corner reflector which will be visible in the latest datasets. Software Defined Radio users and developers are well aware of the {I, Q} stream and their handling for powerful software processing at baseband. While most developments focus on hardware, acquisition and digital communication signal decoding, a huge dataset of {I, Q} samples is available from the spaceborne Sentinel1 satellites. Indeed, the European Space Agency is providing free access (the anonymous registration with the service will be discussed in the presentation) to the datasets collected by the two Sentinel-1{A, B} satellites. Spaceborne RADAR provide all-weather (RADAR is not affected by cloud), day-night (RADAR is active and does not depend on external illumination sources) monitoring conditions covering the whole surface of the Earth from the low Earth polar orbiting satellites. Most significant over optical measurements, microwave RADAR measurements allow for phase recovery and hence interferometric measurement which is not possible with optical measurements. Furthermore, radiofrequence wave complex interactions with the reflective surfaces (scattering, absorption, polarization rotation) provides a rich context for analysis complementary to optical observations. Thanks to the Single Look Complex, Interferometric Wide datasets collected over land, discovering Interferometric Synthetic Aperture RADAR processing is no longer a matter of being associated with a dedicated laboratory and applying to selective research projects (e.g. Canadian RADAR-Sat datasets or German TanDEM-X) but only of fetching the huge datasets (4-GB/image) and learning the processing sequence. In this talk which will appear as a sequel to the development of Ground Based SDR RADAR discussed during GRCon2020 [1], we will introduce a processing flowchart first relying on the SNAP graphical user interface provided by ESA before switching to an automated command line approach relying on Makefile since each processing step depends on the proper completion of the previous one. We will address some basic conditions whose results are expected, namely German open-pit coal mines and earthquake-induced land motion. Indeed the 5 mx20 m pixel and 5.6 cm wavelength is best suited for large scale, sub-cm natural or human-induced geomorphological transformations, while the short term coherence is best achieved by analyzing the successive data collected from one observation to another with a 12-day repetition rate. After demonstrating a functional flowchart resulting in GeoTIFF phase and coherence maps consistent with optical satellite and aerial imagery, we conclude the presentation by adding a cooperative target corner reflector acting as localized point-like measurement source, assuming the reflector is large enough to be the dominant reflection source over the pixel area.

uk: вхід без авторизації

name: Talking to spaceborne RADAR: Sentinel1 data processing: ... and seeing a corner reflector as cooperative target


A modular future for GNU Radio

uk: Комп'ютерні науки

description: The vision for a new GNU Radio runtime is to have a straightforward implementation of distributed SDR systems that make efficient use of the platform and its accelerators. Though there have been many projects over the years to address some of these goals, many aspects are challenging to do in the current GNU Radio runtime. One year ago, several of us got together at the pre-FOSDEM hackfest and started planning how to "write a GNU Radio runtime that works for humans". Since that time the project has taken several different directions, all aiming to make the core aspects of GNU Radio modular and easier to use by laying a fresh foundation. In this talk, we will overview the current state of the "newsched" project, and where we plan to take it.

uk: вхід без авторизації


uk: Комп'ютерні науки

description: Embedded systems are tailored to a specific task aimed at minimizing resource and energy consumption (e.g. ADi PlutoSDR). Cross-compiling benefits from powerful personal computer computational resources and user-friendly interfaces while removing the burden on the embedded board of running the compiler. GNU Radio was ported to Buildroot to provide SDR enthusiasts access to the many boards supported by this cross-compilation framework. We demonstrate its use in a graduate course project aimed at developing an embedded network analyzer. A network analyzer for characterizing a radiofrequency device requires a radiofrequency receiver for collecting the signal that was generated to probe the response of a Device Under Test, and a matching signal source. We consider the RTL-SDR dongle as the receiver, while the Raspberry Pi processor Phase Locked Loop (PLL) has been shown to generate a radiofrequency signal in the FM band. In this demonstration, PiFM is used as a signal source. As students were not allowed to visit university during lockdown, a cost-effective solution had to be found to provide hardware to all students to complete the course at home: the solution of a Raspberry Pi4 and DVB-T dongle was selected to provide the framework of embedded radiofrequency system development. GNU Radio is cross-compiled using Buildroot to the Raspberry Pi 4, iterative tests allow for checking the functionality of each step, until a complete measurement is achieved.

uk: вхід без авторизації

name: Never compile on the target ! GNU Radio on embedded systems using Buildroot: feedback on a graduate course on developing an embedded network analyzer


uk: Комп'ютерні науки

description: The year 2020 had some interesting organizational updates for the GNU Radio project. We summarize the changes, describe the new leadership structure, and show how we intend these changes to propagate into the future. In 2020, the GNU Radio organization went through some major changes. In the past, the leadership of GNU Radio followed a "benevolent dictator" model. This is an efficient leadership structure, but it assumes dictators' benevolence, and is not a scalable model. Starting 2020, we have a new leader ship team (the General Assembly), and a new Board. With the exception of the initial General Assembly, all members are elected, and there's an official process in place to keep the organization going. On top of that, we merged with The SETI Project. We are hopeful that this collaboration is a great win for both parties, and we'll talk about why.

uk: вхід без авторизації

name: GNU Radio: Organizational Updates 2020: How the GNU Radio organization may look like


uk: Комп'ютерні науки

description: Progress is deeply engrained in the structure that makes up the GNU Radio project. A lot of it has been made in 2020 – but unlike crop circles, we do know where it came from, and what we can do with it.

uk: вхід без авторизації

name: GNU Radio Tech Update: Lifting the mystery of what has happened in GNU Radio over the last 12 months


gr-satellites project update

uk: Комп'ютерні науки

description: gr-satellites is a GNU Radio OOT module that contains a collection of telemetry decoders for Amateur satellites. At FOSDEM20 we presented an on-going large refactor to improve modularity and usabilty. The new version was finally released in June and includes a command line tool to run the decoders, GNU Radio blocks of both high and low level to allow customized designs, and comprehensive user documentation. Moreover, gr-satellites now has cross-platform support through Conda, has been included in Debian and has an Ubuntu PPA. In this talk we will look at the main features of the new gr-satellites releases and the important things that have happened this year surrounding the development of gr-satellites.

uk: вхід без авторизації


uk: Комп'ютерні науки

description: Accelerator devices such as GPUs, FPGAs, or DSPs can be very useful for offloading computationally intensive digital signal processing tasks. Unfortunately, the GNU Radio SDR framework does not directly support such devices. Many workarounds have been developed to allow accelerator devices to be used within GNU Radio, but each comes with performance and/or flexibility tradeoffs. To solve these problems work is currently underway to develop generic support for accelerator devices within GNU Radio itself. The focus of this work is to modify GNU Radio to allow support for custom buffers. Custom buffer support will allow GNU Radio to directly utilize device specific buffers (e.g. DMA buffers) and therefore eliminate the need to double copy in order to move data into and out of an accelerator device. Furthermore, the custom buffer concept can be extended to allow “zero copy” data access between two kernels on the same accelerator device. This presentation will cover the design and current status of custom buffer support for GNU Radio.

uk: вхід без авторизації

name: Improving GNU Radio Accelerator Device Dataflow


uk: Комп'ютерні науки

description: Openwifi project, the opensource WiFi chip design, was firstly announced in FOSDEM 2020. During the unusual 2020, openwifi project has made many progresses, also encountered some difficulties. In this presentation, openwifi project would share with you: - result of user/community growth - main progresses: hardware support; performance; stability; bug fixes; new features - difficulties: community participation (FPGA people << software people); too expensive hardware - idea of low cost hardware - new features planned

uk: вхід без авторизації

name: openwifi - opensource WiFi chip: Progress 2020 and future idea/plan


uk: Комп'ютерні науки

description: Recently proposed domain-specific systems-on-chip (DSSoCs) optimize the architecture, computing resources, and run-time management by exploiting the application characteristics for a given domain. As such, DSSoCs can boost the performance and energy-efficiency of software-defined radio (SDR) applications without degrading their flexibility. Harvesting the full potential of DSSoCs depends critically on integrating an optimal combination of computing resources and their effective runtime utilization. For this reason, the design space exploration process requires evaluation frameworks to guide the design process. Full-system simulators, such as gem5, can perform instruction-level cycle-accurate simulation. However, this level of detail leads to long execution times and is beyond high-level design space exploration requirements. In contrast, hardware emulation using Field-Programmable Gate Array (FPGA) prototypes are substantially faster. However, they involve significantly higher development effort to implement the target SoC and applications. Given the design complexity, there is a strong need for a simulation environment that enables rapid, high-level, simultaneous exploration of scheduling algorithms and power-thermal management techniques. To this end, we present DS3, an open-source system-level domain-specific system-on-chip simulation framework that targets SDR applications. DS3 framework enables (1) run-time scheduling algorithm development, (2) dynamic thermal-power management (DTPM) policy design, and (3) rapid design space exploration. DS3 facilitates plug-and-play simulation of scheduling algorithms; it also incorporates built-in heuristics and a constraint programming-based scheduler to provide an upper bound of performance (i.e., optimal schedule for a set of applications and an SoC configuration) for users. Hence, it can be used to develop and evaluate new schedulers that can be integrated into GNU Radio. DS3 also includes power dissipation and thermal models that enable users to design and evaluate new DTPM policies. Furthermore, it features built-in dynamic voltage and frequency scaling (DVFS) governors deployed on commercial SoCs. In this talk as we discuss the DS3 capabilities, we will present a benchmark application suite with applications from wireless communications and radar processing domains including WiFi TX/RX, low-power single-carrier TX/RX, range detection, and pulse Doppler. We will conclude the talk with design-space exploration studies using these applications.

uk: вхід без авторизації

name: Optimization of SDR Applications on Heterogeneous Systems-on-Chip (SoCs): A High-Level Simulation Framework for Evaluating SDR on Heterogeneous SoCs


uk: Комп'ютерні науки

description: I discuss the challenges of teaching Digital Signal Processing (DSP) and Software-Defined Radio (SDR) concepts to those without any background in the area. At the University of Maryland I created an elective for undergraduates in the CS dept. that introduced DSP and SDR in a hands-on manner, and have since taught the course twice. During this course, students learn basic wireless communications and DSP concepts, and how to implement the techniques onto SDRs. Additional course learning objectives include digital signals, filtering, frequency domain, digital modulation, noisey channels, cellular, and IoT. The course utilizes open-source SDR toolkit software including GNU Radio and Python libraries, allowing students more interesting and engaging assignments/exercises and more advanced concepts to be explored. Every student had a PlutoSDR to use during the semester. What is unique about this course is that this material is typically taught at the graduate level within ECE, spread across numerous individual courses. CS students, at least at our university, do not get exposed to any DSP or signals background which is normally required to learn about SDR using traditional methods/textbooks, so they must start from scratch, which is why this course has heavy use of graphics, animations, and examples. As such, this course does not dive as deep into the mathematics behind the theory as a normal graduate level ECE course would. There is much more emphasis on "learning by doing", and actually creating SDR applications. In addition to the course I have created a free online textbook called PySDR, that is based on the material I taught in my course, which anyone can use to learn DSP and SDR using Python. My textbook does not use any custom libraries or code, it's essentially showing how to use straight Python (e.g. mostly numpy, scipy, and matplotlib) to actually do DSP and create SDR applications. Through feedback I've gotten from people using this online textbook, I have learned about what it takes to teach DSP and SDR to folks in a non-university setting. The source code used to generate the textbook (using Sphinx) is hosted on GitHub, so that readers can submit issues or even PRs, to date there has been several contributors. I'm hoping this presentation can show that you don't need to be a EE with a masters degree to dive into DSP and SDR.

uk: вхід без авторизації

name: PySDR: A Guide to SDR and DSP using Python: And my Experience Teaching CS students DSP + SDR


uk: Комп'ютерні науки

description: Heterogeneous architectures, composed of a pool of general-purpose processors and accelerators, on one hand offers the ability to balance the application performance, programming flexibility, and energy consumption. On the other hand, they give rise to a number of challenges on a) designing and implementing a suitable architecture for the needs of the target applications, b) deploying dynamic and low-overhead resource management strategies, and c) effectively enabling execution of pipelined workflows for streaming applications. Furthermore, application developers need productive tools to port their software-defined radio applications to increasingly heterogeneous SoCs. We think that application developers should not waste their time reading datasheets or APIs for SoC-specific kernel extensions just to take full advantage of their hardware. With these in mind, this talk will discuss strategies we are using to address the aforementioned inter-related challenges through our vertically integrated compile-time and run-time environment CEDR: a Compiler-integrated, Extensible, DSSoC Runtime. CEDR is an open-source ecosystem that runs in Linux user-space and enables compilation and development of user applications, resource management strategies, and accelerator integration in one unified framework. CEDR supports highly recurring, stream-based application graphs through pipelined execution and processing element based work queues. CEDR is built on a thread-per-PE scheduling methodology, enables integration of complex resource management heuristics that rely on work queues and require reservation-based policies. CEDR supports contemporary scheduling algorithms built on imitation learning (IL) that uses complex schedulers offline to construct an Oracle and effortlessly replicates those decisions online using machine learning models such as regression trees and neural networks. We will demonstrate CEDR deployed on the Zynq UltraScale MPSoC by conducting execution time, throughput, resource utilization analysis through dynamically arriving workload scenarios composed of Radar and WiFi applications. We will demonstrate the distinct plug-and-play integration points offered by CEDR for application engineers and hardware architects through case studies that illustrate our ability to rapidly evaluate various configurations of applications, schedulers, and accelerator IPs.

uk: вхід без авторизації

name: Runtime Strategies and Task Scheduling of Software-Defined Radio on Heterogeneous Hardware: Is an accelerator always the best option?


uk: Комп'ютерні науки

description: SigDigger is a free digital signal analyzer with an intuitive Qt5 interface, originally designed for GNU/Linux but that has been successfully ported to macOS as well. In this talk, I will give a brief introduction to SigDigger, what are its use cases, and why it is a reasonable option with respect to existing alternatives. In order to better illustrate these use cases, I will perform a live demonstration of its features and capabilities and give some real-time performance figures. I will then describe its internals, how the demodulator pipeline is implemented, why it is so fast, and why it could be even faster. I will finish with the mid-term goals of the project, WIP, and a request for collaboration for anyone who could be interested in making this software grow.

uk: вхід без авторизації

name: SigDigger: blind signal analysis made easy: Introduction, examples, design details and seeking collaboration.


uk: Комп'ютерні науки

description: This talk provides an update on the srsLTE project. We'll look at the two past releases in 2020 and, more importantly, provide an outlook on the two upcoming releases for 2021 which will include 5G NSA support.

uk: вхід без авторизації

name: srsLTE project update: How the year went and what's up next


uk: Комп'ютерні науки

description: During the last year, we saw quite a significant amount of changes to VOLK. Here, we want to present a summary of these changes and how users may benefit from them. Further, we want to give an outlook on future directions of the project. 2020 started with a new VOLK maintainer team. Michael Dickens and Johannes Demel took over to lead the effort to improve VOLK. VOLK started as a subproject of GNU Radio and evolved quite significantly since then. Since 2020 VOLK is a bit more independent from GNU Radio because it is not considered a submodule anymore. Nonetheless, we continue to work under the GNU Radio organization umbrella and intend to do so in the future. We start this talk with a quick recap on "What is VOLK?" and how we define the scope of the project. Then we want to have a quick review on what happened in 2020 with statistics but also some significant changes that we want to point out. Finally, we want to look at future directions. Some topics that are coming up.

uk: вхід без авторизації

name: Vector Optimized Library of Kernels: A year in review


Black box panel

uk: Комп'ютерні науки

description: Live Q/A panel with two speakers who presented works arround black box issues.

uk: вхід без авторизації


uk: Комп'ютерні науки

description: We will describe in this talk how to combine crowdsourcing approaches with scientific expertise in Digital Humanities projects, and some of the issues that are at stake. The talk will focus on Recital, a Digital Humanities project aiming at gaining insights on 18th-century theater through the analysis of its accounting books. It combines crowdsourcing, using the ScribeAPI free software, producing results that need to be evaluated and validated by scientific expertise, which requires appropriate visualisation and analysis tooling.

uk: вхід без авторизації

name: Recital: Combining crowdsourcing and expertise in Digital Humanities


uk: Комп'ютерні науки

description: Datasette is a tool for exploring and publishing data. It helps people take data of any shape or size, analyze and explore it, and publish it as an interactive website and accompanying API. Datasette is aimed at data journalists, museum curators, archivists, local governments and anyone else who has data that they wish to share with the world. It is part of a wider ecosystem of tools and plugins dedicated to making working with structured data as productive as possible. I’ll use this talk to introduce Datasette and show how it can be used to quickly explore and publish data. I’ll talk about why SQLite is an ideal publishing format for structured data and demonstrate several open source tools for converting data from different sources into SQLite databases for use with Datasette. Datasette is the foundation of my Dogsheep personal data warehouse project. I’ll show how I’ve pulled together data about my own life from a wide range of sources - from Twitter and GitHub to 23AndMe and Apple Health - and used it to build my own data warehouse to help me answer questions about myself.

uk: вхід без авторизації

name: Datasette: An open source multi-tool for exploring and publishing data


eLabFTW - the open source lab notebook

uk: Комп'ютерні науки

description: eLabFTW is an open source laboratory notebook for research labs. It tracks experiments and results but also features a database where you can keep track of all the elements in your lab. Created in 2012 and published on GitHub, eLabFTW quickly gained traction in the research community and several contributors joined over time to help implementing new features and fixing bugs. Now translated in 17 languages, eLabFTW has become a pillar of the ELN landscape and more and more labs and universities are using it all around the world. In this presentation I will talk about the software itself but also how publishing the source code on GitHub with a AGPLv3 license helped tremandously the software to grow. When doing research work, it is important to keep track of your experiments and results. To do that, we normally use paper lab notebooks. But nowadays, it makes little sense to stick to paper, especially when all of our results are produced in a numeric format. Users are now looking for a solution to that problem, and that solution is Electronic Laboratory Notebooks (ELN). Several ELN are available to researchers. Some are proprietary, and only a few are truly free (as in beer and as in speech). Among the libre ones, we can find quite a lot of abandoned projects. Since 2012, eLabFTW has seen continuous improvements with a constant flow of new features and a growing community of users, translators and contributors. It is now a mature and polished piece of software, widely used by startups, research labs and universities. Now backed by a company, the future seems bright and full of promises with fruitful collaborations with Universities to implement specific features that will benefit the whole community of users.

uk: вхід без авторизації


uk: Комп'ютерні науки

description: This presentation illustrates how the GNU Emacs text editor provides an powerful integrated environment for reproducible research, effectively bypassing the need for juggling different software in order to write and execute code, manage data or write papers. GNU Emacs as a long history, and is still widely used and supported by a very active community of users and developers. A very popular feature of GNU Emacs is Org-mode which, at its core, offers a markup language similar to Markdown. Following a brief introduction to Org-mode, this presentation demonstrates its use for reproducible research: straightforward mixing of prose and code, execution of code blocks as well as display of the results. With Org-mode, GNU Emacs is turned into a computational notebook which functionalities goes well beyond popular alternatives such as Jupyter. Code blocks are not restricted to a particular programming language and data can be passed between them: generate data in C, analyse it in Python, visualise it with R, all in one single executable document. Moreover, Org-mode documents are nothing but plain text, making them inherently portable, sustainable, and suited to version control - crucial qualities for academic research. Moving on, I illustrate the export of Org-mode documents to richer formats: PDF, ODT, HTML and many more - all from within GNU Emacs. Lastly, I broaden the scope of this presentation and discuss the open nature of GNU Emacs itself. Indeed, GNU Emacs is free (as in freedom) software under a copyleft license. This ensures that GNU Emacs remains sustainable, community-owned software: GNU Emacs will never be "discontinued" or its features reduced inside a "community edition". If GNU Emacs is widely used among GNU/Linux users, it is a rather unusual component of nowadays researchers' toolbox. This presentation is an opportunity for attendees to (re)discover GNU Emacs, not so much as a code editor, but as a powerful tool for reproducible research, from day-to-day data collection and analysis, all the way to paper publication. Despite being over 30 years old, GNU Emacs comes with with very modern ideas, highly relevant to today's discussions of openness and reproducibility in scientific research. Beyond the tool itself, this presentation is an opportunity to sparkle discussions on the nature of research tooling. GNU Emacs has always been developed and maintained in the open, and its license ensures that it will always be. GNU Emacs maintenance and development is a collective, not-for-profit effort of thousands of developers worldwide and anyone wanting to make modifications to it is welcome to do so. This ensures both reliability and sustainability, which are key characteristics for any tool at the core of a reproducible research practice.

uk: вхід без авторизації

name: Reproducible research with GNU Emacs and Org-mode: Organize your research in plain text!


uk: Комп'ютерні науки

description: Come learn about how researchers and open data initiatives are using IPFS and Filecoin to make their data resilient, accessible, and verifiable. From Starling to Qri to EDGI - many groups are pioneering the use of distributed web tools to preserve important data, empower researchers, and bring new capabilities like end-to-end verifiability or peer-to-peer data transfer to their research. Learn about best practices using these tools today, and how they're getting better in 2021.

uk: вхід без авторизації

name: Filecoin & IPFS: A new Home for Research Data


uk: Комп'ютерні науки

description: The Law Factory is a research project which attempts to make it easier to observe the law-making process in the French Parliament. It allows to track down the different steps of the parliament process, to identify when a particular piece of law was introduced, and to look at all the amendments and the debates per article. The software is fully open-source, based on Python 3 for the data collection. It's a common project of the association Regards Citoyens, the médialab research lab of Sciences Po Paris and the Centre d’Études Européennes et de Politique Comparée. In this Talk we will present the work done and the research output produced.

uk: вхід без авторизації

name: The Law Factory: Research on the french law-making process: What happens when you try to put the law into git


uk: Комп'ютерні науки

description: This talk aims to give a user’s perspective on FLOSS tools for open research in social science. It will be based on personal experience with a team project that aimed to analyze the Twitter follow graph of last year’s FOSDEM and CHAOSScon participants. The project used open source tools and agile management: data was collected with a command line tool (Twarc), network visualization was done with Gephi, and Framagit provided a collaborative framework for managing code, data, visualization and text. Implementing this project led to insight about what it takes for social scientists who have minimal tech knowledge and culture, to practice open research with FLOSS tools. This talk will specifically address three types of challenges I faced : training, documenting, and collaborating. This talk will be particularly relevant for people who are designing FLOSS tools in interdisciplinary research environments. More generally, it can be of interest to people who attended the Open Research Tools and Technologies devroom talks in 2020.

uk: вхід без авторизації

name: FLOSS meets Social Science Research (and lived to tell the tale)


uk: Комп'ютерні науки

description: In this talk we present the experience of the software produced, as part of the research activities, at the French Gaspard-Monge Computer Science laboratory (Laboratoire d'informatique Gaspard-Monge or LIGM in French). The LIGM has an important production of research software with 66 software items identified for the period 2013-18, where 50 have been disseminated as FOSS. Since 2006, the Lab has worked in order to improve the dissemination and the visibility conditions of this research production [1], which includes the adoption of policies and the production and maintenance of a catalogue. In this context, one of the first issues we had to deal with was the concept of the Lab's software, in order to answer the questions of the researchers. The second concept was the identification or reference (or citation form) of such objects. The concept of "Logiciel d'un laboratoire" [1,2] initially proposed in 2006 has since then evolved to become research software ("Logiciel de la recherche") and it is a central concept in order to propose services and infrastructures to deal with this production in the current Open Science global context evolution [3,4], where the goals are to make it visible, accessible, reusable. It is also a central concept in order to propose research evaluation procedures related to this scientific output [5].

uk: вхід без авторизації

name: Free/Open source Research Software production at the Gaspard-Monge Computer Science laboratory (LIGM): Lessons learnt


uk: Комп'ютерні науки

description: Many open-source libraries provide an interface for the Twitter API. However, most people use these tools in temporary scripts for a one-time tweets collection. Moving to a robust application for collecting and indexing tweets over long periods of time requires some programming knowledge that most social science researchers do not master. In order to meet this need, the medialab has developed gazouilloire, a tool that makes it possible to easily configure the collection parameters (keywords searched, language of tweets, location of tweets, etc.) and can then be launched from the command line. Gazouilloire combines two methods to collect tweets from the Twitter API ("search" and "filter") in order to maximize the number of collected tweets, and automatically fills the gaps in the collection in case of connexion errors or reboots. It also provides a large range of features that are not directly available from the free Twitter API: collecting during specific periods of time, resolving redirected urls, downloading only certain types of media contents (only photos and no videos, for example) or unfolding Twitter conversations. The user can then choose to export the tweets in csv format, and select the fields that will form the columns of the table. Social science researchers have already used gazouilloire for a wide variety of studies: measuring online activity during COVID-19 lockdown, studying the public discourse of anti-vaxxers, or monitoring urban nature policies, among many others...

uk: вхід без авторизації

name: Gazouilloire: a command line tool for long-term tweets collection


uk: Комп'ютерні науки

description: Open source software powers incredible scientific and research discoveries, from images of the black hole in 2019, visualising proteins in 3D virtual reality, and open source hardware can affordably save lives during the COVID-19 pandemic. Despite this, the academic credit/metric system does not incentivise or reward activities around code sharing, instead preferring to use research papers, and citations for structured reward and promotion systems. In this short talk, we will share the vision of the Wellcome Trust Data for Science and Health team, which is working over the next five years to incentivise the foundational tools, trust, and talent required to recognise and fund open research software sustainably. Picture Sam, a researcher in a white coat: they spend hours in the lab with their beakers, test tubes, and agar plates. Once they’ve gathered results they think the world will want to know, they write up their conclusions, publish in a journal, and repeat. While this type of research has existed for a long time, and will continue to do so, this model doesn’t effectively acknowledge newer scenarios, where machines and mass data collection result in what is often referred to by the now-buzzword “big data” – data at a scale where it must be managed and analysed with the use of computers. This type of research gap is often addressed by Joy, the computational researcher. Joy may identify as a coder, a researcher, an engineer, a data scientist, support staff, a lab assistant, or some other title. The main theme is that Joy writes computer code in order to make their job easier, or perhaps even to make it feasible at all. Given that this computer code feeds into and creates the end results, it is reasonable to consider it a research method, albeit a less traditional research method or output than the research paper. In the current world, Joy is typically less supported than a more traditional academic like Sam: Fewer funding calls exist for funding code work, and ever fewer recognise or reward good open source behaviour, even though an incredible number of scientific analyses rely on open source software themselves, and even though the perils of not sharing research code could be completely wrong scientific results that don't look wrong since no-one can see inside the black-box of proprietary code. Things have gotten a little better - there are scientific journals that accept software papers, and even journals that are exclusive to open source software papers, but they're far from the norm. We still have a long way to go. In order to make real progress, research code must be open to allow others to verify, re-use, and build upon it. This includes recognising and funding underfunded areas such as open source community management, accessibility, software maintenance, and user experience. The Wellcome Trust has dedicated £75 million GBP over the next five years towards making trustworthy data science a first-class citizen in the research ecosystem. By sharing our vision with others in the open source world we hope to encourage this attitude, meet others working towards the same goals, and meet prominent contributors to the open source research ecosystem who might be looking for funding opportunities.

uk: вхід без авторизації

name: Open research in life science: funding foundational tools, trust, and talent


uk: Комп'ютерні науки

description: As technology advances, so as our maps. In this talk, we will explore the ever growing open map data that can help us understand, validate, and explore socio-economic indicators with the aid of network theory and machine learning techniques. Participants will learn what data are available in OpenStreetMap that can be used to profile cities and municipalities for socio-economic conditions based on proxy variables. These variables include existence of businesses through establishments and buildings, road network densities and complexities, topographical features, vegetation and water indices, etc. Machine learning models will be used for categorization aided by graph metrics. Results will be cross validated with existing city/municipality tags.

uk: вхід без авторизації

name: OpenStreetMap Features as Proxy to Socio-Economic Indicators: A Network Theory Approach


PANDORÆ - Core

uk: Комп'ютерні науки

description: PANDORÆ : Retrieving, curating and exploring enhanced corpi through time and space Mapping the state of research in a particular field has been made easier through commercial services providing API-based bibliometric-enhanced corpuses retrieval. Common assertions such as “the use of CRISPR technologies has skyrocketed in laboratories all around the world since 2012” can now be easily verified in both quantitative and qualitative perspectives using those platforms. Such services as Elsevier’s Scopus propose inbuilt functions to explore corpuses chronologically and geographically. They don’t, however, allow for hand curation and enrichment of the corpus. This lecture advocates for a solution to this methodological issue using PANDORÆ, a free and open source software designed for that purpose. PANDORÆ requests corpuses from the Scopus API, enriches its data by geolocating each document’s affiliations, and then uploads the resulting dataset to a Zotero library. The user is then free to curate the corpus, adding, editing or removing items. PANDORÆ allows downloading it back from Zotero to its internal databases, and to display the enriched corpuses on a map, on a timeline, or as an author-directed force-layout network graph. This presentation will also introduce more advanced PANDORAE features, such as displaying Twitter dataset obtained through Gazouilloire, mapping web entities loaded from Hyphe and scraping biorXiv results using Artoo.

uk: вхід без авторизації


uk: Комп'ютерні науки

description: Having started on a very typical path for open source projects - needing to solve our own problems - we were struck by the challenge that our technology wouldn’t be sufficient for our eventual goal: improving the culture and process of scientific publishing. The challenge is not only technologically broad and complicated - but there are also enormous cultural and operational logistics needed to approach real solutions. Not least of which is the ability to provide resource-constrained, technologically-limited organizations with the stability and support they need to make commitments that will last years if not decades. We’ll share our experience with PubPub and the Knowledge Futures Group (a non-profit organization dedicated to building digital infrastructure as a public utility), what it’s taught us about building sustainable open source products, and welcome contributions to make our work more supportive and inclusive of the entire knowledge community.

uk: вхід без авторизації

name: Open source isn't enough. Working towards sustainable solutions with PubPub.


uk: Комп'ютерні науки

description: RAWGraphs is an open source web application for the creation of static data visualisations that are designed to be further modified. Originally conceived for graphic designers to provide a series of tasks not available with other tools, it evolved into a platform widely used in research and data journalism contexts that provides simple ways to map data dimensions onto visual variables. It presents a chart-based approach to data visualisation: each visual model is an independent module exposing different visual variables that can be used to map data dimensions. Consequently, users can create complex data visualisations. Finally, the tool is meant to produce outputs that are open, that is, not subjected to proprietary solutions, which can be further edited. Thanks to an intuitive user interface and experience drafting visualizations become an easy task, enabling the user to produce the visualizations not only as a mere output but also as a tool within the research process. Last year we launched a successful crowdfunding campaign to raise funds for the redesign and development of a new version of RAWGraphs, that will be released in the first months of 2021. The new version is written from scratch with the aim to make the tool more flexible for customisation and to create an active community also on the development side. The talk aims at presenting how RAWGraphs has been used in research context and our strategies to keep the project free, open source, economically sustainable and independent.

uk: вхід без авторизації

name: Rawgraphs: An open visualization framework for open outputs


uk: Комп'ютерні науки

description: The ReplicationWiki provides an overview of published empirical studies in the social sciences with information on data and code availability, data sources, and software. One can search for keywords, Journal of Economic Literature codes, and geographical origin of data. It informs about 670 replications, that is studies reanalyzing previously published results, as well as corrections and retractions. The wiki helps researchers to compare their results to those of previous studies. It is a resource that helps to identify useful teaching examples for statistical methods, replication and studies of social science. It allows advanced students and practicing researchers to find guidance on how to publish their replication research in various journals. A collection of teaching resources, useful tools, and literature helps instructors to integrate replication into their teaching and students to integrate open science practices into their own research. With the ongoing expansion of the wiki, currently covering more than 4,500 empirical studies, it is becoming an ever more powerful tool for social science research and education. It is a crowd-based platform where users can add their own replication results, suggest studies that should be replicated, and identify for example further data sources used in the empirical studies, especially ones from countries underrepresented in the literature and for whom economic policies are thus difficult to investigate. The Wiki uses Semantic Media Wiki technology that is evolving, and a number of technical improvements in terms of usability and database structure are planned. A massive expansion of the content is planned based on machine learning and natural language processing techniques identifying the relevant information from the available data. For the technical improvements further expertise is welcome, and for the content expansion developers and researchers from all fields of the empirical social sciences are invited to join.

uk: вхід без авторизації

name: ReplicationWiki - Information on empirical studies in the Social Sciences: Informing about Data & Code Availability and Published Replications


uk: Комп'ютерні науки

description: Reverse-engineering investigations implies to be able to reconstruct and experiment with the methods and information acquired in the initial process in order to visualize what elements are indispensable to how a "system" works. It also allows one to figure out what elements could be removed, replaced with more contextual information if the method can be replicated, or "hacked" to make the "system" or method work differently in other settings. Methodology & Major Findings: We are experimentally trying to revisit the practice of reverse-engineering to explore these possible and effective contributions in the case of investigation (journalism, activism, science, art). We engage with different techniques, tools and methods along with the individual practices of those working at the new frontiers of investigation. We all come from very different research and professional backgrounds, use different methodologies and techniques, investigate very different things. From a software perspective, reverse-engineering is used for: - industrial espionage - cracking - exploit creation - security audit - bug correction - malware analysis - interoperability - scientific study - fun.

uk: вхід без авторизації

name: Reverse-engineering as a crossroads for investigation, science and open tools and technologies: We are experimentally trying to revisit the practice of reverse-engineering to explore these possible and effective contributions in the case of investigation (journalism, activism, science, art).


uk: Комп'ютерні науки

description: schema-collaboration is a tool that helps data managers and researchers to collaborate on documenting datasets using Frictionless Data schemas. It uses Frictionless Data Package Creator and allows the collaborators to create and share dataset schemas, edit them, post messages and export the schemas in different formats (text, Markdown, PDF). The tool is implemented in Python and Django. The talk will consist of a brief explanation of Frictionless Data schemas, how data managers work with researchers and then I shall do a demo of how the tool can be used.

uk: вхід без авторизації

name: Collaborating to describe datasets using Frictionless Data schemas: schema-collaboration


uk: Комп'ютерні науки

description: Google Scholar, Web of Science, Scopus, Dimensions, Crossref, Scite.ai, ... What used to be the home turf of for-profit publishers has become a buzzing field of technological innovation. Scholarly metrics, not only limited to citations and altmetrics, come from a host of data providers using an even wider range of technologies to capture and disseminate their data. Citations come as closed or open data, using traditional text processing or AI methods by private corporations, research projects or NGOs. What is missing is a language and standard to talk about the provenance of scholarly metrics. In this lightning talk, I will present an argument why we need to pay more attention to the processes of tracing and patterning that go into the creation of the precious data that determine our academic profiles, influence hiring and promotion decitions, and even national funding strategies. Furthmermore, I present an early prototype of Metrics in Context, a data specification for scholarly metrics implemented in Frictionless Data. Additionally, the benefits and application of Metrics in Context is presented using both traditional citation data and a selection of common altmetrics such as the number of Tweets or FB shares.

uk: вхід без авторизації

name: Metrics in Context: Towards A Data Specification For Scholarly Metrics


uk: Комп'ютерні науки

description: This talk will focus on our experiences with making open source tools for the study of social media platforms (amongst others, DMI-TCAT for Twitter, the YouTube Data Tools, and 4CAT for forum-like platforms such as Reddit and 4chan) in the context of social science and humanities research. We will discuss questions of reliability and reproducibility, but also how tools are taking part in shaping which questions are being asked and how research is done in practice - making open source particularly relevant as a form of methodological transparency. Two aspects have become particularly important for our tool-making practice: the relationship with large platform companies and their Web-APIs as well as concerns about user privacy and legal compliance with regulations such as the GDPR. Our talk will address these in turn, scoping the issue and proposing ways forward.

uk: вхід без авторизації

name: Making Tools for Social Media Research: Principles and (Future) Challenges


uk: Комп'ютерні науки

description: Software Heritage is a long term, non profit, multistakeholder initiative with the ambitious goal to collect, preserve and share all source code publicly available, protecting our Software Commons, in collaboration with UNESCO. In this presentation we will share recent developments in the Software Heritage archive that make it the ideal platform for archiving, referencing and citing research software: it's a stepping stone for reproducibility and for raising awareness about the importance of software in research.

uk: вхід без авторизації

name: Archiving, referencing and citing research software in Software Heritage


Using ElabFTW for materials science

uk: Комп'ютерні науки

description: Keeping work organized in experimental materials science research is a nightmare. Projects involve data collected with dozens of different instruments on dozens of different samples that are related to eachother in a hierarchical fashion. For each new project, researchers struggle with questions like: how should I organize my files and data? How should I name my samples? How should I keep track of the links between data and samples? Since no standard answer to these questions has been formulated, labs and individuals just improvise. The result is that most data and samples become utterly useless once the person who conducted the research leaves; no one else can find their way through the ad-hoc naming conventions and various excel sheets. This eventually translates into a lot of wasted and repeated efforts. The biological sciences have long ago figured out solutions to these problems, and they are lab information systems (LIMS) and digital lab notebooks. In this talk I will present how I organize my research workflow in eLabFTW, a free and open source lab notebook with some LIMS capabilities. The tool was originally developed with molecular biologists in mind, but most of the tooling is useful for materials scientists. I will also talk about how I could leverage the python API for tailoring the tool to my needs, for example for printing QR-code stickers for database items.

uk: вхід без авторизації


uk: Комп'ютерні науки

description: The World Wide Web’s original design as a vast open documentary space built around the concept of hypertext made it a fantastic research field to study networks of actors of a specific field or controversy and analyse their connectivity. Navicrawler, IssueCrawler, Hyphe... Over the past 15 years, a variety of web crawling tools, most often free and open source, have been developped by or for social sciences research labs across the world. They provide means to engage with the web as a research field or to teach students what the WWW is beyond Google or Facebook’s interfaces. We will first present an overview of this history of open source web crawling tools built for research, teaching or data journalism purposes. Then we will propose a short demonstration of the latest version of médialab's HyBro, aka Hyphe-Browser, a tool built to let users benefit from automated web crawling as well as in situ web browsing and categorizing. Its friendly user interface allows a variety of publics to engage with web crawling, including non-experts like students, social science scholars, and activists.

uk: вхід без авторизації

name: From Navicrawler to HyBro: a brief history of webcrawlers for social sciences


uk: Комп'ютерні науки

description: We all know that Ada Lovelace is credited as the first computer programmer. But what did she write? What did it do? And how does it work? We look at the program, its function, and break it down line-by-line so you can understand the origins of our entire industry. After all, it doesn't get any more retro than this! In this talk, developer, geek, and digital archaeologist, Steven Goodwin, breaks down the very first program ever written to explain what it does and how it works. He goes on to simulate it within a JavaScript version of Babbage's analytical engine, rewriting it piece-by-piece until it looks like modern code, and thereby demonstrate what features of current languages we now all take for granted. He finishes up with a discussion on the controversy surrounding her involvement in computing, aiming to answer the question once and for all - "Was she really the first programmer?"

uk: вхід без авторизації

name: Ada Lovelace and The Very First Computer Program


uk: Комп'ютерні науки

description: Your computer only supports 16 text colors, and 8 background colors. Why so few colors? And why is there a "Bright Black"? This fun lightning talk will explain the origins of these 16 colors, and why the colors look the way they do.

uk: вхід без авторизації

name: Why your PC only has sixteen colors: And what is "Bright Black" anyway?