Postgres Performance Optimization: Connection Pooling, JDBC, and Distributed Databases
An airhacks.fm conversation with Alvaro Hernandez (@ahachete) about:
discussion on Postgres JDBC driver contributions,
SCRAM authentication library implementation,
importance of connection pooling for Postgres performance,
tuning Postgres configuration,
PgBouncer as a popular connection pooler,
challenges with lambda and database connections,
benefits of using connection poolers at multiple levels,
the need for an HTTP-based protocol for PostgreSQL,
PostgresSQL Configuration Tool by StackGres,
distributed SQL databases like DSQL and their trade-offs,
optimistic vs pessimistic locking in distributed databases,
comparison of JPA optimistic locking to distributed database conflicts,
the power of using SQL directly vs ORM frameworks,
the evolution of Java and JDBC making direct database queries more convenient,
the potential benefits of using stored procedures in databases,
the importance of understanding database internals for optimal performance,
the need for careful consideration when choosing between ORM and direct SQL queries,
the complexities of distributed databases and their impact on application design
Alvaro Hernandez on twitter: @ahachete
--------
1:09:52
Natural Born Breaker
An airhacks.fm conversation with Francesco Nigro (@forked_franz) about:
starting with a used Commodore 64 without display,
breakdancing as a hobby and its influence on his learning approach,
studying computer science at university with a focus on AI and compilers,
pursuing a PhD in reinforcement learning,
transitioning to IoT and embedded system work,
discovering high-performance computing and concurrency patterns like the Disruptor,
contributing to open-source projects,
persistence in joining Red Hat despite initial rejection,
rewriting ActiveMQ Artemis journal,
considering Hazelcast before ultimately choosing Red Hat,
working on messaging and performance optimization at Red Hat,
becoming the performance expert for quarkus,
journey from assembly and C programming to Java performance optimization,
the importance of understanding low-level details in high-level languages,
the impact of container resources on Java JVM performance,
the value of deep technical knowledge in the age of AI and LLMs,
Francesco's current role at Red Hat focusing on Quarkus performance and scalability issues
Francesco Nigro on twitter: @forked_franz
--------
1:22:40
Just Another CDI Committer
An airhacks.fm conversation with Ladislav Thon (@ladicek) about:
CDI history and evolution,
transition from XML-based configuration to annotation-based dependency injection,
introduction of CDI lite in version 4.0,
differences between portable extensions and build-compatible extensions,
Arc as Quarkus CDI implementation,
challenges in implementing CDI at build time,
new features in CDI 4.0 and 4.1 including lifecycle events and method invokers,
comparison of CDI with other dependency injection frameworks,
discussion on decorators,
interceptors, and stereotypes in CDI,
performance implications of CDI in Quarkus,
Convention over Configuration in CDI,
upcoming changes in CDI 5,
removal of expression language dependency from CDI API,
benefits of build-time oriented implementations like Quarkus,
challenges in migrating portable extensions to build-compatible extensions,
introduction of synthetic beans and observers,
addition of priority support for stereotypes,
improvements in invocation context API,
ability to declare priority on producers in CDI 4.1,
integration of CDI with application programming models,
Convention over Configuration paired with dependency injection,
performance considerations of CDI in Quarkus compared to manual dependency management
Ladislav Thon on twitter: @ladicek
--------
1:02:23
Prepared Statements, Connection Pooling, Sharding, Partitioning and Serverless Workloads with Oracle Database
An airhacks.fm conversation with Gerald Venzl (@GeraldVenzl) about:
discussion on prepared statements and their benefits in Oracle databases,
explanation of hard parsing vs soft parsing in database queries,
overview of connection pooling and its importance in database performance,
introduction to Oracle's Database Resident Connection Pool (DRCP),
exploration of Oracle's support for serverless workloads,
discussion on PL/SQL and JavaScript support in Oracle databases,
brief mention of ADA programming language and its influence on PL/SQL,
introduction to GraalVM and its role in Oracle databases,
comparison of performance between PL/SQL and JavaScript in Oracle,
mention of Oracle database support for ARM architecture including M1 Macs and Raspberry Pi 5,
explanation of database sharding vs partitioning,
discussion on the benefits of stored procedures for data-intensive operations
Gerald Venzl on twitter: @GeraldVenzl
--------
1:12:36
From Enterprise Java to Cloud-Native PostgreSQL
An airhacks.fm conversation with Alvaro Hernandez (@ahachete) about:
first computer experiences with Amstrad CPC 464,
early programming with Basic,
university studies in Telecommunication Engineering,
transition from PHP to Java development,
creating an ERP system,
attending JavaOne conferences,
failed startup attempt with a mobile phone bill analysis app,
specialization in PostgreSQL,
founding ongres company,
developing stackgres as a kubernetes operator for PostgreSQL,
discussion about the benefits of open-source software and the "My Server,
My Rules" philosophy,
comparison of cloud-managed services vs. self-managed solutions,
the importance of control and transparency in database management,
Stackgres as a solution for running PostgreSQL as a service with full control,
the use of Java in developing kubernetes operators,
the shift from on-premises to cloud deployments and its implications for developers,
the challenges of setting up and managing databases in the cloud,
the benefits of serverless and managed services,
the importance of understanding the underlying infrastructure in cloud deployments,
the evolution of database management from dedicated teams to self-service models,
the potential for new container-related products from Ongress,
the recent popularity of Bluesky as a social media platform for the Java community
Alvaro Hernandez on twitter: @ahachete
New Zealand