Re: PostgreSQL questions

From: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
To: Carel Combrink <s25291930(at)tuks(dot)co(dot)za>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: PostgreSQL questions
Date: 2010-03-15 21:51:27
Message-ID: 65937bea1003151451r59b4f4bcnea9b679a6cd85cbc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

For asynchronous notifications Postgres' LISTEN/NOTIFY mechanism would be
ideal, but I am not sure if Qt provides a way of listening to such
notifications.

Till Postgres 8.4 the NOTIFY commands could get lost, but with upcoming 9.0
first there's guaranteed delivery and second it is extensible by application
by using the 'payload' part.

http://developer.postgresql.org/pgdocs/postgres/sql-notify.html

Best regards,

On Fri, Mar 12, 2010 at 4:09 AM, Carel Combrink <s25291930(at)tuks(dot)co(dot)za>wrote:

> Dear PostgreSQL novice list,
>
> I am starting development on an application that requires the use of a
> Database. I am considering MySQL vs PostgreSQL and have done extensive
> (perhaps incomplete) research on both of these.
>
> I have 2 questions about PostgreSQL:
> 1.) Is there a difference in running PostgreSQL on Windows vs Linux. I am a
> Windows user but have a Linux box. For the application I am leaning more to
> Linux. Is there advantages or factors I should consider when choosing the
> OS?
>
> 2.) This question is related to triggers. Can I use a trigger to notify my
> external application about a change in the database. I am looking at using
> QT for development because of its platform independence. Thus the complete
> question is: Can I notify the QT application that data was added to the
> database (using a trigger) without having to query the database the whole
> time?
>
> The specifications for the application are real-time to semi-real-time thus
> I need an OS with semi-real-time characteristics (Windows is not as far as I
> know, that is why Linux is a good option). And I want to notifying the
> application of changes in the database as soon as they happen, this will
> help with the real-time aspect.
>
> Hope I can get this sorted soon as development should start asap.
>
> Thank you,
> Carel
>
> This message and attachments are subject to a disclaimer. Please refer
> to www.it.up.ac.za/documentation/governance/disclaimer/ for full
> details. / Hierdie boodskap en aanhangsels is aan 'n vrywaringsklousule
> onderhewig. Volledige besonderhede is by
> www.it.up.ac.za/documentation/governance/disclaimer/ beskikbaar.
>
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

--
gurjeet.singh
@ EnterpriseDB - The Enterprise Postgres Company
http://www.enterprisedb.com

singh(dot)gurjeet(at){ gmail | yahoo }.com
Twitter/Skype: singh_gurjeet

Mail sent from my BlackLaptop device

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2010-03-16 00:33:08 Re: PostgreSQL questions
Previous Message Jasen Betts 2010-03-15 08:19:50 Re: I need your thoughts ....