Discover how open-source technologies are transforming Indonesia's business world, fostering innovation, collaboration, and self-reliance. Embrace the power of open source to strengthen independence and drive sustainable growth!

YDB is a versatile open-source Distributed SQL database management system that combines high availability and scalability with strong consistency and ACID transactions. It accommodates transactional (OLTP), analytical (OLAP), and streaming workloads simultaneously. It is publicly available under Apache 2.0, one of the most permissive open-source licenses. In this talk, I'll introduce the system and explain how it can be used to build reliable data-driven applications that implement business-critical processes.

This session will provide a comprehensive guide on releasing code to the public, exploring the benefits, step-by-step instructions, and practical tips based on my personal experience.

Open-source technologies offer a powerful, cost-effective way to bootstrap a startup, enabling founders to minimize costs, iterate quickly, and scale efficiently. In this session, I'll explore how to select the right open-source tools, leverage community support, and build a sustainable business model around open technologies. Attendees will gain actionable insights on reducing infrastructure and software costs, fostering collaboration, and developing an agile, scalable startup without heavy reliance on venture capital.

Group Photo

Co-location pattern mining is one of spatial data mining technique originated from Shashi Shekhar to find 2 or more spatial data neigborhood. Finding Co-location pattern mining is useful for City government, Public health, Bio diversity, etc.
The spatial data comes from Open street map which transformed to PostgreSQL with PostGIS and processed with Flask and Leaflet to find some measurements which finally find co-location pattern. Besides finding some measurements such as participaion index, participation ratio and conditional probability, it will display the map over Open Street map.
There will be short theory about Data Mining and Spatial data mining. There will be theory about Co-location pattern mining and its implementation.

KubeVirt is one of CNCF project and KubeVirt can provisioning vm on top of kubernetes, is kubevirt fuction can replace the existing IaaS in future? in this session I want to break down how KubeVirt works and we will see how good and bad point from kubevirt as IaaS

This talk will challenge the conventional separation of web APIs and front-end Single Page Applications (SPAs) by demonstrating how full-stack engineering is possible using predominantly front-end programming languages. This session explores how Next.js enables this paradigm shift by seamlessly blending front-end and back-end development into a unified solution.

We'll demonstrate how to build cloud-native applications using Next.js, an open-source framework that leverages modern container orchestration platforms like Docker and Kubernetes for scalable, distributed deployments. Additionally, we'll explore best practices for integrating modern databases such as PostgreSQL, showcasing a comprehensive approach to full-stack development.

Open Source is more than just a practice of Software collaboration, it’s a powerful platform that facilitates personal and professional development. Throughout the session, attendees will gain understanding on the importance of open source contributions in sharpening technical skills, creating professional networks, and even building a portfolio of projects. These traits will collectively contribute to standing out in the industry!

Whether you are a seasoned contributor or just getting starting in the space, you’ll learn how open source can unlock new opportunities. Through real-life examples and practical insights, we’ll share how developers can find the right projects, make impactful contributions and leverage the ecosystem to accelerate professional growth and success.

The complexity of modern data solutions goes far beyond the capabilities of modern relational databases. Some real-world relationships like social networks, blockchain transactions, network perimeters, and others are challenging when you try to model them within a relational or document database. But those problems are manageable if you solve them using graphs, nodes, and edges.

Neo4j is a popular and widely used graph database management system designed for storing, managing, and querying data using the principles of graph theory. It is designed to handle data that has complex relationships and connections, which may not be efficiently represented in a traditional relational model. Moreover, it has a fantastic, straightforward integration with Python, making it usable for solving data science, analytics, networking, etc.

In the following session, I will share my experience using the Neo4j database in the cloud computing space. I will cover how to analyze and visualize network relationships using Cypher, the Neo4j query language, PyVis, and NetworkX, the Python graph libraries. By the end of the presentation, the audience should understand the basic graph theory and how to apply it to solve their problems using Neo4j and Python.

Google Summer of Code (GSoC) is a unique opportunity for students and new contributors to dive into the world of open-source development. In this session, I’ll walk you through how GSoC works, what benefits it offers, and how you can make the most of it. Whether you're looking to enhance your coding skills, build real-world experience, or contribute to impactful projects, GSoC can be a game-changer. You’ll learn how to get started, tips for applying, and how to make meaningful contributions to open-source organizations. Join this session to discover how you can turn your passion for coding into a rewarding global experience.

In this session, I'll share my journey of building an AI-powered copywriting assistant, focusing on how developers can leverage Large Language Models to create practical AI applications. The talk will cover the technical implementation, challenges faced, and lessons learned in developing an AI tool that helps users improve their writing skills. We'll explore real-world examples of how AI can enhance human creativity rather than replace it

Open source adoption has been steadily increasing across many organizations in recent years. We will be sharing inspiring success stories and valuable lessons learned during the open source journey. Attendees will gain valuable knowledge on best practices in open source, maintaining code quality, fostering inclusivity, and contributing meaningfully to the open-source community. The session will include : overview of Open source development, Success Strategies, Lessons Learned and overcoming challenges, Contribution to Industry Standards, Best Practices and Collaborative Development, Conclusion and key takeaways etc. Throughout the session, we will explore the paths followed by successful projects, uncovering the lessons learned from overcoming challenges and adversities. Don't miss this transformative opportunity to master best practices, learning through lessons learned, foster innovation, and become an integral part of the open-source triumphs.

Hey there, Mario! You’ve entered the Open Source Kingdom, where the mission is to build and nurture developer programs that thrive. As you navigate your way through the adventurous realms, you make sure you carve a storytelling arc so powerful that magnetizes the developers around your product or technology. Through your knack for crafting First-Time User Experiences that are comprehensive yet intuitive, you onboard the right set of audience for your technology. Just like your journey through the Mushroom Kingdom, this adventure is filled with power-ups, challenges, and opportunities to level up.
In this talk, we'll explore how the strategies that make Mario's quests so iconic can be applied to designing a dynamic and engaging Open Source Developer experience.

The best part is that just like every character in the Mushroom kingdom has a story to tell, so does every developer. And leveraging these unique stories, one can create a compact network of allies that believe in community loyalty. Through the talk we discover that this isn’t a linear path, there are challenges involved and with challenges come mistakes but mistakes give an opportunity to iterate and restart! That’s how the feedback loop ensures the improvement of both: the game as well as the community.

CogniCity Open Source Software (OSS) is the largest and first open source project of its kind to prove the value of integrated social media and API-sourced data for the civic co-management of disasters. First tested in Indonesia, the software has now been adopted and adapted by groups across the region to address a wide range of urban challenges.

Bringing together experts with a diverse set of backgrounds and experience in utilizing and contributing to CogniCity OSS, this session will explore how the design and development of open source systems can harness the power of crowdsourcing to aid disaster and humanitarian response and recovery. Highlighting the relationship between software and social behaviours, the session will discuss how a multi-sectoral design methodology can help shape the development of softwares for next generation disaster risk management. The session will expand on the significance of open source softwares as knowledge sharing infrastructures in the ASEAN context; allowing experts from different backgrounds and geographies to share, exchange, and create ideas for the future of humanitarian management.

This presentation delves into the ethical considerations surrounding generative AI art, showcase the innovative attribution and compensation mechanisms implemented in Lawful Diffusion, and discuss the potential for building a more sustainable and inclusive creative community through open-source collaboration.

How the Postgres was created. Key principals of community that supports continues system development and technological leadership. Openness, independence and extensibility of Postgres. From university project to most popular database in the world.

As Indonesia accelerates its digital transformation, PostgreSQL stands out as a powerful, open-source solution to meet the growing demands of local industries. In this 15-minute keynote, we’ll explore how PostgreSQL is enabling businesses across sectors like e-commerce, fintech, and public services to build scalable, cost-effective systems. With real-world examples, we’ll showcase how PostgreSQL is driving innovation and supporting Indonesia’s digital-first future. Whether you're a developer or business leader, discover how PostgreSQL can empower your organization to scale and innovate.

At Adjust, one of the systems we worked with was a massive log management solution we called Bagger. This system had up to 10 PB of log data in it and handled it without a scale-induced problem. We always wanted to open source it but never had the time. More recently I (and several of my former colleagues) have been writing a workalike from scratch.

In this talk we discuss why we built it, the overall architecture, the state of the project and the code, and the sort of scale-based tradeoffs that we made. This will be helpful for anyonethinking about moving to a distributed data environment.

This talk introduces OpenStreetMap (OSM) projects, data licensing, and governance, followed by the basics of OSM data, architecture, and components. It helps people understand what OSM is, how it was started, and how you can use and work with the data and even contribute to the projects. While you don’t need a tech background, there will be a section aimed at programmers and data scientists interested in this topic.

There are many things to implement free and open spatial data, such as disaster response mapping to evacuate the victims, and road network mapping for transportation systems to foster urban resilience development. However, those can only be implemented when spatial data is available. Participatory mapping, as a collaborative map-making process utilizing OpenStreetMap as a freely accessible platform, involves the active involvement of government, scholars, and communities as key stakeholders. This approach is essential for collectively identifying and mapping geographic features, especially in disaster-prone regions, where sharing spatial data has historically posed significant challenges in Indonesia. The goal of participatory mapping is to generate and share openly available spatial data that can be accessed by the public, addressing the need for collective and accessible information in these urban areas.

Today’s modern applications must be Always-on, Always-available and serve a global user base that demands fast response times. A fully Multi-master Distributed Database architecture is critical for organizations to meet these demands. In this talk, we will explore the core use cases that benefit from deploying PostgreSQL with asynchronous logical replication in a Multi-region or even Multi-cloud environment. Learn how issues such as slow response times, maintenance or provider downtimes, data storage requirements, and throughput can easily be addressed.

In this session, explore how to build modern, scalable applications using PostgreSQL on Nutanix DBaaS. Discover the advantages of leveraging Nutanix’s Database-as-a-Service to streamline database management, improve performance, and enhance scalability for your PostgreSQL workloads. We’ll dive into real-world examples of how PostgreSQL, powered by Nutanix, supports faster app development, seamless deployment, and operational efficiency. Whether you’re a developer or a database administrator, learn how this powerful combination can elevate your modern app infrastructure.

The instructor will demonstrate how anyone can contribute to OpenStreetMap using laptop or mobile device. There 3 applications that will be introduced to the workshop participants, ID Editor, Go Map!!, and Vespucci. Participants will also learn how to track their contribution within OpenStreetMap community.

PostgreSQL, offers specialized features that are particularly beneficial for organizations managing complex network infrastructures, such as Internet Service Providers (ISPs), telecommunications operators, and university campuses. Critical tasks in network management, including IP address allocation, network segmentation (subnetting), and subnet aggregation, are essential precursors to the deployment of routing protocols like Border Gateway Protocol (BGP) or Open Shortest Path First (OSPF).

Traditionally, network administrators have relied on general-purpose tools such as spreadsheets for these tasks. However, these tools are not inherently designed for IP address management, potentially leading to human errors such as IP address conflicts or overlapping subnets. Such errors can have significant implications for network stability and performance.

This presentation explores the utilization of PostgreSQL's specialized features, particularly the inet and cidr data types, as a more robust alternative to traditional methods. We posit that leveraging these purpose-built database features can substantially reduce the incidence of human error in network management tasks. By providing a structured and validated approach to storing and manipulating network address data, PostgreSQL offers a promising solution to enhance the accuracy and efficiency of network administration processes.

Connecting with fellow attendees during this 30-minute networking session. This is a great opportunity to meet industry leaders, exchange ideas with peers, and build meaningful connections in a relaxed, informal setting.

In today's fast-paced environment, downtime is simply not an option for large organizations, making High Availability (HA) crucial for maintaining uninterrupted operations. This talk will explore the essentials of HA and its importance for achieving near-zero downtime. We'll cover key concepts, including
- What HA is and why it’s critical for business continuity
- The fundamentals of Load Balancing
- Understanding Auto Failover mechanisms
- How pgpool can enhance performance

As a special feature, we'll showcase the open-source tool pg_cirrus, which automates the setup of a 3-node HA cluster. Simply provide the IP addresses of your machines, and pg_cirrus handles the rest—delivering a fully functional HA cluster with ease.

Zed is a pretty new code editor with a promising future. It is built from the ground up with Rust. It has interesting features such as a built-in LLM assistant with many models available, built-in Copilot support, built-in collaborative tools, and many more. However, since Zed is a new code editor, the available extensions are currently limited. Fortunately, language support extensions for popular programming languages are available. How about the niche one? Is there any language support for HAML yet? Let's kickstart our open-source contribution journey by making a language support extension for Zed!

Accessing Database from Application is one of the weakest point in the most system. Once the application breachs, with a less effort attacker can gain access into database as well. Data Encryption can protect you from physical stealing, when physical attacker or OS level attacker get into your system, but front end attacker from beaching application? that is another story. How can we protect our database from data leaks caused by front end attacker? Let's talk

Postgres Professional making Postgres useful for Enterprises. We added hundreds of features to support big databases and high load. A lot of efforts was spend to making Postgres secure enough to fit enterprise requirements. Built in clusters, data compression, TDE and so on.

Discover how Alibaba Cloud’s Apache Flink and Qwen can elevate your projects by harnessing real-time data processing and AI. Apache Flink lets you analyze streaming data on the fly, perfect for scenarios like live monitoring, recommendation systems, and anomaly detection. Paired with Qwen, Alibaba’s powerful language model, you can unlock advanced AI capabilities to generate insights and make predictions faster than ever.

In this session, we’ll explore use cases, examples, and discuss how to integrate these tools to solve real-world challenges. We’ll also introduce Alibaba Cloud’s programs for developers to help you get started with Flink, Qwen, and other open-source projects. Whether you’re a developer, data scientist, or AI enthusiast, join us to see how Flink and Qwen, alongside Alibaba Cloud’s developer ecosystem, can help you build the future with data and intelligence.

Tea Break

As security, compliance, and efficiency become more vital than ever, open source offers a powerful and transparent solution. This presentation details our approach to leveraging open-source technologies to reinforce infrastructure, ensure regulatory compliance, and embed transparency at the heart of our business strategy.

Key Highlights:

• Automating and Securing Infrastructure with Ansible: Simplifying operations and achieving scalable compliance.
• Real-Time Monitoring with Journald, InfluxDB, and Grafana: Providing comprehensive insights across internal and client environments.
• Fostering Open Leadership Across Teams: Enabling collaboration across sales, support, and systems for a unified, transparent culture.

Discover how open source empowers us to build secure, compliant infrastructures, supporting over 2,500 clients—including government, military, and large enterprises.

Stress management has been a hot topic as stress has been linked to many poor outcomes both in our lives and in our work. This workshop provides high level but advanced training on stress management.

This workshop will consist of three parts

1. Physiology and signs of stress. Here we cover how observe, monitor, and assess stress levels in yourself and others.
2. Stress and decision making. Here we will cover how stress affects our decision making, the sorts of errors which are frequently induced by stress, and so forth.
3. Recognizing stress in incident responses, and assessing stress in post mortems.

Implementing RDBMS for managing your business transaction is very crucial, not only maintaining performance but also ensuring its security both for access and data, especially for private and confidential data. PDP Law has been enacting, therefore any violation such as data leaks and system breach are real risk of business continuity. In the other hand, Implementing security in RDBMS is very tricky, we should deal with ease of use, maximum protection, and seamless migration and usage while still expecting to have such a great performance delivery.

All of those requirement are hard targets for most RDBMS including the proprietary one. That is not the case for 11DB/Postgres, with our patented invention, we complies will all those requirement. and therefore become the answer for the most business needs. Want to know how 11DB surpassed any other RDBMS in sophisticated compliment of any security standards?

Come to our workshop! You may learn on how to protect your privacy data well, end-to-end and while maintaining performance and ease of use: Fast encryption, Very fast data search with index, seamless integration and strong security with HSM!

Wrap-up of Open Tech Summit 2024

Join us at the PGDay Networking Reception for an evening of conversation, connections, and community-building with PostgreSQL enthusiasts. This casual reception offers the perfect opportunity to relax after a day of sessions, share insights, and explore collaboration opportunities with fellow developers, database administrators, open source advocates, and industry experts. Don’t miss this chance to expand your network and spark new ideas in a welcoming and lively atmosphere!