Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Tell HN: My Web App has 13 Users

news.ycombinator.com

Post reply on HN
Print view View original

161–166 of 166 posts

Re: Tell HN: My Web App has 13 Users

#161

Post by lubos »

aaronblohowiak wrote: post #123
lubos wrote: post #87

Earlier quoted context omitted.

MixPanel can do this and they have a free plan. I custom-built my own cohort reports but as number of users grow in my own app, I'm planning to replace it with MixPanel. You don't really want to put stress on your own database servers which are meant for production, not for analysis.

You should not be doing analysis (OLAP) on your main transactional database (OLTP). Moving from transaction-processing system (TPS) to analysis is done through a process call ETL (Extract, Transform, Load.) You will want to transform your data into facts and dimensions -- this is going from a relational model to a multidemensional model (using a star schema.)

but that would be another system to maintain. I'm happy to outsource this to MixPanel or some other company. My needs are pretty generic. I appreciate your response though.

Re: Tell HN: My Web App has 13 Users

#162

Post by Joyfield »

xur17 wrote: post #25
Joyfield wrote: post #15

Pfff. 13 users are much more than my pet project ( http://www.DNSDigger.com ) has. It is a couple of years old but i recently started with paid accounts and API-access.

That's actually a pretty cool service! I was looking for a reverse dns lookup site like that a while back. A few thoughts: -You should make the explanation of what your site offers a little bit more clear. It took me a few minutes to figure it out. -What is the Google Analytics/Adsense lookup Database part? I can lookup sites that use a specific google analytics or adsense id?

Yes. If you put in a Google Analytics code the site will show you what other site share the OwnerID-part. Same with adsense (and soon AddThis). I am not a designer and the first thing i would do if i had some money over would be to hire a designer to make my site look more pro.

Re: Tell HN: My Web App has 13 Users

#163

Post by Joyfield »

bert2002 wrote: post #135
Joyfield wrote: post #15

Pfff. 13 users are much more than my pet project ( http://www.DNSDigger.com ) has. It is a couple of years old but i recently started with paid accounts and API-access.

WOW! Thats pretty sweet. Would be nice to see some v6 (psst. may be one more feature for the paid account ;)

Thanx! Yes IPv6 support should be implemented soon (within this year). But as i am not actually making any money at all right now (i suffering from depression & ADD) i have problem scaling the site with the much needed extra hardware and design. This is something i put together first for fun and now it has grown a bit hehe. To be able to serve the data i do i have to resolve hunders of millions of hostnames/domains and spider the net. That takes hardware, software, time and bandwidth which i only has time of hehe. Looking for sponsors when you are trying to be a commercial service is a bit hard but if anyone here has a hosting company that could give me access to dedi and/or VPS (low outgoing bw and HIGH incomming) i would love to trade "powered by COMPANY" and maybe banners.

Re: Tell HN: My Web App has 13 Users

#164

Post by tyang »

Just Make Lemonade. If you start with a low base (9 sign ups), then just focus on percentage increases in user growth rather than actual users. This can make your growth charts look great for several months.

Re: Tell HN: My Web App has 13 Users

#165

Post by aaronblohowiak »

lubos wrote: post #161
aaronblohowiak wrote: post #123

Earlier quoted context omitted.

You should not be doing analysis (OLAP) on your main transactional database (OLTP). Moving from transaction-processing system (TPS) to analysis is done through a process call ETL (Extract, Transform, Load.) You will want to transform your data into facts and dimensions -- this is going from a relational model to a multidemensional model (using a star schema.)

but that would be another system to maintain. I'm happy to outsource this to MixPanel or some other company. My needs are pretty generic. I appreciate your response though.

Yes, I 100% believe in focusing on your core competencies. If the OLAP is self-hosted or external, the key takeaway is to not do analysis against production (once your data set is larger than RAM ;) before that, who cares?)
Post reply on HN