tag:engineers.sg,2005:/episodes?page=134Engineers.SG2024-03-19T08:19:09Ztag:engineers.sg,2005:Episode/15822017-03-19T14:06:13Z2024-03-15T00:01:13ZMySQL Group Replication - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/8pUfB5FueLk" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Venkatesh Duggirala (Bangalore)</p>
<p>Abstract:
<br>The MySQL Group Replication feature is a multi-master update anywhere replication plugin for MySQL with built-in conflict detection and resolution, automatic distributed recovery, and group membership. MySQL released GA version of Group Replication plugin on Dec 12 2012 (MySQL 5.7.17).MySQL Group Replication provides distributed state machine replication with strong coordination between servers. Servers coordinate themselves automatically when they are part of the same group. The group can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. Alternatively, for more advanced users the group can be deployed in multi-primary mode, where all servers can accept updates, even if they are issued concurrently. There is a built-in group membership service that keeps the view of the group consistent and available for all servers at any given point in time.</p>
<p>(Type: Talk | Track: Database - MySQL Day | Room: Curie & Hershel (Floor 2))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5L44/">http://amara.org/v/5L44/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15812017-03-19T14:06:12Z2024-02-18T06:01:55ZUnleash the power of Generated/Virtual Columns in MySQL - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/YQtRO_O3GWM" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Amit Bhattacharya (Bangalore)</p>
<p>Abstract:
<br>Get in depth knowledge of implementation and usage of Generated/Virtual Columns in MySQL(a new feature in MySQL 5.7). * Generated Columns can be used as materialized storage for most used expressions.* It provides a way for supporting indexes for joins with non-relational data(JSON data type) and it gives an option to either store the value of expression or let it be calculated on the fly when the record is read from the table. * Last but not the least we support indexing on these column.</p>
<p>(Type: Talk | Track: Database - MySQL Day | Room: Curie & Hershel (Floor 2))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5L1b/">http://amara.org/v/5L1b/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15802017-03-19T14:06:12Z2023-06-16T11:00:53ZFast and easy to build a mobile app (FOSSASIA registration app) with NATIVESCRIPT - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/_j1Zxnysy2Y" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Cendekia Putra (Jakarta)</p>
<p>Abstract:
<br>In this workshop, i will show on how easy and fast to build a mobile application for both IOS and Android OS. They don't have to know about Java, Xcode or Swift, it is just need knowledge about Javascript.The framework that we will be using it is Nativescript, a fully free, open source mobile framework. Build truly native iOS and Android mobile apps. Get 100% native API access with Javascript, TypeScript or Angular.We are going to build a "FOSSASIA registration application" within 1 hour. Participants should learn and understand basic of Nativescript (<a href="http://docs.nativescript.org/">http://docs.nativescript.org/</a>), or atleast learn how to install it (find at blog.cendekiapp.com)</p>
<p>(Type: Workshop | Track: Web & Mobile | Room: Fermi (Floor 3))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5L1d/">http://amara.org/v/5L1d/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15792017-03-19T14:06:11Z2024-02-19T13:00:32ZExpectations from Open Source Designers - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/3M9ptBxFyP4" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Ecaterina Moraru (Iasi)</p>
<p>Abstract:
<br>Every open source project will tell you that they want more design contributions and that they want their project to be easy to use, beautiful, modern, etc. Still there are lots of complains that is hard to have a designer integrated inside the community. So, is this true? Is there a mismatch between the designer and the community? Are there differences in participants' expectations?- Should the designer be involved in the project from the beginning to the end? - Should the designer be also a technical person? - Should the designer be responsible for the implementation of his proposals? - What we request in a design work is realistic and according to designer's specialty? - How can we evaluate a designer's proposals inside our community? - Can we have more than one designer involved in the community? - Do we know our target and provide full specifications when requesting design work? - Who should have the final decision on design proposals? - Is the designer responsible for all the usability problems of the project?- Why it is so easy to provide design feedback?- etc.All the above are valid questions when interacting with designers in open source communities and some times the answers don't match. Stating very clear what the expectations are can be helpful in having long term design contributions. In this presentation we will go over the common questions and expectations designers and open source communities have and try to provide a base for design work interactions.</p>
<p>(Type: Talk | Track: Design, Art, Community | Room: Planck (Floor 3))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5L1g/">http://amara.org/v/5L1g/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15772017-03-19T14:06:10Z2022-09-02T13:01:27ZConnecting design, culture, art, and technology across the archipelago - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/IJE4I467JCw" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Kathleen Azali (Between Surabaya (Indonesia) and Singapore)</p>
<p>Abstract:
<br>Art, design, and cultural events and organisations have proliferated in Indonesia in various scales. Designers, artists, researchers, environmentalists, handymen, technologists, hobbyists, entrepreneurs and government use open source licenses and tools mixed with assemblages of media technologies, “pirated” softwares and hardwares. Using two case studies, i.e. (1) Design It Yourself conference in Surabaya; and (2) Senayan SLiMS, an open-source Library Management Systems, I elaborate how various individuals and organisations (de)couple, calibrate, cobble up repair and maintenance in facing social or environmental challenges and emerging technologies in Indonesia. And how in the process, they generate networks of solidarity, tension, innovation, power, breakdown and resilience, across different boundaries.</p>
<p>(Type: Talk | Track: Design, Art, Community | Room: Planck (Floor 3))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5L1a/">http://amara.org/v/5L1a/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15782017-03-19T14:06:10Z2024-03-16T21:00:52ZOpen Event Web App - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/Ar8p9zgy0J8" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Aayush Arora (Noida)</p>
<p>Abstract: </p>
<p>Open-event Webapp generator can generate event websites by getting data from event JSON files and binary media files that are stored in form of ZIP. </p>
<p>The talk will focus on some features in Open-event-webapp generator, the client-side implementations for webapp and optimizations including pageload time and performance issues.</p>
<p>(Type: Talk | Track: Web & Mobile | Room: Fermi (Floor 3))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5L1e/">http://amara.org/v/5L1e/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15762017-03-19T14:06:09Z2024-01-28T22:00:44ZMySQL Performance Schema : A great insight of running MySQL server - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/y7xGCIZQ5B8" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Mayank Prasad (Bangalore)</p>
<p>Abstract:
<br>The MySQL Performance Schema is a feature for monitoring Oracle's MySQL Server execution at a low level. This versatile and tightly integrated component collects performance and session data from various subsystems within the server during runtime with minimal impact on overall server performance.With help of few real world use cases, this talk aims to explain how/what statistical information user is provided with using Performance Schema. With these use cases, it also explains how this information can be used for monitoring and trouble shooting to track an issue back to the relevant file and line of code in source file. Again, with some use cases, this talk also explains how Performance Schema gives consolidated view of different activities of MySQL server behind the scene with the multiple summary tables and how this can be tuned and used. This talk also covers the manual/automatic configuration of Performance Schema to suite to individual requirement in a specific scenario.This talk is targeted to many database users which includes DBA, Database Application developers, Database developers, Students. This talk is to give overview of MySQL Performance Schema and also how/what information can be collected using it and how this information could be used further for debugging/trouble shooting Database users' issue.Takeaways from the talk: - Overview of tuning and monitoring MySQL Server activities using Performance Schema. - Understanding of how to tailor the Performance Schema to track the data you want. - With few real world usecases, explain how to diagnosing problems with the Performance Schema. - A glimpse of new features in Performance Schema in MySQL 5.7 GA.</p>
<p>(Type: Talk | Track: Database - MySQL Day | Room: Curie & Hershel (Floor 2))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5L1c/">http://amara.org/v/5L1c/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15752017-03-19T14:06:08Z2024-03-13T20:00:52ZIntroduction to MySQL Performance Tuning - workshop 1hr - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/O6PTi-Itk_8" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Jesper Wisborg Krogh (Sydney, NSW)</p>
<p>Abstract:
<br>It is easy to get started with MySQL, but you may still need to do some tuning to get the required performance. This talk gives an introduction to MySQL performance tuning by looking at best practices, the most important configuration options, monitoring, etc. There will also be examples of finding the queries most in need of optimization using performance reports in MySQL Workbench or through the sys schema. Attend this talk if you want some primers on tuning your MySQL database.</p>
<p>(Type: Workshop | Track: Database - MySQL Day | Room: Curie & Hershel (Floor 2))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5L1f/">http://amara.org/v/5L1f/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15742017-03-19T14:06:08Z2024-03-12T23:01:12ZJSON support in MySQL - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/2G8B4tmlrBk" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Evgeny Potemkin (Samara)</p>
<p>Abstract:
<br>This session overviews support for JSON in MySQL - storage, available functions, indexing options, ways to handle schemaless data by means of relational database and along with relational data.</p>
<p>(Type: Talk | Track: Database - MySQL Day | Room: Curie & Hershel (Floor 2))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5L19/">http://amara.org/v/5L19/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15732017-03-19T14:06:07Z2023-09-29T11:01:09ZVirtual Reality OS: Open Source, Of Singapore - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/2TDbujZip9M" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Lionel Chok (Singapore)</p>
<p>Abstract:
<br>Overview of VR developments and possible VROS Project</p>
<p>(Type: Talk | Track: Design, Art, Community | Room: Planck (Floor 3))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5LZK/">http://amara.org/v/5LZK/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15712017-03-19T14:06:06Z2024-02-20T09:00:37ZOpen Event API - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/1-W9ZI7gAl8" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Avi Aryan (Gandhinagar)</p>
<p>Abstract:
<br>Open Event API uses Flask-restplus framework to manage its API. In this session, we will talk about the various considerations taking into account while designing the Open Event API. We will appreciate the modular design of the API and learn how it helps to sustain other features like Import/Export. </p>
<p>(Type: Talk | Track: Web & Mobile | Room: Fermi (Floor 3))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5LZM/">http://amara.org/v/5LZM/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15722017-03-19T14:06:06Z2024-03-15T12:01:16ZIoT - Secure MQTT/HTTP Apis using Node-Red - workshop 1hr - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/UyuOglOCtn8" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Jimish Parekh (Ahmedabad)</p>
<p>Abstract:
<br>Smart Devices do need to talk to servers lying on some cloud. This talk will include basic knowledge of Node-Red framework of Nodejs, which can be used as MQTT (Message Queue Telemetry Transportation) Broker and HTTP Api server. So any developer can communicate to devices (publish/subscribe) using MQTT protocol and they can develop any REST APIs using http feature of Node-Red. Node-Red is drag and drop, light weight framework built upon Nodejs. Now, developer can develop a API in lesser time that he/she takes to make a cup of coffee.</p>
<p>(Type: Workshop | Track: Security and Privacy | Room: Faraday (Floor 3))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5LZN/">http://amara.org/v/5LZN/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15702017-03-19T14:06:05Z2023-06-26T00:01:37ZBetter Events with Open Event - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/mhgFA6hTU5U" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Mario Behling ()</p>
<p>Abstract:
<br>Finally an Open Source event management system.</p>
<p>(Type: | Track: Web & Mobile | Room: Fermi (Floor 3))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5LWe/">http://amara.org/v/5LWe/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15682017-03-19T14:06:04Z2023-08-15T21:01:41ZIntroduction to NodeRED<iframe width="560" height="315" src="https://www.youtube.com/embed/R04C7Y2mHNM" frameborder="0" allowfullscreen></iframe><p>Speaker: Stephan Wissel (IBM)</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Description: NodeRED is programming tool that provides a great browser interface to wire together hardware devices, APIs and online services. Stephan gives a quick rundown on the elements of a NodeRED project and how he uses it to quickly prototype his projects, including his blinking lights project which he covered in FOSSASIA 2017. Stephan is an IBM Code Mage who started coding with COBOL. He's a frequent speaker on IT related topics and interested in mobile and IoT. He's blogging for more than a decade at wissel.net.</p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5LWf/">http://amara.org/v/5LWf/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15692017-03-19T14:06:04Z2024-03-18T00:01:22ZDeploy Open Event Organizer Server - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/X8pvEIn-I04" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Saptak Sengupta (Allahabad)</p>
<p>Abstract:
<br>Open Event Organizer Server is a complete event management system which anyone can use to host their own events. In this talk, we will get to know how to setup the server over google cloud and local system for you to use it individually.</p>
<p>(Type: Workshop | Track: Web & Mobile | Room: Fermi (Floor 3))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5LWd/">http://amara.org/v/5LWd/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15672017-03-19T14:06:03Z2024-01-15T07:01:45ZIntegrated Physical Computing on the Web - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/_TWGDklUlD4" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Dietrich Ayala (Portland, OR)</p>
<p>Abstract:
<br>Ubiquitous physical computing is here, blurring what is digital and real in our experience of reality. Join me for an interactive tour of how to create digital+physical experiences on the web.</p>
<p>(Type: Talk | Track: Design, Art, Community | Room: Planck (Floor 3))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5LWc/">http://amara.org/v/5LWc/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15652017-03-19T14:06:02Z2023-12-07T07:01:12ZAn Introduction to the Open Event Android Project and it's capabilities. - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/fi2mj6GTi2g" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Manan Wason (Delhi)</p>
<p>Abstract:
<br>This session will be an introduction to the open event android with both the components that is Open Event APK generator as well as open event android app. </p>
<p>(Type: Talk | Track: Web & Mobile | Room: Fermi (Floor 3))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5L1h/">http://amara.org/v/5L1h/</a></p>Engineers.SGtag:engineers.sg,2005:Episode/15662017-03-19T14:06:02Z2024-03-09T10:01:09ZScaling Open Event Server with Kubernetes - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/tyiebK4CIwQ" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Niranjan Rajendran (Bangalore)</p>
<p>Abstract:
<br>A brief introduction to the revamped Open Event project and how we use Kubernetes, an open-sourced Container Orchestration tool and Google Container Engine to deploy our production servers to the masses.</p>
<p>(Type: Talk | Track: Web & Mobile | Room: Fermi (Floor 3))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>
<p>Help us caption & translate this video!</p>
<p><a href="http://amara.org/v/5LWb/">http://amara.org/v/5LWb/</a></p>Engineers.SG