vercantez (u/vercantez)

vercantez commented on What 7,112 Hacker News users listened to on my side project skeptrune.com/posts/jukeb... · Posted by u/skeptrune

vercantez · a month ago

I love the plotly graphs, especially the sankey diagram. Seems HN may be an older crowd than I expected.

vercantez commented on Analyzing database trends through 1.8M Hacker News headlines camelai.com/blog/hn-datab... · Posted by u/vercantez

xnx · 2 months ago

Would be great to share the queries. Are these results weighted for storypoints and/or number of comments?

vercantez · 2 months ago

Updated with weighted analysis.

vercantez commented on Analyzing database trends through 1.8M Hacker News headlines camelai.com/blog/hn-datab... · Posted by u/vercantez

vercantez · 2 months ago

UPDATE: Added a weighted average analysis based on story points and comments. SQLite ranks highest in points per story and Redis ranks highest in comments per post. Also added SQLite to the growth table. I had accidentally deleted this row in the original post.

vercantez commented on Analyzing database trends through 1.8M Hacker News headlines camelai.com/blog/hn-datab... · Posted by u/vercantez

RS-232 · 2 months ago

No SQLite?

vercantez · 2 months ago

Fixed.

vercantez commented on Analyzing database trends through 1.8M Hacker News headlines camelai.com/blog/hn-datab... · Posted by u/vercantez

Tepix · 2 months ago

Sqlite seems to be growing recently which matches my perception, but it‘s not listed among the growing databases. Weird.

vercantez · 2 months ago

SQLite is now reflected in the growth table

vercantez commented on Analyzing database trends through 1.8M Hacker News headlines camelai.com/blog/hn-datab... · Posted by u/vercantez

xnx · 2 months ago

Would be great to share the queries. Are these results weighted for storypoints and/or number of comments?

vercantez · 2 months ago

Purely based on headline occurrence but weighing based on storypoints and comments is a great idea. I'll update the blog, thanks.

vercantez commented on Analyzing database trends through 1.8M Hacker News headlines camelai.com/blog/hn-datab... · Posted by u/vercantez

sega_sai · 2 months ago

I am getting an infinite loop of 'Verify you are human'....

vercantez · 2 months ago

We use cloudflare turnstile. Sometimes it blocks some VPNs. Very rarely it blocks some browsers.

vercantez commented on Analyzing database trends through 1.8M Hacker News headlines camelai.com/blog/hn-datab... · Posted by u/vercantez

RS-232 · 2 months ago

No SQLite?

vercantez · 2 months ago

Mistake in the analysis. Fixing now.

vercantez commented on Analyzing database trends through 1.8M Hacker News headlines camelai.com/blog/hn-datab... · Posted by u/vercantez

Tepix · 2 months ago

Sqlite seems to be growing recently which matches my perception, but it‘s not listed among the growing databases. Weird.

vercantez · 2 months ago

Yeah I found a mistake in the analysis. I'm updating the post to reflect SQLite's popularity.