[SATLUG] LAMP Server Question #4

Stewart Smith tuupes80 at hotmail.com
Wed Oct 8 10:40:40 CDT 2014

Answering a question with a question, are you doing a transactional database?  
If so, you need to remember that you have to code for rollback recovery of partially completed transactions.  HTML is stateless.  
In high volume transactional databases you get into he problem of deadly embrace, two transactions each locking a different data element that the other needs.  You need to make sure this problem is treated.    
Will you be updating more than one database in a transaction?  If so, you need to consider the problem of two phase commit.
Sadly, this points in the direction of transaction processors.  Tuxedo and JBoss or their open source equivalents. 
Dreamweaver is the commercial standard in professional Web development, but there are open source alternatives.
Depending on the volume of the transactions, you might gain something from considering something other than the "P" in LAMP being PHP.  Python comes to mind.  Further, don't dismiss C, if the transactions are bogging down.
One final note.  If you are doing something like a catalogue order entry application, where there will be a great deal of graphic data served in addition to high transaction volume, you might want to consider offloading the graphic serving to another machine that does only that.  
Sorry for the all over the place answer.  If these things get big, they can create some interesting problems.

> Date: Tue, 7 Oct 2014 22:48:57 -0500
> From: alesmerises at satx.rr.com
> To: satlug at satlug.org
> Subject: [SATLUG] LAMP Server Question #4
> I am working on a project that involves setting up a server for a 
> customer where they will need to access a database on an on-going basis 
> for various kinds of record-keeping, etc.  I have come to the conclusion 
> that a LAMP server will be the best solution for them (I won't bore you 
> with all the reasons why, but let's assume that is the way I will go).
> This will be the first time I will undertake a project quite like this, 
> so I have a few specific questions where I would like some opinions, 
> especially the professionals out there who may have done jobs similar to 
> this for paying customers.
> Since the questions deal with different topics, I will send them out 
> separately so as not to muddy the waters by mixing things together.
> -->  QUESTION #4:
> What tools / software recommendations do you have for the PHP coding & 
> web page development would you recommend?  I'd prefer something that 
> runs in the GUI so that I can get quick and easy feedback about layout, 
> etc. to speed-up the development process.
> Al Lesmerises
> -- 
> _______________________________________________
> SATLUG mailing list
> SATLUG at satlug.org
> http://alamo.satlug.org/mailman/listinfo/satlug to manage/unsubscribe
> Powered by Rackspace (www.rackspace.com)

More information about the SATLUG mailing list