What PostgreSQL could learn from MySQL - PGCon

decubitisannouncerΔιαχείριση Δεδομένων

27 Νοε 2012 (πριν από 4 χρόνια και 11 μήνες)

256 εμφανίσεις

 
 
What PostgreSQL could 
learn from MySQL
The learning continues ...
Susanne Ebrecht
PostgreSQL User Group Germany
MySQL Support Engineer
PGCon 2008
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
2
Main questions
Why get MySQL so popular?
What are they doing to stay popular?
Lets start analysing this ...
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
3
Market
Where can you find the most users?

Windows

Linux
For what could they need a RDBMS?

World Wild Web / Intranet

PHP

Private issues
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
4
Easy to use
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
5
Packaging
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
6
Knowledge about basics
Normalisation
3NF
Entity Relationship Model
Referential Integrity
SQL
Background
Transactions
Trigger
Functions
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
7
Documentation
Eine Datenbank ist eine strukturierte Sammlung von Daten.
A database is a structured collection of data.
Une base de données est un ensemble
organisé de données.
Una base de datos es una colección
estruturada de datos.
Books
Books
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
8
Combination with others
 
Agreement with PHP to implement

MySQL as default

LAMP

Tries to get an agreement

with OpenOffice

Tries to get agreements

with others
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
9
Users
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
10
Advantages

No Transactions at MyISAM

Mail (Greylisting)

Call center (out calls)

Games

No strict error behaviour

February, 31
st

No check of referential integrity
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
11
Upgrade version
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
12
Backward Compatibility

Strict mode not default

Behaviour of February, 31
st

Only default on Windows

Users don't have to change
their software

Old behaviours won't
changed by default

New options and behaviours
can be configured by user
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
13
Eierlegende Wollmilchsau
eggs, wool and milk spending pic
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
14
Replication / Cluster

Simple statement based replication

Simple row based replication

Simple master <-> master replication

Simple clustering

All in only one package
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
15
Perfection

Step by step development

Replication

Cluster

Connectors

Other features

Release before feature is perfect
(good enough feature)

Continuous development
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
16
Release

Release often

Release early

Don't try to be perfect

Fix bugs after release
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
17
Feature Release
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
18
Nice to have
A good marketing that is able

to sell bugs as features
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
19
Bug tracking
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
20
Warnings
 
Don't implement encoding stuff by your own
 
Don't stop strong code review
 
Stay being such a great community
 
 
© Mai 2008, MySQL/PostgreSQL User Group Germany, Author: Susanne Ebrecht
21
Closing Words
Thank you ...
My
SQL
community for helping
to prepare this talk
Josh Berkus
for motivating me
Thanks for listening