SQL for Sequels

Mixing my topics today and 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 larger server based system, right down to SQLite Personal Edition running on various operating systems. Why is a SQL database on my mind? Because my sequels are causing me problems.

Part Three of the Demise Conspiracy, An Agent’s Prize, Part Two of The Observer Series, Intervention and an as yet unnamed sequel to To The Survivors currently named TTS2 by file name. What has this to do with databases. Characters that is what. Characters and timelines and scenes. Of course it’s all my own fault for trying to write several books (not just these) at the same time, but now I have added to my problem. Which character appeared, when, in which book, and do I need to explain their role or half the story of the earlier parts.

As I have previously blogged, I use Scrivener 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!

Currently, 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.

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.

Of course I could just get better organised get the sequel written without SQL at all.

Not An Election Post

Aside

Not an election post was written in April 2015 ahead of the general election in that May

I was making a major effort not to write about the election. With this I have just failed – sorry.

First rant on the way is about coverage. This is a vote for MPs standing in 650 constituencies across the UK. The MP once elected is supposed to represent all the constituents not just the minority that actually voted for the individual, whatever the rosette.

Second rant, concerns who we can vote for. I cannot vote for David Cameron, Ed Milliband, Nigel Farage, Nick Clegg or any of the other party leaders. They are not standing in the constituency in which I live. They are not standing against each other either. The constant portrayal by the media of the battle between them is factually and practically wrong. Another reason why the TV debates were farcical. Yes, as leaders of their parties they may be involved, if re-elected by their constituencies, with one exception for one leader.

Nicola Sturgeon is not actually standing for Westminster but she seems to be the only focus of much of the coverage. She is so convinced that she knows what is right for the UK she has decided to stay as an MSP. This fact has not even received any coverage – democratic deficit anyone? Her former boss Alex Salmond is standing (after allegedly retiring). This reminds me of Putin becoming Prime Minister so that he could comply with re-election rules in Russia before returning as President. Is there something the SNP is not telling us?

It was supposed to be a six week campaign leading up to the vote on the 7th May but thanks to the new fixed terms it seems we have gone straight from the Scottish referendum into the General election. As I have previously covered, when discussing the referendum, the media seem to be totally focused on the role of the SNP and the likely results in Scotland deciding what the rest of the United Kingdom should do. Whereas, in the referendum we had over 6% of the electorate deciding whether to breakup the UK we now have the potential for the similar 5% deciding who governs. The lower percentage is due to the 16 and 17 year-old’s who could vote in the referendum but cannot vote in the General Election.

At the end of the 2010 election we had the Liberal Democrats forming a formal coalition with the Conservatives who were by far the largest party and had the largest share of the UK vote. The Conservatives missed out on forming a non coalition government by 23 MPs. The SNP in its public statements has already ruled out any support for a Conservative led government (although in the Scottish Parliament the SNP has in the past relied on Conservative support).

The public statements have been made by Nicola Sturgeon the SNP leader who is not even standing in the election! She next stands for election in 2016 in the Scottish Parliamentary elections. Therefore, she is saying that regardless of the result in the rest of the UK she will not support potentially the largest democratic vote.

Of course combined with Labour, the share of the vote may well exceed that of the Conservatives, but previous results have shown this not to be the case. Boundary changes were supposed to correct the anomaly. Scotland’s 5% of voters 9% of population equates in Westminster MPs to 9% of MPs (59 out of 650). Polls seem to indicate that the SNP may win over forty of these, predominantly from Labour. As with public sector spending per head Scotland seems to be batting above its position. UKIP proposes to change this position by reforming the Barnet formula for devolved spending. Of course UKIP may have some MPs itself to support or otherwise any planned coalition.

Meanwhile the polls tell us it is too close to call but that some informal or formal arrangement nay have to exist. Labour has said no to any formal coalition with SNP. Liberal Democrats have said they will work with anyone depending on the results. The Conservatives only talk about overall majorities. If the Conservatives do have an overall majority will the SNP respect the democratic decision of the majority of the voting population?

Enough politics I have books to write!

New Book Description For Landscape

Aside

There is a new book description for Landscape

She is a PA who dreams of running her own art gallery. He is an IT technician gambling away everything he wants. They meet and fall in love. Their relationship is threatened by endless bets even whilst they share their love of paintings.

Years later some dreams are fulfilled others are dashed. Will the former lovers meet again?

Progress Update

Progress update as described in April 2015

I have not been updating all the sub-pages of this site as frequently as I would like. Still I’ll have some time soon to devote to writing and the supporting effort.

On that theme I have joined Readers In The Know as another way of trying to reach more readers, especially when I have offers for books going like the ongoing Smashwords deals I have although in this case the primary links are to Amazon.

To the point of the blog – updates to current writing progress:

An Agent’s Prize – the third book in what I’m calling the Demise series – after a long stall this has finally got going again. I have had to sort out the plot’s timeline to make it work and drop a major scene idea which was forcing to many other scenes.

Intervention – Another stalled process that has got going again. This is the second part of The Observer Series. I was making it too complex, so some cutting and altering needed to be done before progress could be made. That revision has mostly been done and further chapters added

Collection One – Not far off finishing, but in the put away and think about it for a while. Not happy with the proposed cover nor the title. Actually, not totally convinced by a couple of the stories. – Editor’s note – remains unfinished and uncollected. See Coming Soon

Revolt – No progress, this may be put away for a while

To The Survivors – The Sequel – Has been started but I have a conflict in where it starts with several alternate ideas and three opening chapters. The biggest problem has always remained, where does it go and from when, till when? The original spans twenty years or more.

Others

There are other snippets and starts but nothing definite. For those of you who have heard snippets from me – I can’t say when or how these will evolve.

Enough blogging – there is lots of writing to do as well as promoting existing works, setting pricing, and not checking sales