top | item 30357954

(no title)

text2db | 4 years ago

I hope that you make more than your salary, how did you attract users to website? Its very hard to get users to visit your site.

I have posted my site (https://text2db.com/) on hackernews, product hunt and reddit for getting reviews but got very few views (guess the idea is bad?), please do recommend me tips on how to increase traffic for site.

Thanks.

discuss

order

pul|4 years ago

> I hope that you make more than your salary

Not yet by a large margin, but it's going up slowly :)

> how did you attract users to website?

Currently, mainly through SEO. My stats are open [1], so you can see the percentage that comes in through search engines. In my case, there's a large search volume for 'nslookup', which is currently the largest chunk of traffic. An 'exact match domain' helped for sure. But in the end, Google will be able to gauge how well you're able to solve the problem that made people search for something. So an excellent product * the search volume * backlink profile * how well Google can understand what you're solving will approximate the number of users that visit your site.

You can use tools like ahrefs [2] (which also has a free tools) to get a sense of the search volume and competition on those keywords.

Hope that helps!

[1]: https://plausible.io/nslookup.io

[2]: https://ahrefs.com/

scrapcode|4 years ago

I used to do a lot of research on SEO and the methods behind the madness of getting decent organic traffic, and it basically always boiled down to quality content built around targeted keywords, phrases, or related topics.

The way I always imagined to accomplish this was to write or hire someone to write this content and present it in a blog format. It does not seem that you do this on these properties, so briefly what kind of SEO optimization can be continually done outside of that? Are you still writing content as a guest poster and generating reputable backlinks? Engaging communities that are focused around your topic and promoting through those channels in hopes of generating backlinks? Or am I just in left field with all of this and what I thought I knew about SEO?

text2db|4 years ago

Awesome, thanks alot. :)

matt_heimer|4 years ago

Don't let one random person dissuade you but my take is that while you consider your text format simple its one more thing I'd have to learn the structure and symbols for.

An other issue you have is that if someone understands the concept of foreign keys already then they've probably already figured out basic create table statements. Lastly, learning a new tool for something that is just a blip (table creation only) doesn't seem worth it.

So your audience for something like this is people that sort of get what a database is but don't know create table statements or people that struggle with tooling enough that an easier mechanism might be useful. I'd suggest pivoting to something like a spreadsheet2db tool. Where filename == database name, sheet name == table name, column name == column name. And the spreadsheet approach lets people actually provide data also. You can also roundtrip and have db2spreadsheet. Once you start supporting rows of data instead of just table creation you open up a lot more use-cases. Plus a lot of people have basic spreadsheet skills.

Everything above is completely off the cuff and I've done zero research to valid the idea. I know there are some integrations in Excel and some tools like SQL Developer partially support this. Another options (to support data in addition to table creation) might be to look into supporting markdown or restructured tables. Might be cool to be able to prototype a database from a basic doc page, markup2db.

cmeacham98|4 years ago

I disagree partially. I like the idea of a simple way to get a barebones schema, and although I'd probably rather use a simplistic GUI than text, it's not bad.

My bigger problem is that the website feels unprofessional in a way that if I found it off a random google search I'd probably not come back:

1. Part of the website is a screenshot of text rather than actual text for seemingly no reason?

2. The examples aren't raw text and include HTML list elements which makes copy and pasting them awkward.

3. The rest of the website really needs to be run through a grammar checker and proofread.

4. The output of the tool is hard to read and poorly formatted.

text2db|4 years ago

Just WOW, amazing ideas you got there, I shall look into it , Thanks alot Dear.

mattsnuts|4 years ago

I’ll bite.

Your opening paragraph is full of bad grammar and punctuation errors, which will instantly turn many people off.

> Reduce your time to create database , write down your database name,tables and foreign key in simple text with pre defined symbols and convert it into database script. paste that script in your development environment

text2db|4 years ago

Thanks, I like that bite :) .

I have re-written and corrected the text. Please check now? .