MySql

How to do database integration with Cypress?

Reading Time: 2 minutes Cypress is one of those popular tools which has established its place very quickly and is very popular for Web integration and End to End UI test automation. Cypress can do database integration. It needs a javascript framework like jasmine or mocha. These are one of the famous assertion libraries in JavaScript. Cypress recommends using mocha. In this blog, we will see how to do database integration using Cypress. Continue Reading

Different types of Keys in DBMS (Database Management)

Reading Time: 4 minutes Introduction A huge amount of data is available in this real-world. Now, for storing the data in DBMS, a large number of tables are required. These tables may contain thousand of duplicate, sorted, and unsorted Records. Now, to fetch any particular or specific record, without any constraints/ restrictions from these tables is a very difficult process. To overcome all the difficulties, a new concept of Continue Reading

Practical Guide: Anorm using MySQL with Scala

Reading Time: 3 minutes  In this blog, we are going to explore the Anorm. Play includes a simple data access layer called Anorms that uses plain SQL to interact with the database and provides an API to parse and transform the resulting datasets. In this blog, we will be using MySQL as our database.  You need to perform the following steps to utilize Anorm: 1)To start with anorm, you Continue Reading

Big Data Evolution: Migrating on-premise database to Hadoop

Reading Time: 4 minutes We are now generating massive volumes of data at an accelerated rate. To meet business needs, address changing market dynamics as well as improve decision-making, sophisticated analysis of this data from disparate sources is required. The challenge is how to capture, store and model these massive pools of data effectively in relational databases. Big data is not a fad. We are just at the beginning Continue Reading

Custom MySQL Docker Instance

Reading Time: 2 minutes Hi folks, I am back with another blog, have you ever been in a situation where you required to set up or mimic the current MySQL instance of any environment. Well recently I have been in such a situation and my use case was to test the overall services so I decided to use minikube for service deployment as a whole, now when I had Continue Reading

BigData Specifications – Part 1 : Configuring MySql Metastore in Apache Hive

Reading Time: 2 minutes Apache Hive is used as a data warehouse over Hadoop to provide users a way to load, analyze and query the data from various resources. Data is stored into databases or file systems like HDFS (Hadoop Distributed File System). Hive can use Spark SQL or HiveQL for the implementation of queries. Now Hive uses its metastore which contains the following information, Ids of tables, Ids Continue Reading

Play Framework 2.0: Connectivity with MySQL in Scala

Reading Time: < 1 minute Welcome to another week of KnolX sessions .The emphasis in this session is on How to connect a Play Application with Mysql as database in Scala.Play includes a simple data access layer called Anorm that uses plain SQL to interact with the database and provides an API to parse and transform the resulting datasets. Entire code can be found here: https://github.com/knoldus/FormDemoInPlayWithMysql