Tag Archives: postgresql

Handling Databases with Perl DBI

Handling Databases with Perl DBI.

Perl DBI (CPAN doc)

Perl DBI is used to interact with databases, DBI stands for DataBase Independent Interface.

The DBI architecture is split into two main groups of software, the DBI itself, and the drivers.

             |<- Scope of DBI ->|
                  .-.   .--------------.   .--------------.
  .-------.       | |---| MySQL Driver |---| MySQL Engine |
  | Perl  |       | |   `--------------'   `--------------'
  | script|  |A|  |D|   .--------------.   .--------------.
  | using |--|P|--|B|---|Postgre Driver|---|Postgre Engine|
  | DBI   |  |I|  |I|   `--------------'   `--------------'
  | API   |       | |...
  |methods|       | |... Other drivers
  `-------'       | |...
                  `-'

Specific drivers are implemented for each different type of database and actually perform the operations on the databases

Read More

Bad Behavior has blocked 333 access attempts in the last 7 days.