# 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

| phpMyAdmin | Adminer
--- | --- | ---
Current versions | 3.4.0-beta4 | 3.2.2
Licences | GPL | GPL or Apache
Requirements | PHP 5.2+, MySQL 5+ | PHP 4.3+, MySQL 4.1+

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/