Databases and Business Analysts

An airhacks.fm conversation with Ben Brumm (@databasestar) about: a macintosh with a color monitor, playing games like time crisis, sim city, on Pentium, pixel perfect vs responsive design, starting "programming" with Microsoft Frontpage, writing simple programs with Visual Basic, starting Java in 2001, writing a Java app to search for file on CDs writing Java CLI with GraalVM, starting with Oracle Database and SQL Server, starting as a business analyst, using toad, datagrip, postico, and SQLplus for database development, using SQL developer and PL/SQL developer, using Visual Studio Code for database development, skipping business analysts and talking directly to users, writing code forces you to think harder, nice Java objects vs. highly normalized database, denormalizing database for performance, structural changes to database take too long, using FlywayDB and liquibase for automated database deployments, when DDLs take too long, dealing with structural rollbacks in DB and the red gate tools, Oracle Editions and Flashbacks, increasing PostgreSQL popularity, using PostgreSQL JSONB functionality as extensions column, using Oracle XStream, using Change Data Capture (CDC) and Debezium, Ben's blog: www.databasestar.com and book: Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional Ben Brumm on twitter: @databasestar