Kamil Pospiech Kamil Pospiech

Spacetraders 2: PostgreSQL - Building a Local Game State with ELT

This entry documents a practical PostgreSQL setup for SpaceTraders gameplay. It covers Python integration, database creation, schema organization, ELT-style raw data ingestion, hashing, and reusable function skeletons for storing and transforming API responses. Designed as a technical reference and archive for building a local game state.

Read More
Kamil Pospiech Kamil Pospiech

Spacetraders 1: OpenAPI and API-first gameplay foundations

SpaceTraders is an API-driven space trading game where all gameplay is performed through REST endpoints. This entry introduces the game in the context of OpenAPI and documents practical Python workflows for authentication, pagination, throttling, and defensive API consumption, serving as both a series introduction and a technical reference note.

Read More
Kamil Pospiech Kamil Pospiech

Heat transfer Chapter 1: Introduction

A concise conceptual introduction to heat transfer, explaining energy storage, temperature, local thermodynamic equilibrium, and the physical meaning of conduction, convection, radiation, and phase change.

Read More
Kamil Pospiech Kamil Pospiech

Multiphase Chapter 5: Discrete Phase Flows

Integrated Master’s-level notes on Discrete Phase Modeling, covering particle dynamics, turbulence interaction, sprays, wall effects, and multiscale VOF–DPM coupling for predictive atomization simulations.

Read More
Kamil Pospiech Kamil Pospiech

Multiphase Chapter 4: Eulerian Flows

A mid-length, integrated set of engineering notes covering Eulerian multiphase modeling—including gas–liquid, gas–solid granular flows, wall-film transport, and population balance modeling—with emphasis on physical intuition, interphase forces, and numerical considerations.

Read More
Kamil Pospiech Kamil Pospiech

Multiphase Chapter 3: Volume-of-Fluid (VOF) Method

The Volume-of-Fluid (VOF) method is a cornerstone of free-surface modeling in CFD. It tracks the motion of interfaces between immiscible fluids—like air and water—by solving a single set of flow equations and evolving a scalar volume fraction that marks how much of each phase fills a cell. This approach enables realistic simulation of sloshing, filling, jet breakup, and dam-break flows without deforming the mesh. In ANSYS Fluent, VOF offers multiple schemes for time integration and interface reconstruction, balancing sharpness, stability, and computational cost

Read More
Kamil Pospiech Kamil Pospiech

Multiphase Chapter 2: Mixture Model

The Mixture Model represents multiphase flow as a single continuous medium while preserving the essence of how its components drift, exchange, and transform within it. This chapter connects the mathematics of the model with its physical meaning — showing how mass, momentum, and energy transfer intertwine with interfacial phenomena, and how ANSYS Fluent applies these ideas in cavitation, wet steam, and condensation analyses.

Read More
Kamil Pospiech Kamil Pospiech

DeepMind’s “Disproof” of Navier-Stokes: Euler Blow-Ups and Why It’s Overhyped

DeepMind and collaborators used physics-informed neural networks to uncover unstable singularities in idealized fluid equations (Euler)—the knife-edge cases where solutions blow up only under perfectly tuned conditions. I summarize what they actually did, what it means (and doesn’t) for the Navier–Stokes Millennium Problem, and why the media buzz may feel overhyped from an engineering/CFD point of view

Read More
Kamil Pospiech Kamil Pospiech

Multiphase Chapter 1: Introduction to Multiphase Flow

Multiphase flows occur when gas, liquid, or solid phases coexist and interact through momentum, heat, and mass transfer. This chapter introduces the main regimes and explains how they are modeled in CFD using ANSYS Fluent. From simplified mixture models to detailed Eulerian formulations and interface-capturing VOF methods, the focus is on understanding the assumptions, strengths, and limitations of each approach. Practical guidelines for model selection and industrial examples help connect theory to real-world applications such as bubble columns, sprays, fluidized beds, and free-surface flows

Read More
Kamil Pospiech Kamil Pospiech

IBM Data Engineering: Relational Database Administration

My archived summary notes from the IBM Relational Database Administration course. Covers DBA roles, backups, security, monitoring, and automation using PostgreSQL, MySQL, and Db2. While it's not my specialty, this was a useful deep dive into the systems side of working with relational databases

Read More