Talks
Speakers
Events
Topics
Sign in
Home
Talks
Speakers
Events
Topics
Leaderboard
Use
Analytics
Sign in
Suggest modification to this talk
Title
Description
Keep Ruby Weird 2018 - Using psql to \watch Star Wars And other silly things! by Will Leinweber Will doesn’t really want to think about how long he’s been working with Postgres. He is currently working on horizontally scalable Postgres at Citus Data, and before that was a principal member of the Heroku Postgres team. Please don’t try to right-click and steal the source for his WebSite bitfission.com.
Date
Summarized using AI?
If this talk's summary was generated by AI, please check this box. A "Summarized using AI" badge will be displayed in the summary tab to indicate that the summary was generated using AI.
Show "Summarized using AI" badge on summary page
Summary
Markdown supported
In this engaging presentation titled "Using psql to \watch Star Wars and other silly things!" at the Keep Ruby Weird 2018 conference, Will Leinweber explores the playful side of programming with PostgreSQL. He connects coding for fun with practical applications, demonstrating how to enjoy coding while still being productive. Will discusses his journey and experiences with automations in chat applications and social media bots, sharing various examples throughout his talk. Key Points Discussed in the Presentation: - **Automation in Coding**: Will highlights the joy of automating small tasks for fun, reminiscing about chat bots in older platforms like Campfire and HipChat, and transitioning to modern tools like Slack. - **Witty Chat Bots**: He shares his experience of creating chat bots that humorously respond to specific keywords, showcasing how fun can be integrated into everyday programming tasks. - **Twitter Bots**: Examples of using simple scripts to respond to tweets show how coding can engage with social media and offer playful interactions, including a humorous method of generating responses based on tweet characteristics. - **Using psql with Star Wars**: The presentation’s highlight is utilizing PostgreSQL to watch a digitized version of "Star Wars" by retrieving the textual content stored in a Postgres database. Will walks through the extraction and transformation process of the data, which includes a detailed explanation of how the animation is presented in a terminal interface. - **PostgreSQL Functions and Features**: He introduces the use of Postgres functions to create a watcher for frames, explaining sequences and how they contribute to the automation of watching a movie. - **The Concept of \\watch**: A notable feature in PostgreSQL that allows for refreshing query output at specified intervals, demonstrating a playful approach to utilizing the database in unexpected ways. - **Introduction of ffmpeg**: Towards the end, he explains how ffmpeg can be used to output a movie format into a terminal, showcasing the technical side of programming in a fun and interesting way. - **Anecdote**: Interspersed throughout the talk, Will narrates a whimsical story about a mother with numerous children and their secret pet dog, metaphorically tying the narrative back to his points about coding and automation. **Conclusion and Takeaways**: The talk emphasizes the inherent fun in coding and the unique ways automation can bring joy to tedious tasks. Will encourages attendees to consider how programming can be enjoyable and to explore creative avenues within their codebases. He also highlights the evolving capabilities of PostgreSQL and its applicability beyond traditional database functions, inviting discussions and questions about his playful approaches to coding.
Suggest modifications
Cancel
