HNHacker News
TopNewBestAskShowJobs

pyroman

105 karma · joined May 6, 2008

Co-Founder of http://ivylees.com

Blog: http://codespatter.com

Portfolio: http://gregallard.com

Contact: greg at ivylees

submissionscomments
pyroman··on Ask HN: Rate my startup: IvyLees
We've opened up parts of the site so that you don't have to be logged in to view it. Some links will need to be added to the front page, but maybe this will satisfy your curiosity for now. http://ivylees.com/associations/IvyLees
pyroman··on Mufin: An Automated Music Recommendation Engine That Actually Works
Some of the recommendations were on target, but there were about half that were far off. I like being able to browse through the similar tracks and it's cool that it keeps the history of them so you can go back.

Do any of the music recommendation places have an api? I've been thinking about creating a site that recommends music for groups of people that might have different tastes in music. Not many of my friends like the same stuff, but I know there is some overlap there.

pyroman··on Does a failed startup count against you on your resume?
I think most people who like to come up with ideas and implement them wouldn't want to work at a large company for the reason you mention. Small companies and other start ups would probably value their ideas and initiative.
pyroman··on Ask YC: What do you actually pay for, you, yourself?
I didn't see anyone mention Pandora. I pay for that and flickr pro.
pyroman··on Poll: Which programming language do you plan on learning next?
I think it's awesome that I've only just begun to learn python and there are all these other languages out there for me to check out.

I haven't even heard of half of these, so I know what I'm doing the rest of the day.

pyroman··on Ask HN: What would you put on the wall behind your desk?
I would put a picture or paining of myself sitting at my desk. It would be like the Colbert painting.
pyroman··on TwitHire: Use Twitter to Find A Job
It would be more useful for job seekers if they were able to follow an account on twitter for their region. Employers could also see how many people they are reaching with their job posting. There might be a way to turn that into money.
pyroman··on A New, Simple Way to Salt your Hashes
Definitely better than what I was suggesting on the site.
pyroman··on Ask HN: Would free copywriting assistance appeal to you?
I think this idea is great. This site has been pushing me towards quitting my comfortable job and going for some of the crazy ideas I've had. I just might be contacting you in the future.
pyroman··on How long will it take for Google to index this?
Some blog software, like wordpress, will ping services when you post something new. http://codex.wordpress.org/Update_Services
pyroman··on MySQL v PostgreSQL: Which have you used and why?
I just ran into a case where I needed a FULL OUTER JOIN and MySQL let me down. It looks like PostgreSQL would have saved me from UNIONing two queries.
pyroman··on How To Pick A Good Domain Name
I'd say number 4 "Keyword Value - a domain with a great keyword in it can be extremely beneficial for SEO purposes" is most important since people are probably becoming more comfortable typing in a company name at google instead of their domain name. I no longer bother with the address bar.
pyroman··on Code on the Road: Laid off? The one thing you absolutely need to do on the first day
You travel a lot. Are there any cheap places left in the Caribbean? I've thought of buying a sail boat and floating around there for a few years.
pyroman··on MySQL v PostgreSQL: Which have you used and why?
That's crazy that there were changes to query results from such a minor revision. I haven't experienced anything like that, but maybe my unit testing could be better.
pyroman··on How to Break a MySQL Left Join
Yeah, I've heard a lot of great things about PostgreSQL. I'll check those out. Thanks.
pyroman··on How to Break a MySQL Left Join
Yeah, it can get crazy sometimes, but I think it's fun still. What would you suggest that is better?
pyroman··on How To Use Triggers to Track Changes in MySQL
I read his post and the one he linked to. It's an interesting argument. I've found great usefulness with views and triggers. When working with multiple developers that might mess with your models, I like to have overall control by being the database guy. That is where I am coming from.
pyroman··on How To Use Triggers to Track Changes in MySQL
Before doing it with triggers, I had a table that mirrored the main one. So whenever there was an update to any value, all of the data would be copied. If a column was changed in the main I would have to change it in the history table. Now I would change the trigger instead of that other table.

Rows are never deleted from the database, a soft delete is used.

When a user edits something the application does store that in the original table.

How would you propose doing it differently?

← PreviousPage 2 of 2