It is too often that developers use the wrong data types in their databases. As queries to databases take a major amount of time in any application, it is essential that the database and its tables are as optimised as possible to ensure the best efficiency, especially in high-demand applications. Read more »
24th
March Saving Bytes: Efficient Data Storage (MySQL) - Part 1
When storing data in databases, it is important to ensure the data is stored using a minimal amount of space, while retaining its value and processing efficiency.
There are many common practices amongst MySQL developers who write applications which store data in a human-interpretable way; they often don't think about the computer's interpretation of the data, and often fail to realise that it can be more efficient and space-saving to store data in a certain form.
It is especially important to consider data storage techniques in high-demand applications, and where speed and storage-efficiency are key values. Web services require these key values: it is important that they can cope with extra demand, and can satisfy their user's desire for immediacy.
(Screenshot from phpMyAdmin)
In the first part of Saving Bytes: Efficient Data Storage, we will look at the storage of strings.
Read more »
25th
September User Accounts with PHP and MySQL
Having a user accounts feature is something that I'd recommend to almost any website. It is one of the best ways to make visitors really feel part of your site. And, it's also gives you an idea of how many "valuable" users you have.
In this article, I'll be telling you how to create a user accounts feature, complete with a login form, registration form and "user area." To make the system, you'll need PHP and MySQL.
Loading ...