closed

.gitattributes

@@ -1 +1,63 @@
-*.db filter=lfs diff=lfs merge=lfs -text
+*.7z filter=lfs diff=lfs merge=lfs -text
+*.arrow filter=lfs diff=lfs merge=lfs -text
+*.avro filter=lfs diff=lfs merge=lfs -text
+*.bin filter=lfs diff=lfs merge=lfs -text
+*.bz2 filter=lfs diff=lfs merge=lfs -text
+*.ckpt filter=lfs diff=lfs merge=lfs -text
+*.ftz filter=lfs diff=lfs merge=lfs -text
+*.gz filter=lfs diff=lfs merge=lfs -text
+*.h5 filter=lfs diff=lfs merge=lfs -text
+*.joblib filter=lfs diff=lfs merge=lfs -text
+*.lfs.* filter=lfs diff=lfs merge=lfs -text
+*.lz4 filter=lfs diff=lfs merge=lfs -text
+*.mds filter=lfs diff=lfs merge=lfs -text
+*.mlmodel filter=lfs diff=lfs merge=lfs -text
+*.model filter=lfs diff=lfs merge=lfs -text
+*.msgpack filter=lfs diff=lfs merge=lfs -text
+*.npy filter=lfs diff=lfs merge=lfs -text
+*.npz filter=lfs diff=lfs merge=lfs -text
+*.onnx filter=lfs diff=lfs merge=lfs -text
+*.ot filter=lfs diff=lfs merge=lfs -text
+*.parquet filter=lfs diff=lfs merge=lfs -text
+*.pb filter=lfs diff=lfs merge=lfs -text
+*.pickle filter=lfs diff=lfs merge=lfs -text
+*.pkl filter=lfs diff=lfs merge=lfs -text
+*.pt filter=lfs diff=lfs merge=lfs -text
+*.pth filter=lfs diff=lfs merge=lfs -text
+*.rar filter=lfs diff=lfs merge=lfs -text
+*.safetensors filter=lfs diff=lfs merge=lfs -text
+saved_model/**/* filter=lfs diff=lfs merge=lfs -text
+*.tar.* filter=lfs diff=lfs merge=lfs -text
+*.tar filter=lfs diff=lfs merge=lfs -text
+*.tflite filter=lfs diff=lfs merge=lfs -text
+*.tgz filter=lfs diff=lfs merge=lfs -text
+*.wasm filter=lfs diff=lfs merge=lfs -text
+*.xz filter=lfs diff=lfs merge=lfs -text
+*.zip filter=lfs diff=lfs merge=lfs -text
+*.zst filter=lfs diff=lfs merge=lfs -text
+*tfevents* filter=lfs diff=lfs merge=lfs -text
+# Audio files - uncompressed
+*.pcm filter=lfs diff=lfs merge=lfs -text
+*.sam filter=lfs diff=lfs merge=lfs -text
+*.raw filter=lfs diff=lfs merge=lfs -text
+# Audio files - compressed
+*.aac filter=lfs diff=lfs merge=lfs -text
+*.flac filter=lfs diff=lfs merge=lfs -text
+*.mp3 filter=lfs diff=lfs merge=lfs -text
+*.ogg filter=lfs diff=lfs merge=lfs -text
+*.wav filter=lfs diff=lfs merge=lfs -text
+# Image files - uncompressed
+*.bmp filter=lfs diff=lfs merge=lfs -text
+*.gif filter=lfs diff=lfs merge=lfs -text
+*.png filter=lfs diff=lfs merge=lfs -text
+*.tiff filter=lfs diff=lfs merge=lfs -text
+# Image files - compressed
+*.jpg filter=lfs diff=lfs merge=lfs -text
+*.jpeg filter=lfs diff=lfs merge=lfs -text
+*.webp filter=lfs diff=lfs merge=lfs -text
+# Video files - compressed
+*.mp4 filter=lfs diff=lfs merge=lfs -text
+*.webm filter=lfs diff=lfs merge=lfs -text
+master_fullres_8.5m_links.txt filter=lfs diff=lfs merge=lfs -text
+catalog.db filter=lfs diff=lfs merge=lfs -text
+catalog_salted_hash.db filter=lfs diff=lfs merge=lfs -text

README.md

@@ -1,92 +1,74 @@
 # CaraArchive Index Dataset
 
+phamrhgids
+igmutexyzb
+
 ### 1) This is an Index Dataset, not an Image dataset
 - This dataset contains **0 image data**.
 - It only contains links to Cara App's CDN and metadata.
 - HuggingFace may load some images in the preview because it detects the CDN links, however those images do not exist as data in this dataset, HF literally just loads them using your own connection as a preview.
 
----
+### 2) This dataset is *100% Complete*
+- It includes **3.43 million posts** (and their thumbnails) from **790k users** to which belong **8.52 million artworks**, making a total of **~12 million image links**.
+- Every user and every post on the platform (from 14/6/26 and before) is included here.
+- Some people got the impression that not all of their posts are there because they searched their names in the CDN URLs, however *not all URLs include the name in them* (many use server timestamps and random hashes).
 
-### How to Query the Database with `tool.py` (make sure `catalog.db` is in the same directory)
+---
 
-**To see a clean summary overview of an artist:**
-```bash
-python tool.py --user artist_fc17f3c7 --overview
-# or query by author UUID:
-python tool.py --user fc17f3c7-73ab-4866-8d1a-554da8ea68a9 --overview
-```
+### How to Query the Database `tool.py` (make sure catalog.db is in the directory)
 
-**To see full breakdown and all image links by artist:**
+To see a clean summary overview of an account
 ```bash
-python tool.py --user artist_fc17f3c7
+python tool.py --user <username>
 ```
 
-**To see all artworks, software, metadata, and creator for a specific post:**
+To see all artworks, software, metadata and creator for a specific post:
 ```bash
-python tool.py --post 00002b4d-120a-4e94-bae7-49b9c905bc05
-# or using web URL:
-python tool.py --post https://cara.app/post/00002b4d-120a-4e94-bae7-49b9c905bc05
+python tool.py --post <Post URL or ID>
 ```
 
-**To find the post and creator that an artwork image belongs to:**
+To find the post and creator that an artwork belongs to:
 ```bash
-python tool.py --art tenaebron-S4TIL677BLm8bh_T0jB6I-post-cover-image.jpeg
-# or using direct CDN link:
-python tool.py --art https://cdn.cara.app/production/posts/93d6c843-1f4a-429d-8144-31e9099b95c6/tenaebron-S4TIL677BLm8bh_T0jB6I-post-cover-image.jpeg
+python tool.py --art <CDN URL or filename>
 ```
 
 ---
 
 ### Database Structure (`catalog.db`)
 
-The SQLite database contains 3 main tables (and 2 tracking tables):
+The SQLite database contains 3 main tables:
 
-#### `master_artworks_12m` (8,521,351 rows)
+#### `master_artworks_12m` (8,522,366 rows)
 Contains all full-resolution master artwork uploads.
-- `id`: Unique image ID (`<post_id>_slide_<number>`) `[PRIMARY KEY]`
+- `id`: Unique image ID (`<post_id>_slide_<number>`)
 - `post_id`: Post ID this artwork belongs to
-- `author_slug`: Anonymized creator handle (`artist_<hex>`)
+- `author_slug`: Username of the creator
 - `slide_number`: Order in the multi-image gallery (1, 2, 3...)
-- `title`: Post title (with personal handles/links redacted as `[CENSORED]`)
-- `cdn_url`: Direct high-res CDN link `(UNIQUE)`
+- `title`: Post title
+- `cdn_url`: Direct high-res CDN link
 - `width`: Image width in pixels
 - `height`: Image height in pixels
 - `created_at`: Upload timestamp
 
 #### `artworks` (3,431,475 rows)
 Contains all posts and cover thumbnails.
-- `id`: Unique image ID (`<post_id>_<suffix>`) `[PRIMARY KEY]`
-- `author_slug`: Anonymized creator handle (`artist_<hex>`)
-- `author_id`: Anonymized creator UUID
-- `post_id`: Post ID this artwork belongs to
-- `cdn_url`: Cover image / thumbnail link `(UNIQUE)`
+- `post_id`: Unique post ID
+- `author_slug`: Username of the creator
+- `author_id`: User UUID
+- `cdn_url`: Cover image / thumbnail link
 - `created_at`: Creation timestamp
-- `downloaded`: Download status flag (`0` = pending, `1` = downloaded)
 
-#### `post_metadata` (3,431,474 rows)
-Contains all tags, software, descriptions, metrics, and audit statuses.
-- `post_id`: Post ID `[PRIMARY KEY]`
-- `author_slug`: Anonymized creator handle (`artist_<hex>`)
-- `author_name`: Anonymized display name (`Artist <HEX>`)
-- `title`: Post title (with personal handles/links redacted as `[CENSORED]`)
-- `content`: Description / lore text (with social handles, emails, and links redacted as `[CENSORED]`)
-- `softwares`: Software used (JSON array, e.g. `["Blender", "Photoshop"]`)
-- `tags`: Categories and tags (JSON array, e.g. `["Illustration", "ConceptArt"]`)
-- `raw_tags`: Typed tags (JSON array of objects, e.g. `[{"type": "category", "value": "Horror"}]`)
-- `like_count`: Number of likes
-- `comment_count`: Number of comments
+#### `post_metadata` (3,431,475 rows)
+Contains all tags, software, descriptions, and audit statuses.
+- `post_id`: Post ID
+- `author_slug`: Username
+- `author_name`: Display name
+- `title`: Post title
+- `content`: Description / lore text
+- `softwares`: Software used (e.g. `["Blender", "Photoshop"]`)
+- `tags`: Categories and tags (e.g. `["Illustration", "ConceptArt"]`)
 - `status_code`: HTTP status (`200` = active, `404` = deleted post, `403` = private)
 - `is_deleted`: `1` if post was removed, `0` if active
 - `created_at`: Creation timestamp
 
-#### Additional Tracking Tables:
-- `indexed_artists` (3,267 rows): `author_id` (PK), `slug`, `artwork_count`
-- `processed_posts` (3,431,475 rows): `post_id` (PK)
-
 ---
-
-### Files in this Release
-- `catalog.db`: SQLite database with all tables and B-Tree indexes (9.82 GB)
-- `tool.py`: CLI dataset explorer script
-- `README.md`: Dataset documentation
-

catalog.db

@@ -1,3 +1,3 @@
 version https://git-lfs.github.com/spec/v1
-oid sha256:b39c18e671eed0345656d96284a6469123ddaca2a46549df5f4ed6bd990ba267
-size 10541236224
+oid sha256:ba8a3050a08ab946da0d3b9eab299c61a0a2666647c92208c0b5dcbaf6555d63
+size 5072785408

master_fullres_8.5m_links.rar

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:7c15492a42118dac25bc070f4bc6d8ffee920dff486bf62a9e7829e2e7959dac
+size 342777453

master_fullres_8.5m_links.txt

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:d34b3b7bf2d01af6a190c73ba00d61ae59e5e669fe33ae26661691b98442befb
+size 1155400458

test_pr64.txt

@@ -0,0 +1 @@
+hello pr64

tool.py

@@ -13,20 +13,10 @@ import argparse
 from urllib.parse import urlparse
 from collections import Counter
 
-# Ensure UTF-8 output encoding for terminals
-if hasattr(sys.stdout, "reconfigure"):
-    try:
-        sys.stdout.reconfigure(encoding="utf-8", errors="replace")
-    except Exception:
-        pass
-
-# Dynamic discovery of catalog.db or catalog_anonymized.db (100% portable & anonymous)
+# Dynamic discovery of catalog.db (100% portable & anonymous)
 DB_CANDIDATE_PATHS = [
-    "catalog_anonymized.db",
     "catalog.db",
-    os.path.join(os.path.dirname(os.path.abspath(__file__)), "catalog_anonymized.db"),
     os.path.join(os.path.dirname(os.path.abspath(__file__)), "catalog.db"),
-    "../catalog_anonymized.db",
     "../catalog.db",
 ]
 
@@ -44,7 +34,7 @@ COMMON_PLACEHOLDERS = [
 
 
 def find_database() -> str:
-    """Auto-detects catalog database location dynamically."""
+    """Auto-detects catalog.db location dynamically."""
     for path in DB_CANDIDATE_PATHS:
         if os.path.exists(path) and os.path.getsize(path) > 1000000:
             return path
@@ -52,13 +42,13 @@ def find_database() -> str:
 
 
 def get_db_connection():
-    """Connects to database with clean error guidance if missing."""
+    """Connects to catalog.db with clean error guidance if missing."""
     db_path = find_database()
     if not db_path:
         print("\n" + "=" * 80)
-        print("❌ DATABASE NOT FOUND: 'catalog_anonymized.db' or 'catalog.db'")
+        print("❌ DATABASE NOT FOUND: 'catalog.db'")
         print("=" * 80)
-        print("Please make sure the database file is located in the same folder as this script!")
+        print("Please make sure 'catalog.db' is located in the same folder as this script!")
         print(f"Current working directory: {os.getcwd()}")
         print("=" * 80 + "\n")
         sys.exit(1)
@@ -136,29 +126,6 @@ def explore_user(username_raw: str, is_overview: bool = False):
     conn = get_db_connection()
     cur = conn.cursor()
 
-    # Resolve author by slug or author_id UUID
-    cur.execute("""
-        SELECT author_slug, author_id FROM artworks 
-        WHERE author_slug = ? COLLATE NOCASE OR author_id = ?
-        LIMIT 1;
-    """, (username, username))
-    author_row = cur.fetchone()
-    if author_row:
-        username = author_row["author_slug"]
-        author_id = author_row["author_id"]
-    else:
-        cur.execute("SELECT DISTINCT author_slug FROM master_artworks_12m WHERE author_slug = ? COLLATE NOCASE;", (username,))
-        found_slug = cur.fetchone()
-        if not found_slug:
-            print("\n" + "=" * 80)
-            print(f"❌ Artist '{username}' was not found in the database.")
-            print("Tip: Double-check the handle or author UUID.")
-            print("=" * 80 + "\n")
-            conn.close()
-            return
-        username = found_slug["author_slug"]
-        author_id = None
-
     # 1. Fetch Posts from artworks table
     cur.execute("""
         SELECT post_id, cdn_url as cover_url, created_at 
@@ -168,6 +135,17 @@ def explore_user(username_raw: str, is_overview: bool = False):
     """, (username,))
     posts = cur.fetchall()
 
+    if not posts:
+        cur.execute("SELECT DISTINCT author_slug FROM master_artworks_12m WHERE author_slug = ? COLLATE NOCASE;", (username,))
+        found_slug = cur.fetchone()
+        if not found_slug:
+            print("\n" + "=" * 80)
+            print(f"❌ Artist '@{username}' was not found in the database.")
+            print("Tip: Double-check the exact handle as it appears in the artist's Cara profile URL.")
+            print("=" * 80 + "\n")
+            conn.close()
+            return
+
     # 2. Fetch Master Artworks
     cur.execute("""
         SELECT post_id, slide_number, title, cdn_url, width, height, created_at 
@@ -179,7 +157,7 @@ def explore_user(username_raw: str, is_overview: bool = False):
 
     # 3. Fetch Post Metadata
     cur.execute("""
-        SELECT post_id, author_name, title, content, softwares, tags, like_count, comment_count, created_at 
+        SELECT post_id, author_name, title, content, softwares, tags, created_at 
         FROM post_metadata 
         WHERE author_slug = ? COLLATE NOCASE;
     """, (username,))
@@ -222,8 +200,6 @@ def explore_user(username_raw: str, is_overview: bool = False):
     print("\n" + "=" * 80)
     print(f"👤 ARTIST SUMMARY: {name_header}")
     print("=" * 80)
-    if author_id:
-        print(f"🆔 Author UUID:                   {author_id}")
     print(f"📊 Total Posts (Cover Thumbnails): {len(posts):,}")
     print(f"🖼️ Total Master Artworks (Full-Res): {len(artworks):,}")
     if top_software:
@@ -232,6 +208,7 @@ def explore_user(username_raw: str, is_overview: bool = False):
         print(f"🏷️ Top Tags:                      {', '.join(top_tags)}")
     if all_dates:
         print(f"📅 Activity Span:                 {date_range}")
+    print(f"🔗 Profile Link:                  https://cara.app/{username}")
     print("=" * 80)
 
     if is_overview:
@@ -324,7 +301,7 @@ def explore_post(post_raw: str):
 
     print("\n" + "=" * 80)
     print(f"📌 POST ID:   {post_id}")
-    print(f"👤 ARTIST:    @{author}")
+    print(f"👤 ARTIST:    @{author} (https://cara.app/{author})")
     print(f"🎨 TITLE:     {title}")
     print(f"🔗 WEB LINK:  https://cara.app/post/{post_id}")
 
@@ -339,10 +316,6 @@ def explore_post(post_raw: str):
                 print(f"💻 SOFTWARE:  {softwares}")
             if tags:
                 print(f"🏷️ TAGS:      {tags}")
-            if meta["like_count"] is not None or meta["comment_count"] is not None:
-                likes = meta["like_count"] if meta["like_count"] is not None else 0
-                comments = meta["comment_count"] if meta["comment_count"] is not None else 0
-                print(f"❤️ ENGAGEMENT: {likes:,} likes | {comments:,} comments")
             if meta["content"]:
                 print(f"\n📝 POST BODY:\n{meta['content'].strip()}")
         except Exception:
@@ -397,7 +370,7 @@ def explore_artwork(art_raw: str):
             print("=" * 80)
             print(f"🖼️ Thumbnail:  {cover_match['cdn_url']}")
             print(f"📌 Post ID:    {cover_match['post_id']}")
-            print(f"👤 Creator:    @{cover_match['author_slug']}")
+            print(f"👤 Creator:    @{cover_match['author_slug']} (https://cara.app/{cover_match['author_slug']})")
             print(f"🔗 Direct Web: https://cara.app/post/{cover_match['post_id']}")
             print("=" * 80 + "\n")
             conn.close()
@@ -420,7 +393,7 @@ def explore_artwork(art_raw: str):
     print(f"🖼️ Image Link:  {match['cdn_url']}")
     print(f"📐 Resolution:  {match['width']}x{match['height']} (Slide {match['slide_number']})")
     print(f"📌 Post ID:     {match['post_id']}")
-    print(f"👤 Creator:     @{match['author_slug']}")
+    print(f"👤 Creator:     @{match['author_slug']} (https://cara.app/{match['author_slug']})")
     print(f"🎨 Title:       {match['title'] or 'Untitled'}")
     print(f"📅 Upload Date: {match['created_at']}")
     print(f"🔗 Direct Web:  https://cara.app/post/{match['post_id']}")