PostgreSQL Table and Insert - Cql Typing CST Test
Loading…
PostgreSQL Table and Insert — Cql Code
Creating a table and inserting rows in PostgreSQL.
CREATE TABLE products (
id SERIAL PRIMARY KEY,
name TEXT NOT NULL,
price NUMERIC
);
INSERT INTO products (name, price)
VALUES ('Laptop', 1200.50),
('Phone', 699.99);
SELECT * FROM products;Cql Language Guide
Cassandra Query Language (CQL) is the native query language for Apache Cassandra, a highly scalable, distributed NoSQL database. CQL provides a SQL-like syntax for interacting with Cassandra's column-family data model, supporting data definition, manipulation, and retrieval.
Primary Use Cases
- ▸High-volume data ingestion
- ▸Time-series and IoT data management
- ▸Real-time analytics and reporting
- ▸Distributed and fault-tolerant applications
- ▸Data warehousing for large-scale datasets
- ▸Session and user activity tracking
Notable Features
- ▸SQL-like syntax familiar to relational users
- ▸Supports primary keys, clustering columns, and partitioning
- ▸TTL (Time to Live) for automatic data expiration
- ▸Lightweight transactions (LWT) for conditional updates
- ▸Integration with many programming language drivers
- ▸High write and read scalability across clusters
Origin & Creator
CQL was developed by DataStax and the Apache Cassandra community, evolving from 2008 onwards to provide a familiar query interface for Cassandra's wide-column store architecture.
Industrial Note
CQL is critical in industries requiring high availability and write scalability, such as IoT platforms, financial transaction systems, social media feeds, and real-time analytics. Its denormalized, column-family approach allows Cassandra to scale horizontally across multiple nodes.