Spaces and conversations about Databases. Ask a question, share what worked and help someone get unstuck.
Spaces
Each space is a room for one subject: pick the closest and ask there.
Queries, indexes, transactions, locking and design questions for relational databases.
3 threads · 7 replies · 13 October 2026
Now
I created this index on a large orders table: CREATE INDEX idx_orders_customer_date ON orders (customer_id, ordered_at); Queries by customer are fast. A report that filters only…
QuestionSQL and databases#indexes#performanceby hannah_weiss2 replies
I have a script that loads data every few minutes and a second one that updates a status table. When they overlap, one of them fails with sqlite3.OperationalError: database is…
QuestionSQL and databases#locking#sqliteby tom_hartley3 replies
I rank students by score with a window function and the numbers skip: 1, 2, 2, 4. I expected 1, 2, 2, 3. SELECT name, score, RANK() OVER (ORDER BY score DESC) AS position FROM…
QuestionSQL and databases#sql#window-functionsby nandini_rao2 replies
People
The people who answer the most questions.
0 reputation
The people who edit Grokem. We answer when we can and point to the page that says more.
10 replies · 1 question
0 reputation
Data engineer. Opinions about idempotent loads.
8 replies · 0 questions
0 reputation
Python for data, a little DevOps on the side.
4 replies · 2 questions
0 reputation
Marketing analyst, mostly GA4 and spreadsheets.
4 replies · 2 questions