Knoldus Blogs

How To Create And Insert Data In Postgre Hstore

June 6, 2022June 9, 2022Studio-ScalaDatabase, database management system, dbms, hstore, Postgre, postgre datatype, postgre hstore, postgreSQL, rdbms, sql, Tech blog, technology

Reading Time: 2 minutes Postgre without a doubt is one of the most popular databases in the market. The reason behind this is PostgreSQL’s speed, security, and robustness. PostgreSQL isn’t just a relational database. PostgreSQL invented many post-relational concepts like in-database functions and user-defined datatypes. Other than that it has many amazing features like Hstore. Now, this blog is for you if you want to know about PostgreSQL Hstore. Continue Reading

Why Use MongoDB in Machine learning? And how to use MongoDB in Python?

May 4, 2022May 4, 2022AI, ML, AI and Data Engineering, python, Studio-Scala#mongodb, #NoSQL, #pymongo, #python, rdbms

Reading Time: 5 minutes In this blog, we will learn why to use MongoDB in Machine Learning. And how we can use MongoDB in Python using Pymongo. MongoDB is a document-oriented NoSQL database used for high-volume data storage. Instead of using tables and rows as in the traditional relational databases. MongoDB makes use of collections and documents. It is an open-source, cross-platform, document-oriented database written in C++. Installing MongoDB Continue Reading

Let’s have a look at the PostgreSQL CRUD operation

February 14, 2022February 14, 2022Database, SQL, Studio-Scala, Tech BlogsPostgre, postgreSQL, rdbms, sql

Reading Time: 4 minutes We are aware that PostgreSQL is one of the most popular and powerful databases in the market. Its amazing features and support from large developer communities always make a difference in the industry. Now, this blog is for you if you want to get familiar with the basic concepts of Postgre SQL. This blog will cover the basic CRUD operation (Create Read Update Delete) in 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

An Introduction to CockroachDB !!!

June 12, 2017June 12, 2017Database, Studio-ScalaCockroachDB, Database, Distributed Database, rdbms

Reading Time: 3 minutes Hello Folks, Today we are going to discuss about the Resilient SQL Database. As we know database is a main part for any organization or business. We say that we have many databases in the present, developers are left with a small range of options: Traditional RDBMS: Traditional Database is known for the Transaction, Consistency and indexes, but are not scalable and fault-tolerant. As you Continue Reading