Simple SQLite translation from Command Prompt

[Atia of the julii]

Hi all,

I'm hoping to get some help/suggestions with this. I have an SQLite database that contains 3 columns.

The 1st column is '_id'
The 2nd column 'SMS'
The 3rd Column is 'English'

Basically, I want to write a simple program that will translate an SMS text message a user can enter onto a command prompt into proper English. The user will enter a message and then the database will be queried and return a translated message just by matching and replacing any parts of the message it finds. My word database is comprehensive and contains roughly 1500 words.

E.g. A user can enter... "LOL I will CU L8R M8" and the program should return "Laughing out loud I Will see you later mate"

I am new to SQLite and have only worked with server-side databases before, mySQL etc and never to do a translation program. Is this going to be difficult to make? Am I right in thinking I would have to use the split function of a string class? I'm a bit lost on where to begin so any help is greatly appreciated. I was try to do all of this as an Android app but it seemed to be too complicated for my skills so I am trying to just keep it simple and do it from a command prompt before I expand and take it further.

Thanks,

Atia

[Atia of the julii]

Any ideas anyone?

[Junky]

I have plenty of ideas. They usually involve food.

[Atia of the julii]

I have plenty of ideas. They usually involve food.

Well that gets me off to a great start... thanks

[Junky]

If you ask a more specific question you might get more specific answers.

[Atia of the julii]

Am I right in thinking I would have to use the split function of a string class? I'm a bit lost on where to begin so any help is greatly appreciated

I thought I did?

[Atia of the julii]

QUESTION...

Would it be easier for me to download the SQLite DLL and program from an environment such as Visual C++ for this task (I have only ever coded in Java)... or should I simply do everything from the command line shell?

Thanks

[Atia of the julii]

OK an update...

I am programming in eclipse with the JDBC driver... the driver is working etc as I have tested it yet I am still stuck as to what classes I will need (whether I need an adapter class etc.. will I end up having lots of classes or just a couple??)


I have been searching the net for a week for a similar design but there is just nothing out there for an SQLite/Java word for word translation program... HELP :)

[Atia of the julii]

Question: For this word for word conversion should I have the SMS column as the primary key or would Id be the primary key? Also what datatype should the SMS and English columns be? I currently have them as VARCHAR but what is the difference between this and 'TEXT'?

Thanks

[Tolls]

Hang on, are you trying to hold the same conversation in two places on this forum?
I just posted in your almost identical thread in Databases.