New Database Model ZXDB

[PeterJ]

Thanks [mention]Einar Saukas[/mention]. I will update the site over the weekend. More exact times to follow.

[Einar Saukas]

Another ZXDB update is available again!

This should be a new record

[Einar Saukas]

There's now a new column "book_isbn" in table "releases".

The old column "book_isbn" in table "entries" is not used anymore, and it will be removed in the next ZXDB release.

The reason for this change is that each book edition has a different ISBN. Therefore this property belongs to book edition, not book title.

A different ISBN per book edition can be seen for instance here.

[pavero]

There's now a new column "book_isbn" in table "releases".

The old column "book_isbn" in table "entries" is not used anymore, and it will be removed in the next ZXDB release.

The reason for this change is that each book edition has a different ISBN. Therefore this property belongs to book edition, not book title.

A different ISBN per book edition can be seen for instance here.

And what about "book_pages" column?

[Einar Saukas]

And what about "book_pages" column?

I didn't think anyone would ask

This change will have to wait for another ZXDB update, simply because I forgot to add this column in the last ZXDB release.

I only noticed my mistake this morning when I updated SC to display book_isbn, then realized that book_pages was still in the wrong place. Dammit!

[pavero]

BTW, why is this column varchar(50)?

[Einar Saukas]

It won't be.

Code: Select all

alter table releases add column book_pages smallint(6) after book_isbn;

[Einar Saukas]

A new ZXDB update is available!

[PeterJ]

A new ZXDB update is available!

Thanks. I will upgrade the site in the morning. It's likely to be early, before I start work. Einar tells me that this includes the fix for [mention]Bubu[/mention].

[Bubu]

Should it be repaired tomorrow?

[PeterJ]

Should it be repaired tomorrow?

Yes, will start update in about one hour.

[PeterJ]

Should it be repaired tomorrow?

All done.

[Einar Saukas]

I only noticed my mistake this morning when I updated SC to display book_isbn, then realized that book_pages was still in the wrong place. Dammit!

OK, there's now a new column "book_pages" in table "releases".

The old column "book_pages" in table "entries" is not used anymore, and it will be removed in the next ZXDB release.

[Einar Saukas]

A new ZXDB update is available!

[PeterJ]

A new ZXDB update is available!

Thanks [mention]Einar Saukas[/mention]. Will update on Thursday. Time to be confirmed.

[Einar Saukas]

I didn't know that "groups" became a reserved word in MySQL 8.0.2 (for absolutely no reason). This change broke several queries in SC when it upgraded the database.

It's too inconvenient to keep a table name that causes issues on certain databases. To avoid this problem affecting any other site or service using ZXDB in the future, I'm planning to rename table "groups" to something else (probably "tags"). As usual, it will be a gradual change: a future version of ZXDB will have both names as synonyms, afterwards sites will have time to change this table name in queries before the old name is removed. It will be a very easy change really.

Even so, I wanted to describe this idea here in advance, before I change anything, thus if anyone sees any problem with this change then please let me know!

[Einar Saukas]

A new ZXDB update is available!

Many thanks to everyone involved!!!

[PeterJ]

A new ZXDB update is available!

Many thanks to everyone involved!!!

Excellent. Will sort the update on Thursday. Details to follow.

[Einar Saukas]

I didn't know that "groups" became a reserved word in MySQL 8.0.2 (for absolutely no reason). This change broke several queries in SC when it upgraded the database.

It's too inconvenient to keep a table name that causes issues on certain databases. To avoid this problem affecting any other site or service using ZXDB in the future, I'm planning to rename table "groups" to something else (probably "tags"). As usual, it will be a gradual change: a future version of ZXDB will have both names as synonyms, afterwards sites will have time to change this table name in queries before the old name is removed. It will be a very easy change really.

In the next ZXDB update, tables "groups" and "grouptypes" will be dropped, for the reasons mentioned above. Instead of them, please use tables "tags" and "tagtypes" (that already exist in latest ZXDB version). Likewise column "members.group_id" will be removed, please use column "members.tag_id" instead.

Moreover table "interviews" will be also dropped. Instead there's now a new table called "articles" that contains different kinds of web articles about people and companies, not just interviews. For instance the page about Veronika Megler now includes also a memoir (written by herself) about her experience developing The Hobbit.

[Einar Saukas]

Another ZXDB update is available!

[PeterJ]

Another ZXDB update is available!

Thanks [mention]Einar Saukas[/mention],

This will be done on Friday. Details to follow.

[Einar Saukas]

A new ZXDB update is now available!

Many thanks to everyone involved!

[PeterJ]

A new ZXDB update is now available!

Many thanks to everyone involved!

Thanks [mention]Einar Saukas[/mention]. I will do on Friday.

[Einar Saukas]

Another ZXDB update is available!

[PeterJ]

Another ZXDB update is available!

Thank you. I will apply this later in the week.. Peter