Blog

  • Sep 24 2014

    Compiling and debugging PostgreSQL’s PgJDBC under Eclipse

    I’ve always worked on PgJDBC, the JDBC Type 4 driver for PostgreSQL, with just a terminal, ant...  

  • Sep 12 2014

    pg_sysdatetime: a simple cross-platform PostgreSQL extension

    A while ago I wrote about compiling PostgreSQL extensions under Visual Studio – without having to recompile...  

  • Sep 12 2014

    pg_sysdatetime: a simple cross-platform PostgreSQL extension

    A while ago I wrote about compiling PostgreSQL extensions under Visual Studio – without having to recompile...  

  • Sep 10 2014

    PHP Tour, La Video

    En juin dernier se tenait le PHP Tour 2014 à Lyon, où j'ai eu le plaisir de présenter une conférence sur PostgreSQL en 2014.

    Cette intervention était filmée, et la vidéo est maintenant disponible :

    En espérant que vous regarderez cette vidéo avec autant d'intérêt que j'ai eu à participer à PHP Tour 2014 !

     

  • Sep 05 2014

    Announcing BDR RPMs for 9.4

    RPMs for BDR (Bi-Directional Replication for PostgreSQL) are now available for testing. They contain BDR release 0.7.1,...  

  • Sep 05 2014

    Announcing BDR RPMs for 9.4

    RPMs for BDR (Bi-Directional Replication for PostgreSQL) are now available for testing. They contain BDR release 0.7.1,...  

  • Aoû 29 2014

    Going to Chicago, Postgres Open

    Next month, Postgres Open 2014 is happening in Chicago, and I'll have the pleasure to host a tutorial about PostgreSQL Extensions Writing & Using Postgres Extensions, and a talk aimed at developers wanting to make the best out of PostgreSQL, PostgreSQL for developers:

    The tutorial is based on first hand experience on the PostgreSQL Extension Packaging System both as a user and a developer. It's a series of practical use cases where using extensions will simplify your life a lot, and each of those practical use case is using real world data (thanks to pgloader).

    Most of the examples covered in the tutorial have a blog entry here that present the idea and the solution, so the tutorial is all about putting it all together. You can already read the blog posts under the YeSQL and Extensions for a preview.

    The developer talk itself is based on the Reset Counter use case where we learn a lot about Common Table Expressions, or WITH queries and Window Functions, my favourite SQL clauses.

    If you want to learn how to implement a modern search user interface for your own product, something that your users know how to use already, then the tutorial is for you, as we will cover PostgreSQL based approximate searches with suggestions ( did you mean ...?) and autocompletion.

    The tutorial gives you the toolset you will use to avoid the situation depicted here.

    See you all in Chicago!

     

  • Aoû 27 2014

    Detecting smelly backups with Barman

    “Ooooh that smell! Can’t you smell that smell?“. That’s a classic rock song by legends Lynyrd Skynyrd,...  

  • Aoû 27 2014

    Detecting smelly backups with Barman

    “Ooooh that smell! Can’t you smell that smell?“. That’s a classic rock song by legends Lynyrd Skynyrd,...  

  • Aoû 25 2014

    Turn your PostgreSQL queries into Charts

    Earlier this year we did compare compare Aggregating NBA data, PostgreSQL vs MongoDB then talked about PostgreSQL, Aggregates and histograms where we even produced a nice Histogram chart directly within the awesome psql console. Today, let's get that same idea to the next level, with pgcharts:

    The new pgcharts application

    The application's specifications are quite simple: edit an SQL query, set your categories and your data series, add in some legends, and get a nice chart. Currently supported are bar, column, pie and donut charts, and we should be able to add anything that http://www.highcharts.com/ has support for.

    Currently, you need to compile the application yourself, and for that you need to install the SBCL compiler. Soon enough you will have a debian package to play with! The README at the pgcharts github place has the details to get you started. Enjoy!

     

© 2001-2014 2ndQuadrant Ltd. All rights reserved. | Privacy Policy