Norbert Orzechowicz
@norbert-tech.bsky.social
Problem solver, software architect, also working as a Data Witcher ⚔️, hunting and killing 🧌 and 🪳in data processing pipelines! Creator of https://flow-php.com
Pinned
Want to learn how I automated the setup of a local development environment for Flow #PHP with the following dependencies:
- PHP 8.2/8.3/8.4
- blackfire/xdebug/pcov/zstd/brotli/snappy/lz4
- PostgreSQL
- MySQL
- Redis
- Elasticsearch
- Meilisearch
- Azureite
- Localstack
Read 🧵
- PHP 8.2/8.3/8.4
- blackfire/xdebug/pcov/zstd/brotli/snappy/lz4
- PostgreSQL
- MySQL
- Redis
- Elasticsearch
- Meilisearch
- Azureite
- Localstack
Read 🧵
A top request with reports? Saving them as XLSX files. That's why we taught Flow #PHP to master #Excel.
flow-php.com/documentati...
Marry Christmas Everyone! 🎄🎁
flow-php.com/documentati...
Marry Christmas Everyone! 🎄🎁
Documentation - Flow PHP - Data Processing Framework
Documentation
flow-php.com
December 25, 2025 at 8:02 AM
A top request with reports? Saving them as XLSX files. That's why we taught Flow #PHP to master #Excel.
flow-php.com/documentati...
Marry Christmas Everyone! 🎄🎁
flow-php.com/documentati...
Marry Christmas Everyone! 🎄🎁
Data processing in #PHP is still in it's early stages. Don't believe me? Look at your system and tell me how it's handling imports/exports.
Is it perhaps hand written importer/exporter?
Any chance it's using file_get_contents?
What stops you from using a Data Frame?
Is it perhaps hand written importer/exporter?
Any chance it's using file_get_contents?
What stops you from using a Data Frame?
December 22, 2025 at 1:18 PM
Data processing in #PHP is still in it's early stages. Don't believe me? Look at your system and tell me how it's handling imports/exports.
Is it perhaps hand written importer/exporter?
Any chance it's using file_get_contents?
What stops you from using a Data Frame?
Is it perhaps hand written importer/exporter?
Any chance it's using file_get_contents?
What stops you from using a Data Frame?
flow-php/postgresql received Client::explain() : Plan feature
This means that we can now programmatically extract and analyze postgresql query execution plan!
More details in flow-php.com/documentati...
This means that we can now programmatically extract and analyze postgresql query execution plan!
More details in flow-php.com/documentati...
December 18, 2025 at 1:41 PM
flow-php/postgresql received Client::explain() : Plan feature
This means that we can now programmatically extract and analyze postgresql query execution plan!
More details in flow-php.com/documentati...
This means that we can now programmatically extract and analyze postgresql query execution plan!
More details in flow-php.com/documentati...
#1 Did you ever had to make a tradeoffs between using a query builder and using a database specific features like CTE in #postgresql?
Not any more flow-php/postresql is a brand new library that just joined Flow #PHP Ecosystem!
flow-php/postgresql comes with 3 building blocks 👇
Not any more flow-php/postresql is a brand new library that just joined Flow #PHP Ecosystem!
flow-php/postgresql comes with 3 building blocks 👇
December 16, 2025 at 5:13 PM
#1 Did you ever had to make a tradeoffs between using a query builder and using a database specific features like CTE in #postgresql?
Not any more flow-php/postresql is a brand new library that just joined Flow #PHP Ecosystem!
flow-php/postgresql comes with 3 building blocks 👇
Not any more flow-php/postresql is a brand new library that just joined Flow #PHP Ecosystem!
flow-php/postgresql comes with 3 building blocks 👇
Flow #PHP now supports PHP 8.5.
Dropped 8.2, moved to 8.3 for development, added support for 8.5.
0.29.0 coming soon.
github.com/flow-php/fl...
Dropped 8.2, moved to 8.3 for development, added support for 8.5.
0.29.0 coming soon.
github.com/flow-php/fl...
Enabled support for php 8.5 in github actions by norberttech · Pull Request #1906 · flow-php/flow
Resolves: #1905
Change Log
Added
support for php 8.5
Fixed
Changed
Removed
Deprecated
Security
github.com
December 12, 2025 at 11:39 AM
Flow #PHP now supports PHP 8.5.
Dropped 8.2, moved to 8.3 for development, added support for 8.5.
0.29.0 coming soon.
github.com/flow-php/fl...
Dropped 8.2, moved to 8.3 for development, added support for 8.5.
0.29.0 coming soon.
github.com/flow-php/fl...
I'm pushing release of next Flow PHP version by a week (maybe 2).
There are two things I would like to include in the next release:
- support for PHP 8.5 (and migrating codebase to 8.3)
- first release of flow-php/postgresql library
There are two things I would like to include in the next release:
- support for PHP 8.5 (and migrating codebase to 8.3)
- first release of flow-php/postgresql library
December 8, 2025 at 6:10 PM
I'm pushing release of next Flow PHP version by a week (maybe 2).
There are two things I would like to include in the next release:
- support for PHP 8.5 (and migrating codebase to 8.3)
- first release of flow-php/postgresql library
There are two things I would like to include in the next release:
- support for PHP 8.5 (and migrating codebase to 8.3)
- first release of flow-php/postgresql library
flow-php/pg-query quickly escalated from "I just want to parse sql to AST" into "why not build a proper query builder?" 😅
So there is, #PHP Query Builder for #PostgreSQL inspired by JOOQ
(API will change, this is just PoC)
So there is, #PHP Query Builder for #PostgreSQL inspired by JOOQ
(API will change, this is just PoC)
December 5, 2025 at 10:42 AM
flow-php/pg-query quickly escalated from "I just want to parse sql to AST" into "why not build a proper query builder?" 😅
So there is, #PHP Query Builder for #PostgreSQL inspired by JOOQ
(API will change, this is just PoC)
So there is, #PHP Query Builder for #PostgreSQL inspired by JOOQ
(API will change, this is just PoC)
Flow #PHP library for parsing SQL flow-php/pg-query just got significantly better!
Now it can not only turn query into AST but also convert AST to nicely formatted string!
flow-php.com/playground/...
Now it can not only turn query into AST but also convert AST to nicely formatted string!
flow-php.com/playground/...
December 3, 2025 at 9:00 AM
Flow #PHP library for parsing SQL flow-php/pg-query just got significantly better!
Now it can not only turn query into AST but also convert AST to nicely formatted string!
flow-php.com/playground/...
Now it can not only turn query into AST but also convert AST to nicely formatted string!
flow-php.com/playground/...
Another addition to Flow, auto generated Table of Contents to easier get to relevant sections of documentation 😁
December 2, 2025 at 5:24 PM
Another addition to Flow, auto generated Table of Contents to easier get to relevant sections of documentation 😁
I just upgraded Flow #PHP Playground.
Now it opens preview of predefined/uploaded files in tabs.
I also added some colors to the output to make it more readable.
Now it opens preview of predefined/uploaded files in tabs.
I also added some colors to the output to make it more readable.
December 1, 2025 at 9:00 AM
I just upgraded Flow #PHP Playground.
Now it opens preview of predefined/uploaded files in tabs.
I also added some colors to the output to make it more readable.
Now it opens preview of predefined/uploaded files in tabs.
I also added some colors to the output to make it more readable.
🇵🇱
Staram się publikować tylko sprawy techniczne, ale ta jest ważna.
Leszek z Joanną potrzebują pomocy, toczą walkę, której nie powinni, trzeba im pomóc wyrównać szanse.
Więcej możecie przeczytać na pomagam.pl/4hgb6g
Wpłać ile możesz, 5, 10, 500, sky is the limit
Staram się publikować tylko sprawy techniczne, ale ta jest ważna.
Leszek z Joanną potrzebują pomocy, toczą walkę, której nie powinni, trzeba im pomóc wyrównać szanse.
Więcej możecie przeczytać na pomagam.pl/4hgb6g
Wpłać ile możesz, 5, 10, 500, sky is the limit
Walka z rozsianym rakiem jajnika | Pomagam.pl
Cześć! Jestem Asia, miałam wtedy 34 lata i nic nie zapowiadało tego co będzie dalej. Zwykła torbiel, usunie się i po sprawie. Nie martwiłam się zbytnio, lekarze mnie uspokajali. Po zabiegu lekarz operator powiedział tylko, że bardzo mu przykro ale to nie było to czego się spodziewali i niestety …
pomagam.pl
November 28, 2025 at 10:45 AM
🇵🇱
Staram się publikować tylko sprawy techniczne, ale ta jest ważna.
Leszek z Joanną potrzebują pomocy, toczą walkę, której nie powinni, trzeba im pomóc wyrównać szanse.
Więcej możecie przeczytać na pomagam.pl/4hgb6g
Wpłać ile możesz, 5, 10, 500, sky is the limit
Staram się publikować tylko sprawy techniczne, ale ta jest ważna.
Leszek z Joanną potrzebują pomocy, toczą walkę, której nie powinni, trzeba im pomóc wyrównać szanse.
Więcej możecie przeczytać na pomagam.pl/4hgb6g
Wpłać ile możesz, 5, 10, 500, sky is the limit
I'm cooking another cool addition to Flow #PHP 👨🍳
What I was always missing was a proper SQL Parser in PHP, something that can create AST Tree from SQL query string.
So I created one: flow-php.com/documentati...
What I was always missing was a proper SQL Parser in PHP, something that can create AST Tree from SQL query string.
So I created one: flow-php.com/documentati...
Documentation - Flow PHP - Data Processing Framework
Documentation
flow-php.com
November 27, 2025 at 2:01 PM
I'm cooking another cool addition to Flow #PHP 👨🍳
What I was always missing was a proper SQL Parser in PHP, something that can create AST Tree from SQL query string.
So I created one: flow-php.com/documentati...
What I was always missing was a proper SQL Parser in PHP, something that can create AST Tree from SQL query string.
So I created one: flow-php.com/documentati...
I'm very excited about what I'm going to share now!
Flow #PHP just received a fully interactive playground allowing to build and execute ETL pipelines directly in the browser!! 🤯
Demo: youtu.be/bJm0BZUrTrg
Flow #PHP just received a fully interactive playground allowing to build and execute ETL pipelines directly in the browser!! 🤯
Demo: youtu.be/bJm0BZUrTrg
November 25, 2025 at 12:06 PM
I'm very excited about what I'm going to share now!
Flow #PHP just received a fully interactive playground allowing to build and execute ETL pipelines directly in the browser!! 🤯
Demo: youtu.be/bJm0BZUrTrg
Flow #PHP just received a fully interactive playground allowing to build and execute ETL pipelines directly in the browser!! 🤯
Demo: youtu.be/bJm0BZUrTrg
New version of Flow #PHP was released, 0.27.0.
This was a bigger release that brought a few very cool features to DataFrame.
Let's start by covering the new data type - HTML delivered by @stloyd.
This was a bigger release that brought a few very cool features to DataFrame.
Let's start by covering the new data type - HTML delivered by @stloyd.
November 12, 2025 at 11:26 AM
New version of Flow #PHP was released, 0.27.0.
This was a bigger release that brought a few very cool features to DataFrame.
Let's start by covering the new data type - HTML delivered by @stloyd.
This was a bigger release that brought a few very cool features to DataFrame.
Let's start by covering the new data type - HTML delivered by @stloyd.
1/8 I have been recently playing with the idea of creating an interactive playground for Flow #PHP where the ETL pipeline can be executed directly in the browser.
Today I managed to put together the first working version!
Today I managed to put together the first working version!
November 3, 2025 at 7:30 AM
1/8 I have been recently playing with the idea of creating an interactive playground for Flow #PHP where the ETL pipeline can be executed directly in the browser.
Today I managed to put together the first working version!
Today I managed to put together the first working version!
@stloyd came up with a proposition of adding HTLM entry type to Flow #PHP and leveraging DOM\HTMLDocument introduced in PHP8.4
Which in my opinion will open a whole new world of possibilities 🤩
You can check the progress and details here: github.com/flow-php/fl...
Which in my opinion will open a whole new world of possibilities 🤩
You can check the progress and details here: github.com/flow-php/fl...
[Proposal]: Add `HTMLEntry` & related · Issue #1912 · flow-php/flow
Describe the Proposal To easily work with the new \DOM\HTMLDocument, it would be good to introduce a new entry, type & cast for this. This would be a nice addition to the existing XML type, whi...
github.com
October 28, 2025 at 9:00 AM
@stloyd came up with a proposition of adding HTLM entry type to Flow #PHP and leveraging DOM\HTMLDocument introduced in PHP8.4
Which in my opinion will open a whole new world of possibilities 🤩
You can check the progress and details here: github.com/flow-php/fl...
Which in my opinion will open a whole new world of possibilities 🤩
You can check the progress and details here: github.com/flow-php/fl...
Flow #PHP 0.26.0 was just released!
Among fixes and improvements to our website, there is also a small gem.
DataFrame::batchBy()
It's a smarter version of batchSize that not only splits the dataset into batches by size but also keeps them logically grouped by column.
Among fixes and improvements to our website, there is also a small gem.
DataFrame::batchBy()
It's a smarter version of batchSize that not only splits the dataset into batches by size but also keeps them logically grouped by column.
October 27, 2025 at 10:59 AM
Flow #PHP 0.26.0 was just released!
Among fixes and improvements to our website, there is also a small gem.
DataFrame::batchBy()
It's a smarter version of batchSize that not only splits the dataset into batches by size but also keeps them logically grouped by column.
Among fixes and improvements to our website, there is also a small gem.
DataFrame::batchBy()
It's a smarter version of batchSize that not only splits the dataset into batches by size but also keeps them logically grouped by column.
Flow #PHP documentation just got significantly better 🤩
From now on, each example can also have multiple options - third nesting level.
Here is a great example: flow-php.com/data_frame/...
From now on, each example can also have multiple options - third nesting level.
Here is a great example: flow-php.com/data_frame/...
October 22, 2025 at 6:31 PM
Flow #PHP documentation just got significantly better 🤩
From now on, each example can also have multiple options - third nesting level.
Here is a great example: flow-php.com/data_frame/...
From now on, each example can also have multiple options - third nesting level.
Here is a great example: flow-php.com/data_frame/...
Modularization is not easy at all, I described some of the challenges and potential solutions in the latest article on my blog:
norbert.tech/blog/2025-1...
norbert.tech/blog/2025-1...
The Dark Sides of Modularization
Practical challenges of system modularization - how to solve database-level coupling when extracting a module from a monolith. Comparing approaches: separation of responsibilities, projections, anemic events, and materialized views.
norbert.tech
October 21, 2025 at 11:36 AM
Modularization is not easy at all, I described some of the challenges and potential solutions in the latest article on my blog:
norbert.tech/blog/2025-1...
norbert.tech/blog/2025-1...
Great news!
Mago (Rust) has a new release that supports Flow (PHP) Types right out of the box, no extensions needed - just Mago 💪
github.com/carthage-so...
Mago (Rust) has a new release that supports Flow (PHP) Types right out of the box, no extensions needed - just Mago 💪
github.com/carthage-so...
October 12, 2025 at 10:13 AM
Great news!
Mago (Rust) has a new release that supports Flow (PHP) Types right out of the box, no extensions needed - just Mago 💪
github.com/carthage-so...
Mago (Rust) has a new release that supports Flow (PHP) Types right out of the box, no extensions needed - just Mago 💪
github.com/carthage-so...
This is a very cool way to share your reusable commands / hooks / sub-agents. One thing I'm missing here is a step where during plugin installation user could configure it providing things that are custom for his use case
docs.claude.com/en/docs/cla...
docs.claude.com/en/docs/cla...
Plugins - Claude Docs
Extend Claude Code with custom commands, agents, hooks, and MCP servers through the plugin system.
docs.claude.com
October 10, 2025 at 8:36 AM
This is a very cool way to share your reusable commands / hooks / sub-agents. One thing I'm missing here is a step where during plugin installation user could configure it providing things that are custom for his use case
docs.claude.com/en/docs/cla...
docs.claude.com/en/docs/cla...
Took me a while to find my hotel room 😅
October 7, 2025 at 8:00 AM
Took me a while to find my hotel room 😅
Last Friday, I gave a talk at the @PHPersPL meetup in Gdańsk about the Parquet file format and its use in #PHP.
For those who couldn't attend: norbert.tech/blog/2025-0...
P.S. I'm working on launching a series of webinars about Flow #PHP - stay tuned! 💪
For those who couldn't attend: norbert.tech/blog/2025-0...
P.S. I'm working on launching a series of webinars about Flow #PHP - stay tuned! 💪
Parquet - Introduction
Complete guide to Apache Parquet - the binary, columnar file format. Learn how to achieve 10x smaller files, use metadata for lightning-fast filtering, understand Row Groups and Data Pages structure, and explore advanced features like encryption and Dremel algorithms.
norbert.tech
October 6, 2025 at 12:56 PM
Last Friday, I gave a talk at the @PHPersPL meetup in Gdańsk about the Parquet file format and its use in #PHP.
For those who couldn't attend: norbert.tech/blog/2025-0...
P.S. I'm working on launching a series of webinars about Flow #PHP - stay tuned! 💪
For those who couldn't attend: norbert.tech/blog/2025-0...
P.S. I'm working on launching a series of webinars about Flow #PHP - stay tuned! 💪
Flow #PHP GitHub Actions workflows just got faster. We introduced a series of refactorings that aim to reduce the total time of the test suite execution. More details below:
October 2, 2025 at 10:14 AM
Flow #PHP GitHub Actions workflows just got faster. We introduced a series of refactorings that aim to reduce the total time of the test suite execution. More details below:
Flow #PHP 0.25.0 was released yesterday.
This time, we have significantly enhanced the Parquet library along with integrations for Excel and Google Sheets.
As always, you can find more details on the release page:
github.com/flow-php/fl...
This time, we have significantly enhanced the Parquet library along with integrations for Excel and Google Sheets.
As always, you can find more details on the release page:
github.com/flow-php/fl...
Release 0.25.0 · flow-php/flow
[0.25.0] - 2025-09-29
Added
#1866 - [XMLParserExtractor] Add support for Schema - @stloyd
#1864 - [ExcelExtractor] Add support for Schema - @stloyd
#1862 - [GoogleSheetExtractor] Add support for S...
github.com
September 30, 2025 at 8:38 AM
Flow #PHP 0.25.0 was released yesterday.
This time, we have significantly enhanced the Parquet library along with integrations for Excel and Google Sheets.
As always, you can find more details on the release page:
github.com/flow-php/fl...
This time, we have significantly enhanced the Parquet library along with integrations for Excel and Google Sheets.
As always, you can find more details on the release page:
github.com/flow-php/fl...