{
  "subreddit": "r/SQL",
  "page": "https://redlisten.com/r/sql",
  "updated": "2026-11-12T00:55:59.392Z",
  "members": 293643,
  "activity": {
    "posts_last_24_hours": 4,
    "posts_per_hour": 0.2,
    "comments_per_hour": 3.1,
    "newest_post_utc": 1794443934.747,
    "newest_comment_utc": 1794428498.199
  },
  "top_threads_this_week": [
    {
      "title": "I Create Things in SQL that Shouldn't be in SQL",
      "score": 247,
      "comments": 30,
      "created_utc": 1794015459.1,
      "snippet": "Hi there, I have been using SQL Server since 1998 - Version 6.0 I think it was and also a SQL Server MVP for 6 years. I have started publishing the articles I have written over these years but...",
      "url": "https://www.reddit.com/r/SQL/comments/1xpu65w/i_create_things_in_sql_that_shouldnt_be_in_sql/"
    },
    {
      "title": "What answer is expected when asked \"Do you know/do SQL?\"?",
      "score": 31,
      "comments": 35,
      "created_utc": 1794313370.54,
      "snippet": "I'm a software developer at heart and at work. Sometimes when a project ends I get asked \"Do you know SQL?\" or \"Do you do SQL?\". I'm puzzled at what exactly are they aiming at. What knowledge or...",
      "url": "https://www.reddit.com/r/SQL/comments/1xslj3h/what_answer_is_expected_when_asked_do_you_knowdo/"
    },
    {
      "title": "I’d like to share an opportunity with the community",
      "score": 22,
      "comments": 41,
      "created_utc": 1793840276.194,
      "snippet": "On Friday I will have a chance to sit and have an open discussion with Microsoft’s VP of SQL Product The ask for the session is to provide product feedback and share product pain points and...",
      "url": "https://www.reddit.com/r/SQL/comments/1xo5btz/id_like_to_share_an_opportunity_with_the_community/"
    },
    {
      "title": "How Screwed am I? 8 years of experience, 3 year gap.",
      "score": 17,
      "comments": 8,
      "created_utc": 1794293748.957,
      "snippet": "Long story short I went through a divorce, had a scary health issue and generally was just burned out. I sold everything and travelled for 3 years. Now that I am back it seems the Datbase...",
      "url": "https://www.reddit.com/r/SQL/comments/1xsg7ap/how_screwed_am_i_8_years_of_experience_3_year_gap/"
    },
    {
      "title": "Best video/diagrams/blog for learning to read the execution plans like an expert?",
      "score": 15,
      "comments": 18,
      "created_utc": 1793942566.204,
      "snippet": "Been at this 10 years, this is still a gap in my knowledge. What is the BEST video or blog post or whatever you have found that cemented query plan knowledge in you?",
      "url": "https://www.reddit.com/r/SQL/comments/1xp4r3q/best_videodiagramsblog_for_learning_to_read_the/"
    },
    {
      "title": "Why implement procedural programming inside an RDBMS (MariaDB) instead of handling all business logic in backend application code?",
      "score": 9,
      "comments": 7,
      "created_utc": 1794234182.645,
      "snippet": "",
      "url": "https://www.reddit.com/r/SQL/comments/1xrsxmy/why_implement_procedural_programming_inside_an/"
    },
    {
      "title": "Is PostgreSQL the best choice for my database?",
      "score": 8,
      "comments": 22,
      "created_utc": 1794260620.301,
      "snippet": "hi, I thought I would get some insights from professionals on this. I'm currently an intern, and I'm tasked with building a database for a church's religious education program, potentially...",
      "url": "https://www.reddit.com/r/SQL/comments/1xs4pze/is_postgresql_the_best_choice_for_my_database/"
    },
    {
      "title": "Best website to get SQL certification?",
      "score": 6,
      "comments": 12,
      "created_utc": 1794290246.998,
      "snippet": "Hi! I’m currently an undergrad college student, Finance, looking to get into a data analytics/science, relative field post-grad. I’m looking into getting certified in SQL and Python and get a...",
      "url": "https://www.reddit.com/r/SQL/comments/1xsf85k/best_website_to_get_sql_certification/"
    },
    {
      "title": "Refactor Pattern for Denormalized Table",
      "score": 6,
      "comments": 9,
      "created_utc": 1794108230.586,
      "snippet": "Hey Hive mind, been stewing on a problem for a long time and getting stuck, so I thought I would reach out and see if anybody can spark some ideas. Say you have a table with fields for X People...",
      "url": "https://www.reddit.com/r/SQL/comments/1xqolj2/refactor_pattern_for_denormalized_table/"
    },
    {
      "title": "How to connect Oracle Database 19c from host machine to VirtualBox guest machine ?",
      "score": 5,
      "comments": 6,
      "created_utc": 1793925755.043,
      "snippet": "Hi everyone, i want to access the oracle database on my guest machine (on VirtualBox) using my host machine (both machines are on windows 11) , i have already set up oracle client on my host...",
      "url": "https://www.reddit.com/r/SQL/comments/1xozaq4/how_to_connect_oracle_database_19c_from_host/"
    }
  ],
  "newest_posts": [
    {
      "title": "Tell me your stories about FillFactor.",
      "score": 1,
      "comments": 0,
      "created_utc": 1794443934.747,
      "url": "https://www.reddit.com/r/SQL/comments/1xtyoxa/tell_me_your_stories_about_fillfactor/"
    },
    {
      "title": "TDS middleware result caching - demo a 15 second query",
      "score": 1,
      "comments": 0,
      "created_utc": 1794438383.515,
      "url": "https://www.reddit.com/r/SQL/comments/1xtwlti/tds_middleware_result_caching_demo_a_15_second/"
    },
    {
      "title": "What are some interesting SQL problems or query mistakes worth discussing?",
      "score": 1,
      "comments": 0,
      "created_utc": 1794407256.398,
      "url": "https://www.reddit.com/r/SQL/comments/1xtj4el/what_are_some_interesting_sql_problems_or_query/"
    },
    {
      "title": "Database Indexing Isn't Magic. Understand It From Scratch",
      "score": 1,
      "comments": 0,
      "created_utc": 1794370340.993,
      "url": "https://www.reddit.com/r/SQL/comments/1xt84hj/database_indexing_isnt_magic_understand_it_from/"
    },
    {
      "title": "Moved from SQL Server to PostgreSQL? Did the licensing savings justify the migration?",
      "score": 1,
      "comments": 0,
      "created_utc": 1794345586.66,
      "url": "https://www.reddit.com/r/SQL/comments/1xsz1mo/moved_from_sql_server_to_postgresql_did_the/"
    },
    {
      "title": "Why do we keep writing sql backwards?",
      "score": 1,
      "comments": 0,
      "created_utc": 1794343618.132,
      "url": "https://www.reddit.com/r/SQL/comments/1xsy7fq/why_do_we_keep_writing_sql_backwards/"
    },
    {
      "title": "What answer is expected when asked \"Do you know/do SQL?\"?",
      "score": 31,
      "comments": 35,
      "created_utc": 1794313370.54,
      "url": "https://www.reddit.com/r/SQL/comments/1xslj3h/what_answer_is_expected_when_asked_do_you_knowdo/"
    },
    {
      "title": "Beginner in SQL, can’t work in person. How can I land remote projects?",
      "score": 1,
      "comments": 0,
      "created_utc": 1794313048.129,
      "url": "https://www.reddit.com/r/SQL/comments/1xslfcz/beginner_in_sql_cant_work_in_person_how_can_i/"
    },
    {
      "title": "Is this overkill for storing current universal time when INSERTing or UPDATEing a row?",
      "score": 1,
      "comments": 5,
      "created_utc": 1794312074.354,
      "url": "https://www.reddit.com/r/SQL/comments/1xsl40b/is_this_overkill_for_storing_current_universal/"
    },
    {
      "title": "How Screwed am I? 8 years of experience, 3 year gap.",
      "score": 17,
      "comments": 8,
      "created_utc": 1794293748.957,
      "url": "https://www.reddit.com/r/SQL/comments/1xsg7ap/how_screwed_am_i_8_years_of_experience_3_year_gap/"
    }
  ],
  "words_this_week": [
    {
      "word": "postgresql",
      "titles": 15
    },
    {
      "word": "database",
      "titles": 14
    },
    {
      "word": "query",
      "titles": 12
    },
    {
      "word": "built",
      "titles": 11
    },
    {
      "word": "best",
      "titles": 8
    },
    {
      "word": "mysql",
      "titles": 8
    },
    {
      "word": "postgres",
      "titles": 7
    },
    {
      "word": "queries",
      "titles": 6
    },
    {
      "word": "business",
      "titles": 5
    },
    {
      "word": "code",
      "titles": 5
    },
    {
      "word": "open",
      "titles": 5
    },
    {
      "word": "source",
      "titles": 5
    }
  ],
  "preview": "This is a preview. Every post and comment in r/SQL, 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/sql"
}