Hacker News
Top stories from https://news.ycombinator.com (with 100+ score) Contribute to the development here: https://github.com/phil-r/hackernewsbot Also check https://t.me/designer_news Contacts: @philr
Show more20 577
Subscribers
+824 hours
+687 days
+27030 days
- Subscribers
- Post coverage
- ER - engagement ratio
Data loading in progress...
Subscriber growth rate
Data loading in progress...
PostgreSQL and UUID as Primary Key (Score: 151+ in 5 hours)
Link: https://readhacker.news/s/6aPh8
Comments: https://readhacker.news/c/6aPh8
Read
69+ Comments
Ente Auth: open-source Authy alternative for 2FA (Score: 152+ in 6 hours)
Link: https://readhacker.news/s/6aNWz
Comments: https://readhacker.news/c/6aNWz
π 3
Read
100+ Comments
Show HN: SQL Explorer β Open-source reporting tool that Just Works (βοΈ Score: 150+ in 3 days)
Link: https://readhacker.news/s/6aEzP
Comments: https://readhacker.news/c/6aEzP
I have been working on SQL Explorer, an open source, Django-based reporting and query tool for (gulp!) almost ten years. It's a tool that fits just right for me and many others, and I love and use almost every day. Write SQL, share results, do some analysis, get insight. No surprises.
A live demo instance is here (no login or anything required):
https://demo.sqlexplorer.io/
And here's a fairly unprofessional, but very enthusiastic, video tour:
https://sql-explorer.s3.amazonaws.com/Sql+Explorer+5.mp4
The UI is constrained enough that there's very little to learn, while there is still a surprising amount of functionality and flexibility to address a lot of use cases.
Some of the stuff I'm excited about in the latest version:
- Intuitive and obvious integration to ChatGPT / the AI API of your choice. Doesn't purport to be 'magic'. Good prompting + relevant table scheme & data automatically injected into the prompt.
- Create a new connection by uploading a CSV or SQLite DB as a new connection, and it's instantly queryable. CSVs are parsed, types inferred, and a SQLite DB gets created (persisted to s3).
- New and improved SQL editor with strong autocomplete (based on your schema), and some fancy keyboard shortcuts.
Some of the old stuff that is still great:
- Pivot tables in-browser, so you don't have to open results in Excel for basic analysis. Unique URLs make everything shareable.
- Expose queries (optionally) as JSON endpoints. Great for prototyping APIs and scripts.
- All of the stuff you'd expect in a reporting tool (email reports, logging, favorites, exporting, etc.)
Hope you enjoy!
π₯ 4π 1
Read
32+ Comments
Moving to a RTOS on the RP2040 (Score: 150+ in 16 hours)
Link: https://readhacker.news/s/6aMzP
Comments: https://readhacker.news/c/6aMzP
Read
85+ Comments
The Snapdragon X Elite's Adreno iGPU (Score: 150+ in 21 hours)
Link: https://readhacker.news/s/6aMag
Comments: https://readhacker.news/c/6aMag
π 4
Read
58+ Comments
Ask HN: Is there any software you only made for your own use but nobody else? (Score: 153+ in 19 hours)
Link: https://readhacker.news/c/6aMjX
Just wondering if any of you has created any software that is meant for your use only and will never see the light of the day for anyone else.
What does it do? How did you make it? How much time you spent making it? How often do you use it?
304+ Comments
Show HN: Iβve made a cheaper SEO research tool (Score: 151+ in 6 hours)
Link: https://readhacker.news/s/6aNiN
Comments: https://readhacker.news/c/6aNiN
In the last 13 months I've spent total $1297 for Ahrefs subscription. Sounds like a little too much so I've build my own Keywords Research tool - Telescope.
While building it my total bill was $51 for 2 months and 41k+ keywords found. Every page of keywords costs $0.03 - $0.05. 2 payment options - usage-based subscription or just top up your balance with the amount you'd like to.
Telescope includes a couple of things:
- Keywords Explorer - finding keywords based on seed phrase and filters
- Keywords Ideas - keywords on interception on provided keywords
- Ranked Keywords - keywords a domain you specified with their positions and change since last DB update
- Saved Keywords - to store found keywords and plan the SEO strategy
I've put a lot of love into it and would love to get some feedback. IMPORTANT: every new account gets some free balance to start with. Appreciate it!
π 1β€ 1
Read
77+ Comments
I was at AMD in the mid-late 2000s helping design CPU/APU/GPUs (Score: 150+ in 5 hours)
Link: https://readhacker.news/s/6aNp7
Comments: https://readhacker.news/c/6aNp7
π 2
Read
99+ Comments
Put the DVD logo in the corner (2023) (π₯ Score: 152+ in 3 hours)
Link: https://readhacker.news/s/6aNLx
Comments: https://readhacker.news/c/6aNLx
Read
25+ Comments
The Sphere (βοΈ Score: 152+ in 3 days)
Link: https://readhacker.news/s/6aEL7
Comments: https://readhacker.news/c/6aEL7
β€ 3π€― 1
Read
65+ Comments
Choose a Different Plan
Your current plan allows analytics for only 5 channels. To get more, please choose a different plan.