Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UWjEn-0000kY-Hl for pgsql-students@arkaria.postgresql.org; Mon, 29 Apr 2013 08:15:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UWjEn-0000HA-1w for pgsql-students@arkaria.postgresql.org; Mon, 29 Apr 2013 08:15:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UWjEm-0000Fr-BL for pgsql-students@postgresql.org; Mon, 29 Apr 2013 08:15:04 +0000 Received: from cl-2390.ham-01.de.sixxs.net ([2001:6f8:900:955::2] helo=feynman.df7cb.de) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UWjEh-0004U8-Uo for pgsql-students@postgresql.org; Mon, 29 Apr 2013 08:15:03 +0000 Received: from msgid.df7cb.de (benz.df7cb.de [IPv6:2001:6f8:10ee:e:134::2]) (using TLSv1 with cipher DHE-RSA-AES128-SHA (128/128 bits)) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 528B469734; Mon, 29 Apr 2013 10:14:58 +0200 (CEST) Date: Mon, 29 Apr 2013 10:14:45 +0200 From: Christoph Berg To: Aditya Bhardwaj Cc: pgsql-students@postgresql.org, david@justatheory.com Subject: Re: [GSoC 2013] [Debian] Message-ID: <20130429081445.GB4457@msgid.df7cb.de> Mail-Followup-To: Christoph Berg , Aditya Bhardwaj , pgsql-students@postgresql.org, david@justatheory.com References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-students Precedence: bulk Sender: pgsql-students-owner@postgresql.org Re: Aditya Bhardwaj 2013-04-29 > I am Aditya Bhardwaj and I am pursuing the project idea 'Enhancing Debian > Blends web sentinel' for GSoC from Debian. > > Here, it is required that UDD (Ultimate Debian Database) shall produce some > appropriate JSON output which can be used to generate data for the Blends > web sentinel. > > And I need some clarification if PostgreSQL can be used for the purpose. > And any headers for the same if it can be used. AFAIK PostgreSQL 9.3 shall > arrive with a lot of JSON goodness. To be useful for Debian, it should probably run on PostgreSQL 9.1 (shipped with Wheezy), or 9.2. I don't think the UDD people would want to rely on 9.3 features. That said, I'd think the JSON stuff would probably be constructed on the client side of the UDD database connection, i.e. you fire of standard SQL queries and render that as JSON for the web request. Did you ask the UDD people about this? Christoph -- cb@df7cb.de | http://www.df7cb.de/ -- Sent via pgsql-students mailing list (pgsql-students@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-students