-
Published Tutorial
In this guide, you will create a sample cron_jobs database on an Ubuntu 20.04 server. Then, you'll set up a tasks table and a script that executes the jobs in your table in intervals of 5 seconds using the PHP while(....
•
By
FRANCIS NDUNGU
PHP
Ubuntu 20.04
MySQL
LAMP Stack
-
Published Tutorial
Redis (Remote Dictionary Server ) is an in-memory open source software. It is a data-structure store that uses a server's RAM, which is several times faster than even the fastest Solid State Drive (SSD). This makes Re...
•
By
FRANCIS NDUNGU
PHP
Redis
Ubuntu 20.04
LAMP Stack
-
Published Tutorial
Caching data is an integral design feature when you're designing web applications with higher reads than writes. Such applications include blogs, online stores, and social media sites. In this tutorial, you'll use Red...
•
By
FRANCIS NDUNGU
Ubuntu 20.04
MySQL
Redis
PHP
Databases
-
Published Tutorial
A Binary Large Object BLOB is a MySQL data type that can store binary data such as images, multimedia, and PDF files. In this guide, you will use the MySQL BLOB data type to store images with PHP on Ubuntu 18.04.
•
By
FRANCIS NDUNGU
MySQL
PHP
Databases
Ubuntu 18.04
-
Published Tutorial
A MySQL transaction is a group of logically related SQL commands that are executed in the database as a single unit. Transactions are used to enforce ACID (Atomicity, Consistency, Isolation, and Durability compliance ...
•
By
FRANCIS NDUNGU
Ubuntu 18.04
MySQL
PHP
Databases
-
Published Tutorial
Pagination is the concept of constraining the number of returned rows in a recordset into separate, orderly pages to allow easy navigation between them, so when there is a large dataset you can configure your paginati...
•
By
FRANCIS NDUNGU
MySQL
PHP
Ubuntu 18.04
LAMP Stack
-
Published Tutorial
In MySQL a trigger is a user-defined SQL command that is invoked automatically during an INSERT, DELETE, or UPDATE operation. The trigger code is associated with a table and is destroyed once a table is dropped. You c...
•
By
FRANCIS NDUNGU
MySQL
Databases
-
Published Answer
As far as I know, it is not advisable to access the managed database directly from a mobile app. For instance, if you are distribut…
•
By
francisndungu
-
Published Tutorial
Query cache is a prominent MySQL feature that speeds up data retrieval from a database. In this tutorial, you will first configure MySQL without query cache and run queries to see the duration results. Then you'll set...
•
By
FRANCIS NDUNGU
Caching
MySQL
Databases
Server Optimization
Ubuntu 18.04
-
Published Answer
@X40C . This answer was for another question and I don’t know how it landed on the domain question. I apologize for this.
•
By
francisndungu
-
Published Answer
The general answer is Yes. You can have both SSH key and password authentication on your Ubuntu server.
You will need to create …
•
By
francisndungu
-
Published Answer
Postfix is responsible for receiving emails and passing them to Dovecot for local delivery. Postfix also works as an SMTP server. S…
•
By
francisndungu
-
Published Answer
This error is usually caused by incorrect username or password. Please make sure that you are supplying the correct credentials whe…
•
By
francisndungu
-
Published Answer
You can’t purchase a domain name from Digital Ocean but you can point a domain name to them. So basically, just purchase a domain …
Accepted Answer:
You can’t purchase a domain name from Digital Ocean but you can point a domain name to them. So basically, just purchase a domain …
•
By
francisndungu