[text2db]

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.

[pul]

> 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]

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?

[pul]

I think you have a pretty good idea on how SEO works. I try to do multiple things, and hope some of them bear fruit.

1. This very blog post is part of the SEO effort. A temporary influx in traffic, a couple of backlinks, and a larger following on Twitter (+80 followers from this post alone).

> 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.

2. I've got an ex-Microsoft employee that writes content on a freelance basis. We do around one knowledge base article or blog post per month.

3. Original content that's genuinely useful and bring something new to the table (like [1]) take a lot of time, but pay off in terms of backlinks. The image by the way is release under creative commons with attribution, so I occasionally look if websites use it and ask for a backlink.

[1] https://www.nslookup.io/learning/dns-record-types/

[text2db]

Awesome, thanks alot. :)

[matt_heimer]

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]

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]

Thanks that you like it.

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

I shall fix it.

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

I made it in list form ,so users can understand that which symbols are table/column names. I can provide copy button on samples.

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

Sorry, English is not my native, but I shall try to proofread

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

I shall add space between lines, you can also stretch the text area, based on your requirement.

[text2db]

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

[mattsnuts]

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]

Thanks, I like that bite :) .

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