CakePHP + PostgreSQL

75 %
25 %
Information about CakePHP + PostgreSQL
Technology

Published on November 23, 2009

Author: shin1x1

Source: slideshare.net

CakePHP PostgreSQL ×

First Mac

(Masashi Shinbara)

(Masashi Shinbara) ×

(Masashi Shinbara) ×

(Masashi Shinbara) × /shin1x1

(Masashi Shinbara) × /shin1x1 Shin x blog http://www.1x1.jp/blog/

PostgreSQL • Oracle / Access(mdb) • 2000 PostgreSQL7.0 • Oracle • DB

Agenda • CakePHP • • pgpool-II + Slony-1

CakePHP

Oracle SQLServer

EASY Oracle SQLServer

EASY Oracle SQLServer TEST

EASY Oracle CUSTOM SQLServer TEST

POPULAR EASY Oracle CUSTOM SQLServer TEST

2007

2007 2008

2007 2008 2009

Cake 2008 2009

SNS

pgpool-II + Slony-1

pgpool-II • CakePHP PostgreSQL • • Web/AP

Slony-I • • • slonik

CakePHP • DB pgpool-II •

DB <?php class DATABASE_CONFIG { var $default = array( 'connect' => 'pg_connect', 'driver' => 'postgres', 'persistent' => false, 'host' => 'localhost', 'port' => '9999', 'login' => '1x1', 'password' => '', 'database' => 'hoge', );

pgpool-II • • • • SQL • •

pgpool-II UPDATE users SET name='abc'; BEGIN; SELECT COUNT(*) FROM users; INSERT INTO users(name) VALUES('abc'); COMMIT; /**/ SELECT * FROM users; SELECT * FROM users;

pgpool-II UPDATE users SET name='abc'; BEGIN; SELECT COUNT(*) FROM users; INSERT INTO users(name) VALUES('abc'); COMMIT; /**/ SELECT * FROM users; SELECT * FROM users;

pgpool-II UPDATE users SET name='abc'; BEGIN; SELECT COUNT(*) FROM users; INSERT INTO users(name) VALUES('abc'); COMMIT; /**/ SELECT * FROM users; SELECT * FROM users;

pgpool-II UPDATE users SET name='abc'; BEGIN; SELECT COUNT(*) FROM users; INSERT INTO users(name) VALUES('abc'); COMMIT; /**/ SELECT * FROM users; SELECT * FROM users;

pgpool-II UPDATE users SET name='abc'; BEGIN; SELECT COUNT(*) FROM users; INSERT INTO users(name) VALUES('abc'); COMMIT; /**/ SELECT * FROM users; SELECT * FROM users;

pgpool-II UPDATE users SET name='abc'; BEGIN; SELECT COUNT(*) FROM users; INSERT INTO users(name) VALUES('abc'); COMMIT; /**/ SELECT * FROM users; SELECT * FROM users;

Slony-I

• • SQL /**/ SELECT * FROM users; CakePHP

CakePHP [app/models/datasources/dbo/dbo_postgres_replication.php] class DboPostgresReplication extends DboPostgres { public function execute($sql) { if (!AppModel::$toSlave) { if (preg_match('/^SELECT/i', $sql)) { $sql = '/**/'.$sql; } } return parent::execute($sql); } }

• CakePHP PHP • CakePHP PostgreSQL • pgpool-II + Slony-I

Q? /shin1x1

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

Class Cake\Database\Driver\Postgres | CakePHP

Sets connection default schema, if any relation defined in a query is not fully qualified postgres will fallback to looking the relation into defined ...
Read more

CakePHPでPostgreSQLを使う - Qiita

CakePHPでPostgreSQLを使う場合のdatabase.phpはこういう感じ。 var $default = array( 'datasource' => 'Database/Postgres', 'persistent ...
Read more

Class Postgres | CakePHP

Contains mappings of custom auto-increment sequences, if a table uses a sequence name other than what is dictated by convention.
Read more

Connecting cakephp 2.0 with PostgreSQL - Stack Overflow

I am using cakephp 2.0 and a wamp server. I have enabled the pdo of postgres in the php and i tried connecting to Postgres. However it still says that ...
Read more

How to connect CakePHP to a Postgres ... - Stack Overflow

I'm just starting with CakePHP, I went through the blog tutorial without trouble but would now like to try it with a proper DBMS like postgres. I tweaked ...
Read more

How to connect to a postgres database with CakePHP ...

Hello everyone, I'm just starting with CakePHP, I went through the blog tutorial without trouble but would now like to try it with a proper DBMS like postgres.
Read more

CakePHP - Build fast, grow solid | PHP Framework | Home

CakePHP is an open-source web, rapid development framework that makes building web applications simpler, faster and require less code.
Read more

CakePHP – Wikipedia

CakePHP; Entwickler: Cake Software Foundation: Erscheinungsjahr: 2005: ... PostgreSQL; SQLite; MSSQL; Oracle; Das sogenannte Model stellt die vorhandenen ...
Read more

PostgreSQL › Wiki › ubuntuusers.de

PostgreSQL nennt sich selbst "The world's most advanced open source database". PostgreSQL ist für Linux, aber auch für alle anderen, gängigen ...
Read more