Working Prototype v1.0 Req. Defn.

Database Table definition:

CREATE TABLE IF NOT EXISTS telugu2english (
id int NOT NULL AUTO_INCREMENT PRIMARY KEY ,
telugu varchar(512) NOT NULL,
english varchar(512),
english_audio_path varchar(255)
);

Update on 19th Sept.: Change telugu column collation to utf8_general_ci. The default latin1_swedish_ci collation cannot handle Telugu characters. Also cannot have telugu column as UNIQUE key as the length is too much (for utf8_general_ci collation).

We need 100 records in this table for showing the app. around and getting feedback and feel of interest in the app. from potential users.

Data can be added using phpmyadmin interface – don’t need app. to do that for first working prototype version.

In this working prototype version v1.0, App. needs to be one page only doing the following:

a) Showing Telugu (in Telugu script) and English (in Latin (English) script) – 2 column table.

b) English entry in two column table should be a hyperlink which when clicked plays the audio.

c) If audio file is not found then, if possible, we should use TTS – worst case, do nothing.

d) The page should show 10 entries and have pagination (10 pages for 100 rows).

This entry was posted in Spoken English App. Blog. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s