https://stackblitz.com/edit/web-platform-hxc9oz?file=index.h...
6 karma · joined January 4, 2022
https://stackblitz.com/edit/web-platform-hxc9oz?file=index.h...
I have re-written and corrected the text. Please check now? .
> 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.
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.
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.
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.
Youtube tutorial :https://www.youtube.com/watch?v=8hYtZ38wuz4
You can find tutorial here : https://www.youtube.com/watch?v=8hYtZ38wuz4
>How do you specify data types for columns or schema names for tables?
For now, to keep it simple, all datatypes will be created as varchar and foreign keys as int, to declare any other column as int, need to write id keyword anywhere in name when defining syntax.
> For modern Postgres versions it's also recommended to use standard compliant identity columns rather than the proprietary serial "types"I have ran it in Postgres version 14 using psql(shell) and it is working fine, but I shall look into it.
Thanks for reviewing it Thanks
A little off topic, but I have created many databases by writing and converting simple text to database scripts
Try this: https://text2db.com/
Btw idea is really cool, its like how will you speak in same tone in other languages.