FRANCIS NDUNGU Author
I am a professional software developer with great passion on cloud technologies.
13 contributions
138.8k 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 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 …