Tag: MySQL
-
Data layer security and permission in a multi-tenancy data warehouse
In this article we will discuss various approaches for achieving data isolation or data layer security in a multi-tenancy data warehouse. I will refer multi-tenancy data warehouse as an architecture where an instance of OLAP database is shared by many customers. In a multi-tenancy platform data isolation (row level data access) is usually performed in…
-
Read and write data using SQLAlchemy and Pandas dataframe
SQLAlchemy has made it easy to read and write data from databases. I am using Google Colab and free databases to store and manipulate data. In this article, I will read data from MySQL database and save the result to a PostgreSQL using Pandas dataframe to_sql method. Steps Prerequisites Needed following Python packages – Google…
-
Getting data from MySQL database using PHP
db4free.net provides a testing service for the latest version of the MySQL Server. You can easily create an account for free and test your applications. db4free.net is also a good resource for education and to make yourself familiar with MySQL database via phpMyAdmin. For more advance example, please read this artcle – Contact Form using HTML, JavaScript, CSS,…
-
Google CoLab and relational database
We will show how to access relational database using Google CoLab. We will use both python module and PySpark for accessing MySQL database and writing data to it. See other articles related to BigQuery and Google Colab Prerequisites For example, you will only need mysql-connector-python for accessing MySQL database. Connect to MySQL database Assuming you…
-
How to Create Pivot Table in MySQL
MySQL does not have a Pivot function to create a pivot table in MySQL. Pivot tables are useful for data analysis, allow you to display row values as columns to easily get insights. Tyerefore one needs to write SQL query to create pivot table in MySQL. You can use SUM and IF OR CASE statements to create…
-
Contact Form using HTML, JavaScript, CSS, PHP and MySQL
Creating a contact form using HTML and saving data in MySQL. Prerequisites Create a table in MySQL database HTML form MySQL connection settings Processing form data Screenshots
-
Import data from google sheets to a MySQL table
Saving data from Google. Sheets to MySQL table using Apps Script. Prerequisites MySQL table Apps Script to insert data into MySQL Data in Google Sheets
-
Python code for connecting to remote MySQL database using SSH
A working code is given below: Login to remote database and mapping port to host
-
Creating Cloud MySQL instance with Terraform
“Terraform is a tool for building, changing, and versioning infrastructure safely and efficiently. Terraform can manage existing and popular service providers as well as custom in-house solutions.” In this post, will show how to use Terraform to mange Google Cloud SQL resources. Prerequisites: Google Cloud Platform account Terraform installed on your machine (you can find…
-
Copy data from local MySQL database to Google Cloud MySQL
The main job performs two tasks: insert latest records into the target database update the target database with delta records PDI crashes if it tries to load more than few millions records at a single run. The approach is taken to overcome this limitation by processing data in smaller data chunks. How it works get…