PostgreSQL

Events happening in the community are now at Drupal community events on 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