News

Release: Pomm 2.0 beta 1
published 3 years ago

We are thrilled to begin the stable release process of Pomm2. This version is almost a complete rewrite of Pomm but still shares the exact same philosophy: Data structure is defined in the place it is the more constrained: the database. Entities are flexible containers and know nothing about databases. There will be no query builders (but there is a condition builder). SQL is first class citizen. The idea behind Pomm took place in...


Pomm2 profiler for Silex
published 4 years ago

We are happy to announce a Profiler is available for the Silex micro-framework. Big big thanks go to Jérôme Macias who bootstrapped the code for Silex2. It has been enhanced since to display all informations available in the query listener for each query: query time query parameters query results count formatted and readable SQL hydrated entity type if any There is still lot to do but it already does the job. We need...


SfCon 2014 in Madrid
published 4 years ago

The SfCon 2014 in Madrid was a huge event and a special one for us. It was one of these times we could unveil the result of several months effort in a 45 minutes presentation. Of course, the main subject of the talk was « how to leverage Postgresql features in a web development » but isn't Pomm2 the best way to do so ? The slides of this talk are available and if you were part of the awsome audience, you can rate the talk (if hadn'...


SymfonyCon Madrid 2014
published 4 years ago

I will be speaking about Pomm and Postgresql at the biggest Symfony event of the year. I am thrilled to unveil how simple it is to leverage Postgresql feature using Pomm2 and how it can turn your database into the best flamenco partner for your next project. See you there ! ...


Pomm2 feature hightlight: the CLI
published 4 years ago

Yes, there is a Command Line Interface with the coming Pomm2. Installing it is a matter of seconds. Just add the following composer.json file in an empty directory: { " minimum-stability ": " dev ", " require ": { " pomm-project/cli ": " dev-master " } } and launch the well known composer.phar install . Once done, the CLI expects to find a Pomm instance pre-loaded with database configuration...


Using Postgresql notify in 5 minutes
published 4 years ago

It takes merely 5 minutes to write an observer using Pomm2: The PHP code is the following: It is a very simple piece of code, it does wait for a postgesql's NOTIFY command on the pika channel. When a notification is received, it is printed on the console. If the data attached with the event is stop , the script exits. Let's have a look in Postgresql's logs to see what happened: 10:46:32 UTC LOG: duration:...


Pomm NextGen is in the pipe
published 4 years ago

It has been quiet around this website lately. In the quietness of a cathedral a new version of Pomm was emerging. What will be Pomm 2.0 has been written from scratch relying on almost four years of Pomm experience. As expected there are tons of improvements, as expected, migrating a project from Pomm 1.x will be hard. Pomm NextGen is still under developments and no beta has been released yet, so it is very likely API will change. Let's...


Pomm 1.2.2 is available
published 4 years ago

I am pleased to announce that Pomm 1.2.2 is available. This is a bug fix release. Lot of thanks go to Arnaud Buchoux for his pull requests on documentation and the code. Changes include More strict primary key checking in 'ByPK' methods. Double quotes bug in Range converters. Better escaping for Pg objects. Typos in documentation. The code update is available from Packagist or Github . ...


PgDayFR Toulon 2014
published 4 years ago

I am very pleased to announce I will talk at the French PgDay in Toulon the 5th and 6th of June. My talk will be about the use of Postgresql's types in web developments. I will illustrate with examples how using Postgres types and operators makes the development easier and why Pomm is one of the best tools to use them. The PGDayFR is the most important Postgresql event in France with a lot of core contributors. If you are just curious or enthusiast...


Pomm 1.2.1 is available
published 4 years ago

This is a maintenance release, Collections were not scrollable iterators, fixed by sanpii . Field definitions could not be overriden. Minor cosmetic changes. Composer should update your projects automatically. ...


PHPTour Lyon 2014
published 4 years ago

I am happy to announce I will talk at the PHPTour 2014 in Lyon. This the biggest PHP event in France and there will be lot of talented developers and interesting talks. The subject of my talk will be how to leverage Postgresql features in PHP developments. As Pomm's lead developer, of course, I am thrilled to be able to share my experience about the subject I love but I guess Postgresql attracts more and more community's attention because...


Pomm 1.1.5 is out
published 4 years ago

This is a maintenance release, it fixes a minor security issue in the converter and some typos. ...


pomm 1.2 is available
published 4 years ago

Better, simpler, faster The 1.2 branch was under development since April 2013 and it has been an interesting time. The heart of Pomm has been deeply remodelled to bring tremendous features and performances. Pomm uses PHP's native Postgresql API instead of PDO Configurable connections JSON, timestamp with timezone and composite types converter have been added Observer for LISTEN / NOTIFY support Prepared statement pooling Generic...


PHP North East Conference 2014
published 4 years ago

I am happy to announce I will be, amongst passionate speakers, part of the PHPNE2014 event that will take place at Newcastle on the 18th of March. The schedule is available from the official website I will present how developers using Pomm are able to leverage Postgresql features in their applications and how it can make the difference. ...


Pomm 1.2-RC3 is out
published 5 years ago

Good news, it sounds final countdown to Pomm 1.2.0 is reaching its end. This third release candidate release proposes a cleaner source code by far, thanks to SensioLabs insight(tm) analysing tool. Although Pomm does not own any medal because of the eval statement in the HStore converter, it provided an deep and accurate analysis of the code that could lead to an efficient refactoring. Without this eval , Pomm would earn a silver medal...


feature highlight: composite types
published 5 years ago

Composite type is a way to represent structured data as part of other data. One example is user postal address. In a lot of cases, addresses are structured in a different table and programmers use a join to fetch the user with its address as an object. From a business perspective, address are never used alone so they should not have their own set. From a performance point of view, this join is really expensive as soon as there are search on every...


Pomm 1.2-RC2 is out
published 5 years ago

We are pleased to inform you the "1.2-RC2" release has been tagged last night. It is somehow unusual to see a Release Candidate version to propose new features, but as this shiny new version of Pomm has been tested on development sites, it appeared we were two fingers from some useful functionalities it would have been foolish not to craft Pomm 1.2 with. One of the most missed features from any other database framework is the Postgresql's asynchronous...


Pomm 1.1.4 is out
published 5 years ago

I am happy to announce that 5 months after the previous version, Pomm 1.1.4 has been released this week end. It appeared a significant number of corrections justified a new version. The changelog contains the following: Bug in the string converter with empty string and NULL Lot of typos were found in the documentation Added missing method getMaxPerPage in the Pager class Bug in PDOFilter Exception Bug with intervals interpretation...


Pomm 1.2 is on the launchpad
published 5 years ago

9 months after the 1.1 release, the first release candidate of the 1.2 version is out. This kind of blog posts often mention that is has been a tough work to make this release to happen but, here, it is not the case. The main word of this release was "Keep It Stupid and Simple" and as such, time has been taken to ensure chosen solutions were the best fit. Pomm now uses PHP's native Postgresql API And this is a huge improvement ! The first...


Feature highlight: The Where query builder.
published 5 years ago

It often happens you can not know in advance what is the condition of your query going to be. Take by example the search form of an electronic part store web site. Just for the resistor component, the possible search criteria are: value in ohms from 0.1 to 10 million with more than 20 possible values in every power of ten. precision (0.1%, 1%, 5% and 10%) power dissipation from 0.125 to 100W type (carbon, metal, wire wound, cement, dissipated...