Cara.app Art Dataset — Full Metadata Database for 52,045 Top Posts with 674k Comment Trees (SQLite)
Yuskeu

@article{,
title= {Cara.app Art Dataset — Full Metadata Database for 52,045 Top Posts with 674k Comment Trees (SQLite)},
journal= {},
author= {Yuskeu},
year= {},
url= {},
abstract= {Companion SQLite database for the Cara.app Art Dataset image archive. 
## Full image database: https://academictorrents.com/details/77d4e2a65852258420a8e47bf29c8f3a5043a446 Cara.app Art Dataset — 123,056 Original Images from Top Community Posts (112 GB) 

Covers all 52,045 posts with over 150 likes on Cara.app (as of August 2026) and contains: full post records (title, body text, timestamps, like/comment/repost counters, software tags, topic tags, flair, polls, mention and quote/repost links, portfolio flags); 162,484 image rows (CDN URLs matching the image archive, carousel order, cover flags, dimensions where recovered, per-image AI-generation flags); 674,762 comments with complete nested thread structure, text, timestamps and like counts; and 5,775 author profiles (display name, bio, website, follower/following counts, account state).

---

## How to link image files to metadata (filename lookup)

Every file in the `images` folder maps to exactly one row in the `images` table by its **basename**, which carries `post_id` — from there you reach the full post and author.

**SQL (any sqlite3 client):**
```sql
-- all metadata for one downloaded file:
SELECT i.*, p.title, p.content, p.created_at, p.like_counter,
       u.name AS author_name, u.slug AS author_slug, u.follower_counter
FROM images i
JOIN posts p ON p.id = i.post_id
JOIN users u ON u.id = p.author_id
WHERE i.cdn_url LIKE '%/' || 'tunamelt-xVmO9g6D26ViDKkmTZnOz-7d865f66-b294-4e12-a0fd-8099137f8467.jpg';

-- build the complete file→post→author manifest yourself:
SELECT substr(i.cdn_url, length('https://cdn.cara.app/')+1) AS filename,
       i.post_id, p.created_at, p.like_counter, u.slug AS author_slug,
       u.name AS author_name, i.is_cover, i.ord, i.width, i.height
FROM images i JOIN posts p ON p.id=i.post_id JOIN users u ON u.id=p.author_id;
```

**Python (3 lines):**
```python
import sqlite3
db = sqlite3.connect("subset_dataset.db")
fn = "tunamelt-xVmO9g6D26ViDKkmTZnOz-7d865f66-b294-4e12-a0fd-8099137f8467.jpg"
img  = db.execute("SELECT * FROM images WHERE cdn_url LIKE '%'||?", ("%/"+fn,)).fetchone()
post = db.execute("SELECT * FROM posts WHERE id=?", (img[1],)).fetchone()
```
(`images.post_id` is column 2; `posts.author_id` is column 2; `users.id` is column 1.)

The same join works for comments: `comments.post_id → posts.id`.},
keywords= {' comments', 'cara.app', ' metadata database', ' sqlite', ' art dataset', ' comment trees', ' artist profiles', ' engagement metrics', ' AI detection', ' social network analysis', ' digital art'},
terms= {},
license= {},
superseded= {}
}