PHP Classes

How to Use PHP ETL Tools to Extract, Transform, and Load Data from a PostgreSQL Database Using the Package ETL Tools: Tools to process data from a PostgreSQL database

Recommend this page to a friend!
     
  Info   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2025-09-09 (5 months ago) RSS 2.0 feedNot yet rated by the usersTotal: Not yet counted Not yet ranked
Version License PHP version Categories
etl-tools 1.0GNU General Publi...5PHP 5, Databases, Tools, Applications
Description 

Author

Moisés Lima

This package provides tools to process data from a PostgreSQL database.

It provides a Web based application to access several types of tools that access a database hosted in PostgreSQL server to extract, transform and load useful information.

Currently, the application provides tools to:

- Analyze database table relationships

- Search for database columns

- Upload a zip file to with data to insert in the database tables

- View the contents of a bytea column using a given SQL query

Innovation Award
PHP Programming Innovation award nominee
September 2025
Number 3		 Extract, Transform, and Load (ETL) tools are a type that can be used to process data in a useful way.

This package provides a set of ETL tools that can process data stored in a PostgreSQL database.

Manuel Lemos
Picture of Moisés Lima
  Performance   Level  
Name: Moisés Lima <contact>
Classes: 6 packages by
Country: Brazil Brazil

Level 1 Star

 Innovation award
Innovation award
Nominee: 4x

Instructions

Please read this document to learn how to install and run this PHP ETL Tools application for PostgreSQL.

Screenshots (1)  
  • public/assets/bg.jpg
  Files folder image Files (48)  
File Role Description
Files folder imagepublic (4 files, 1 directory)
Files folder imagesrc (3 files, 3 directories)
Files folder imagevendor (1 file, 1 directory)
Accessible without login Plain text file composer.json Data Auxiliary data
Accessible without login Plain text file composer.lock Data Auxiliary data
Accessible without login Plain text file README.md Doc. Documentation
Accessible without login Plain text file server.php Aux. Configuration script
Accessible without login Plain text file start.sh Data Auxiliary data

  Files folder image Files (48)  /  public  
File Role Description
Files folder imageassets (2 files, 2 directories)
  Accessible without login Plain text file .htaccess Data Auxiliary data
  Accessible without login Image file favicon.ico Data Auxiliary data
  Accessible without login Plain text file index.php Appl. Application script
  Accessible without login Plain text file robots.txt Doc. Documentation

  Files folder image Files (48)  /  public  /  assets  
File Role Description
Files folder imagecomponents (3 files)
Files folder imagetools (6 files)
  Accessible without login Plain text file app.js Data Auxiliary data
  Accessible without login Image file bg.png Icon Icon image

  Files folder image Files (48)  /  public  /  assets  /  components  
File Role Description
  Accessible without login Plain text file ConfirmDialog.js Data Auxiliary data
  Accessible without login Plain text file SqlEditor.js Data Auxiliary data
  Accessible without login Plain text file Terminal.js Data Auxiliary data

  Files folder image Files (48)  /  public  /  assets  /  tools  
File Role Description
  Accessible without login Plain text file Player.js Data Auxiliary data
  Accessible without login Plain text file RelationshipAnalyser.js Data Auxiliary data
  Accessible without login Plain text file SearchColumns.js Data Auxiliary data
  Accessible without login Plain text file Sql.js Data Auxiliary data
  Accessible without login Plain text file UploadZip.js Data Auxiliary data
  Accessible without login Plain text file ViewBytea.js Data Auxiliary data

  Files folder image Files (48)  /  src  
File Role Description
Files folder imageControllers (3 files)
Files folder imageModel (2 files, 3 directories)
Files folder imageView (1 file)
  Plain text file Home.php Class Class source
  Plain text file Router.php Class Class source
  Plain text file SearchColumn.php Class Class source

  Files folder image Files (48)  /  src  /  Controllers  
File Role Description
  Plain text file RelationshipAnalyser.php Class Class source
  Plain text file UploadZipController.php Class Class source
  Plain text file ViewByteaController.php Class Class source

  Files folder image Files (48)  /  src  /  Model  
File Role Description
Files folder imageEnvironment (1 file)
Files folder imagePostgres (2 files)
Files folder imageTools (2 files, 1 directory)
  Plain text file Project.php Class Class source
  Plain text file RaPgsqlException.php Class Class source

  Files folder image Files (48)  /  src  /  Model  /  Environment  
File Role Description
  Plain text file Env.php Class Class source

  Files folder image Files (48)  /  src  /  Model  /  Postgres  
File Role Description
  Plain text file Schemas.php Class Class source
  Plain text file Search.php Class Class source

  Files folder image Files (48)  /  src  /  Model  /  Tools  
File Role Description
Files folder imageRelationshipAnalyser (1 file)
  Plain text file UploadZip.php Class Class source
  Plain text file ViewBytea.php Class Class source

  Files folder image Files (48)  /  src  /  Model  /  Tools  /  RelationshipAnalyser  
File Role Description
  Plain text file Analyser.php Class Class source

  Files folder image Files (48)  /  src  /  View  
File Role Description
  Accessible without login HTML file home.html Doc. Documentation

  Files folder image Files (48)  /  vendor  
File Role Description
Files folder imagecomposer (11 files)
  Accessible without login Plain text file autoload.php Aux. Configuration script

  Files folder image Files (48)  /  vendor  /  composer  
File Role Description
  Accessible without login Plain text file autoload_classmap.php Aux. Configuration script
  Accessible without login Plain text file autoload_namespaces.php Aux. Configuration script
  Accessible without login Plain text file autoload_psr4.php Aux. Configuration script
  Plain text file autoload_real.php Class Class source
  Plain text file autoload_static.php Class Class source
  Plain text file ClassLoader.php Class Class source
  Accessible without login Plain text file installed.json Data Auxiliary data
  Accessible without login Plain text file installed.php Aux. Configuration script
  Plain text file InstalledVersions.php Class Class source
  Accessible without login Plain text file LICENSE Lic. License text
  Accessible without login Plain text file platform_check.php Aux. Configuration script

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadetl-tools-2025-09-09.zip
Downloadetl-tools-2025-09-09.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads  
 100%
Total:0
This week:0

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.