{
  "subreddit": "r/Database",
  "page": "https://redlisten.com/r/database",
  "updated": "2026-11-12T00:55:59.634Z",
  "members": 91504,
  "activity": {
    "posts_last_24_hours": 4,
    "posts_per_hour": 0.1,
    "comments_per_hour": 0.5,
    "newest_post_utc": 1794413649.389,
    "newest_comment_utc": 1794412476.44
  },
  "top_threads_this_week": [
    {
      "title": "Designing Pokémon Database in SQL - How to Show Multiple Route Locations?",
      "score": 15,
      "comments": 13,
      "created_utc": 1794107754.52,
      "snippet": "Hello! I'm taking my first database design course in grad school and our final project is to make our own databook on any topic we want. I chose to make a database of all the Pokémon, moves,...",
      "url": "https://www.reddit.com/r/Database/comments/1xqog9h/designing_pokémon_database_in_sql_how_to_show/"
    },
    {
      "title": "[RAG / pgvector] How do you handle vector chunks when a document is soft-deleted?",
      "score": 4,
      "comments": 5,
      "created_utc": 1794311620.843,
      "snippet": "Hi everyone, I'm building an ingestion pipeline for a RAG system. My tech stack relies on PostgreSQL for relational data and pgvectore for storing text chunks and performing similarity searches....",
      "url": "https://www.reddit.com/r/Database/comments/1xskyk7/rag_pgvector_how_do_you_handle_vector_chunks_when/"
    },
    {
      "title": "Database Indexing Isn't Magic. Understand It From Scratch",
      "score": 3,
      "comments": 0,
      "created_utc": 1794295797.525,
      "snippet": "",
      "url": "https://www.reddit.com/r/Database/comments/1xsgr3o/database_indexing_isnt_magic_understand_it_from/"
    },
    {
      "title": "Is data transfer speed still a major bottleneck when migrating from on-premise to Snowflake?",
      "score": 1,
      "comments": 1,
      "created_utc": 1794217418.654,
      "snippet": "",
      "url": "https://www.reddit.com/r/Database/comments/1xrnje7/is_data_transfer_speed_still_a_major_bottleneck/"
    },
    {
      "title": "Does anyone test how easy/hard it is to leave a managed database before committing?",
      "score": 1,
      "comments": 0,
      "created_utc": 1794413649.389,
      "snippet": "I was going through a checklist for evaluating managed Postgres and one section was about getting out of the DB again. The questions are whether you can move data out with standard Postgres...",
      "url": "https://www.reddit.com/r/Database/comments/1xtluus/does_anyone_test_how_easyhard_it_is_to_leave_a/"
    },
    {
      "title": "New In-Memory Database Purpose-Built for AI Agents by Neo4J",
      "score": 1,
      "comments": 0,
      "created_utc": 1794404774.609,
      "snippet": "",
      "url": "https://www.reddit.com/r/Database/comments/1xti4wu/new_inmemory_database_purposebuilt_for_ai_agents/"
    },
    {
      "title": "Building a key-value store as an experiment in AI-assisted research and development",
      "score": 1,
      "comments": 0,
      "created_utc": 1794396709.958,
      "snippet": "I used AI to explore approaches, discuss tradeoffs, and work through implementation. It helped me finish the project much faster. But it also reinforced something for me: trusting generated code...",
      "url": "https://www.reddit.com/r/Database/comments/1xtfgg4/building_a_keyvalue_store_as_an_experiment_in/"
    },
    {
      "title": "Superstore Dataset",
      "score": 1,
      "comments": 0,
      "created_utc": 1794379384.236,
      "snippet": "",
      "url": "https://www.reddit.com/r/Database/comments/1xtatl8/superstore_dataset/"
    },
    {
      "title": "Things I learned while investigating slow MySQL queries in production",
      "score": 1,
      "comments": 0,
      "created_utc": 1794341919.875,
      "snippet": "I've been spending some time investigating slow MySQL queries in production recently. Thought I'd put together some notes on the approach I followed and a few things I found useful along the way....",
      "url": "https://www.reddit.com/r/Database/comments/1xsxhkm/things_i_learned_while_investigating_slow_mysql/"
    },
    {
      "title": "What could our tools do to make working with Oracle Database, easier?",
      "score": 1,
      "comments": 0,
      "created_utc": 1794338610.058,
      "snippet": "",
      "url": "https://www.reddit.com/r/Database/comments/1xsw283/what_could_our_tools_do_to_make_working_with/"
    }
  ],
  "newest_posts": [
    {
      "title": "Does anyone test how easy/hard it is to leave a managed database before committing?",
      "score": 1,
      "comments": 0,
      "created_utc": 1794413649.389,
      "url": "https://www.reddit.com/r/Database/comments/1xtluus/does_anyone_test_how_easyhard_it_is_to_leave_a/"
    },
    {
      "title": "New In-Memory Database Purpose-Built for AI Agents by Neo4J",
      "score": 1,
      "comments": 0,
      "created_utc": 1794404774.609,
      "url": "https://www.reddit.com/r/Database/comments/1xti4wu/new_inmemory_database_purposebuilt_for_ai_agents/"
    },
    {
      "title": "Building a key-value store as an experiment in AI-assisted research and development",
      "score": 1,
      "comments": 0,
      "created_utc": 1794396709.958,
      "url": "https://www.reddit.com/r/Database/comments/1xtfgg4/building_a_keyvalue_store_as_an_experiment_in/"
    },
    {
      "title": "Superstore Dataset",
      "score": 1,
      "comments": 0,
      "created_utc": 1794379384.236,
      "url": "https://www.reddit.com/r/Database/comments/1xtatl8/superstore_dataset/"
    },
    {
      "title": "Things I learned while investigating slow MySQL queries in production",
      "score": 1,
      "comments": 0,
      "created_utc": 1794341919.875,
      "url": "https://www.reddit.com/r/Database/comments/1xsxhkm/things_i_learned_while_investigating_slow_mysql/"
    },
    {
      "title": "What could our tools do to make working with Oracle Database, easier?",
      "score": 1,
      "comments": 0,
      "created_utc": 1794338610.058,
      "url": "https://www.reddit.com/r/Database/comments/1xsw283/what_could_our_tools_do_to_make_working_with/"
    },
    {
      "title": "[RAG / pgvector] How do you handle vector chunks when a document is soft-deleted?",
      "score": 4,
      "comments": 5,
      "created_utc": 1794311620.843,
      "url": "https://www.reddit.com/r/Database/comments/1xskyk7/rag_pgvector_how_do_you_handle_vector_chunks_when/"
    },
    {
      "title": "Database Indexing Isn't Magic. Understand It From Scratch",
      "score": 3,
      "comments": 0,
      "created_utc": 1794295797.525,
      "url": "https://www.reddit.com/r/Database/comments/1xsgr3o/database_indexing_isnt_magic_understand_it_from/"
    },
    {
      "title": "Recommendations For Data Warehouse RDBMS on Laptop?",
      "score": 0,
      "comments": 25,
      "created_utc": 1794270449.761,
      "url": "https://www.reddit.com/r/Database/comments/1xs8pdq/recommendations_for_data_warehouse_rdbms_on_laptop/"
    },
    {
      "title": "Xata is joining ClickHouse",
      "score": 0,
      "comments": 0,
      "created_utc": 1794246730.185,
      "url": "https://www.reddit.com/r/Database/comments/1xryimr/xata_is_joining_clickhouse/"
    }
  ],
  "words_this_week": [
    {
      "word": "oracle",
      "titles": 5
    },
    {
      "word": "databases",
      "titles": 5
    },
    {
      "word": "sql",
      "titles": 4
    },
    {
      "word": "agents",
      "titles": 4
    },
    {
      "word": "production",
      "titles": 4
    },
    {
      "word": "postgresql",
      "titles": 4
    },
    {
      "word": "postgres",
      "titles": 4
    },
    {
      "word": "designing",
      "titles": 3
    },
    {
      "word": "pgvector",
      "titles": 3
    },
    {
      "word": "vector",
      "titles": 3
    },
    {
      "word": "soft",
      "titles": 3
    },
    {
      "word": "deleted",
      "titles": 3
    }
  ],
  "preview": "This is a preview. Every post and comment in r/Database, live, as JSON or RSS on the same paths a Reddit client uses, plus keyword streams to Slack, Discord, webhook or email, needs a free key: https://app.redlisten.com/?signup=1&utm_source=redlisten&utm_medium=subreddit",
  "docs": "https://redlisten.com/docs",
  "attribution": "Source: Redlisten, https://redlisten.com/r/database"
}