PostgreSQL

gilsbert's picture

Drupal core's issue with postgresql

Hi.

I have found this specific issue with postgresql: https://drupal.org/node/2142107 .
Do you know a solution for this?

Regards,
Gilsberty

Read more
mariacha1's picture

Does Drupal support DISTINCT ON (field1, field2)

Hi guys,

I'm new to postgreSQL in Drupal and can't figure out how to do a DISTINCT ON select within drupal's query classes with declared fields like this:

SELECT DISTINCT ON (field1, field2) field1, field2, field3 FROM table1

I see you can set a query as $query->distinct(TRUE) but that just seems to add the word DISTINCT, which if I understand it, just makes sure that all columns combined are unique.

Is this possible to pass those DISTINCT ONs to a funciton or should I rewrite my query to do it some other way?

Read more
shendric's picture

Application Programmer Specialist | University of Georgia - Franklin College of Arts and Sciences

Employment type: 
Full time
Telecommute: 
Not allowed

This position will work independently and serve as a member of a project team. This position will provide all aspects of application development using PHP/MySQL and/or PostgreSQL as well as other current and emerging web technologies such as AJAX, JavaScript, SOAP, and other web services. Familiarity with source control systems, content management systems preferably Drupal, and RSS feeds highly desired. Experience designing application interfaces for usability and intuitive client experience also highly desired. Experience with web frameworks strongly desired.

Read more
dpovshed's picture

Postgres Signature module

Hi there!

In our recent project we had implemented 'personalized' database querying, so all queries from particular user executed (and appears in SQL log) as dedicated Postgres user.

Maybe someone find it useful for same purpose or for future evolution - like setting some users with more priority, limiting users activity, etc.

The project was initially published with sandbox status, then promoted to regular
http://drupal.org/project/pgsign

Thank you,
Dennis

Read more
urs.rindlisbacher@auditrium.ch's picture

Software Engineer/IT-Teamleader mit Drive (m/w) | Start-up Unternehmen in der Schweiz

Employment type: 
Full time
Telecommute: 
Allowed

Unsere Mandantin ist ein junges, schnell wachsendes Online-Unternehmen, welches eine speziell auf die internationale Finanzindustrie ausgerichtete Online-Community-Plattform betreibt. Durch die enge Zusammenarbeit mit grossen internationalen Partnerunternehmen, der Mehrzahl der marktrelevanten Institutionen, Verbände und Netzwerke soll die Plattform rasch zur führenden Expertenplattform in den Bereichen tax/law, financial services, real estate und audit/accounting heranwachsen. Um dieses Wachstum voranzutreiben, suchen wir im Grossraum Zürich per sofort oder nach Vereinbarung den

Read more
matsbla's picture

Website Developer | Globalbility

Employment type: 
Contract
Telecommute: 
Allowed

I need help to make a website to connect volunteers in a collaborative translation work. It is a postcard and translation project, you can see our simple website here to get an idea: www.globalbility.org - It is a non-commercial initiative, it is registered in the Norwegian Voluntary Register as a NGO.

Read more
tunic's picture

Migrating a MySQL Drupal to PostgreSQL

After several hours of uncertainty it seems that I have managed to migrate a MySQL Drupal to a PostgreSQL. So I want to share my experience with this group where I think could be useful.

There are several problemas to solve: table structure translation, autoincrement values / sequences, serialized data, etc.

I've tried several ways, but always I came up against some problem.

Database schema

MySQL and PostgreSQL use different data types for its columns, they define its tables in its own way, you can't use MySQl definitions.

Read more
xurxosanz's picture

Charla sobre OpenStreetMap y novedades PostgreSQL/PostGIS en la UPV

Buenas me permito hacer un anuncio desde el grupo de Geoinquietos de Valencia ya que alguna vez me habéis preguntado (u os he dado la brasa) sobre las posibilidades de OpenStreetMap como fuente de datos para aplicaciones web y similares. Supongo que con los recientes casos de cambio de Google Maps a esta plataforma de cartografía en web (especialmente Foursquare) a más de uno le interesará...

Read more
djunger's picture

Drupal Web Developers | Westat

Employment type: 
Part time
Telecommute: 
Allowed

Westat is currently seeking Drupal developers for immediate work on two science education websites. Candidates should have a solid grasp of Drupal 7, including site configuration, theme development, custom module programming, and using the API. Database skills in MySQL and PostgreSQL, as well as coding in PHP, JavaScript, and jQuery are required.

Read more
yogaesh's picture

Need help - Dynamic pages not rendering fine

Hi,

I recently installed Drupal 7 on Windows with Apache Web server (2.2) and PostGres DB. When I try to access the drupal site, I'm always seeing the directory listing and if I click on a specific php page, I'm able to see the HTML contents; but none of the dynamic features (search, filter, etc.) are working. I thought PHP wasn't installed fine; but if I throw in a simple PHP page with PHP functions, I'm able to get dynamic contents on the page. Is there any other configuration I need to do before I get started with my first site?

Thanks in advance for your help!

Regards,
Yogaesh

Read more
Subscribe with RSS Syndicate content