Tera-WURFL With postgreSQL

[veeradileep]

Hi,

First Up all, Thanks For Tera-WURFL support.

I have clarification on, Whether Tera-WURFL will support with back end postgreSQL database ? Please any one tell suggestion on this one.

Thanks in advance.

[kamermans]

I'm actually working on PostgreSQL support right now - I've received several requests for it in the last couple weeks. I hope to have a working version this weekend.

[veeradileep]

Hi,

Thanks for ur reply. Am waiting for your product with postgreSQL back end.

[kamermans]

There's another active PostgreSQL thread here: viewtopic.php?f=7&t=53&start=0, maybe you and that author can help me decide whether to use ADOdb or PDO for PostgreSQL.

[n1k00]

Hello,

I would like to know if postgreSQL is supported now or it's still under developpement.

[kamermans]

Hi n1k00, I'm still surprised at the amount of interest there is in a PostgreSQL version I guess I'm going to have to sit down and write a connector for it this weekend - are any of you willing to test it once I get it working? Can someone provide me with the appropriate pgSQL CREATE TABLE statements based on these MySQL table DDLs?

Code: Select all

CREATE TABLE `TeraWurflCache` (
  `user_agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `cache_data` mediumtext NOT NULL,
  PRIMARY KEY (`user_agent`)
)

CREATE TABLE `TeraWurflIndex` (
  `deviceID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `matcher` varchar(64) NOT NULL,
  PRIMARY KEY (`deviceID`)
)

CREATE TABLE `TeraWurflMerge` (
  `deviceID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `user_agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `fall_back` varchar(64) DEFAULT NULL,
  `actual_device_root` tinyint(1) DEFAULT '0',
  `match` tinyint(1) DEFAULT '1',
  `capabilities` mediumtext,
  PRIMARY KEY (`deviceID`),
  KEY `fallback` (`fall_back`),
  KEY `useragent` (`user_agent`),
  KEY `dev_root` (`actual_device_root`),
  KEY `idxmatch` (`match`)
)

CREATE TABLE `TeraWurflSettings` (
  `id` varchar(64) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
)

CREATE TABLE `TeraWurfl_CatchAll` (
  `deviceID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `user_agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `fall_back` varchar(64) DEFAULT NULL,
  `actual_device_root` tinyint(1) DEFAULT '0',
  `match` tinyint(1) DEFAULT '1',
  `capabilities` mediumtext,
  PRIMARY KEY (`deviceID`),
  KEY `fallback` (`fall_back`),
  KEY `useragent` (`user_agent`),
  KEY `dev_root` (`actual_device_root`),
  KEY `idxmatch` (`match`)
)


Note that I'm using the "utf8_bin" collation on some columns to for case sensitive comparisons.

[n1k00]

Hi, Here the transposition for creating tables with POSTGRESQL.

Code: Select all

-- en postgresql

CREATE TABLE TeraWurflCache (
  user_agent varchar(255)  NOT NULL DEFAULT '',
  cache_data text NOT NULL,
  PRIMARY KEY (user_agent)
)
;
CREATE TABLE TeraWurflIndex (
  deviceID varchar(64)  NOT NULL DEFAULT '',
  matcher varchar(64) NOT NULL,
  PRIMARY KEY (deviceID)
)
;
CREATE TABLE TeraWurflMerge (
  deviceID varchar(64)  NOT NULL DEFAULT '',
  user_agent varchar(255)  DEFAULT NULL,
  fall_back varchar(64) DEFAULT NULL,
  actual_device_root smallint DEFAULT '0',
  match smallint DEFAULT '1',
  capabilities text,
  PRIMARY KEY (deviceID)
)
;
CREATE INDEX TeraWurflMerge_fallback_idx on TeraWurflMerge(fall_back);
CREATE INDEX TeraWurflMerge_useragent_idx on TeraWurflMerge(user_agent);
CREATE INDEX TeraWurflMerge_dev_root_idx on TeraWurflMerge(actual_device_root);
CREATE INDEX TeraWurflMerge_match_idx on TeraWurflMerge(match);

CREATE TABLE TeraWurflSettings (
  id varchar(64) NOT NULL,
  value varchar(255) DEFAULT NULL,
  PRIMARY KEY (id)
)
;

CREATE TABLE TeraWurfl_CatchAll (
  deviceID varchar(64)  NOT NULL DEFAULT '',
  user_agent varchar(255)  DEFAULT NULL,
  fall_back varchar(64) DEFAULT NULL,
  actual_device_root smallint DEFAULT '0',
  match smallint DEFAULT '1',
  capabilities text,
  PRIMARY KEY (deviceID)
)
;
CREATE INDEX TeraWurfl_CatchAll_fallback_idx on TeraWurfl_CatchAll (fall_back);
CREATE INDEX TeraWurfl_CatchAll_useragent_idx on TeraWurfl_CatchAll (user_agent);
CREATE INDEX TeraWurfl_CatchAll_dev_root_idx on TeraWurfl_CatchAll (actual_device_root);
CREATE INDEX TeraWurfl_CatchAll_match_idx on TeraWurfl_CatchAll (match);


Thanks for your help and work

[kamermans]

Thanks for the help - I'll definitely use these. Do you have a preference for the DB adapter (i.e. PDO, pgsql, etc...)?

[n1k00]

My project use pgsql. Thanks

[tutunci]

Hi,
any news about postgresql DBConnector? I'm interested in using it, so if you need help I can do.

Thanks
Maurizio