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 are adding social features to their websites, and organisations are bringing social networking into their intranets. Previously, building your own social networking applications involved some serious engineering challenges. Thanks to Ringside Networks, that just got a lot easier, [...]
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.
If you are familiar with full text searching in MySQL, you will be surprised to know that MySQL doesn’t index words containing 3 or less characters by default. Searching such words ends up with no result. I am sure sometime you also suffered from the same problem. If you are not familiar with this default [...]
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 tutorial shows how to take use dynamic PHP/MySQL content with PayPal. This is my firsts GoLive tutorial so please let me know how to improve things. I’m also open to any suggestions for more tutorials.
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 few days ago, a user came into #phphelp on UnderNet wanting to know how to insert an array into a database. A simple enough concept, but how exactly does one look up information on the subject?
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…
