time-based events and triggers in postgre SQL - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

time-based events and triggers in postgre SQL

NaugNaug Posts: 15Member
Im trying to make a game using php and postgre, and I need few things to happen:

1) for db to do specified operation like deleting all unneeded records after some time (or immideatley) from certain conditions being meat.
2) for db to do some action at regular intervals ,like bank adding interest for example.

Comments

  • infidelinfidel Posts: 2,900Member
    : Im trying to make a game using php and postgre, and I need few things to happen:
    :
    : 1) for db to do specified operation like deleting all unneeded records after some time (or immideatley) from certain conditions being meat.
    : 2) for db to do some action at regular intervals ,like bank adding interest for example.

    I don't know about postgres, but Oracle allows you to schedule "jobs" that it will run. Generally speaking, though, most production databases that require batch updates like this use external programs or scripts that are run (either by operators or a task scheduler like cron) at specified intervals.


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

  • NaugNaug Posts: 15Member
    Could you tell a bit more about corn? and those scripts how involved with that language I have to become?


    : : Im trying to make a game using php and postgre, and I need few things to happen:
    : :
    : : 1) for db to do specified operation like deleting all unneeded records after some time (or immideatley) from certain conditions being meat.
    : : 2) for db to do some action at regular intervals ,like bank adding interest for example.
    :
    : I don't know about postgres, but Oracle allows you to schedule "jobs" that it will run. Generally speaking, though, most production databases that require batch updates like this use external programs or scripts that are run (either by operators or a task scheduler like cron) at specified intervals.
    :
    :
    : [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]
    :
    :

  • infidelinfidel Posts: 2,900Member
    : Could you tell a bit more about corn? and those scripts how involved with that language I have to become?

    cron is just an example. It's a UNIX utility that runs scripts at scheduled intervals. The scripts that you need depend on what the database you're using supports and what you're trying to accomplish. I've never used postgres so I don't know what you would use.


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

Sign In or Register to comment.