Open Source People Network (OSPN) Japan Special track

Greetings from Masafumi, the organizer/moderator of OSPN Japan track and introducing speakers/sessions on Day 1

講者

Masafumi Ohta

Masafumi has been running the Raspberry Pi community in Japan and is an IT consultant for the public sector. He used to be a core contributor to the OpenSolaris project and now contributes to many more OSS projects in Japan. Masafumi has taught OSS licenses and compliance at a Japanese university, and He is now looking for/investigating many more incidents about OSS licenses and compliance for my lecture.

PostgreSQL is a globally renowned open-source database, widely utilized across various industries. It was honored as the DBMS of the Year in 2023 by DB-Engines Ranking[1]. One of the key factors contributing to its popularity is its extensibility. Extensions allow users to add new features to PostgreSQL. Despite many users' desire to create extensions, a clear guide on where to start has been lacking. Last year, I gave a talk on taking the first steps towards developing extensions[2]. This year, I will present a more advanced lecture. Initially, I will explain how to develop a simple extension, followed by a detailed exploration of my developed extensions that provide features like "Automatic Query Execution Plan Tuning" and "Automatic Hint Clause Generation" through the extension pg_plan_advsr[3]. I will explain the hooks used, the mechanisms involved, their impacts, and provide demonstrations. The intended audience includes individuals interested in PostgreSQL, those eager to develop extensions, and anyone keen on query performance enhancement. My hope is that this talk will contribute to the growth of the PostgreSQL community. [1]: https://db-engines.com/en/blog_post/106 [2]: https://coscup.org/2023/en/session/V3YWCF [3]: https://github.com/ossc-db/pg_plan_advsr

講者

Tatsuro Yamada

Tatsuro Yamada is a PostgreSQL Support Team Leader for NTT Open Source Software Center. He continues contributing to the PostgreSQL community and is an Oracle_fdw committer, pg_plan_advsr author, and officially recognized PostgreSQL contributor. He has been a speaker for the promotion of the PostgreSQL community and was a speaker at Postgres Conference Japan 2014, PGCon 2016, PGConf.Eu 2018, PGConf.Asia 2019, among others. For PGConf.Asia, he contributed as one of the organizing members from 2017-2022.

It is said that Object-Oriented is important or Object-Oriented is difficult, but what is Object-Oriented? In fact, there is no widely agreed definition. In this session, I want to talk about what is the thing that is represented only by Object-Oriented, and how to use or not to use Object-Oriented.

講者

Naoki Kishida

Java enthusiast. Live in Fukuoka, Japan. Publishing "プロになるJava(To become Java Professional)" which is Java beginners book to learn Java knowledge required on a field that contains Java syntax, library, JUnit, Git, Spring Boot.

Since 2021, the presenter has offered a programming course on developing applications using Ruby and Ruby on Rails at their university. Delivered online, the course has posed challenges for some students due to its demand for advanced programming skills. To address these difficulties, the bulletin board system (BBS) functionality integrated into the learning management system was leveraged during the academic years 2022 and 2023. This presentation will unveil the findings of text analysis conducted on the questions and answers exchanged on the BBS. It aims to offer insightful and actionable suggestions for educators, trainers, and individuals delivering programming education.

Download Slide

講者

Jun Iio

Dr. Jun Iio was born in Gifu in 1970. He received his Master's degree in Mathematical Engineering and Information Physics from the University of Tokyo in 1994 and joined Mitsubishi Research Institute, Inc. in the same year. He has been a visiting associate professor at the International Center of Tokyo University of Agriculture and Technology since 2009. In 2013, he became an Associate Professor at the Department of Socio-informatics, Faculty of Letters, Chuo University, a Research Fellow at the Institute of Science and Engineering, Institute of Social Science, Chuo University, and a Professor at the same department at the same university from 2014. He is now a Professor at the Faculty of Global Informatics at the same university since 2019. He is engaged in research on the interaction between humans and information systems. His research keywords are image processing, user interface, optimization of information systems, etc. He is an HCD-Net certified human-centered design expert, Professional Engineer (Information Engineering), and Ph.D. in Engineering.

Recently, there has been a growing trend of running database products on Kubernetes. In this article, the author shares their experience of deploying and managing MySQL on Kubernetes, highlighting some of the challenges they faced as a beginner, including the pitfalls they encountered and how they overcame them. This presentation will describe the technical challenges we have encountered with MySQL, MySQL Operator, and MySQL on Kubernetes, and the approaches we have taken to address them. There are various possibilities for individuals who are not specialized in DB engineering to collaborate with MySQL. This presentation is intended to serve as a reference for those who are beginner to databases.

講者

Shizuka Yasukochi

Infrastructure Engineer. Enjoying building Kubernetes and deploying applications on it since last year. At COSCUP2023, she presented "Digital twin workbench with Jupyter hub/lab and Hadoop/Spark/Kafka for geospatial-temporal applications.

Automotive Grade Linux is a open source technical community. It aim to build common linux software stack for automotive use. What is strong point of it? We are focusing to integration not only a common software development. We are invest new technology to incubate new value for automotive. In this session, we present our activity such as In Vehicle Infotainment, Instrument Cluster, Software Defined Vehicle, and more.

Download Slide

講者

Naoto Yamaguchi

Developer of embedded linux for automotive since 2011. AGL and AGL Japan local community member. Mainly developed linux container for embedded since 2019.

Raspberry Pi 5 was released at the end of September; it is almost renewed compared with old models. What do you need to look deeply to bite the new Pi? Masafumi will talk about deep-diving the Pi5's latest feature with some demos and its development stories and discuss what is useful in the new Pi5, unlike old models.

Download Slide

講者

Masafumi Ohta

Masafumi has been running the Raspberry Pi community in Japan and is an IT consultant for the public sector. He used to be a core contributor to the OpenSolaris project and now contributes to many more OSS projects in Japan. Masafumi has taught OSS licenses and compliance at a Japanese university, and He is now looking for/investigating many more incidents about OSS licenses and compliance for my lecture.

Greetings from Naruhiko, the organizer/moderator of OSPN Japan track and introducing speakers/sessions on Day 2

Download Slide

講者

Naruhiko Ogasawara

Naruhiko Ogasawara is a security engineer in Japan. His expertise lies in vulnerability detection through source code static analysis for applications. He is also an avid enthusiast of desktop OSS, favoring LibreOffice and Ubuntu. He is a watcher of Linux printing technology. He is a former member of The Document Foundation and OpenPrinting Japan.

Yuki Otsuka provides an overview of Lean4 and provides materials and tools to help you learn. Lean4 is an open-source theorem-proving support system and an environment that can also be used as a programming language. His presentation will not be an industrial introduction to the theorem-proving support system but will be introducing Lean4 as an environment for learning logic and mathematics through Lean4.

講者

Yuki Otsuka

Yuki Otsuka is a Japanese university student with a strong interest in open-source technologies, programming languages, programming language theory, and programming language type systems. He is a member of the Japan openSUSE user group and served as a volunteer staff member at the Linux Foundation's Open Source Summit Japan.

LibreOffice Asia Conference 2024 is being held in Taipei at the same time as COSCUP. Chinese, Japanese, Korean (CJK) users need different features than other languages. Language and culture dependent features and usage are important for productivity software such as LibreOffice. This talk will introduce some recent problems encountered in the CJK user environment of LibreOffice and how to improve them. Patterns of CJK language specific problems can be common across different software. Therefore, it may be applicable to other smartphones and desktop apps as well. The LibreOffice project is an aimed at multilingualism, as stated in The Document Foundation’s “Our Values” of “Our Next Decade Manifesto” that anyone can translate so that everyone can use it in their mother tongue. https://www.documentfoundation.org/pdf/tdf_manifesto.pdf However, LibreOffice developers are mostly in Europe, and in order to use them conveniently in other languages, those who understand those languages ​​need to solve the problem. LibreOffice 's CJK and problems unique to the Japanese environment are various such as vertical writing, external characters, phonetic, currency and date notation. Sometimes CJK regression bugs occur in the LibreOffice project. It is important to strengthen user’s feedback loop approach. We have to be able to explain it to people from different cultures. It is also important that CJK people actually try to fix the CJK bugs. From COSCUP 2019, I introduced typical LibreOffice's CJK bugs every year. In this talk, I will present some of the major recent issues and episodes in CJK environment. I will also introduce activities in Asian communities and TDF's efforts in non-European languages.

Download Slide

講者

Shinji Enoki

Shinji Enoki is a member of the LibreOffice Japanese Team and The Document Foundation. He focuses on organizing events and community and sometimes on QA activities. His other community activities are a volunteer staff of Japan UNIX Society, a volunteer staff of KANSAI OPEN SOURCE, etc. He is a freelance and developing LibreOffice support business with iCRAFT Corp.

Explore the potential of RISC-V technology and its compatibility with Ubuntu in this presentation. We will provide an overview of RISC-V and its significance in the computing world, along with Ubuntu's support for RISC-V Single Board Computers (SBCs). The focus will be on VisionFive 2, a readily available RISC-V SBC, explaining how to install Ubuntu 24.04 LTS on its SSD, including necessary modifications and the use of preinstalled versus live server images. Attendees will also learn about utilizing VisionFive 2's peripherals like cameras and HDMI with Ubuntu. This presentation aims to inspire exploration and appreciation of the possibilities within the open-source ecosystem. Ubuntu is a popular free operating system. We will show how Ubuntu supports RISC-V computers, especially the VisionFive 2 board. You will learn how to install Ubuntu on VisionFive 2 and use its features like cameras and HDMI. This presentation is for anyone interested in new computer technology and open-source software.

講者

Mitsuya Shibata

Mitsuya is a software engineer working in Japan, developing embedded devices and network devices while also contributing to FLOSS development. He is also a member of the Ubuntu Japanese Local Community Team and writes regular lolumns and articles related to Ubuntu for numerous IT magazines and technical websites.

"MyDNS" is a Dynamic DNS service that associates the IP address of your server with the registered Domain Name. Would you build and operate your own servers in your environment on desktops, laptops, VPS services, clouds, or etc? You can have good experiences to improve your skills through those activities! Takeshi will introduce his Dynamic DNS service - MyDNS and talk related updates. If you are interested in keywords 'MX', 'PSL', and 'Phishing Sites', you should listen to his talk.

Download Slide

講者

Takeshi Kaburagi

Takeshi Kaburagi has been operating his own DDNS service, "MyDNS", as a hobby for over two decades. His experience ranges from waste incineration plants to space station systems and programs.

Searching through a vast collection of comics can be challenging. We often rely on matching titles, words, descriptions, publication years, character names, and publishers. But what about categorizing comics by genre or other intriguing criteria? In this session, we’ll explore Vector Index, a powerful index now use with relational databases and graph databases. We'll cover the basics of indexes, demystify Vector Index, and showcase its potential for more effective searches.

Download Slide

講者

Koji Annoura

Koji Annoura is a highly experienced full-stack developer with over 40 years of experience. He has been engaged in Agile software development since 2009 and played a pivotal role in establishing the "Neo4j Users Group Tokyo" in Japan. Moreover, in 2021, he founded the "Apache Hop User Group Japan" Koji has actively contributed to numerous companies and teams, guiding them through the Agile transformation process and facilitating the implementation of Agile and Scrum methodologies. An accomplished author, Koji has made significant contributions to "The Practical Guide to MacOS X Server" Additionally, he serves as a technical reviewer for "Graph Data Processing with Cypher

The open-source supply chain issue has attracted considerable attention. Therefore, there is a focus on managing software dependencies and vulnerabilities using SBOM (Software Bill of Materials). In this talk, he will discuss how to create an SBOM from software dependencies using Dependency-Track, an open-source tool developed primarily by OWASP, and CycloneDX, a SBOM format, to visualize vulnerabilities in the software being developed.

Download Slide

講者

Naruhiko Ogasawara

Naruhiko Ogasawara is a security engineer in Japan. His expertise lies in vulnerability detection through source code static analysis for applications. He is also an avid enthusiast of desktop OSS, favoring LibreOffice and Ubuntu. He is a watcher of Linux printing technology. He is a former member of The Document Foundation and OpenPrinting Japan.