joubee

Joined 17 years ago

Karma
156
Submissions
88
Member since
Aug 24
I like to make stuff... Good stuff

Feel free to get in touch if you want to chat I've always got time to talk :)

http://www[dot]joubee[dot]com

View on Hacker News

Recent submissions

Comment · 12 years ago
it depends on how you frame it. I just want to know the problem(s) that you find infuriating or lacking in your day to day that could be solved with a web based app.

It's different for everyone of course. I have just finished a contract and am looking for something fun to make while I take a few months off - so I'm interested in anything and everything :)

Comment · 14 years ago
Is advertising the only way to make money online?

If we can come up with a model to make money we want to relaunch the website but.... as what?

thanks for input guys

Comment · 14 years ago
codinghorror.com: Give me parameterized SQL, or give me death

http://www.codinghorror.com/blog/2005/04/give-me-parameteriz...

I have fairly strong feelings when it comes to the stored procedures versus dynamic SQL argument, but one thing is clear: you should never, ever use concatenated SQL strings in your applications. Give me parameterized SQL, or give me death. There are two good reasons you should never do this.

[I need to spend some time looking at this - tyvm benologist]

Comment · 14 years ago
As the topic of SQL injection has come up... what are your thoughts on:

MySQL vs MySQLi vs PDO MySQL

Also I grabbed this checklist online. Does anyone have anything to add?

1. Use dynamic SQL if and only if there is no other alternative

2. Escape user input always

3. Always assume magic quotes is off

4. Install security updates and patches regularly

5. Remove all the dead SQL's or other codes that you don't use

6. Never display the system defined error message for SQL errors

7. Store database credentials in a separate file

8. Use the principle of least privilege

9. Disable shells

10. Use SQL injection Hack tools to check vulnerabilities

Comment · 14 years ago
tyvm for feedback. What country are you writing from? Is court action common place when a site is compromised in your country?

I'm guessing you are from the US?

Comment · 14 years ago
I'm not the host. Just the developer. The host is shrugging it off as 'just one of those things', which it may well be and have billed for restoring dbs etc..

I think you're right - I not sure how to broach the subject with the client though. tyvm for your $0.02 :)

Comment · 14 years ago
Yes I should have included what happens when a site is compromised in the terms. As the developer, not host this just didn't occur to me. I provide a 90 warranty but generally this only requires a small amount of hours as major problems are usually picked up in testing.

tyvm - great comments

Comment · 14 years ago
Thank you so much for the reply. I should be more concise.

1-I am a developer.

2-I have tested shopify as a concept as it would be a good fit for small retailors to dip their toe in the water

3-I have done sccessful ad campaigns in the past for clients (one client has contributed over 750k in adword related sales for a campaign although they were a decent sized company with good market share already :) )

4-I am testing how adwords works with shopify. All adwords ads are approved and active

5-My 'test' shopify site has not generated a single adwords impression in 2 weeks

6-This is really odd.

7-I have tried to contact google and to read everything I can to see if this problem has come up for others and can't get any traction

8-I just need a fresh perspective as I'm at my wits end

Main question: Have I missed anything obvious that is causing me to be ignored by adwords. I get the horrible feeling that I've overlooked something obvious. I'm not trying to get you to generate me more traffic I just wanted you to have a quick look and say whether you can see a probelm

I've tried

-A/B testing of ads

-Using both redirect url and shopify domains in ads

-Targeted really non competitive key words and searched for them directly in Google to see if I can get adwords to acknoledge my ads

-My campaign has hundreds of keyword recommendations from the adwords keyword generator.

-Would it have been better to use Exact match domains and targeted a 'selling' word(s) for the sites name?

Occam's Razor suggests that this is a average site in a competitive market that is a hard(ish) sell to customers?

I really don't want to waste your time so sorry. I just need a fresh pair of eyes pls

tyvm

Comment · 14 years ago
Hi I've set up a shopify site. I decided to give shopify a go as I'm getting requests from clients for ecommerce and already do wordpress and custom carts but wanted to try and find a low cost offering for small businesses. The url for my concept test is (it's live and all setup)

http://nzsunglasses.co.nz

It redirects to

nzsunglasses.myshopify.com

It has good products but I csn't seem to get any traffic (like 5 visits in 3 weeks). Adwords hasn't delivered any impressions, posibbly because it's a very competitive category. Maybe it's the redirect but I've but I've a/b tested urls and even used.

Any suggestions much appreciated

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton