#100DaysOfCode Day 2: Cassandra Query Language
source link: https://dev.to/danielhe4rt/100daysofcode-day-2-cassandra-query-language-3foe
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Databases can be an interesting topic to study.
TL;DR
This article is what I learn in today's challenge about CQL and CassandraDB.
1. Introduction
My second day of #100daysofcode studies was into Cassandra Query Language (CQL). Since I started to study about ScyllaDB, I should focus to learn CQL and probably pass through this "rabbit hole" of databases.
2. CQL vs SQL
CQL (Cassandra Query Language) and SQL (Structured Query Language) are both query languages used to interact with databases, but they have some significant differences. Here are some of the major differences between CQL and SQL.
2.1 Data model
SQL is based on the relational data model, which organizes data into tables with defined columns and relationships between them. CQL is based on the column-family data model, which organizes data into columns grouped by column families or tables. This data model allows for more flexibility in data modeling and querying.
2.2 Query syntax
While CQL has a syntax similar to SQL, there are some key differences. For example, CQL uses a SELECT * FROM statement to query all rows in a table, and uses a WHERE clause to filter data. CQL also supports additional features such as collections, which allow for the storage of multiple values within a single column.
2.3 Schema definition
In SQL, the schema for a database must be defined before any data can be added to the tables. In CQL, the schema can be defined on the fly as data is added to the database. This allows for more flexibility in data modeling and makes it easier to adapt to changing data requirements.
3. Final Considerations
I didn't have so much time today to go further into this studies but there's a few topics that probably I'll be going deeper on the next days.
Don't forget to stay hydrated and see you tomorrow's daily post!
- Follow me on Twitter: @danielhe4rtless
- Follow me on Github: @danielhe4rt
- Follow me on Twitch (daily livecoding sessons now in English): twitch.tv/danielhe4rt
Recommend
-
5
Day 39 :100DaysOfCode gave div2 contest on codeforces (solved 1 only :(-) ... studied subset sum in dp and dutch national flag problem... leetcode easy on strings...(just a few) will...
-
6
Day~2 of #100DaysofCode Hello Everyone, Today is day two of the 100daysofcode challenge, but today is the worst day of the week, I was unable to create any react app it was giving me this error
-
2
Day 0 of #100DaysOfCode! Here I begin my #100DaysofCode challenge. I am excited to document and journal my journey on becoming a better front-end developer. I first heard the phrase
-
4
100daysofcode [Day - 04] ; Today I have gained some knowledge about JS DOM (Document Object Model). Also, read some documentation about machine language and high-level programming language. also completed some real-time pract...
-
8
Have you ever been working in a new language and right when you start feeling confident, you realize that something you've been using does not function at all the way you thought it did? Let me walk you through today's journey of how...
-
1
My free time on Tuesdays is usually incredibly low, so this update (along with future Tuesday updates) will be fairly short. Client vs. Server To quickly preface the below, the part of the project in question simply...
-
3
My week started with way more work than expected. Today I started today off by finishing the JS Basics portion of FreeCodeCamp. These lessons seem to be very well structured, so I'm going to continue with this course...
-
3
100daysofcode (22 Part Series) I hope everyone has had a great holiday so far. One of my mentors really liked the phrase "Your code will haunt you" and...
-
2
-
5
100daysofcode (31 Part Series) Hey again everybody! I didn't have any great time to set aside for diggin...
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK