FRANCIS NDUNGU Author
I am a professional software developer with great passion on cloud technologies.
17 contributions
321.5k contribution views
Skills
- mysql
- php
- ubuntu
- centos
- debian
- server security
- high availability
Interested in learning
- python
- containers
- kubernets
Follow Me
Recognition
Posts
-
Published Tutorial
How To Use Foreign Keys in SQL
When working on a large SQL project, you must maintain the accuracy and consistency of data across all tables using foreign keys. This is where referential integrity comes into play. Referential integrity ensures all ... -
Published Tutorial
How To Run a PHP Job Multiple Times in a Minute with Crontab on Ubuntu 20.04
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(.... -
Published Tutorial
How To Implement PHP Rate Limiting with Redis on Ubuntu 20.04
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... -
Published Tutorial
How To Set Up Redis as a Cache for MySQL with PHP on Ubuntu 20.04
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... -
Published Tutorial
How To Use the MySQL BLOB Data Type to Store Images with PHP on Ubuntu 18.04
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. -
Published Tutorial
How To Use the PDO PHP Extension to Perform MySQL Transactions in PHP on Ubuntu 18.04
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 ... -
Published Tutorial
How To Implement Pagination in MySQL with PHP on Ubuntu 18.04
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... -
Published Tutorial
How To Manage and Use MySQL Database Triggers on Ubuntu 18.04
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... -
Published Answer
Access managed mysql database from Mobile app
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… -
Published Tutorial
How To Optimize MySQL with Query Cache on Ubuntu 18.04
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... -
Published Answer
Can I register my domain through Digital Ocean? If so how.
@X40C . This answer was for another question and I don’t know how it landed on the domain question. I apologize for this. -
Published Answer
Can both password authentication and an SSH key be used on the same account at Digital Ocean?
The general answer is Yes. You can have both SSH key and password authentication on your Ubuntu server. You will need to create … -
Published Answer
Not able to receive emails on postfix dovecot configuration
Postfix is responsible for receiving emails and passing them to Dovecot for local delivery. Postfix also works as an SMTP server. S… -
Published Answer
How to fix "Error establishing a database connection" ?
This error is usually caused by incorrect username or password. Please make sure that you are supplying the correct credentials whe… -
Published Answer
Can I register my domain through Digital Ocean? If so how.
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 …