Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Three options I can think of-</p> <ol> <li>Make a cron job that calls your script. Cron is a common name for a GNU/Linux daemon that periodically launches scripts according to a schedule you set. You add your script into a crontab or place a symlink to it into a special directory and the daemon handles the job of launching it in the background. You can read more at wikipedia. There is a variety of different cron daemons, but your GNU/Linux system should have it already installed.</li> <li>Pythonic approach (a library, for example) for your script to be able to daemonize itself. Yes, it will require a simple event loop (where your events are timer triggering, possibly, provided by sleep function). Here is the one I recommend &amp; use - <strong><a href="http://www.jejik.com/articles/2007/02/a_simple_unix_linux_daemon_in_python/" rel="nofollow">A simple unix/linux daemon in Python</a></strong></li> <li>Use python <code>multiprocessing</code> module. The nitty-gritty of trying to fork a process etc. are hidden in this implementation. It's pretty neat.</li> </ol> <p>I wouldn't recommend 2 or 3 'coz you're in fact repeating cron functionality. The Linux system paradigm is to let multiple simple tools interact and solve your problems. Unless there are additional reasons why you should make a daemon (in addition to trigger periodically), choose the other approach.</p> <p>Also, if you use daemonize with a loop and a crash happens, make sure that you have logs which will help you debug. Also devise a way so that the script starts again. While if the script is added as a cron job, it will trigger again in the time gap you kept.</p>
    singulars
    1. This table or related slice is empty.
    1. POWorking implementation of daemon in Python
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USSrikar Appalaraju
    1. USSrikar Appalaraju
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWorking implementation of daemon in Python
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI've been trying #2 without success. it's like once the daemon forks itself, I can't reference my django project anymore. thinking it's a path issue. see http://stackoverflow.com/questions/3992175/python-import-module-results-in-nameerror
      singulars
      1. PO
      1. USRyanBrady
    2. COdid you follow the code example in the link I gave? That works fine for me.
      singulars
      1. PO
      1. USSrikar Appalaraju
    3. COyes, I followed it. downloaded his daemon.py, subclassed it. when trying to import my django project it fails.
      singulars
      1. PO
      1. USRyanBrady
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload