Marek Mráz

Welcome to my digital playground, where I combine my love for sports, coding, and music to create, explore, and always keep moving forward. Dive in to see what sparks my curiosity and hopefully yours, too!

I’m Marek Mráz, a software developer driven by a passion for coding, music, and sports. I’ve worked with various tech stacks, including Node.js, Docker, and PostgreSQL, and I’ve created tools such as my own CMS and database migration solutions. In my spare time, I play the piano and accordion and stay active through sports. I enjoy rolling with my friends in BJJ class, hiking, and biking.

Introducing pg-altergen: A Node.js CLI Tool for Effortless PostgreSQL Migrations

pg-altergen is a Node.js CLI tool that streamlines PostgreSQL schema versioning and migrations by organizing SQL objects into separate files. Files such as table definitions, views, functions, procedures, and data for initial configuration are stored in separate files. For definitions, we use plain SQL, so there's no need to learn a new language.
It automatically detects and merges your schemas, tables, views, and functions into an orderly “alter.sql” script, simplifying updates. With a focus on dependency resolution, pg-altergen ensures objects are created or dropped in the correct order.

Building a Multilingual CMS and E-Shop with PostgreSQL and Total.js

I’ve created my own CMS and e-shop for a multilingual store. Before developing my own CMS, I couldn’t find a solution versatile enough to publish pages and products in different languages. I decided to use Total.js CMS, remove the in-memory database, and replace it with PostgreSQL—taking advantage of its views, functions, and procedures. I also added an e-shop module that lists all products in every language.

I’m currently using this CMS for Biolamp.net, which is available in 25 languages and contains around 200 translated pages. In this project, I’m also using my own npm library, pg-altergen, which I built to simplify database versioning and migration. It’s really handy because I can rely on pure SQL rather than more complicated tools. I had struggled with Liquibase and Sequelize in the past.

Right now, this CMS is running on both biolamp.net and marek-mraz.com.

Node.js Database App Template: Simplify App development with Total.js and pg-altergen.

Kickstart your Node.js application with this powerful template combining the Total.js framework and the pg-altergen library! Perfect for building scalable apps, this template includes pre-organized SQL scripts for schemas, views, functions, triggers, and initial data setup, all managed seamlessly with pg-altergen.

Leverage Total.js to create robust, high-performance applications while enjoying effortless database versioning and migrations. Explore the live example and see how to set up and manage your PostgreSQL database with ease: https://github.com/Mrazbb/nodejs-database-app-template

Visualizing Music with Blender

Check out my latest music visualization project, created with Blender’s Geometry Nodes and integrated into a virtual production setup. I wanted to show how seamlessly music and visual effects can blend together to create an immersive experience. You can watch my videos on my YouTube channel to see how I used complex mathematics—along with Blender, DaVinci Resolve, and Cubase—to animate each note. My passion is to create something new that brings happiness to me and to others, and I hope you enjoy both the music and the visuals in my latest work!


Gallery