The 2nd master-class “Using PostgreSQL in Web Applications” was successfully completed
The first PostgreSQL masterclass was held as part of PHPConf 2004.
In the current, there were many questions about competent tuning of PostgreSQL
and the use of interesting solutions in database design (scaling tables to different servers and much more).
The search for the missing index was also fascinating :-) The
friendly and immediate atmosphere of the event helped
all participants to find practical solutions to the problems.
Many of the participants pointed to the low distribution of PostgreSQL among domestic hosters.
From the finds on conducting a master class - LiveCD is already with a finished course,
which in the future will allow for remote training, the participant needs
will download (receive) the disc and handouts to start working with the master class.
It is worth noting the professionalism of the presenters:
Nikolay Samokhvalov - architect and developer of PostgreSQL DBMS
Ivan Zolotukhin - leading developer and administrator of PostgreSQL
- A Brief History of PostgreSQL. Current version. Opportunities.
Installation in conjunction with Apache / PHP. Initial setup.
Starting scripts for various OS.
Psql console, pgAdmin III GUI application, phpPgAdmin web-based management interface.
Regression tests, benchmarks. HelloWorld
PostgreSQL device: MVCC, transactions, VACUUM.
The concept of a cluster. Schemes. System directories.
Basic configuration options.
Methods for improving performance: setting up postgresql.conf, using indexes, modifying SQL queries, persistent connection, load balancing.
Monitoring the status of the database, statistics.
Types of indexes. Log analysis with pgFouine.
A variety of procedural languages (PL / pgSQL, PL / Perl, plPHP). Triggers and functions. Rule, view. Inheritance mechanism. Prepared transactions. Two-phase commit.
Additional features: contrib-modules. GiST-based modules intarray, hstore, ltree, pg_trgm. Full-text search (tsearch2) and its features.
Those wishing to participate in the next. master classes - sign up for the newsletter