Posts Tagged ‘Operation New Desk’

Mid-Month Report in which I talk about JSON

Wednesday, January 20th, 2016

So far, my 2016 has been a success factory!

1. Operation New (to me) Desk remains on target, if not slightly ahead of schedule.
2. My keyboard tray arrived and I assembled and attached it.
3. My file cabinet/printer stand arrived, and I assembled it, put it next to the desk, put the printer on it, and then put stuff in the drawers.
4. I researched, decided, ordered and obtained a new chair. It arrived and I assembled it and I’m now sitting on it.
5. My Demon Warlord is at the proofreader.
6. I got all the files for the stand alone novella release of An Unsuitable Duchess to the person I decided to use for all my formatting going forward.
7. I asked my graphics guy to do color versions of some custom work he did for me because I’ve stopped kidding myself that I want to deal with it myself. Finals arrived today. They’re awesome.
8. I found someone to do the cover for An Unsuitable Duchess and that’s done. I’m just waiting for the final files.
9. I hire someone to do a software update for me because that’s another thing I don’t have time for.
10. Print cover for My Demon Warlord is done and awaiting final page count.

And, here’s a coincidence that I thought was pretty funny, which in a way is No. 11 only it’s not done yet. I was emailing with my formatter who mentioned that he was using JSON files for a database source and I sent him this screenshot:

screenshot of a JSON file. Code.

JSON

Because I was, at at very moment, working out the schema for my planned DB to manage my ebook info and links because I didn’t put it all in something SQL Server-ish because — I do that all day, and I didn’t want to come home and do more even though I could have bothered to learn MySQL and used that but to be honest, a NoSQL solution was way more interesting to me and I even think it’s more appropriate, because NoSQL is kind of designed for systems that are a bit fluid the way this book shit is, and now I don’t have deal with NULLs and spend more time than I want to properly architect the relational version because, quite literally, I would be sitting there going, but how would I scale this out?? if I took shortcuts that denormalized the tables. That would drive me nuts. And so.

I picked one book as my sample schema document and started setting out the data and mapping the arrays and since I have mongoDB installed on the macs I guess I’ll just put it all in MongoDB and now I’ll get my money’s worth from the time I decided to buy my own Mongo GUI tools from when I was playing around with MongoDB at the previous day job and getting SQL Server to produce JSON files for me. Supposedly SQL Server 2016 CTP 3.2.1 (which I have at the current day job)  can supposedly do this without all the shennanigans I went through in SQL 2012. So, fun, eh?

 

 

Share

Operation New Desk: Sub-Optimal Areas of Organization

Sunday, January 10th, 2016

To Avoid Hell, Organization Requires Commitment

So, some time ago, the day job negotiated renovated office space… and a lot of office equipment was offered up to employees. I snagged an adjustable desk because I want to set up a treadmill desk. I measured etc and confirmed the desk would fit in my room. I found a college student with a truck and arranged to get the desk to my house. The desk isn’t huge but it’s not light. But also, I was in the middle of trying to finish My Demon Warlord and Seduction in Winter and so I ended up having the guy park the desk in the living room until I had time to clear out drawers etc…

And there the desk stayed. For a really really long time. Because desk drawers. Because all the stuff I had on the desk… And the closet and and…. And every spare minute needed to go into writing.  Organization requires commitment of heart and time. If you stop halfway into an organization project you might as well go live in hell.

I was starting to hate the desk, taking up space in the living room on its end… A too-inviting target for small dogs.

And I was dreading the work…

But then I finished My Demon Warlord and sent it to the copy editor and whoo-hoo! My son was still home for Winter break and I finally had time to spend with him. I had him set up Apple TV when he got here and then signed up for the free trial of Netflix. And he had been watching Netflix. With my break between books he and I watched the first episodes of Jessica Jones, Daredevil, and Sense8. Then we watched several episodes of Jessica Jones and then he went back to school.

Sub-Optimal Areas of Organization

And so, there I was with a long New Year weekend and a desk taking up space and so began Operation New Desk Binge Watch. I emptied desk drawers and surfaces and other places of  . . . let’s be kind and call them “sub-optimal areas of organization” and I brought out the shredder and put all this “stuff” into boxes and watched Jessica Jones while I shredded and sorted and discarded and found new homes for things. Rinse and repeat. When I ran out of Jessica Jones, I started on Daredevil.

Then I was exhausted. But yesterday, I looked at my office with my old icky desk cleaned off but still with a broken drawer and said “I’m going in!”

Only Slightly Bruised

I got the old desk out by myself because it’s not all that heavy, just 20 years old and, well, it’s had a broken drawer for years and no holes for cables so I wasn’t even sorry to see it go out. My brother was over, and he helped me maneuver the “new” desk in. My right toenail is only slightly bruised, I swear.

Then I set up the computer and dropped the cables through the cable holes in the back and Whoo-hoo!!

Phase Two Point Five

So it turns out I need a keyboard tray for the desk, which whatever. I ordered one on Amazon last night — while I was in bed with the lights off. THIS is how technology improves our lives. Since the new desk does not have drawers, today I’m going to buy something suitable that the printer can sit on (currently it’s on the floor) with drawers so I can proceed to Phase 3.

Phase Three

Phase three is to go through all the stuff I didn’t discard and figure out where to store it. Some will go in the Phase 2.5 pedestal thingee and the rest will be relocated to …. somewhere else.

Because of the NSA case, I have a lot of documents that need to be preserved, which is an additional challenge but might as well have it all in the same box, right?

Verdict

Jessica Jones is an awesome series. I love her so hard. I didn’t love Daredevil until about 4 episodes in but then I did. I’m on Sense8 now and I’m blown away at how great this series is. Normally, when I see TV it’s something from the more traditional channels and I watch maybe 2 times a year. But these shows have women doing awesome things and people of all colors and no one is being safe about writing, especially Jessica Jones. Though, a couple of times on Daredevil I thought some of the dialogue was pretty clunky and maybe they needed to call a lawyer a couple of times to get a grounding in how the law might actually work. I’m only a few episodes into Sense8 but yay for a show that isn’t just straight white guys!

Share