How to go about creating an online language dictionary?

[rockiam]

I suppose I have to start with a DB, If so which one (Remember audio inputs), that would meet the requirements below?

Medium term requirements: The website would look like wiktionary.org. You can move to the next word alphabetically (Choice: alphabetical with respect to A or B). You can search for a word of (A) – (1) by typing it in A (2) by its phonetic equivalent in English or (3) One can search all instances of an English word in the dictionary.
There will be Photos/ videos to illustrate a word. There will be a sample pronunciation (that speaker icon). Experts to put their approval (or reject) for certain new words.

Long term requirements: Thinking of creating apps later.

 

[JiminSA]

Hello rockiam and welcome to TSG
You would need to write your website in a server-side language (I recommend PHP) with an SQL database serviced by using MySqli or PDO protocol and created using phpMyAdmin
I have included some links above which I hope will help

 

[rockiam]

Jim,
Thanks v much. I have got a life line in your reply. I am intending to start populating the data, my optimistic estimate is that it would take 1 year. So, I would just download the free mysql and start populating it. During the 1 year, I can learn PHP or hire a freelancer to put the pieces together, I suppose.
Am I missing something here?

 

[JiminSA]

rockiam, I would recommend that you download xampp which is a server-side package for your computer. It will allow you to develop your database (it has phpMyAdmin) on your computer's hard drive, negating the need (and unnecessary expense) of website hosting during the year of preparation.
In addition, I recommend you use a small Content Management System, to help you maintain your database.

 

[colinsp]

I prefer DesktopServer from here as it does everything for you including setting up your hosts file so that you can access your development site via url like http://mysite.dev. It will also do an install of Wordpress for you too. Xampp and Wampserver require you to know far more about the working of a webserver whereas Desktopserver does it all for you.

 

[JiminSA]

I prefer DesktopServer

Thanks Colin - looks like a nice tool. Does it cater for databases? If so, does it maybe have some associated CMS to make maintenance easier?

 

[rockiam]

As I am not a Techie, I am leaning towards DeskTop server. After 'wikipedia'ing I think CMS will be useful.
Oh, I forgot to say ....
The person who will be populating the database is in India, I would like to monitor the progress, get some peer review etc.,
Jim, Would your answer be different if I need some connection via net at the design stage.
Thanks so much guys.

 

[JiminSA]

Jim, Would your answer be different if I need some connection via net at the design stage.

Yes indeed! You'll need an accessible view (via CMS, for convenience, or you could just go straight to the database via the hosts CPanel) on a hosted website.
There is no need in that case to get involved with xampp or Desktopserver.

 

[colinsp]

Thanks Colin - looks like a nice tool. Does it cater for databases? If so, does it maybe have some associated CMS to make maintenance easier?

Jim,

Yes, complete Apache, PHP and mySQL. So any CMS can be installed but it specialises in Wordpress as that is installed in DesktopServer and it will install it in your development site if required.