a basic structure of apps for memorizing words on both PC and Android

The basic structure of such app is mainly comprised of two components. One of them is the GUI part and the other one is about how to transform a script file written by hands into a database file.

It’s better to master a database of words you ever encountered and keep track of them.

Maybe someday you can use the database to compile a vocabulary book.

And you can also lean multiple languages simultaneously just by gathering words in different languages together around a central word, for example in English.

<1> GUI

The main android layout basically consists of 7 pars as the left prototype screenshot.

1 ID number

2 check box to denote whether users are already over the word.

3 spelling of the word itself

4 a speaker symbol which can be pressed to pronounce the word.

5 usage example

6 meanings of the word which can be displayed in a rich HTML format.

7 buttons to navigate to the previous one and the next one.



<2> script format

What should be done first is to make conventions of the script formats, then use a program to transform the script data into database data.

The most convenient approach is to use Python because the web framework which is going to be used is written in Python.

<3> web framework and database system

Django and sqlite

Sqlite can be embedded in both Android and Django, so the db files created by Django can also be used directly by Android as it is in which way you can so exploit sqlite.


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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s