Tag: SQL
Learn how to – Install Microsoft SQL Server 2019 on CentOS 7 / Fedora
Learn how to – Install Microsoft SQL Server 2019 on CentOS 7 / Fedora. SQL Server runs on Linux starting with SQL Server 2017. This SQL Server is the same SQL Server database engine running on Microsoft Operating systems, with many similar features and services. This guide will take you through the steps to install Microsoft …
Learn how to – Install Microsoft SQL Server 2019 on CentOS 7 / FedoraRead More
Learn how to – Install MyWebSQL on RHEL 8 / CentOS 8
Learn how to – Install MyWebSQL on RHEL 8 / CentOS 8. How do I install MyWebSQL on RHEL 8 / CentOS 8?. MyWebSQL is an open source web-based WYSIWYG Database client written in PHP for performing Database operations. It offers features similar to those of phpMyAdmin. MyWebSQL has support for MySQL, PostgreSQL and SQLite …
Learn how to – Install MyWebSQL on RHEL 8 / CentOS 8Read More
Filter Pandas dataframe using ‘in’ & ‘not in’ like SQL
In this article, we will discuss multiple ways to filter a pandas DataFrame using the “in” and “not in” like functions in SQL. These functions are very handy to filter any DataFrame based on some custom conditions or predecided values. Table of Contents Preparation of solution Using pandas.DataFrame.isin() function Using numpy.isin() function Using query() method …
Filter Pandas dataframe using ‘in’ & ‘not in’ like SQLRead More
Setup Cloud SQL for PostgreSQL on Google Cloud
In this post, you are going to create a Cloud SQL for PostgreSQL in Google Cloud Platform and connect it to Compute Engine VM Instance. Prerequisites Your Compute Engine Instance is setup and running. For setting up Compute Engine, see the Setting up Compute Engine Instance. Domain name is pointed to your virtual machine. For …
Setup PhpMyAdmin with Cloud SQL on Compute Engine
In this post, I will guide you to install PHPMyAdmin on a Compute Engine VM Instance and connect it to Cloud SQL. Prerequisites Your Compute Engine Instance running. For setting up Compute Engine, see the Setting up Compute Engine Instance. For installing Nginx and PHP, see how to install LEMP in Compute Engine Instance. Google …
Install Typo 3 on Google Cloud with Ubuntu 18.04, Nginx and Cloud SQL
Install Typo 3 on Google Cloud with Ubuntu 18.04, Nginx and Cloud SQL. Prerequisites Your Compute Engine Instance running. For setting up Compute Engine, see the Setting up Compute Engine Instance. For installing Nginx and PHP, see how to install LEMP in Compute Engine Instance. Domain name is pointed to your virtual machine. For setting …
Install Typo 3 on Google Cloud with Ubuntu 18.04, Nginx and Cloud SQLRead More
Install Strapi on Ubuntu 18.04 LTS on Google Cloud with Cloud SQL
Install Strapi on Ubuntu 18.04 LTS on Google Cloud with Cloud SQL. Strapi is a most advanced open source content management framework to build powerful API. It is a headless CMS built with Node.js. In this guide you are going to learn how to install and setup Node.js, Strapi for production on Ubuntu 18.04 on …
Install Strapi on Ubuntu 18.04 LTS on Google Cloud with Cloud SQLRead More
Install Ruby on Rails on Ubuntu 18.04 with Google Cloud SQL
Prerequisites For setting up Compute Engine, see the Setting up Compute Engine Instance. Domain name is pointed to your virtual machine. For setting up Cloud DNS, see the Setting up Google Cloud DNS for your domain. Google Cloud SQL Setup, see Setup Cloud SQL and connect with Compute Engine. Install Ruby on Rails with RVM …
Install Ruby on Rails on Ubuntu 18.04 with Google Cloud SQLRead More
Install Prestashop on Google Cloud with Ubuntu 18.04, Nginx, PHP 7.2, Cloud SQL and Let’s Encrypt SSL
Install Prestashop on Google Cloud with Ubuntu 18.04, Nginx, PHP 7.2, Cloud SQL and Let’s Encrypt SSL Prerequisites Your Compute Engine Instance running and installed with Nginx and PHP. For setting up Compute Engine, see the Setting up Compute Engine Instance. For installing Nginx and PHP, see how to install LEMP in Compute Engine Instance. …
Install Opencart on Google Cloud with Ubuntu 18.04, Nginx, PHP 7.3, Cloud SQL and Let’s Encrypt SSL
Install Opencart on Google Cloud with Ubuntu 18.04, Nginx, PHP 7.3, Cloud SQL and Let’s Encrypt SSL Prerequisites Your Compute Engine Instance running and installed with Nginx and PHP. For setting up Compute Engine, see the Setting up Compute Engine Instance. For installing Nginx and PHP, see how to install LEMP in Compute Engine Instance. …