SUNNY DAY Database: An Introduction for Beginners

SUNNY DAY Database: An Introduction for Beginners

What it is: SUNNY DAY Database is a hypothetical (or assumed) modern database system designed for simplicity, reliability, and high read performance. It combines a relational-like query model with scalable storage and built-in replication.

Key concepts

• Data model: Tables with schemas; supports structured types and optional schemaless JSON columns for flexibility.
• Storage engine: Log-structured merge-tree (LSM) for fast writes and compaction to optimize reads.
• Replication: Multi-region replication with leader-follower and optional leaderless modes for low-latency reads.
• Query language: SQL-compatible core with extensions for JSON querying and time-series functions.
• Transactions: ACID transactions at row-level with snapshot isolation; lightweight distributed transactions for multi-shard operations.
• Indexes: B-tree for point lookups, inverted/GIN-style indexes for JSON and full-text, and time-partitioned indexes for time-series.

Typical use cases

• Read-heavy web applications and APIs
• Analytics on near-real-time data streams
• Time-series monitoring (metrics, logs)
• Flexible-schema apps combining structured and JSON data

Basic setup (assumed defaults)

1. Install SUNNY DAY binary on each node.
2. Configure cluster.yaml with node roles, replication factor = 3, and data directories.
3. Initialize with sunnyctl init –cluster cluster.yaml.
4. Create a database and table:

Code
Copy CodeCopied
CREATE DATABASE app_db; CREATE TABLE users (id UUID PRIMARY KEY,   name TEXT,   profile JSONB,   createdat TIMESTAMP DEFAULT now() ); 

Code
 ffON2NH02oMAcqyoh2UU MQCbz04ET5EljRmK3YpQ CPXAhl7VTkj2dHDyAYAf” data-copycode=“true” role=“button” aria-label=“Copy Code”>Copy CodeCopied
INSERT INTO users (id, name, profile) VALUES (gen_randomuuid(), ‘Ada’, ‘{“bio”:“developer”}’); 

Code
 ffON2NH02oMAcqyoh2UU MQCbz04ET5EljRmK3YpQ CPXAhl7VTkj2dHDyAYAf” data-copycode=“true” role=“button” aria-label=“Copy Code”>Copy CodeCopied
SELECT id, name FROM users WHERE name = ‘Ada’; 

Code
Copy CodeCopied
SELECT profile->>‘bio’ FROM users WHERE profile->>‘role’ = ‘admin’; 

Code
Copy CodeCopied
SELECT time_bucket(‘1h’, timestamp) AS hour, count(*) FROM events GROUP BY hour;