Show HN: Manage your gif collection, search and drag/drop from a desktop app
airgif.com
airgif.com
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'waiting for initial communication packet', system error: 95 in /home/zane/public_html/airgif/api/engine/mysql.php on line 12
{"error":"Failed to connect to the database: Lost connection to MySQL server at 'waiting for initial communication packet', system error: 95"}
For those of you starting new PHP projects, and for the sake of this one: the mysql_* set of functions in PHP have been discouraged for many years and are deprecated[1] as of PHP 5.5.Hopefully it isn't too late to migrate to mysqli_*[2] functions or, what many developers prefer, PDO[3]. Should you choose to go the PDO route, there are some good resources out there[4] to get started.
[1] - https://php.net/manual/en/migration55.deprecated.php
[2] - https://php.net/manual/en/book.mysqli.php
[3] - https://php.net/manual/en/book.pdo.php
[4] - http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers
If anything, it's a testament to PHP that you've managed to get a web-app up and running when you have so little experience with it.
I'm reusing PHP code from 5+ years ago. So, yep.
- I don't have a GIF folder, so it would be nice if there was a "create" folder button, or if you just created me one
- Can you offer a standalone build outside of the mac app store?
The gamification that you've included is kind of neat as well.
I have a habit of describing by filename every single image/gif/video I download which helps beyond measure when performing a search, and have over 8,000 files named in this way. I can find what I'm looking for in a few seconds. The benefit is it only takes a few moments to name initially but saves an enormous amount of time in the long run. Rewarding users to tag descriptively is a nice idea.
And FOSS.
The homepage does a poor job of convincing me to install the application : an image (carousels don't count) and two lines of text for a visual application.
And I like your iAP monetization. Just bought 200 gif downloads for $1.99, well worth it :)