Scrivener<\/a> to write and it is an excellent system to list characters and scenes within a manuscript. I have tried importing all the characters over from the earlier parts but that just makes the lists longer. What I need is a clever database that tells me when, where and in what context I wrote about the character or the scene. In other words i need to add all the meta-data and link all the appearances of the character in Scrivener. I also need to know how much I should cover of the earlier story in order to have the current actions make sense. Not sure any tool can help with that. Many might say it did not make sense in the first parts!<\/p>\n\n\n\nCurrently, I end up re-reading long sections of the earlier books, using Scriveners’ tool set to find the relevant section, but then comes the real problem. I end up wanting to change the original for grammar, construction or even plot to fit in with the next part’s scene. Oh if only I had written it differently, called the character something else, not killed off xx. God knows how longer series writers manage. Did J K Rowling have a database of Harry Potter characters? Now, if I had a database of all my ideas, characters etc there would be one place to go. This would avoid one section I just had to change where I used the same character name in two different manuscripts.<\/p>\n\n\n\n
So clever database designers get on it. Get me a SQL database with the right easy to use queries so that I can look it all up. My writing would increase in speed, I could effortlessly cross reference and the world would be a better place.<\/p>\n\n\n\n
Of course I could just get better organised get the sequel written without SQL at all.<\/p>","protected":false},"excerpt":{"rendered":"
Mixing my topics today SQL and sequels while probably confusing everyone in the process including me. SQL stands for Structured Query Language a method of querying databases to find results but often used to describe the database itself. It is normally pronounced sequel hence the connection.There are several databases that call themselves SQL including Microsoft’s […]<\/p>\n","protected":false},"author":1,"featured_media":632,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[35,36,37,177,221,305,320,390,472,525,548,645,696,698,747,749,764,823,824],"class_list":["post-708","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-writing-blogs","tag-an-agents-demise","tag-an-agents-prize","tag-an-agents-rise","tag-database","tag-editing","tag-grammar","tag-harry-potter","tag-j-k-rowling","tag-microsoft","tag-online-writing","tag-philip-g-henley","tag-scrivener","tag-sql","tag-sqlite","tag-the-observer-series-part-two-intervention","tag-the-observers-part-one","tag-to-the-survivors","tag-writers-resources","tag-writing"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t