News for hackers. Stuff that matters.

chrisBHappy

Show HN: Home Cam – turn an old iPhone into an offline hidden security camera

https://www.hiddencameraapp.com/

I built Home Cam because I needed a security camera I could trust. Every app I tried either streamed to someone’s server or buried analytics in the code.What it does: • Turns any iPhone (iOS 15+) into a motion-activated camera • Records locally up to 4K 60 fps, stores clips in an AES-256 vault • Works fully offline by default so nothing leaves the device unless you enable iCloud Photos •...

( Read More... | no comments | 3 points | on HN )
Re:List of free SQL games to learn databases by playing on Thursday May 29, 2025 @10:24AM (#44126445)
Yes, I love the idea of gamified learning. I've been working in my free time on gamified learning of git. Will call it something like "Git Commit Crimes". After receiving such a positive feedback for SQL Noir I'll definitely continue to make such games. I might also think about making one for Python since that was requested a couple of times.
Re:List of free SQL games to learn databases by playing on Thursday May 29, 2025 @09:51AM (#44126140)
I see.

Show HN: SQL Noir – A detective game where you learn SQL by solving crimes

https://github.com/hristo2612/SQLNoir

I posted about SQL Noir a while ago — it’s an open-source game that teaches SQL through narrative-driven investigations. You act as a detective solving crimes by writing real SQL queries against actual databases.Since then, I’ve added 2 new cases (now 6 in total), improved the UX, and fixed a bunch of early issues thanks to community feedback.It’s still 100% free and open source. Would love...

( Read More... | no comments | 2 points | on HN )
Re:Ask HN: How does one get invited to Lobste.rs? on Sunday April 06, 2025 @03:40PM (#43604283)
Thank you for the heads up.
Re:Ask HN: How does one get invited to Lobste.rs? on Sunday April 06, 2025 @10:30AM (#43601633)
No, I haven’t, frankly, I didn’t even know this existed. Thanks for the tip!

Show HN: I built an app to teach my toddler 30 languages in just 10 min/day

https://www.learncolors.app/en

I wanted my toddler to benefit from early exposure to multiple languages but struggled to find a simple, engaging tool. So, I created 'Learn Colors - In 30 Languages,' a minimalist app designed specifically for toddlers.The app helps children learn basic colors through interactive play, high-quality audio pronunciations, and a clean, minimalist design. Each language features carefully generated...

( Read More... | 1 comment | on HN )
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Friday February 14, 2025 @09:29AM (#43048661)
Just implemented it. Looks really nice on Desktop. Nice and compact.
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Friday February 14, 2025 @09:27AM (#43048647)
Yes! I just implemented a "Side By Side" view that will enable you to view 2 separate tabs side by side. Only on Desktop.
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Friday February 14, 2025 @09:26AM (#43048624)
Oh wow. That's strange. What browser are you using?
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Friday February 14, 2025 @09:26AM (#43048612)
Yep. This was a bug. I just fixed it.
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Friday February 14, 2025 @09:25AM (#43048604)
Indeed. I think I just fixed this bug.
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Friday February 14, 2025 @09:22AM (#43048551)
Good notes indeed. I have just implemented a side by side view so that you can view 2 tabs at once. I hope this helps. Also as other users suggested you can use the notes for saving queries but you can also comment them out in the editor.
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Friday February 14, 2025 @09:17AM (#43048509)
Thank you for the suggestions. I have just implemented the following: - Side by Side view to open up two different tabs at the same time - Copy button to copy table names
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Friday February 14, 2025 @08:09AM (#43047939)
Thanks for pointing that out. I just fixed the single line comments. It should work as expected now.
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Friday February 14, 2025 @07:26AM (#43047683)
Yep, comments are broken. Currently working on a fix.
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Friday February 14, 2025 @07:25AM (#43047680)
Haha. You found a cheat code I guess. I would have to think of hiding the answers from plain sight for the next cases or adding some more rows that include these specific strings.
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Friday February 14, 2025 @07:21AM (#43047653)
Glad you asked. I don’t want to put a price tag on it because I believe everyone should have access to learning for free. The right to learn shouldn’t be behind a paywall. That said, I’ve added a ‘Buy Me a Coffee’ link for anyone who wants to support the project. No pressure, just an option!
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Friday February 14, 2025 @07:15AM (#43047603)
Thank you for pointing that out. During the creation of the cases I did not take much consideration on naming the tables. I will either make all of them plural or singular.
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Thursday February 13, 2025 @06:28PM (#43042803)
Thank you for pointing that out. Will look into it.
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Thursday February 13, 2025 @06:13PM (#43042687)
Thank you very much. That's actually a great suggestion. I completely forgot about that. As for the single line comments, indeed this is a bug, I'll try to fix it.
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Thursday February 13, 2025 @06:11PM (#43042669)
You can try commenting out the first query with -- and running it like that. I have not implemented yet the ability to run multiple queries.
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Thursday February 13, 2025 @05:53PM (#43042506)
That's a good suggestion. I'm not sure if screen real estate won't be a problem though.
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Thursday February 13, 2025 @05:51PM (#43042485)
You should be able to add -- and comment out lines of queries. If not, this is a bug that I will investigate. Also you can use the Notes tab to store any past queries and findings.
Re:Show HN: SQL Noir – Learn SQL by solving crimes on Thursday February 13, 2025 @05:48PM (#43042462)
An honorable mention. This was in fact my inspiration for creating SQL Noir.