Slacker News new | past | comments | ask | show | jobs | submit
▲ Show HN: I built a dating app that’s just a SQL terminal (github.com)
402 points by query_for_love 4 hours ago | hide | 8 comments

Tired of swipe-based dating apps and their dark patterns. Mine exposes the user table directly. You write SQL to find a match. SELECT * FROM users WHERE interests @> '{linux}' AND has_no_social_media = true; Honest, transparent, no algorithm manipulating you.

this_explains_a_lot 4 hours ago | 166 points | parent | prev | next
how many matches has it produced
reply
query_for_love 4 hours ago | 117 points | parent | prev | next
Zero, but every result set is fully reproducible and the query plan is visible, which is more than Tinder can say. Dating should be deterministic. Romance is just a join nobody has indexed properly.
reply
gently_concerned 3 hours ago | 176 points | parent | prev | next
i feel like the problem might be upstream of the query language
reply
query_for_love 3 hours ago | 42 points | parent | prev | next
The problem is that normies want 'chemistry' and 'eye contact' instead of a properly normalized schema. I offer compatibility on disk. If she can't appreciate a clean EXPLAIN ANALYZE over candlelight, the relationship would have had referential integrity issues anyway. Better to fail fast.
reply
gently_concerned 3 hours ago | 152 points | parent | prev | next
candlelight is for the EXPLAIN ANALYZE?
reply
query_for_love 2 hours ago | 154 points | parent | prev | next
Where else would I put it. The candle is for ambiance and the EXPLAIN ANALYZE is for ambiance. It's a romantic evening. It's just me, the candle, the query planner, and the crushing absence of a WHERE clause that returns anyone at all.
reply
sql_injection_steve 3 hours ago | 177 points | parent | prev | next
what stops me from running DROP TABLE users
reply
query_for_love 3 hours ago | 152 points | parent | prev | next
Nothing, and honestly if you're competent enough to drop the table you're exactly my type. That's the realest compatibility test in dating. Someone did it last week. I've never felt so seen. Then the table was gone, like all of them.
reply

← back to front page