technologyJul 17, 20241:02:33pending
Navigating SQL Data Changes: Tools and Techniques for Data Recovery - RUBY 645
About this episode
In today's episode, Valentino is joined by Evgeny Li, a seasoned software developer and founder of Bemi, to delve into the complex world of data recovery and auditing within SQL databases. They explore advanced solutions like paper trail and refi for querying historical changes, point-in-time recovery features offered by cloud-managed databases, and the use of AI to humanize data structures and enhance monitoring.
They highlight the critical role of Change Data Capture (CDC) in tracking and troubleshooting data changes, with real-world applications across logistics, healthcare, and more. They also discuss the pros and cons of different CDC implementations—query-based, trigger-based, and log-based approaches.
Valentino and Evgeny shed light on the challenges of managing large data volumes, emphasizing proactive design and the importance of strong data management systems. They touch upon essential tools like GitHub Copilot, OpenTelemetry, and various auditing gems, offering valuable insights into maintaining data integrity and performance.
Tune in as we navigate the intricacies of data management, the impact of AI, and best practices to ensure reliable and efficient database operations.
Socials
Become a supporter of this podcast: https://www.spreaker.com/podcast/ruby-rogues--6102073/support.
They highlight the critical role of Change Data Capture (CDC) in tracking and troubleshooting data changes, with real-world applications across logistics, healthcare, and more. They also discuss the pros and cons of different CDC implementations—query-based, trigger-based, and log-based approaches.
Valentino and Evgeny shed light on the challenges of managing large data volumes, emphasizing proactive design and the importance of strong data management systems. They touch upon essential tools like GitHub Copilot, OpenTelemetry, and various auditing gems, offering valuable insights into maintaining data integrity and performance.
Tune in as we navigate the intricacies of data management, the impact of AI, and best practices to ensure reliable and efficient database operations.
Socials
Become a supporter of this podcast: https://www.spreaker.com/podcast/ruby-rogues--6102073/support.
Get every episode summarized
Each time Ruby Rogues publishes, we email you a written briefing from the transcript — the topics, who appeared, and any specific claims, with the ad reads skipped.
Email me new episodesFree for 3 shows. No card needed.
Hosts & guests
No transcript yet
This episode has not been transcribed. Request it and it moves to the front of the queue.
More episodes
More from Ruby Rogues
Autogenetic AI Agents and the Future of Ruby Development - RUBY 682
Ruby Rogues
Dec 24, 20251:00:35pending
The New Era of Rails: Markdown, Offline Mode, and Smarter Dev Tools - RUBY 681
Ruby Rogues
Nov 23, 202535:08pending
Keeping Ruby Welcoming: A Conversation We Need to Have - RUBY 680
Ruby Rogues
Nov 14, 202541:48pending
Inside the RubyGems Controversy: Transparency, Trust, and the Future of Ruby Cen...
Ruby Rogues
Nov 1, 202550:58pending