norbert

@norbert@phpc.social
43 Followers
39 Following
281 Posts
Problem solver, software architect, also working as a Data Witcher ⚔️, hunting and killing 🧌 and 🪳in data processing pipelines! Creator of https://flow-php.com
GitHubhttps://github.com/norberttech
Flow PHPhttps://flow-php.com/
LinkedInhttps://www.linkedin.com/in/norberttech/
Websitehttps://norbert.tech
norbert2d ago

A top request with reports? Saving them as XLSX files. That's why we taught Flow #PHP to master #Excel.

https://flow-php.com/documentation/components/adapters/excel/

Marry Christmas Everyone! 🎄🎁

Documentation - Flow PHP - Data Processing Framework

Documentation

norbert5d ago

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?

norbertDec 18

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 https://flow-php.com/documentation/components/libs/postgresql/client-explain

Show threadnorbertDec 16
#8 If you find my work useful, please consider sponsoring me at https://flow-php.com/sponsor/
Sponsor - Flow PHP - Data Processing Framework

Flow is a PHP-based, strongly typed data processing framework with low memory footprint that can process various data sources consistently. It offers a unified API for all data sources, including CSV, JSON, XML, Text, Parquet, Avro, Rest API, RDBMS, Elasticsearch / Meilisearch. Flow not only enables you to process various data sources consistently, but also strives to accurately detect data types and cast them to the appropriate PHP types.

Show threadnorbertDec 16
#7 I highly encourage you take a look at our docs and share your feedback! https://flow-php.com/documentation/components/libs/postgresql/
Documentation - Flow PHP - Data Processing Framework

Documentation

Show threadnorbertDec 16

#6 And this is only a beginning! What's comming next is going to make extracting data from postgresql a piece of cake.

We are working on dedicated Flow PostgreSQL extract that would let you process PostgreSQL data based on any custom query string!

Show threadnorbertDec 16

#3 On top of AST Nodes from parser we have probably the most advanced PHP Query builder ⚙️

Thanks to experience of other amazing projects like JOOQ, Dapper or sqlx we crafter very elegant fluent interfaces helping you create any query you can imagine!

https://flow-php.com/documentation/components/libs/postgresql/#query-builder

Documentation - Flow PHP - Data Processing Framework

Documentation

Show threadnorbertDec 16
#5 flow-php/postgresql is using flow-php/types to convert data between PHP and PostgreSql that you can easily extend in order to provide your own custom converters!
norbertDec 16

#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 👇

Show threadnorbertDec 16

#4 Last but not least, PostgreSql Client interface! with built in support for Row Mappers 🤯 It comes with a simple Constructor Mapper available out of the box but we are already working on providing bridges for:

- cuyz/valinor
- crell/serde