Soil quality across the world is degrading, and this will result in 40% less food for everyone by 2045. Check out the Save Soil movement, and find out what you can do to contribute to a better world for our children.
Note: This is not an ad. We are not being paid to put up this notice.
If you’re managing a WordPress site that you’ve developed yourself, or one that has been created by a developer and handed over to you, this is a handy guide that you should read. It covers how to optimise your images, so that:
Your site loads as fast as possible, and;
Your images are optimised for crawling and indexing by search engines like Google
In a previous article, we explored how to import a CSV file into a table in MySQL. This is a continuation of that article, where we will explore how to split CSV files that contain data which is supposed to go into multiple tables.
Here’s a quick article on an error that the blog has been running into over the weekend. While hard at work on our farming RPG tutorials, we ran into an error when trying to save or publish our (very large) accompanying articles for the videos.
Concerned that I had done something wrong, I Googled for a solution. Unfortunately, I didn’t find any answers there, so I ended up having to find the source of this warning myself.
In the previous part of this tutorial series, we set up a mail server that could accept connections from mail clients like Gmail. This allowed us to send out domain emails using a mail client, instead of having to implement a mailbox on our server.
With our mail server’s basic functionality properly set up, we can now turn our attention to another problem — email deliverability.Spam email is a really big problem online, so many email providers have some kind of system in place to assess whether an incoming email is spam and either flag it, or reject it. Hence, after setting up our mail server, one thing we need to do is to ensure that our mail server conforms to certain email security standards, policies and protocols. This goes a long way to help us communicate to other mail servers that we are trustworthy, so that our emails will be deliverable.
In the first part of this series, we set up a basic virtual mail server with Postfix that received emails for our domain and forwarded it to a mailbox of our choice. To round off the basic set of features for our mail server, we will be setting up Simple Authentication and Security Layer (SASL) to work with Postfix, so that we can access our mail server with a mailbox client (like Gmail) and send out emails from our domain.
The former option is cheap, but can be clunky to use and ineffective with blocking spam. The latter option — being specialised services — are generally much more accessible and effective with spam, but cost more.
There’s actually also a third option, and that is:
Running your own mail server on a cloud server.
This means that you have to set up the server and maintain it, but it also means that you can have a cheap and effective mail server, instead of having to choose between one or the other.
In this series of articles, we are going to explore how we can set up a virtual mail server using a Mail Transfer Agent (MTA) called Postfix. This will be a fully-featured mail server, meaning that over the course of these articles, we will be building a mail server that can:
Send and receive emails,
Filter incoming emails for spam, and;
Pass email policy checks, so that the emails it sends out are not flagged as spam.
Essentially, the CSV file format is meant to represent tabular data. The above CSV file represents the following table:
Username
Email
Address
Contact
johndoe
john@example.com
71 Pickering Street, Singapore, Singapore
+65-91234567
janedoe
jane@website.com
24 Raffles Lane, Singapore, Singapore
+65-81234567
marysmith
mary@smith.com
83 Riveting Road, Singapore, Singapore
+65-97654321
bobsmith
bob@smith.com
84 Riveting Road, Singapore, Singapore
+65-87654321
Due to their tabular nature, data in a CSV file can very easily be imported into and stored in an SQL table. The commands to do that, however, are not very well-documented online.
If a CSV file does not open as a text file on your computer, that’s because your computer is opening the file with a spreadsheet program such as Microsoft Excel. In such a case, to see the file as text, you will want to open these files on a text editing software such as Notepad.
If you, for some reason, are trying to remove the WordPress admin bar on the backend using show_admin_bar(false) to no avail, that’s because the method does not remove the admin bar on the WordPress admin backend by design. If you still want to remove it, then this article is for you.