Knoldus Blogs

How to do database integration with Cypress?

May 27, 2022May 31, 2022Test Automation Studioautomation testing, Cypress.io, MySql, QA

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)

January 30, 2021August 10, 2021Database, SQL, Tech Blogs#Database, MySql, rdbms

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

Flyway with SBT

March 19, 2020March 19, 2020Database, software, SQL, Studio-ScalaDatabase, Flyway, Migration, MySql, Scala Libraries, singapore, singaporetech, technology

Reading Time: 3 minutes flyway integration with sbt | Database migration

Practical Guide: Anorm using MySQL with Scala

December 10, 2019December 13, 2019Play, Studio-ScalaAnorm, Database, frm, MySql, orm, 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

July 11, 2019July 11, 2019Apache Spark, Big Data and Fast Data, HDFS, Studio-Scala, TableauAnalytics, apache hadoop, Apache Hive, Apache Spark, Big Data, Big Data Analytics, data analysis, Hadoop, Hadoop Distributed File System, HDFS, Hive, MySql, NoSql Database, Spark, Spark with Scala, Tableau

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

June 3, 2019Database, Docker, Studio-DevOps, Tech Blogs, Tutorialdocker, MySql, mysqldump

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

November 28, 2016December 27, 2016Studio-ScalaHadoop, HDFS, Hive, HiveQL, Metastore, MySql, programming, scala, Spark, sql

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

January 28, 2013January 31, 2013Studio-ScalaAnorm, MySql, Play framework, 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