Replace phpMyAdmin
with Something Better

O'Reilly MySQL Conference 2011

Jakub Vrána – www.adminer.org

B2011-03-31
elePHPant at Vernal Fall,
Yosemite National Park

C2011-04-01
elePHPant at General Grant Tree,
Kings Canyon National Park

D2011-04-02
elePHPant at Joshua tree,
Mojave National Preserve

E2011-04-03
elePHPant at viewpoint,
Hoover Dam

F2011-04-04
elePHPant at Bright Angel Trail,
Grand Canyon National Park

G2011-04-05
elePHPant at Pueblo Betatakin,
Navajo National Monument

H2011-04-06
elePHPant at View Hotel,
Monument Valley

I2011-04-07
elePHPant at Landscape Arch,
Arches National Park

J2011-04-08
elePHPant under the snow,
Bryce Canyon National Park

K2011-04-09
elePHPant at Badwater,
Death Valley National Park

About the Speaker

• Prague, Czech Republic, Europe
• Freelance web developer for 10+ years
• PHP Manual co-author
• MySQL Community Contributor
• Author of Adminer
  • Database management in single PHP file
• Author of NotORM
  • PHP library for simple working with data in the database
• Wrote a book: 1001 Tips and Tricks for PHP (Czech)

Audience

• Who knows phpMyAdmin?
• Who uses phpMyAdmin?
• Who likes phpMyAdmin?

About phpMyAdmin

• 11+ years old
• 6+ active developers
• 280K+ downloads per month
• I used it for ~5 years

Why Consider Something Else?

• User experience
• Feature set
  • Triggers
  • Views
  • Stored routines
  • Events
• Performance
• Extensibility

phpMyAdmin and Adminer Comparison

Demos use the default configuration.

Data Definition

• Create a new table
• Add some columns to it
• Create foreign keys
• Create indexes
• Alter and create trigger
• phpMyAdmin demo
• Adminer demo

Data Manipulation

• Select data
• Fix typo in text
  • Try Edit here first
  • Use full edit and press Ctrl+Left
  • Compare with Ctrl+Enter in Adminer
• Try to filter something or order by more columns
• Create browser bookmark or use history
• Several SQL queries
• phpMyAdmin demo
• Adminer demo

Adminer Extra Features

• Edit several rows at once
• Views, routines, triggers, events
• MySQL, SQLite, PostgreSQL, Oracle, MS SQL
• Alter export
  • phpMyAdmin Synchronization
• Database schema

Performance

• Just click around to see the difference
• Alter big table, try to show the process list
• phpMyAdmin demo
• Adminer demo
• Installation

Extensibility

• phpMyAdmin
  • 200+ configuration directives
  • Extension tables
    • Database schema
    • Data transformations
    • ...
  • Themes in ~150 files
  • Tends to be bloated
• Adminer
  • Zero configuration
  • Plugins and PHP customization
    • XML export
    • Tiny MCE
    • ...
    • Adminer Editor
  • Skins in a single file
  • Tends to be tidy

Other Alternatives

• SQL Buddy
  • Development discontinued
• Desktop applications
  • Usually no remote access to the database
  • Some tools offer HTTP tunnel
  • Not available everywhere, require installation

Questions?

• http://www.adminer.org/en/phpmyadmin/