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
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
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 denRead more
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
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.
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
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
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!