Norbert Orzechowicz
@norbert_tech
Followers
1K
Following
2K
Media
336
Statuses
3K
Problem solver, independent consultant, software architect, on a quest to make data friendly and helpful.
Internet
Joined July 2012
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?
1
0
1
Yes ๐
One really, really, really good use case for AI and coding: Writing unit integration tests. I always hated doing these, because most of the effort was about the setup (remembering how to use the test framework, how to create a fake, a mock, the syntax) Love handing it off!!
0
0
0
Mago 1.0 is live. ๐ฆ ๐ โ
Linter โ
Formatter โ
Static Analyzer โ
Architectural Guard A unified, oxidized PHP toolchain. ๐ฆ๐ https://t.co/W9US18CrSG
#PHP #StaticAnalysis #Linter
20
66
385
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://t.co/S0mXh0kboY
0
0
0
#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 ๐
1
1
0
#8 If you find my work useful, please consider sponsoring me at
flow-php.com
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...
#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 ๐
0
0
0
#7 I highly encourage you take a look at our docs and share your feedback!
flow-php.com
Documentation
1
0
0
#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!
1
0
0
#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!
1
0
0
#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
1
0
0
#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://t.co/QwQIvJZ2Lt
flow-php.com
Documentation
1
0
0
#2 Parser Thanks to awesome https://t.co/iqwowDaILe our parser can break any valid postgresql query string into AST. It works with a single or multiple queries statements. Super helpful for adjusting programmatically any query (for example for pagination or validation)
github.com
C library for accessing the PostgreSQL parser outside of the server environment - pganalyze/libpg_query
1
0
0
#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 ๐
1
1
0
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
Resolves: #1905 Change Log Added support for php 8.5 Fixed Changed Removed Deprecated Security
0
0
0
As you can imagine, creating query builders for whole SQL (not only INSERT/DELETE/UPDATE/SELECT) is a maaaaaasive task. That's why new Flow will come a bit later, maybe as a ๐๐ from ๐
0
0
1
flow-php/postgresql library is an evolution of flow-php/pg-query that started as a simple parsers and already evolved into whole postgresql library that comes with query builders for pretty much anything available in postgresql syntax until version 17 ๐คฏ
1
0
0
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
1
0
0
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)
1
0
1
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! https://t.co/GF3utKCAqq
0
0
2
Another addition to Flow, auto generated Table of Contents to easier get to relevant sections of documentation ๐
0
0
1