Live data from Hacker News

Show HN: Lychee — Self-hosted photo-management done right

lychee.electerious.com

11–20 of 75 posts

Re: Show HN: Lychee — Self-hosted photo-management done right

#11
post #6

I like it very much; both the code and interface seem clean and lightweight. You should use mysqli prepared statements though, after a quick glance over the code I can't quite shake the feeling that there might be some sql injections lurking.

All calls to the API are going through the api.php where every $_POST gets escaped. I'm not an expert when it comes to SQL injection, but I think this should prevent it. See line 61 in php/api.php. It would be great to know if this actually helps or not.

Re: Show HN: Lychee — Self-hosted photo-management done right

#12

Dude, you could've easily made money out it. I for one would've definitely bought it. Your product is superb, simple and gives us capability to add stuff on top of it like authentication

Thanks! Donations are welcome :)

No - you didn't read what (s)he wrote. You should charge. Charging people real money gets you real users who give you real feedback. It allows you to allocate more money to the development of the project.

Providing this tool for free is a cost to you.

Sure, allow a certain number of photos free of charge and charge for more.

Re: Show HN: Lychee — Self-hosted photo-management done right

#13
post #3

Nice. A few questions (I might add more, just using the demo) 1. How does it deal with mixed landscape and portrait images? 2. Is preloading the next image possible? 3. Scrollbars are appearing, I can't work out why, e.g. on http://electerious.com/lychee_demo/#3/13901681813613

1. If the image is to tall/wide it will be scaled to fit into your browser. This happens via CSS. Photos won't be compressed or scaled, Lychee keeps their original quality and dimensions. You can click the 'Full Photo' button on the top right to see the file. 2. Nope. Not at the moment. 3. Does this happen only sometimes or always? Which browser and OS are you using?

I also have the same problem (3). It happens when using chrome 32 on windows 8.0 with full screen mode enabled. The scroll bars appear when I open an image and click the right arrow on my keyboard to switch to the next. For me it doesn't happen if I don't navigate to another image or if I'm not browsing in full-screen mode (f11).

Re: Show HN: Lychee — Self-hosted photo-management done right

#14
I really like this! I've been wanting to work on a project where I can just insert a SD card into my home server, and it imports all the images into a locally hosted photo-management automatically. This looks like the perfect solution for that. Thanks for sharing!

Re: Show HN: Lychee — Self-hosted photo-management done right

#16
post #6

I like it very much; both the code and interface seem clean and lightweight. You should use mysqli prepared statements though, after a quick glance over the code I can't quite shake the feeling that there might be some sql injections lurking.

All calls to the API are going through the api.php where every $_POST gets escaped. I'm not an expert when it comes to SQL injection, but I think this should prevent it. See line 61 in php/api.php. It would be great to know if this actually helps or not.

i haven't looked at the code, but you really should switch to prepared statements. they make your code cleaner and more secure (and maybe faster, but that's pretty negligible in this case). have a look at PDO.

Re: Show HN: Lychee — Self-hosted photo-management done right

#19

Earlier quoted context omitted.

Thanks! Donations are welcome :)

No - you didn't read what (s)he wrote. You should charge. Charging people real money gets you real users who give you real feedback. It allows you to allocate more money to the development of the project. Providing this tool for free is a cost to you. Sure, allow a certain number of photos free of charge and charge for more.

I also agree. I want to pay for this, not donate. This can be very important for my personal needs and I want to rely on it. If I donate, I don't get the feeling that the project is moving forward.
Post reply on HN