There is much debate as to whether or not data calculations should be done in the web app or in the database. There are good arguments on both sides. Depending on what is being calculated, executing calculations in some web programming languages tends to be faster than doing the same thing in the database.
Social networking just keeps on growing. It seems every major public business wants a Facebook application, corporations…
As Web sites and Web-based applications become more important to commercial firms and other organizations, so too does the methods used for storing data online, such as customer contact information, system login details, product data, and much more. Rewritable flat files may be sufficient for extremely limited data for which security is not an issue. But for most Web sites and applications, a robust database is called for.
MySQL provides a built-in data replication functionality for maintaining identical copies of its data to one or more backend servers, thus providing a simple High Availability mechanism. On the other hand, the Open Source community has several projects to implement failover techniques, being one of them Heartbeat.
I much prefer to upload files to mysql instead of saving them directly to the file system. I can run database backups/mirrors that are much easier to manage then if files were placed on the file system. Here are the simple scripts I use to upload files and a script to stream the file back to the browser.
This section deals mainly with exploring the possibilities of combining PHP and MySQL. To check if PHP is setup to use MySQL on your server, look for a section on MySQL in the phpinfo file described earlier. The technical details of setting up MySQL on your system are covered comprehensively in various text books. See the “Source Code Books” link below for more information.
A lot of developers are taught to use database stored procedures, triggers and database constraints at every possible opportunity, and they cannot understand why an old dinosaur like me should choose to take an opposite view. The reason can be summed up quite simply…
Apr 15, 2008 - 96 Comments
Aug 6, 2008 - 20 Comments
Mar 7, 2008 - 13 Comments
Oct 8, 2010 - 2 Comments
Oct 6, 2010 - 0 Comment
Sep 22, 2010 - 0 Comment