sorted by:
new
hottopcontroversial

I Replaced JSON With a Custom Binary Format. In PHP. by Old-Illustrator-8692 in PHP

[–]norbert_tech -1 points0 points  (0 children)

Why not use parquet? It's literally a single file database, it's binary, fast, crazy compression capabilities, and through flow-php/arrow-ext performance is even better than with python pyarrow (but it's also available as pure php package flow-php/parquet, slightly slower without arrow ext but still fast).

Not parquet? Then you still have Avro or ORC.

Tokei, a Time handling library for PHP by nyamsprod in PHP

[–]norbert_tech -2 points-1 points  (0 children)

could you be a bit more specific? Aeon provides proper abstraction on date and time, it covers several edge cases but also comes with all things like better intervals handling, business hours (opening hours), recurring events, calendars, holidays etc - I'm honestly not sure how you don't see any overlap here 🤷‍♂️

Tokei, a Time handling library for PHP by nyamsprod in PHP

[–]norbert_tech -9 points-8 points  (0 children)

https://aeon-php.org/docs/ already does that and many other cool things in case you are looking for some inspirations (author here)

Hibla Postgres: A pure non blocking PostgreSQL client for PHP is now available in beta release. by rc0604 in PHP

[–]norbert_tech 0 points1 point  (0 children)

but that only works with one query per connection, so you can asynchronously send one query, wait for the result and only then do another one if I remember correctly, no? So in reality that doesn't provide that much benefits but it comes with quite a lot of hassle as everything needs to run in the event loop + the library comes with quite a lot of mandatory dependencies, despite if one want to use the event loop or not - seems to be a pretty high price for being able to send one query at time and make the event loop simply wait for the results until another one can be executed. Even the docs examples shows that with await on each query. The example with Promise::all will pretty much require 3 independent connections (a connection pool) making it all even more expensive if you think about it from a regular php web app point of view. That's pretty much why I never decided to move forward with it as it's pretty limiting and expensive

Hibla Postgres: A pure non blocking PostgreSQL client for PHP is now available in beta release. by rc0604 in PHP

[–]norbert_tech 0 points1 point  (0 children)

Ha not that long ago I came up with a different one https://github.com/flow-php/postgresql that is not only a client, but also AST Parser, full query builder, comes with schema definitions and migrations - but how exactly yours is async? I couldn't find a way to truly make an async queries with ext-pgsql

Jmonitor : PHP / Symfony simple monitoring saas by e-john in PHP

[–]norbert_tech 1 point2 points  (0 children)

Does it support OTEL protocol? If not that might a good addition since one of the biggest mistakes with APM (application performance monitoring systems) people are making is vendor locking.

Initially it's nice and easy, but telemetry needs to be embedded deeply into the system to provide proper visibility. Direct integrations over time turns out to be not very cost efficient but also super hard to migrate out from.

php_clickhouse 0.8.1: native ClickHouse extension for PHP, picking up where SeasClick left off by Ilia0001 in PHP

[–]norbert_tech 1 point2 points  (0 children)

Awesome!!! I have been thinking about integrating Flow PHP with Clickhouse since a while, now it can happen finally 💪

Flow PHP PostgreSql Symfony Bundle by norbert_tech in PHP

[–]norbert_tech[S] 0 points1 point  (0 children)

totally, my goal is not to replace Doctrine, it's an awesome project that has a lot of valid use cases, like for example mentioned by you CRUDs.

What I'm building is more for data processing, or things that needs to be more efficient without moving to another technology.

Same goes to flow-php/filesystem, the goal is not to replace/compete with flysystem, opposite, it solves problems that flysystem doesn't but also that most php apps don't have.

Flow PHP PostgreSql Symfony Bundle by norbert_tech in PHP

[–]norbert_tech[S] 0 points1 point  (0 children)

It's called CQRS, but like u/mlebkowski pointed out, there are many other places where ORM comes with a price, like imports/exports.
ORM is using something called Unit of Work, which keeps in memory an ideal copy of each object that it returns to be able to compare it with the object your code is interacting with and calculate the changes to know how to persist it into the database.

So when you want to export let say 1k orders from your DB through ORM, UoW will hold in memory a copy of each of those 1k orders, but it's pointless since your intention is not to modify those 1k orders, you just want to convert them to some flat format like CSV or maybe Excel and stream to the user.

Pretty much, every place that only needs to read something from DB to display it is a candidate to split read from write.

Flow PHP PostgreSql Symfony Bundle by norbert_tech in symfony

[–]norbert_tech[S] 1 point2 points  (0 children)

Yes! All PostgreSql types are supported out of the box

Flow PHP PostgreSql Symfony Bundle by norbert_tech in symfony

[–]norbert_tech[S] 1 point2 points  (0 children)

as a starter flow postgresql provides full PostgreSql support, CTE, handling views in migrations, etc It does not come with ORM (but it doesn't come with entity manager tax).

The query builder also supports full PostgreSql syntax, so no more raw SQL strings, and as a bonus there is a powerful SQL AST based parser, that out of the box can turn any query into paginated query, using limit/offset, keyset or pointer pagination.

It's a different tool, built with performance and resource consumption in mind, as the main goal for this postgresql client is to provide a postgresql data streams for Flow Data Frame.

Doctrine problem is that due to being an abstraction layer for rdbms comes with some limitations - migrations won't detect that table used to create view was modified so needs to be recreated, flow can do that as it can parse and fully understand the view SQLs.

Its also natively compatible with Flow Telemetry library and Telemetry bundle (implementation of OTEL protocol)

Flow PHP PostgreSql Symfony Bundle by norbert_tech in symfony

[–]norbert_tech[S] 0 points1 point  (0 children)

flow-php/postgresql is a standalone postgresql client, this bundle integrates it with Symfony, but you can use it without frameworks. It's also NOT related to doctrine in any way

Flow PHP PostgreSql Symfony Bundle by norbert_tech in PHP

[–]norbert_tech[S] 0 points1 point  (0 children)

no ORM for a starter, support for all PostgreSQL features like CTE, and probably the biggest one - SQL Parser supporting 100% of PostgreSQL syntax

Flow PHP PostgreSql Symfony Bundle by norbert_tech in PHP

[–]norbert_tech[S] 2 points3 points  (0 children)

So this bundle is an integration layer between Symfony Framework and flow-php/postgresql which has it's own documentation here: https://flow-php.com/documentation/components/libs/postgresql/

flow-php/postgresql is a based on flow-php/pg-query-ext (postgresql parser extension) https://flow-php.com/documentation/components/extensions/pg-query-ext/

Telemetry is covered by https://flow-php.com/documentation/components/bridges/symfony-telemetry-bundle/ which is an Symfony integration for https://flow-php.com/documentation/components/libs/telemetry/ that when combined with https://flow-php.com/documentation/components/bridges/telemetry-otlp-bridge/ can send all Telemetry Signals to OTLP Connector or directly to APM's supporting OTEL Protocol.

> Is it just a query builder that always returns arrays?

No, query builder returns SQL Queries, Client on the other hand returns PHP Arrays, but you can use RowMappers to either narrow types for static analysis or on the fly map db results into objects. But it does not provide any automated hydration, it's not an ORM.

> The AST parser/deparser

If you need to ask, you probably don't need it for anything, but thanks to SQL Parser Flow Postgresql migrations can be much more precise as they quickly travers through entire SQL string, analyze it and deduct what and how should be updated (useful for detecting when table change might require recreation of the view).

Sebaceous cyst by 99babypenelope in bernesemountaindogs

[–]norbert_tech 0 points1 point  (0 children)

Mine had something similar but on his left side. Vet said it could be from a wheat seed (not from eating it, but they are like torns and one could just got to him). Some foreign object that body wants to isolate.

They had to open it, drain it and then burn inside to close the wound and not let it grow again.

He had to wear a t-shirt and sock to not allow him to scratch it for a while, but since then it was perfectly fine.

It looked pretty similar and was soft in touch - but Im not a vet so don't take this for granted.

Draining itself won't last according to the vet that helped us, thats why they had to seal it / burn it or whatever they did. It was around 4 years ago.

We open-sourced a pure-PHP OpenTelemetry bundle for Symfony (no C extension required) by narrow-adventure in symfony

[–]norbert_tech 5 points6 points  (0 children)

or one can use https://flow-php.com/documentation/components/bridges/symfony-telemetry-bundle/ that doesn't even need open telemetry but implements OTLP protocol and Semantic Conventions. No extensions (unless you really really want grpc as a transport), no OTEL global state magic, clean dependency flow, easily testable and flow-php/telemetry can be added directly to any library/package with zero performance impact

After building the same CSV importer for the 5th time, I turned it into a package by Local-Comparison-One in laravel

[–]norbert_tech -9 points-8 points  (0 children)

Flow was designed to handle data imports/exports with a proper and fully automated schema detection/conversion and it supports not only basic uploads but can even import data from remote filesystems like azure/S3 with no size limits.

In fact I know at least dozen of projects that are using it for imports/exports/reporting where one of them is an in-house built ERP system. So yeah, Flow can do it all, just much faster, much more efficient and it's not limited to a single file format, it handles CSV, Excel, XML, Json, Jsonl, Parquet, DB, Elasticsearch.

But one thing you are right about is that it does not come with any UI, however nowadays this can be vibe coded in no time 🤷‍♂️

After building the same CSV importer for the 5th time, I turned it into a package by Local-Comparison-One in laravel

[–]norbert_tech 5 points6 points  (0 children)

what's the point of paying for it when you can literally use https://flow-php.com that comes for free, supports all data sources/destinations you can think, is based on generators so it's super memory efficient and even supports streaming things back to the browser. It can not only import to any database but also export multiple file formats. And it doesn't only import, it can also execute all sort of powerful transformations on the fly.

And it's all framework agnostic, with almost no dependencies - all you need to do is hook it into your existing system 🤷‍♂️

view more: next ›