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 - Speaking at the PHP Barcelona conference 2009
    Protocols Historical Twitter access A journey into optimising Hadoop jobs Kafka proposed as Apache incubator project NoSQL Databases What When and Why PHPUK2011 PHPNW10 slides and new job Speaking at the PHP Barcelona conference 2009 PHP Database PostgreSQL Firebird SQL Oracle SQL Server 26 October 2009 09 30 I m happy to announce I ll be speaking at the PHP Barcelona Conference 2009 Barcelona 30 31 October 2009 I will be giving my Trees in the database talk with an in depth explanation on the various models to store a tree data structure into a relational database If you can make it register for the event it s very cheap 50 euro for a two day ticket or 30 euro for a single day ticket and the schedule looks great with interesting talks and top rated speakers See you there Follow lorenzoalberton Related articles Speaking at the Dutch PHP Conference 2009 The Art of Scalability DPC10 wrapup Back to the articles archive Lorenzo Alberton Lorenzo has been working with large enterprise UK companies for the past years and is now CTO at DataSift He s an international conference speaker and a long time contributor to many open source projects Follow

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


  • Lorenzo Alberton - Articles - Speaking at the Dutch PHP Conference 2009
    Oracle SQL Server 10 April 2009 00 18 I m happy to announce I ll be speaking at the Dutch PHP Conference 2009 in Amsterdam 11th to 13th June 2009 The conference organised by Ibuildings is packed with advanced tutorials and talks with great presenters from the EU and the US My talk is about tree data structures in the database Storing tree structures in a bi dimensional table has always been problematic The simplest tree models are usually quite inefficient while more complex ones aren t necessarily better In this talk I ll briefly go through the most used models adjacency list materialized path nested sets and introduce some more advanced ones belonging to the nested intervals family MPTT Continued Fractions Farey algorithm and other encodings I ll describe the advantages and pitfalls of each model some proprietary solutions e g Oracle s CONNECT BY and one of the SQL Standard s upcoming features Common Table Expressions I hope to see you there NB Early Bird Registration ends April 30th Follow lorenzoalberton Related articles Trees in the database It sure ain t no CouchDB Speaking at the PHP Barcelona conference 2009 The Art of Scalability DPC10 wrapup Back to

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

  • Lorenzo Alberton - Articles - Updated articles to extract META informations from databases
    journey into optimising Hadoop jobs Kafka proposed as Apache incubator project NoSQL Databases What When and Why PHPUK2011 PHPNW10 slides and new job Updated articles to extract META informations from databases PHP Database PostgreSQL Firebird SQL Oracle SQL Server INFORMATION SCHEMA 09 September 2008 12 40 It looks like my articles on how to extract META information from your favorite DBMS with INFORMATION SCHEMA or system tables are still very popular and I keep receiving a lot of mails on how to write similar queries to retrieve some obscure details about constraints indices stored procedures etc For the greater good of mankind and to reduce the flow of emails to my Inbox a bit I updated the articles and included new queries Interbase Firebird INFORMATION SCHEMA Oracle INFORMATION SCHEMA PostgreSQL INFORMATION SCHEMA SQL Server INFORMATION SCHEMA Enjoy Follow lorenzoalberton Related articles Extracting META information from Interbase Firebird SQL INFORMATION SCHEMA Extracting META information from Oracle INFORMATION SCHEMA Extracting META information from PostgreSQL INFORMATION SCHEMA Extracting META information from SQL Server INFORMATION SCHEMA Back to the articles archive Lorenzo Alberton Lorenzo has been working with large enterprise UK companies for the past years and is now CTO at DataSift He s

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

  • Lorenzo Alberton - Articles
    Packt Publishing Book contents highlights and impressions A sample chapter is included Extracting META information from Interbase Firebird SQL INFORMATION SCHEMA Database Firebird SQL INFORMATION SCHEMA 13 November 2007 Extracting META informations from Interbase Firebird System Tables INFORMATION SCHEMA PEAR MDB2 2 5 0a1 released PHP PEAR Database 28 October 2007 A new alpha release of MDB2 is out Please test the new FOREIGN KEY support and report any issue you may experience before a stable release Enjoy PEAR MDB2 FOREIGN KEY support is complete PHP PEAR Database 15 August 2007 I ve finally committed the last pieces of code to implement full FOREIGN KEY support in the MDB2 Manager and Reverse modules Please fetch the CVS version of the package and test it Catching up July 2007 PHP PEAR Database 22 July 2007 Zürich PEAR updates and MDB2 Oracle development PEAR MDB2 updates FOREIGN KEY support PHP PEAR Database 17 June 2007 Some updates on recent MDB2 developement FOREIGN KEY support in the Manager and Reverse modules etc Also updated SQL technical articles on INFORMATION SCHEMA for Firebird PostgreSQL SQL Server and Oracle Extracting META information from Oracle INFORMATION SCHEMA PHP Database Oracle INFORMATION SCHEMA 17 June 2007 Extracting

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

  • Lorenzo Alberton - Articles
    T SQL 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 of new examples about the most requested features 1 how to use Pager with a template engine like Smarty 2 how to use Pager Wrapper to paginate database results and display them using AJAX PostgreSQL table audit Database PostgreSQL 20 February 2007 PostgreSQL table audit a tutorial featuring a working example with triggers and a PL TCL function Or for once in a while PHP is not the right tool Firebird 2 cheat sheet PHP Database Firebird SQL Cheat Sheet 6 November 2006 Cheat sheet for the upcoming Firebird 2 A handy reference of the FB2 datatypes an useful query reference and a list of the PHP Firebird Interbase functions PostgreSQL cheat sheet PHP Database PostgreSQL Cheat Sheet 6 November 2006 Cheat sheet for PostgreSQL 8 A handy reference of the PostgreSQL datatypes an useful query reference with an eye on the INFORMATION SCHEMA tables and a list of the internal PostgreSQL functions PEAR Pager Tutorials Article Pagination and Navigation PHP PEAR Database Tutorial 16 October 2006 How to navigate through the paragraphs of a long article with PEAR Pager DBMS and charsets a summary and a call for help PHP PEAR Database MySQL PostgreSQL Firebird SQL Oracle SQLite Charset 28 September 2006 Some clarification about charset settings for the various DBMS MySQL PostgreSQL Firebird Interbase Oracle Sqlite and a call for help for charset setting support in PEAR MDB2 PEAR Pager Tutorials Paginate database results PHP PEAR Database Tutorial 8 September 2006 Paginate database results with PEAR Pager in an efficient way PEAR Pager Tutorials PHP PEAR Database Tutorial 8 September 2006 New

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

  • Lorenzo Alberton - Articles
    META information from a PostgreSQL database using the INFORMATION SCHEMA views and the system catalogs pg class pg user pg view PHP PDO Firebird status PHP PEAR Database Firebird SQL Windows PDO 11 April 2006 A quick roundup of the PHP PDO Firebird driver Test of its current status what works and what doesn t HowTo Install Firebird Interbase with PHP on Windows A step by step tutorial PHP PEAR

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

  • Lorenzo Alberton - Articles - Extracting META information from Interbase/Firebird SQL (INFORMATION_SCHEMA)
    1 THEN INSERT WHEN 2 THEN INSERT WHEN 3 THEN UPDATE WHEN 4 THEN UPDATE WHEN 5 THEN DELETE WHEN 6 THEN DELETE END AS trigger event CASE RDB TRIGGER INACTIVE WHEN 1 THEN 0 ELSE 1 END AS trigger enabled RDB DESCRIPTION AS trigger comment FROM RDB TRIGGERS WHERE UPPER RDB TRIGGER NAME AUTOINCREMENTPK Detailed VIEW info If given a VIEW name you want to retrieve the field aliases and the field names in the original table you can run this query SELECT d RDB DEPENDENT NAME AS view name r RDB FIELD NAME AS field name d RDB DEPENDED ON NAME AS depended on table d RDB FIELD NAME AS depended on field FROM RDB DEPENDENCIES d LEFT JOIN RDB RELATION FIELDS r ON d RDB DEPENDENT NAME r RDB RELATION NAME AND d RDB FIELD NAME r RDB BASE FIELD WHERE UPPER d RDB DEPENDENT NAME NUMBERSVIEW AND r RDB SYSTEM FLAG 0 AND d RDB DEPENDENT TYPE 1 VIEW ORDER BY r RDB FIELD POSITION If you want to get the VIEW definition though the above query is not enough It will only show the matches between aliases and real fields Use the following query to get the VIEW body SELECT RDB VIEW SOURCE FROM RDB RELATIONS WHERE RDB VIEW SOURCE IS NOT NULL AND UPPER RDB RELATION NAME NUMBERSVIEW One last tip Since Firebird 2 1 you can query the database for some system information like the engine version the network protocol etc Have a look at the doc sql extensions README context variables2 txt file for a listing of all the system variables that are available Here s an example of what you can do SELECT RDB GET CONTEXT SYSTEM ENGINE VERSION AS engine version RDB GET CONTEXT SYSTEM NETWORK PROTOCOL AS protocol RDB GET CONTEXT SYSTEM CLIENT ADDRESS AS address FROM RDB DATABASE What else System tables are a powerful tool in the hands of the Interbase Firebird db admins The queries listed in this page are just the top of the iceberg you can retrieve a lot more from these tables If you d like to see some other examples or have some comments and or suggestions just drop me a mail you can find my address in the footer of this page and I ll add them to this list HTH Follow lorenzoalberton Related articles Firebird 2 cheat sheet Extracting META information from Oracle INFORMATION SCHEMA Extracting META information from PostgreSQL INFORMATION SCHEMA Extracting META information from SQL Server INFORMATION SCHEMA Updated articles to extract META informations from databases 33 responses to Extracting META information from Interbase Firebird SQL INFORMATION SCHEMA Jaen 06 August 2009 13 04 Great article thanks Sofi 27 August 2009 13 40 This is really great article I was wondering what system tables are affected when data is inserted updated deleted to ordinary tables If there are any I m interested in adding a trigger to such table to add some global functionality if it is possible Thanks Albert 27 August 2009 22 04 Nice article but when I executed the query to extract Foreign Keys information on Firebird 2 1 1 17910 I didn t get any rows though I have foreign keys on my tables After playing a while with metadata tables I ve discover right query select rc rdb constraint name AS fk name rcc rdb relation name AS child table isc rdb field name AS child column rcp rdb relation name AS parent table isp rdb field name AS parent column rc rdb update rule AS update rule rc rdb delete rule AS delete rule from rdb ref constraints AS rc inner join rdb relation constraints AS rcc on rc rdb constraint name rcc rdb constraint name inner join rdb index segments AS isc on rcc rdb index name isc rdb index name inner join rdb relation constraints AS rcp on rc rdb const name uq rcp rdb constraint name inner join rdb index segments AS isp on rcp rdb index name isp rdb index name Ady 07 September 2009 11 05 Hi Nice article and great work I tried obtaining the dependencies of a table particularly the stored procedures that depend on a table What s strange is that the RDB DEPENDENCIES table returns a few rows indicating certain procedures depend on the table but the RDB PROCEDURES indicates that there are no stored procedures in the database Is the RDB DEPENDENCIES content outdated Do I need to update sync it before querying it Lorenzo Alberton 08 September 2009 00 10 Ady I don t think the content of the system tables ever gets outdated What s the value of the RDB DEPENDENCIES RDB DEPENDENT TYPE field for your stored procedure If it s 5 there should be an entry in the RDB PROCEDURES table as well Hans 03 October 2009 18 53 When listing triggers the correct WHERE statement should be WHERE RDB SYSTEM FLAG 0 not IS NULL Lorenzo Alberton 03 October 2009 19 17 Hans that depends on what Firebird version you are using The safest thing to do is to check for both WHERE RDB SYSTEM FLAG IS NULL OR RDB SYSTEM FLAG 0 David Ballantyne 22 October 2009 16 09 Hi Lorenzo Im a dbms software tools developer currently working on ISO Information Schema objects for DBMS s that do not have an ISO standard implementation e g firebird oracle etc Just as a point of clarrification ISO Information Schema views were introduced in the 92 SQL Standard then updated in both the 99 and 2003 Standards As far as I am aware there are currently no DMBS implementations based on the 99 or 2003 extensions I am also hoping that once complete the Firebird foundation may be interested in implementing the ISO Information Schema views which I will be more than happy to dontate once complete and tested Moez Slimi 28 March 2010 19 42 Great article Firebird is the best choice for database centric development

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

  • Lorenzo Alberton - Articles
    book Articles Firebird SQL PHP PDO Firebird status PHP PEAR Database Firebird SQL Windows PDO 11 April 2006 A quick roundup of the PHP PDO Firebird driver Test of its current status what works and what doesn t HowTo Install Firebird Interbase with PHP on Windows A step by step tutorial PHP PEAR Database Firebird SQL Windows 30 March 2006 A step by step tutorial to install Firebird SQL on

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



  •