Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Interesting question. From all the different solutions i assume you are quite flexible in what you can do.</p> <p>Personally i would use site B as a job queue server with the db on it (though the db would also be better on a different server). Ask for the users email address and once the job (processing the PDF) has been completed they get it emailed to them, or you could do what i suggested in the comments and send them to a page saying "generating pdf, will refresh in 10 seconds" which keeps refreshing until it finds the generated PDF. This would also allow it to scale pretty well (just add more workers) and would not hold up users while the PDF is being generated.</p> <p>You can use Gearman to interface with PHP to create the job queue.</p> <p><a href="http://php.net/manual/en/book.gearman.php" rel="nofollow">http://php.net/manual/en/book.gearman.php</a></p> <p><strong>Pros</strong></p> <ul> <li>Scales very well - just add more workers if you need more PDF's to be generated at once</li> <li>Uses are not held up thinking the page has crashed while the PDF is generated</li> <li>Not limited to just PDF's, you can queue any CPU intensive jobs in it</li> <li>Won't need to be ripped out and replaced with something different as site traffic increases (just add more workers)</li> <li>Allows control of how many processes / threads are trying to generate PDF's (apache for example will allow say 10 or more PDF's to be generated at once - you have little control over it when done directly in the web requests process and would be a way for attackers to crash your site)</li> </ul> <p><strong>Cons</strong></p> <ul> <li>Requires installation and setup of gearman</li> <li>Requires you to create the gearman PHP scripts to actually generate the PDF</li> </ul> <p>The main reason i would go down this route is because of the user experience, ease of scalability and control over the worker processes.</p> <p><strong>Side Note</strong></p> <p>Your setup of site A and B seems a little strange though i'm sure you have your reasons. If you have two servers, you would be better with nginx on site A proxying all requests to the internal server B with Apache, DB and gearman on it. You can then seperate the apps to seperate servers as your site grows in traffic.</p>
    singulars
    1. This table or related slice is empty.
    1. POGenerating PDF between 2 sites
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USVBAssassin
    1. USVBAssassin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COJust added a new pro :)
      singulars
      1. PO
      1. USVBAssassin
    2. COThe setup of the sites is something I was left with, and not my personal preference. So basicly, you say I should send the PDFs as attachments to their mail? Although that would be a nice approach and something I could do easily with through CodeIgniter, I'm not sure I can easily create PDF files and attach them in the same script execution in CakePHP 1.3. I may want to be able to inactivate these PDFs aswell. (I know people can Save them, but few will)
      singulars
      1. PO
      1. USRobin Castlin
    3. COYou don't have to send as emails. You could just send them to a page that says "created your PDF, page will auto refresh in 10 seconds" and stop refreshing once the PDF is generated. Emailing was just a suggestion - gearman is only a job queue, it's up to you how you get the PDF to the user once the job has completed ;)
      singulars
      1. PO
      1. USVBAssassin
 

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