archive-info.com » INFO » A » ALBERTON.INFO

Total: 92

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • Lorenzo Alberton - Articles
    Performance Scalability NoSQL Message Queues Kafka 24 June 2011 Kafka is a distributed publish subscribe messaging system developed at LinkedIn designed to support a very high throughput persistent messages and parallel loading into Hadoop A proposal has been submitted to make Kafka an Apache incubator project PHPNW10 slides and new job PHP Zend Framework Apache Performance Scalability Profiling 19 October 2010 Summary of the PHPNW10 conference Slides about my talk Profile your PHP application and make it fly and new job The Art of Scalability DPC10 wrapup PHP Database Performance Scalability 13 June 2010 A wrapup of the Dutch PHP Conference 2010 Uploaded slides of my talk The Art of Scalability Managing growth PHP UK 2010 RDBMS in the social networks age PHP Database PostgreSQL Firebird SQL Oracle SQL Server Data structures 27 February 2010 Wrapup of the PHP UK Conference 2010 Uploaded slides of my talk RDBMS in the social networks age about graphs in the database Profiling PHP applications with XHProf the path to scalability PHP Tutorial Performance Scalability Profiling 1 December 2009 My latest article on Profiling using XHProf a neat tool developed at Facebook A step by step tutorial to install and use XHProf and some useful hints on how to improve performances and scalability of your PHP application Profiling PHP Applications with XHProf PHP Tutorial Performance Profiling 1 December 2009 An introduction to PHP Profiling using XHProf and some techniques on how to get the most out of your application Speaking at the PHP Barcelona conference 2009 PHP Database PostgreSQL Firebird SQL Oracle SQL Server 26 October 2009 Speaking at the PHP Barcelona Conference 2009 Talk Trees in the Database Advanced Data Structures Create a video preview as animated GIF with FFmpeg and PHP SPL PHP SPL Tutorial Imagick 31 August 2009 Extract frames from

    Original URL path: http://www.alberton.info/articles/filter/tag/PHP/page/1 (2016-04-24)
    Open archived version from archive



  • NEW field 0 pk name set pk value lindex array get NEW field 1 break log inserted row values foreach field TG relatts if string equal nocase lindex array get NEW field 0 pk name 0 set modified field lindex array get NEW field 0 set current value lindex array get NEW field 1 spi exec array C INSERT INTO audit table ts usr tbl fld pk name pk value mod type old val new val VALUES CURRENT TIMESTAMP tguser tgname modified field pk name pk value TG op NULL current value UPDATE set pk value get PK value foreach field TG relatts if string equal nocase lindex array get NEW field 0 pk name set pk value lindex array get NEW field 1 break log updated row values foreach field TG relatts check changed fields if string equal nocase array get NEW field array get OLD field 0 set modified field lindex array get OLD field 0 if string compare modified field 0 set modified field lindex array get NEW field 0 set previous value lindex array get OLD field 1 set current value lindex array get NEW field 1 spi exec array C INSERT INTO audit table ts usr tbl fld pk name pk value mod type old val new val VALUES CURRENT TIMESTAMP tguser tgname modified field pk name pk value TG op previous value current value DELETE set pk value get PK value foreach field TG relatts if string equal nocase lindex array get OLD field 0 pk name set pk value lindex array get OLD field 1 break log deleted row values foreach field TG relatts if string equal nocase lindex array get OLD field 0 pk name 0 set modified field lindex array get OLD field 0 set previous value lindex array get OLD

    Original URL path: http://www.alberton.info/downloads/pgsql_audit_table.sql (2016-04-24)
    Open archived version from archive

  • Lorenzo Alberton - Articles
    conference 2009 PHP Database PostgreSQL Firebird SQL Oracle SQL Server 26 October 2009 Speaking at the PHP Barcelona Conference 2009 Talk Trees in the Database Advanced Data Structures New article Graphs in the database SQL meets social networks Database PostgreSQL Firebird SQL Oracle SQL Server Tutorial Data structures 7 September 2009 Graphs in the database how to store a graph data structure in a DBMS and answer the most common queries typical of social networks like You might also know or You might also like or How you are connected to XYZ degrees of separation Graphs in the database SQL meets social networks Database PostgreSQL Firebird SQL Oracle Data structures 7 September 2009 How to store a graph data structure in a DBMS and query it to solve many of the problems of social networks Trees in the database It sure ain t no CouchDB PHP Database PostgreSQL Firebird SQL Oracle SQL Server Data structures 27 June 2009 Wrap up of the Dutch PHP Conference Amsterdam 11 13 June 2009 Speaking at the Dutch PHP Conference 2009 PHP Database PostgreSQL Firebird SQL Oracle SQL Server 10 April 2009 Speaking at the Dutch PHP Conference 2009 Talk Trees in the Database Advanced Data Structures Database identifiers quoting and case sensitivity PHP PEAR PostgreSQL Oracle 3 December 2008 Exploring database delimited identifiers and case sensitivity the effect of quoting table and field names in the various DBMS Updated articles to extract META informations from databases PHP Database PostgreSQL Firebird SQL Oracle SQL Server INFORMATION SCHEMA 9 September 2008 By popular request I ve updated my articles explaining how to retrieve meta data from your DBMS Firebird SQL PostgreSQL Oracle SQL Server Have fun PostgreSQL table audit Database PostgreSQL 20 February 2007 PostgreSQL table audit a tutorial featuring a working example with triggers

    Original URL path: http://www.alberton.info/articles/filter/tag/PostgreSQL/page/1 (2016-04-24)
    Open archived version from archive

  • Lorenzo Alberton - Articles
    of your PHP application Profiling PHP Applications with XHProf PHP Tutorial Performance Profiling 1 December 2009 An introduction to PHP Profiling using XHProf and some techniques on how to get the most out of your application New article Graphs in the database SQL meets social networks Database PostgreSQL Firebird SQL Oracle SQL Server Tutorial Data structures 7 September 2009 Graphs in the database how to store a graph data structure in a DBMS and answer the most common queries typical of social networks like You might also know or You might also like or How you are connected to XYZ degrees of separation Create a video preview as animated GIF with FFmpeg and PHP SPL PHP SPL Tutorial Imagick 31 August 2009 Extract frames from a movie and create a preview as animated GIF using PHP SPL Imagick and FFmpeg Zend Framework testing emulating HTTP calls PHP PEAR Zend Framework Tutorial Testing 29 October 2008 How to test HTTP calls using Zend Framework using Dependency Injection and a stub HTTP Client PEAR Translation2 tutorials backend usage PHP PEAR Tutorial 18 May 2008 This second Translation2 tutorial shows how to add update and remove languages and translations PEAR Translation2 tutorials frontend usage PHP PEAR Tutorial 13 May 2008 This first Translation2 tutorial shows how to deal with translated strings how to fetch them one by one or in groups and how to transform cache and decorate them PEAR Translation2 Tutorials PHP PEAR Tutorial 6 May 2008 I just released the first stable version of Translation2 Here s an overview of the package its purpose and its design PEAR Pager Tutorials Use Pager with Smarty Use Pager Wrapper with AJAX PHP PEAR Database Tutorial 8 March 2007 Since I keep getting emails asking for help with PEAR Pager here s a couple

    Original URL path: http://www.alberton.info/articles/filter/tag/Tutorial/page/1 (2016-04-24)
    Open archived version from archive



  •