Many useful applications are written in PHP backed by MariaDB/MySQL for data persistency.
When you wondering what you can use a Raspberry Pi for, one way is to turn it into a LEMP server for hosting PHP applications.
With this in mind, let us look at how we can setup a Raspberry Pi LEMP server with Raspbian Buster Lite for running PHP applications.
Previously, I wrote about why programmers should blog. When you are convinced that you should blog as a programmer, you may wonder how to start a blog.
In order to have a place to refer people who wants to learn more about this topic, I write my experience in this article.
Given that in mind, this is how you can start a blog about computer technology.
The phpMyAdmin project is a solid software tool written in PHP, that can help us handle the administration of MySQL / MariaDB over the web.
If you want to build your next project with a Raspbian Stretch Lite, Nginx, MariaDB / MySQL and PHP 7 LEMP stack, you may want to consider setting up phpMyAdmin as well. This post details how you can do so.
If you had been building the content for your new WordPress site on a Raspberry Pi 3, there will come a time when you need to migrate the underlying MySQL database to another machine, for eg. a DigitalOcean droplet, for production usage.
MySQL provides us with the mongodump client utility to produce a set of SQL statements that can be executed to reproduce the original database object definitions and table data.
A simple MySQL database migration can be performed with the following steps:
tar command to compress it.scp command to send the mysqldump output from the source server to the destination server.tar command to compress the mysqldump output, use the tar command at the destination server to decompress it.mysqldump output at the destination server.This post documents how you can migrate your MySQL / MariaDB database with utilities provided by MySQL and most Linux servers.
I was trying to start a new WordPress site. Before hosting it on a Digital Ocean droplet, I decided to incubate the WordPress site on a Raspberry Pi 3 to clock some content. This post documents the steps that I took to set up a LEMP web server on Raspberry Pi 3 with an Ubuntu server 15.10.3 image to host a new WordPress site.
I was trying to setup a WordPress instance with the built-in PHP-FPM server on my Mac OS X el Capitan. After applying the relevant Nginx configurations for WordPress installations, I had been able to run the php codes from my WordPress instance.
However, when I tried to run the WordPress install script, my WordPress setup complained that it was unable to connect to the database server.
I had decided to include node.js into my toolbox. In the process of getting myself acquainted with node.js, I had jotted down some key points for myself for developing node.js applications in the future. This posts list those key points, and I will update the list as and when I learn more about this useful tool.
There was a second need for me to display a list of countries for my users to select. While the first required insertion of names of the countries into the database, the second required the list of countries to be populated as an array of data objects via Java.
Although the text list of countries from Pedro Posada is useful in both instances, it only fulfills part of what I need. In addition to the names, I need to include additional boiler plate coding to convert the text list of countries into usable forms for the two different programming requirements.
And since the list is more than a 100 items long, it will be more efficient to get the computer to generate the list of countries with the necessary boiler plate coding.
Content is king and large software cannot get away from serving content. In this post, I shall document how to use Java to access relational databases, with the MySQL database as an example.
© 2010 - 2023 Techcoil.com: All Rights Reserved / Disclaimer
Follow us