We have designed a basic text editor using GTK+ in Ubuntu.
We are supposed to store text files within a database(postgreSQL) which can be retrieved, viewed on our editor, modified using the options cut, copy & paste(these options are there in our editor) and these modified files should again get stored in the database as a version of the original file.The user should also get the meaning of any word on which he/she clicks in the file in a side pane or preferably a tooltip as we will read these values from an XML file stored in the same database.All these text files are Novels basically.
We have a very limited idea with reference to databases, and we need to make three tables within this database namely Text_files, to store the text files, description, to store the description of the novel as in its name, author,etc and lastly dictionary, to provide the users with meanings of selected words in the file.Kindly, reply to us as soon as possible with a solution to store these text files,their descriptions and the dictionary in our database dbEditPro.