I have made this small tool which coverts simple text to full database script with foreign keys, there are some limitations thought, its main purpose is to shorten time spend on remembering syntax and creating database.
Currently MSSQL , MySQL and PostgreSQL are supported.
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.
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.
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?
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.
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.
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.
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
I know its off topic, but I created a tool which converts simple text to PostgreSQL tables with foreign key relation ships, It reduces time to create database structure
I needed to learn javascript, So I created a web app https://text2db.com/ , which coverts simple text to database script. It took 3 months to make it. A long time but I learned alot.
Maybe a bit off topic, but I created a simple tool which converts text to database scripts, it reduces time to create database tables and foreign key relationships, currently, MySQL, PostgreSql and MSSQL are supported
A bit of off topic but I created a small tool which converts simple text to database script, It reduces development time to create database tables and foreign key relationships.
Hi, I'm the creator of https://text2db.com/ , I have build this tiny tool to quickly create database script without any extra knowledge of script format.
This is my first project to help new learners/developers to quickly create database script using predefined symbols, only varchar an int datatypes are supported for now.
I want other people to save time creating databases.
This website is still in progress, for now only MYSQL,PostgresSQL and MSSQL are supported.
Thanks for reading this,
Feel free to ask any questions/give opinions here
Also I am looking for tips on how to improve it further.
https://stackblitz.com/edit/web-platform-hxc9oz?file=index.h...
https://www.youtube.com/watch?v=8hYtZ38wuz4