tag:engineers.sg,2005:/episodes?page=139Engineers.SG2024-03-19T12:22:42Ztag:engineers.sg,2005:Episode/14902017-03-18T07:05:48Z2023-02-18T14:00:33ZRunning Highly Available Postgres in AWS RDS - Sushant Mahesh Pawar - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/-9QTJhER9tk" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Sushant Mahesh Pawar (Mumbai)</p>
<p>Abstract:
<br>If we look back and see the changes that have happened in last few years, we will realize that how things have changed very rapidly. A decade back, most of the organizations either would have their in-house database servers running on certain hardware and storage configuration. Over the period, when the servers become obsolete, then server/storage migration would itself become separate project and the procurement process for new hardware in any organization is usually time consuming process. In last two years, there has been rise in adoption of Cloud that tries to address this and many other issues. Now you do not have to worry about the underlying hardware and storage, once you know CPU, RAM and storage requirement, you can customize the server and build your own server in cloud. Also, migrating Postgres cluster to cloud is a viable option for safety (no data loss, including if rollback), minimal downtime (switchover and rollback), minimal effort for the team.Considering one of the above reasons for moving to cloud, one of our client’s in FinTech space decided to move their PostgreSQL instance to AWS RDS since RDS offered some of the following benefits like:• Automated failover of primary in case of failure • Automated creation of replicas• Automated updates• A purely declarative setup, via Cloud formationHere I will talk about how technical aspects of moving PostgreSQL server to AWS RDS.• How to configure, tune the parameters in config file while moving onto RDS. • How you can select the storage depending upon growth estimate and IOPS requirement• How you can configure HA setup in RDS.• How you can distribute your reporting workload.• How to monitor Postgres instance and alert configuration</p>
<p>(Type: | Track: Database - PGDay | 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>Engineers.SGtag:engineers.sg,2005:Episode/14892017-03-18T06:30:28Z2024-03-19T11:00:35ZHow to teach an elephant to dance rock'n'roll - Maksym Boguk - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/Ha38lcjVyhQ" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Maksym Boguk (Australia)</p>
<p>Abstract:
<br>Unconventional query optimization in PostgreSQL, or how to teach an elephant to dance rock'n'roll.Query performance is usually tuned by simply adding indexes and rewriting the query minimally, while the basic idea of the query stays the same. For many query, this is not the best way to optimize them: you need to rethink and rewrite them completely. To do this, you need to know how optimizer and executor work, and keep that in mind while composing your queries. In this talk, I will present an overview of a few less known and rarely used techniques such as:* using and implementing loose index scan for different scenarios;* using IOS in situation where it isn't applicable directly;* replacing IN (long list of values) with JOIN VALUES ();* moving a limit or offset clause inside joins;* and other tricks with row types and arrays of row types.Using these techniques and some other ideas, we will learn how to optimize a 'friends feed/subscription news' query, which is a typical task in many projects. We will diretcly compare performance of four different approaches: direct approach (simplest query), optimized direct approach (more complicated version of it), pl/pgsql with different algorithms, and implementation of this pl/plsql code in plain sql. I will show how this approach can convert almost any read-only non-dynamic (no EXECUTE statements and no exceptions) pl/pgsql code to a plain sql query.</p>
<p>(Type: | Track: Database - PGDay | 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>Engineers.SGtag:engineers.sg,2005:Episode/14882017-03-18T05:40:23Z2024-03-14T15:00:54ZMassive Multi-node setup with Postgres and BDR in Retail System - Julyanto Sutandang - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/bizW3-QyGrM" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Julyanto Sutandang (Indonesia)</p>
<p>Abstract:
<br>In Distributed System, such as Centralized Retail System like Hypermarket, there are 2 approaches for data collection and integration. Use Webservices or use Distributed Databases. By enabling Distributed Databases, and maintained it as if single integrated system, we can achieve simplicity, no context producer and subscriber anymore. this saves a lot of effort, time and resources of course. There are no worry about data synchronization, no need to maintain data Integrity with much effort. In this talk, we will cover about why and how BDR (Bidirectional Replications) implemted in high performance transaction system (which we developed, i.e POS Retail System). Why that matter and how this can be a great lesson for any other implementation.</p>
<p>(Type: | Track: Database - PGDay | 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>Engineers.SGtag:engineers.sg,2005:Episode/14872017-03-18T05:30:36Z2023-05-09T01:01:44ZOpen Source - A Blessing or a Curse? - Michael Meskes - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/ArkH4pqi4Jc" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Michael Meskes ()</p>
<p>Abstract:
<br>A lot of pros and cons are regularly dicussed when it comes to Open Source usage in business IT. There are a lot of reasons why Open Source is ideal for business critical system, but there are also a lot of uncertainties and doubts by people who are not really involved with Open Source communities. This is in particular a topic for PostgeSQL, which is the most important Open Source solution for businesses. This presentation evaluates those pros and cons and shows how to get the most out of PostgreSQL's Open Source nature for enterprise IT.</p>
<p>(Type: Talk | Track: Database - PGDay | 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>Engineers.SGtag:engineers.sg,2005:Episode/14862017-03-18T05:16:48Z2024-03-17T23:01:03ZAWS Aurora - Blair Layton - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/-5TL8tdLRnc" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Blair Layton (Singapore)</p>
<p>Abstract:
<br>Amazon Web Services announced a new PostgreSQL-Compatible edition of its Amazon Aurora Database at the re:Invent conference in Las Vegas on November 30, 2016. With Amazon Aurora’s new PostgreSQL support, customers can get several times better performance than the typical PostgreSQL database and take advantage of the scalability, durability, and security capabilities of Amazon Aurora. This session will explain the underlying architecture of the Aurora platform and how it benefits users of PostgreSQL. It will also discuss industry trends on migrations to PostgreSQL and feature a customer's experience of migrating from Microsoft SQL Server to Amazon RDS PostgreSQL.</p>
<p>(Type: | Track: Database - PGDay | 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>Engineers.SGtag:engineers.sg,2005:Episode/14852017-03-17T13:00:42Z2024-03-19T08:01:24ZLEO Satellite Reception and Doppler-Shift Correction - Roland Turner - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/X0d-7b0tqmQ" frameborder="0" allowfullscreen></iframe><p>LEO Satellite Reception and Doppler-Shift Correction with an SDR built on the Novena's FPRF and FPGA</p>
<p>Speaker(s): Roland Turner</p>
<p>Abstract:
<br>Low Earth Orbit (LEO) satellites cross the sky fast enough that Doppler-shift often has to be corrected for in order to sustain communication. In this talk I describe my efforts to make use of the Novena's Field-Programmable Radio-Frequency (FPRF) and Gate Array (FPGA) components in combination with various open source Software Defined Radio (SDR) front-ends to receive UHF downlinks and to perform phase-preserving Doppler-shift correction in real-time.</p>
<p>(Type: Talk | Track: Open Tech | Room: Annexe Hall (Ground Floor))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>Roland Turnertag:engineers.sg,2005:Episode/14842017-03-17T12:57:39Z2024-02-16T23:00:38ZArtificial Intelligence - Panel - Andrew Selle - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/qMoypa93-_M" frameborder="0" allowfullscreen></iframe><p>Speaker(s):</p>
<p>Andrew Selle, Google Brain Team
<br>Steffen Braun, KI Group
<br>Michael Christen, SUSI AI
<br>Harish Pillay, Internet Society
<br>Bunnie Huang (Singapore), Chibitronics PTE LTD</p>
<p>(Type: Panel | Track: Open Tech | Room: Annexe Hall (Ground Floor))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>Engineers.SGtag:engineers.sg,2005:Episode/14832017-03-17T12:49:07Z2023-05-28T11:01:04ZFOSSASIA What's Next - Mario Behling - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/5GvN6NFzWx4" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Mario Behling</p>
<p>Abstract:
<br>FOSSASIA - Our next steps!</p>
<p>(Type: | Track: Open Tech | Room: Annexe Hall (Ground Floor))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>Engineers.SGtag:engineers.sg,2005:Episode/14822017-03-17T12:48:38Z2023-03-21T20:01:42ZKeynote - Protecting privacy with free software - Frank Karlitschek - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/aoGQN0XW6sU" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Frank Karlitschek, Nextcloud</p>
<p>Abstract:
<br>The privacy and the personal data on the internet are under attack by hackers and international espionage programs. If we want to use the internet as a free and democratic medium again then we have to fix the internet to provide the security and privacy that people deserve. The Nextcloud community is build an open source and fully federated and distributed network for files and communication. Everyone can run an Nextcloud server at home or somewhere on the internet and collaborate and share with everyone else. Nextcloud can be used to provide file access, syncing, sharing, calendar, contacts, video calling, music and video streaming in a distributed way.This talk will cover the current problems with surveillance and espionage and strategies on how to fix this problem. It will also discuss the current and upcoming federation features of Nextcloud and how to become part of the community.'</p>
<p>(Type: Talk | Track: Open Tech | Room: Annexe Hall (Ground Floor))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>Engineers.SGtag:engineers.sg,2005:Episode/14812017-03-17T12:45:06Z2023-10-27T19:01:10ZKeynote - Microsoft + Open Source: Empowering Customers - Andrey Terekhov - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/N_799Yu3k_w" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Andrey Terekhov (Singapore), Microsoft</p>
<p>Abstract:
<br>Andrey will talk about Microsofts Open Source strategy. He will put a particular focus on scaling up open source workloads on Microsoft Azure cloud platform.</p>
<p>(Type: Talk | Track: Open Tech | Room: Annexe Hall (Ground Floor))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>Engineers.SGtag:engineers.sg,2005:Episode/14802017-03-17T12:42:26Z2024-02-27T23:00:25ZLet's Make Technology more Inclusive - Bunnie Huang - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/ABJc3G7XLo8" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Bunnie Huang (Singapore), Chibitronics PTE LTD</p>
<p>Abstract:
<br>As society and technology become more deeply intertwined, society is taking interest in -- and influencing -- nuanced technological issues, ranging from net neutrality, to the selection of emojis, to the enforcement of open source licenses. The FOSS community takes for granted the values of open source, but the benefits can be difficult to explain to those who are not empowered to utilize the source. This talk examines some of the cultural and technological barriers that have stymied inclusiveness, using gender imbalance as a case study. Finally, we propose a solution which we call "Love to Code", which attempts to address the issue of inclusiveness in technology.</p>
<p>(Type: Talk | Track: Open Tech | Room: Annexe Hall (Ground Floor))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>Engineers.SGtag:engineers.sg,2005:Episode/14792017-03-17T12:29:48Z2024-01-04T02:01:39ZThe Brainduino Project, Brain-Computer Interfaces & AI in the Future - Konrad Willi - FOSSASIA 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/oOhUbpyVroo" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Konrad Willi Döring (Berlin), Neurofox</p>
<p>Abstract:
<br>This talk is about the Brainduino project, including a brief introduction to EEG-based brain-computer interfaces, how to participate, as well as a look into the future of BCI technology.</p>
<p>Slides: <a href="http://neurofox.com/nfx_brainduino_fossasia.pdf">http://neurofox.com/nfx_brainduino_fossasia.pdf</a></p>
<p>(Type: Talk | Track: Open Tech | Room: Annexe Hall (Ground Floor))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>Engineers.SGtag:engineers.sg,2005:Episode/14782017-03-17T12:27:22Z2024-02-02T03:01:44ZThe Open Source World of Natural Language Processing - Liling Tan - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/hqK4KWH5yZY" frameborder="0" allowfullscreen></iframe><p>Speaker: Liling Tan (Singapore), Rakuten Asia</p>
<p>Abstract:
<br>Natural Language Processing (NLP) is the task of the computationally understanding and production of human languages, often using a mix of hand-crafted rules and machine learning techniques. The recent hype in artificial intelligence and deep learning has brought a tsunami of media coverage, governmental interest and public enthusiast. And NLP rode the wave and pushed the computational processing of language to the current frontier. In this talk, we will go through the various NLP open source available and share my experience being a contributor to Natural Language Tool Kit (NLTK) and Moses machine translation suite.</p>
<p>(Type: Talk | Track: Open Tech | Room: Annexe Hall (Ground Floor))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>Engineers.SGtag:engineers.sg,2005:Episode/14772017-03-17T12:24:22Z2023-04-01T15:03:45ZOpen AI Assistants - Michael Christen - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/EtKsjTR4ANI" frameborder="0" allowfullscreen></iframe><p>Speaker: Michael Christen, SUSI AI</p>
<p>Abstract:
<br>AI Assistants are able to augment the human intellect, to perform task and offer services, to have capabilities beyond the ordinary power of humans. With open AI Assistants a community can create such tools for their own need. We show that the creation of such tools can be as easy as writing a wiki article. With the proper Cognitive Assistant Technology we will be able to augment human intellect in the same way as it is possible to document the world knowledge with the wikipedia.</p>
<p>(Type: Talk | Track: Open Tech | Room: Annexe Hall (Ground Floor))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>Engineers.SGtag:engineers.sg,2005:Episode/14762017-03-17T12:19:22Z2023-08-09T07:01:39ZKeynote - Contributing to Google Cloud Open Source Projects - Øyvind Roti - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/i3HrvRlfms4" frameborder="0" allowfullscreen></iframe><p>Speaker: Øyvind Roti, Google</p>
<p>Abstract:
<br>Are you looking for ways to get involved with Open Source in the Cloud? Here's your chance. In this talk, I will briefly talk about Google Cloud Open Source products and related projects, including machine learning, systems, client side libraries and data analytics tools. I'll explain how you can get involved, contribute and share some tips for code reviews.</p>
<p>(Type: Talk | Track: Open Tech | Room: Annexe Hall (Ground Floor))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>Engineers.SGtag:engineers.sg,2005:Episode/14752017-03-17T12:11:51Z2023-10-11T08:01:49ZKeynote - Future of Digital Government - Chan Cheow Hoe - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/IUKl3NXqYgE" frameborder="0" allowfullscreen></iframe><p>Speaker(s): Chan Cheow Hoe (Singapore), GovTech</p>
<p>Abstract:
<br>How Singapore Government’s central information technology systems and infrastructure, drives the development and delivery of innovative public services for citizens and businesses.</p>
<p>(Type: Talk | Track: Open Tech | Room: Annexe Hall (Ground Floor))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>Engineers.SGtag:engineers.sg,2005:Episode/14742017-03-17T12:08:55Z2022-10-08T17:01:43ZArtificial Intelligence and Science - Lim Tit Meng - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/COllmgIKOnM" frameborder="0" allowfullscreen></iframe><p>Speaker: Lim Tit Meng (Science Centre Singapore)</p>
<p>Abstract:
<br>Artificial Intelligence and Science</p>
<p>(Type: | Track: Open Tech | Room: Annexe Hall (Ground Floor))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>Engineers.SGtag:engineers.sg,2005:Episode/14732017-03-17T12:06:35Z2024-03-18T17:00:51ZAI and Machine Learning Personal Assistants - Harish Pillay - FOSSASIA Summit 2017<iframe width="560" height="315" src="https://www.youtube.com/embed/RVSGTKVos80" frameborder="0" allowfullscreen></iframe><p>Speaker: Harish Pillay</p>
<p>Abstract:
<br>Can a future of Singularity as articulated by Ray Kurtzwild and also the gloom and doom as noted by Stephen Hawkings indeed be a cataclysmic end to humanity - just as the meteoric accident that killed off dinosaurs? I will paint a picture of hope and one of collaboration. There are plenty of rules we can articulate and follow - including the 'new overlords'.</p>
<p>(Type: Talk | Track: Open Tech | Room: Annexe Hall (Ground Floor))</p>
<p>Event Page: <a href="http://2017.fossasia.org">http://2017.fossasia.org</a></p>
<p>Produced by Engineers.SG</p>Harish Pillay