User:ErsatzCulture

From ISFDB

(Difference between revisions)
Jump to: navigation, search
m (Link to subpage that I'm about to create)
(Add some notes on the projects I'm (intermittently) working on)
Line 21: Line 21:
= My subpages on this Wiki =
= My subpages on this Wiki =
 +
 +
(Possibly incomplete)
* [[User:ErsatzCulture/DevelopmentNotes]] - how I have my local developer environment set up, notes about the code/database/etc
* [[User:ErsatzCulture/DevelopmentNotes]] - how I have my local developer environment set up, notes about the code/database/etc
Line 26: Line 28:
* [[User:ErsatzCulture/SQLQueries]] - useful (?) SQL queries
* [[User:ErsatzCulture/SQLQueries]] - useful (?) SQL queries
* [[User:ErsatzCulture/ExperimentalTestingFramework]] - work-in-progress
* [[User:ErsatzCulture/ExperimentalTestingFramework]] - work-in-progress
 +
 +
= Projects =
 +
 +
== Completable ==
 +
 +
* Filling in the first ~8 years of The Kitschies nominees & finalists.
 +
 +
== Ongoing ==
 +
 +
* Filling in and tidying up award details, especially British awards. (This is somewhat out of self interest, as the cleaner the award data is, the better [https://sf.ersatzculture.com/award-charts/ my personal projects] that make use of it will work.)
 +
* [https://sf.ersatzculture.com/gender-award-charts/ Another personal project] might cause torrents of trivial edits to author pages; these will be links to Wikipedia pages and/or Twitter accounts, so that I can pick up biographical data that isn't stored in ISFDB.
 +
* Improving coverage of British books, as Fixer isn't doing too well with Amazon UK these days. Most critically this is for books that haven't (yet) been published in the US, but more commonly it'll be missing UK publications (especially ebooks) of known titles. This involves some semi-automated tools I'm working on which work off ISBNs and ASINs, so I may well end up doing a lot of minor edits that are just adding those IDs to existing publication records, so they no longer clog up my reports - apologies in advance to any mods processing the submission queue if/when I dump a bunch of these on you.

Revision as of 15:29, 26 March 2020

Contents

Background

I grew up in the north of England, but have spent most of the past 20+ years in London. As a kid, pretty much all of my SF-reading was courtesy of my local libraries, which meant that I read an awful lot of part-two-in-a-series books, and only recently have gotten round to reading their first installments.

I dropped out of reading SF in the early/mid 1990s, due to a combination of finding other interests, and not being particularly enthralled by a lot of of the most heralded books and writers of that era. In the past 3 or 4 years, I've rediscovered written SF, and have been catching up on loads of stuff that I previously missed out on, as well as newer works.

I don't generally engage in "real world" fandom, but I have SFnal presences on Twitter, Reddit, Wikipedia and Goodreads.

Me and ISFDB

I have a number of SF-related personal projects in various stages of completion or abandonment, many of which use a local copy of the ISFDB.

Ones that actually got to a state that I felt brave enough to expose to the rest of the world can be found here.

Some bits and pieces from works-in-progress can be found in my Twitter feed.

Some of the code I use to interrogate the database can be found on GitHub. All of this has - as of time of writing - been written without looking at the proper ISFDB code, so doubtless there are lots of stupid errors and misconceptions as to how the database is designed. The code certainly isn't going to win any awards for quality, given that much of it is the result of blundering hacking around post midnight.

Most of my edits to ISFDB are minor data fixes or additions in order to support these personal projects.

My subpages on this Wiki

(Possibly incomplete)

Projects

Completable

  • Filling in the first ~8 years of The Kitschies nominees & finalists.

Ongoing

  • Filling in and tidying up award details, especially British awards. (This is somewhat out of self interest, as the cleaner the award data is, the better my personal projects that make use of it will work.)
  • Another personal project might cause torrents of trivial edits to author pages; these will be links to Wikipedia pages and/or Twitter accounts, so that I can pick up biographical data that isn't stored in ISFDB.
  • Improving coverage of British books, as Fixer isn't doing too well with Amazon UK these days. Most critically this is for books that haven't (yet) been published in the US, but more commonly it'll be missing UK publications (especially ebooks) of known titles. This involves some semi-automated tools I'm working on which work off ISBNs and ASINs, so I may well end up doing a lot of minor edits that are just adding those IDs to existing publication records, so they no longer clog up my reports - apologies in advance to any mods processing the submission queue if/when I dump a bunch of these on you.
Personal tools