Skip to main content

What Format to Use and Where to Store the Maps?

Having been through ZXDB (on GitHub), I am in two minds about starting with a database. Now, don't get me wrong. I will install Postgres locally on my Mac and create a database, and everything will go in there but it is worth taking one step up and writing the output data in a JSON format in a one-file-per-magazine structure.

The advantage I see in this is that once I have the file generated, I can import it into Postgres and go from there. Should someone else pick a different database - then they will have the base files to work with as well. 

Like ZXDB I have created a GitHub project for this, and, because I should never be allowed to name anything, I have chosen the name "Total Magazine Archive Project" or TMAP for short. See? I told you I shouldn't name things.

The GitHub link is here (the project is public).

So, at least one decision has been made: GitHub will be used to store the maps.

Regarding the files themselves, I'm looking at JSON. For example;

{
  "magazine": "Bar Hill News",
  "description": "November 1986 Issue 315",
  "key": "BHN198611",
  "publisher": "BH Residents Association",
  "date": "1986-11",
  "reference": "N/A",
  "box_size": {
    "x": 1,
    "y": 1
  },
  "pages": [
    {
      "page": 1,
      "key": "P01",
      "objects": [
        {
          "orderBy": 1,
          "key": "O01"
          "parent": "P01"
          "type": "article",
          "title": "The title of an article goes in here",
          "position": {
            "x_start": 0,
            "y_start": 0,
            "width": 1,
            "height": 1
          },
          "summary": "A summary/description goes in here"
        }
      ]
    }
  ]
}

This is a straightforward example - a single page with a single article - but the point should be clear.

I think the easiest way to do this is to create files to iron out the kinks and to bravely take that first step beyond planning!

Comments

Popular posts from this blog

Bar Hill News - September 2025 Issue 672

The September 2025 issue of the Bar Hill News has been released. Here is a brief summary of this month's stories; Saxon Park Skatepark, p.3: Tender document approved by Parish Council; fundraising begins for a geotechnical survey as the first step towards building the skatepark. Community Hub, p.5: Weekly Monday sessions at The Octagon with coffee stop, foodbank, carers cafĂ©, health & wellbeing, parish councillor drop-ins, and new activities like Hope Active Kurling. Letters & Notices, p.7: Thanks to volunteers for the fete, appreciation for bench cleaning, and invitations to local clubs, including Bowls, Happy Hours, and the 8 o’clock Club. Bar Hill Library, p.8: Library temporarily closed for three months for building work; services available at nearby libraries and via drop-in sessions. Church News – Rev’d Julie, p.11: Former teacher shares her journey from teaching to priesthood, and her passion for prayer and village life. District Councillor’s Report (Cllr Bunty Water...

Clares ProArtisan 2 Advanced Painting Image Processing Manual 1993

This is part of a large bundle of BBC/ Acorn Computers manuals that I purchased as a bundle a few years ago. It's slightly frustrating that there are some "blurred" edges in this scan. I have a solution for this now, but I scanned this a few months ago. This manual was produced in 1993 for the ProArtisan 2 software package. This manual is available on the Internet Archive here .

1980s BBC Micro Books

A small range of books (mostly programming) for the BBC Micro;       The books are (links to the Internet Archive); Invaluable Utilities for the BBC Micro by Jeff Aughton (Personal Computer News Library) Using Floppy Disks with the BBC Microcomputer by Keith Davis (A Cumana Publication) White Knight Mk II The Chess Master (BBC Soft) Manual by Martin Bryant Computer Programming In BASIC - Peter Bishop - Second Edition, 1983