PostgreSQL

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
Souvent22's picture

The Time Draws near for Stored Procs...across the board

Ok, i'll be the one to call the pink elephant in the room.....stored procedures do exisit. There I said it. :). With MySQL 5 starting to support them, Postgres has had them, and the push latley to start using a wider array and more robust DB's (oracle, mssql, DB2), it is time I think to start thinking about a database abstraction layer to handel stored procedures. I'm thinking perhaps something like this:

/**
* @param $proc_name Name of the stored proc.
* @param $args Argements to send to the proc indexed by the variables name. e.g. array('name' => 'Jim Smith');

Read more
yaanno's picture

First steps to a Recommendation Proposal

Almost every developer know that there is an other Open Source Database Server besides MySQL; her name is PostgreSQL. She is a good option if you are planning a scalable website with high traffic or specific transactions (e.g. e-commerce, large community sites). There are more advantages but my aim here is not a list of "top ten list of ... ".

Read more
agittins's picture

External Product database?

I have a funny feeling I am missing something important here, so perhaps I just need sufficient "clue" to get further along.

I want to be able to display our products on our Drupal site, but using the existing postgresql product data from SQL-Ledger (ie, not have to import repeatedly or run two copies of our product data).

I currently run SQL-Ledger with more than 134,000 product lines, only a few thousand of which are typically active, but any and all could be ordered in for customers on demand. We run a retail store so we have inventory control, POS, shipping etc already via SQL-Ledger.

Read more
c_lombao@yahoo.com's picture

E-Commerce and PostgreSQL

Hi
In advance, my apologizes if I'm not addressing to the right place this comment of mine, I'm quite new on Drupal world and , therefore, on E-commerce.
Just Today evening I installed Drupal, and E-Commerce , with PostgreSQL instead MySQL.

After Installed the E-Commerce Module I started to get errors in the Log


query: INSERT INTO ec_tax (realm_value, realm, ptype, operand, operator, taxid) VALUES('fr', 'country', 'file', '+', '6.00', '')

Reviewing the postgresql logs I see that

ERROR: relation "ec_tax_taxid_seq" does not exist

So I searched in the file tax.install

Read more
Subscribe with RSS Syndicate content