TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Recreating YikYak with Postgres

82 点作者 AJRF将近 5 年前

6 条评论

asdff将近 5 年前
It's so weird how yikyak blew up then rapidly failed. I used it pretty heavily in undergrad and popularity didn't seem to wane during that school year when it got big. It just died over the summer since you were geolocked to your hometown, then it inexplicably never picked up again the next school year, just dead on arrival. Had they let people still use their collegiate yikak while off campus for the summer, yik yak might have been a juggernaut by today. I still don't think the niche has been captured: an anonymous, hyperlocal twitter/reddit hodgepodge, fueled solely by original and genuine campus memes and therefore immune to corporate ad peddling like global networks. Maybe that's why it failed.
评论 #23839739 未加载
评论 #23839085 未加载
评论 #23838825 未加载
评论 #23838830 未加载
评论 #23839128 未加载
AJRF将近 5 年前
Hey - I&#x27;m the author (I self-posted this, I hope that isn&#x27;t against the posting etiquette here).<p>I wrote this post after a bit of a failed startup I tried making at the start of lockdown. It was called Ottr and it essentially aped YikYak exactly. I made a react web app, an API with web sockets (it had real time posting and comments) and even an iOS app.<p>I burnt out on it and gave up because it seems so hard to get that initial traction.<p>I&#x27;ve been trying to get the project posted publicly on GitHub for a while now but I wrote maybe 10k+ lines with literally zero tests because I was just trying to get it to market. The code isn&#x27;t bad but i&#x27;d feel bad posting it without tests so that&#x27;s what i&#x27;m working through now.
评论 #23838465 未加载
评论 #23838879 未加载
评论 #23838419 未加载
dvt将近 5 年前
Very interesting, and good intro to Postgres R-trees! I kind of miss YikYak, it was pretty fun to see all the posts around UCLA. If it focused a bit more on promoting good content (and not just mindless noise, which eventually turns into edgy racist garbage), it might still be around.<p>(As a side note, I&#x27;ve always wanted to give MongoDB geospatial[1] queries a try. Wonder how they compare to Postgres&#x27; offering.)<p>[1] <a href="https:&#x2F;&#x2F;docs.mongodb.com&#x2F;manual&#x2F;geospatial-queries&#x2F;" rel="nofollow">https:&#x2F;&#x2F;docs.mongodb.com&#x2F;manual&#x2F;geospatial-queries&#x2F;</a>
realbarack将近 5 年前
Nice post! I love hacking around with PostGIS. While I&#x27;m not normally a huge ORM advocate I do like the GeoDjango API for this sort of thing [0].<p>There hasn&#x27;t been enough experimentation with geospatial social applications. (There was a lot back in the early 2010s but it petered out.) I&#x27;m currently working on an experimental chat app that creates Slack-like channels associated with a topic and a location. I&#x27;m looking for collaborators on this project (primary need is for designers and community-builders, but also programmers) so if it appeals to you please get in touch (HN-facing email in profile).<p>[0] <a href="https:&#x2F;&#x2F;docs.djangoproject.com&#x2F;en&#x2F;3.0&#x2F;ref&#x2F;contrib&#x2F;gis&#x2F;" rel="nofollow">https:&#x2F;&#x2F;docs.djangoproject.com&#x2F;en&#x2F;3.0&#x2F;ref&#x2F;contrib&#x2F;gis&#x2F;</a>
dmlittle将近 5 年前
Nice! I hadn&#x27;t heard about R-Trees before. I guess you can potentially make do with a quadtree[1] but it seems R-Trees are better suited for geodetic data.<p>[1] <a href="https:&#x2F;&#x2F;en.wikipedia.org&#x2F;wiki&#x2F;Quadtree" rel="nofollow">https:&#x2F;&#x2F;en.wikipedia.org&#x2F;wiki&#x2F;Quadtree</a>
sennacy将近 5 年前
Interesting post! I also recreated YikYak as a side project and had to solve a lot of similar problems (It&#x27;s called Clacku on the iOS and Android app stores if anyone cares). Managed to get a decent chunk of users to actually use it.