DataOps Zeta
Interactive PostgreSQL Operations Sandbox
🎓 Welcome to the Database Sandbox!
DataOps Zeta is an interactive educational dashboard designed to help you visualize and play with real database operations. This sandbox connects directly to a live PostgreSQL database hosted on Neon. Every action you run here directly modifies or queries the database table, helping you understand how standard operations like inserting, updating, deleting, sorting, and aggregating work under the hood.
▶How does this database work? Click to read the interactive guide
📥 Insert (Write Operation):
Adds a new row containing a title, numeric value, and text content. A new unique ID is automatically assigned by PostgreSQL.
🔍 Access (Read Operation):
Fetches specific records from the table using either their exact primary key ID, or finding the oldest/newest entries.
🔎 Search (Read Operation):
Filters rows by performing a case-insensitive keyword search (`ILIKE` query) across the title and content fields.
✏️ Update (Write Operation):
Edits the title, numeric value, and content of an existing record matching the ID you provide.
🗑️ Delete (Write Operation):
Permanently removes a record from the database table based on its unique primary key ID.
🔄 Traversal (Read Operation):
Iterates through and lists the entire table sequentially (either oldest first or newest first).
📊 Sort (Read Operation):
Reorders the active database rows based on specific columns (e.g. by numeric value, alphabetically, or date).
📈 Aggregate (Calculate Operation):
Runs math operations on your data rows, counting total records or computing the average of the value column.
🗄️ Live Database View
Displaying all entries directly from your Neon PostgreSQL database.
| ID | Title | Value | Content | Created At |
|---|---|---|---|---|
| #1 | sdfsdfsdf | 3333 | asdfsdfsdfsdf | 2026-02-02 08:27:36 |
| #3 | dsfsdfsaf | 3 | efsfadsfsdf | 2026-02-02 08:27:52 |
| #6 | Helloo boys | 25 | Something is nothing and something cooking | 2026-02-03 07:01:31 |
| #7 | kjhgszkdjhfsdfds | 33 | gsrgredrgsdrgdrfg | 2026-02-03 09:19:54 |
| #10 | hello | 20 | nothing | 2026-05-21 17:48:26 |
| #12 | Hello how are you? | 64 | Nothing testing | 2026-05-21 19:30:34 |
| #13 | Djsb | 3 | Shwywg | 2026-05-21 19:30:43 |
| #15 | Hello testing | 100 | bye testing | 2026-06-02 08:37:25 |
Database Modifiers (Write Actions)
Add entry
One form: text (title), number (value), and content.
Update
Edit title, value, and content by ID.
Delete
Remove one entry by ID.
Database Queries (Read Actions)
Access
Fetch by ID, or latest / earliest by date.
Search
Find entries by keyword (title or content).
Traversal
Show all entries in order or reverse order.
Sorting
List entries by date, value, or title.
Aggregation
Total count and average value.