History of the Project - Revision history

Dmac at 19:03, 31 March 2026

2026-03-31T19:03:40Z

← Older revision		Revision as of 19:03, 31 March 2026
Line 22:		Line 22:
	The plan is to maintain the data in the database (now in MySQL) and regenerate the wiki pages as and when necessary.		The plan is to maintain the data in the database (now in MySQL) and regenerate the wiki pages as and when necessary.

	While there are still (at time of writing in early 2026) some portions of the database that do not yet appear in the wiki - such as English Stock and charter signatories - sufficient data are included to make this version publicly available. We are considering additional enhancements, ~~including~~ integration with other repositories including the ESTC, and will address any significant data quality issues as part of a future project.		While there are still (at time of writing in early 2026) some portions of the database that do not yet appear in the wiki - such as English Stock and charter signatories - sufficient data are included to make this version publicly available. We are considering additional enhancements, such as integration with other repositories including the ESTC, and will address any significant data quality issues as part of a future project.
	</div>		</div>
	[[Category:Front Matter]]		[[Category:Front Matter]]

Dmac: /* Wiki Version 2.0 */

2026-03-31T18:51:50Z

Wiki Version 2.0

← Older revision		Revision as of 18:51, 31 March 2026
Line 18:		Line 18:
	When Oxford University closed the web host that was running LBT at the end of 2024, '''The Bibliographical Society''' obtained the system files from Oxford and proceeded to analyse how the site had been built over time. Separately, a copy of MLT's original database was obtained. The results of an extensive review was to determine that the 2008 version of Michael Turner's database (in MS Access format) was still usable because of the structures built into the relational database and the normalisation employed in populating it. Additionally, the edits that had been made in the Wiki after the ULCC conversion of the database were identifiable in the history records of the wiki and could be extracted.		When Oxford University closed the web host that was running LBT at the end of 2024, '''The Bibliographical Society''' obtained the system files from Oxford and proceeded to analyse how the site had been built over time. Separately, a copy of MLT's original database was obtained. The results of an extensive review was to determine that the 2008 version of Michael Turner's database (in MS Access format) was still usable because of the structures built into the relational database and the normalisation employed in populating it. Additionally, the edits that had been made in the Wiki after the ULCC conversion of the database were identifiable in the history records of the wiki and could be extracted.
	==Wiki Version 2.0==		==Wiki Version 2.0==
	Given the choice between standing up the ULCC version of the data in the wiki or rebuilding from scratch, the Bibliographical Society decided to preserve the centrality of the database and create a transformation script that would pull the data out of the database and construct the pages of a wiki automatically. The Web Group of The Society chose to upgrade and redesign the database using current sustainable technologies. '''David Macfarlane''' led this effort and was able to build a successful replacement for the LBT wiki site by early 2026. This involved several hundred hours of time, the development of over 20,000 lines of code, and data analysis that kept the database server running at 2,000,000 queries a day for weeks on end. Details of the process is available in [[Data Conversion Notes]].		Given the choice between standing up the ULCC version of the data in the wiki or rebuilding from scratch, the Bibliographical Society decided to preserve the centrality of the database and create a transformation script that would pull the data out of the database and construct the pages of a read-only wiki automatically. The Web Group of The Society chose to upgrade and redesign the database using current sustainable technologies. '''David Macfarlane''' led this effort and was able to build a successful replacement for the LBT wiki site by early 2026. This involved several hundred hours of time, the development of over 20,000 lines of code, and data analysis that kept the database server running at 2,000,000 queries a day for weeks on end. Details of the process is available in [[Data Conversion Notes]].

	The plan is to maintain the data in the database (now in MySQL) and regenerate the wiki pages as and when necessary.		The plan is to maintain the data in the database (now in MySQL) and regenerate the wiki pages as and when necessary.

Dmac at 18:51, 31 March 2026

2026-03-31T18:51:20Z

← Older revision		Revision as of 18:51, 31 March 2026
Line 22:		Line 22:
	The plan is to maintain the data in the database (now in MySQL) and regenerate the wiki pages as and when necessary.		The plan is to maintain the data in the database (now in MySQL) and regenerate the wiki pages as and when necessary.

	While there are still (at time of writing in early 2026) some portions of the database that do not yet appear in the wiki - such as English Stock and charter signatories - sufficient data are included to make this version publicly available. ~~More~~ data ~~will be added~~ as ~~time permits~~.		While there are still (at time of writing in early 2026) some portions of the database that do not yet appear in the wiki - such as English Stock and charter signatories - sufficient data are included to make this version publicly available. We are considering additional enhancements, including integration with other repositories including the ESTC, and will address any significant data quality issues as part of a future project.


	</div>		</div>
	[[Category:Front Matter]]		[[Category:Front Matter]]

Dmac: /* Plans */

2026-03-31T18:46:36Z

Plans

← Older revision		Revision as of 18:46, 31 March 2026
Line 24:		Line 24:
	While there are still (at time of writing in early 2026) some portions of the database that do not yet appear in the wiki - such as English Stock and charter signatories - sufficient data are included to make this version publicly available. More data will be added as time permits.		While there are still (at time of writing in early 2026) some portions of the database that do not yet appear in the wiki - such as English Stock and charter signatories - sufficient data are included to make this version publicly available. More data will be added as time permits.

	~~==Plans==~~
	~~===Release 2.1===~~
	* Controlled editability (download/edit/upload csv files)
	* Additional data extracted from database

	~~===Release 2.2===~~
	* List of books printed by each printer (from ESTC)
	* Links to Wikipedia, VIAF, etc

	~~===Release 2.3===~~
	* Final analysis and extraction of more obscure data from Michael Turner’s database
	</div>		</div>
	[[Category:Front Matter]]		[[Category:Front Matter]]

Dmac: /* Plans */

2026-03-31T18:45:09Z

Plans

← Older revision		Revision as of 18:45, 31 March 2026
Line 35:		Line 35:
	===Release 2.3===		===Release 2.3===
	* Final analysis and extraction of more obscure data from Michael Turner’s database		* Final analysis and extraction of more obscure data from Michael Turner’s database


	~~If you have research to add to this database or are interested on working on the London Book Trades website, contact us at [mailto:lbt@bibsoc.org.uk "LBT at BibSoc"].~~
	</div>		</div>
	[[Category:Front Matter]]		[[Category:Front Matter]]

Dmac: /* Wiki Version 2.0 */

2026-03-30T14:10:44Z

Wiki Version 2.0

← Older revision		Revision as of 14:10, 30 March 2026
Line 18:		Line 18:
	When Oxford University closed the web host that was running LBT at the end of 2024, '''The Bibliographical Society''' obtained the system files from Oxford and proceeded to analyse how the site had been built over time. Separately, a copy of MLT's original database was obtained. The results of an extensive review was to determine that the 2008 version of Michael Turner's database (in MS Access format) was still usable because of the structures built into the relational database and the normalisation employed in populating it. Additionally, the edits that had been made in the Wiki after the ULCC conversion of the database were identifiable in the history records of the wiki and could be extracted.		When Oxford University closed the web host that was running LBT at the end of 2024, '''The Bibliographical Society''' obtained the system files from Oxford and proceeded to analyse how the site had been built over time. Separately, a copy of MLT's original database was obtained. The results of an extensive review was to determine that the 2008 version of Michael Turner's database (in MS Access format) was still usable because of the structures built into the relational database and the normalisation employed in populating it. Additionally, the edits that had been made in the Wiki after the ULCC conversion of the database were identifiable in the history records of the wiki and could be extracted.
	==Wiki Version 2.0==		==Wiki Version 2.0==
	Given the choice between standing up the ULCC version of the data in the wiki or rebuilding from scratch, the Bibliographical Society decided to preserve the centrality of the database and create a transformation script that would pull the data out of the database and construct the pages of a wiki automatically. The Web Group of The Society chose to upgrade and redesign the database using current sustainable technologies. '''David Macfarlane''' led this effort and was able to build a successful replacement for the LBT wiki site by early 2026. This involved several hundred hours of time ~~and~~ the development of over 20,000 lines of code. Details of the process is available in [[Data Conversion Notes]].		Given the choice between standing up the ULCC version of the data in the wiki or rebuilding from scratch, the Bibliographical Society decided to preserve the centrality of the database and create a transformation script that would pull the data out of the database and construct the pages of a wiki automatically. The Web Group of The Society chose to upgrade and redesign the database using current sustainable technologies. '''David Macfarlane''' led this effort and was able to build a successful replacement for the LBT wiki site by early 2026. This involved several hundred hours of time, the development of over 20,000 lines of code, and data analysis that kept the database server running at 2,000,000 queries a day for weeks on end. Details of the process is available in [[Data Conversion Notes]].

	The plan is to maintain the data in the database (now in MySQL) and regenerate the wiki pages as and when necessary.		The plan is to maintain the data in the database (now in MySQL) and regenerate the wiki pages as and when necessary.

Dmac: /* Wiki Version 2.0 */

2026-03-29T17:51:14Z

Wiki Version 2.0

← Older revision		Revision as of 17:51, 29 March 2026
Line 18:		Line 18:
	When Oxford University closed the web host that was running LBT at the end of 2024, '''The Bibliographical Society''' obtained the system files from Oxford and proceeded to analyse how the site had been built over time. Separately, a copy of MLT's original database was obtained. The results of an extensive review was to determine that the 2008 version of Michael Turner's database (in MS Access format) was still usable because of the structures built into the relational database and the normalisation employed in populating it. Additionally, the edits that had been made in the Wiki after the ULCC conversion of the database were identifiable in the history records of the wiki and could be extracted.		When Oxford University closed the web host that was running LBT at the end of 2024, '''The Bibliographical Society''' obtained the system files from Oxford and proceeded to analyse how the site had been built over time. Separately, a copy of MLT's original database was obtained. The results of an extensive review was to determine that the 2008 version of Michael Turner's database (in MS Access format) was still usable because of the structures built into the relational database and the normalisation employed in populating it. Additionally, the edits that had been made in the Wiki after the ULCC conversion of the database were identifiable in the history records of the wiki and could be extracted.
	==Wiki Version 2.0==		==Wiki Version 2.0==
	Given the choice between standing up the ULCC version of the data in the wiki or rebuilding from scratch, the Bibliographical Society decided to preserve the centrality of the database and create a transformation script that would pull the data out of the database and construct the pages of a wiki automatically. The Web Group of The Society ~~preferred~~ to ~~reimplement~~ the database using current sustainable technologies. '''David Macfarlane''' led this effort and was able to build a successful replacement for the LBT wiki site by early 2026. Details of the process is available in [[Data Conversion Notes]].		Given the choice between standing up the ULCC version of the data in the wiki or rebuilding from scratch, the Bibliographical Society decided to preserve the centrality of the database and create a transformation script that would pull the data out of the database and construct the pages of a wiki automatically. The Web Group of The Society chose to upgrade and redesign the database using current sustainable technologies. '''David Macfarlane''' led this effort and was able to build a successful replacement for the LBT wiki site by early 2026. This involved several hundred hours of time and the development of over 20,000 lines of code. Details of the process is available in [[Data Conversion Notes]].

	The ~~intent~~ is to maintain the data in the database (now in MySQL) and regenerate the wiki pages as and when necessary.		The plan is to maintain the data in the database (now in MySQL) and regenerate the wiki pages as and when necessary.

	While there are still (at time of writing in early 2026) some portions of the database that do not yet appear in the wiki - such as English Stock, charter signatories~~, and Livery Companies other than the Stationers' Company~~ - sufficient data are included to make this version publicly available.		While there are still (at time of writing in early 2026) some portions of the database that do not yet appear in the wiki - such as English Stock and charter signatories - sufficient data are included to make this version publicly available. More data will be added as time permits.

	==Plans==		==Plans==

Dmac: /* Wiki Version 2.0 */

2026-03-15T16:15:23Z

Wiki Version 2.0

← Older revision		Revision as of 16:15, 15 March 2026
Line 18:		Line 18:
	When Oxford University closed the web host that was running LBT at the end of 2024, '''The Bibliographical Society''' obtained the system files from Oxford and proceeded to analyse how the site had been built over time. Separately, a copy of MLT's original database was obtained. The results of an extensive review was to determine that the 2008 version of Michael Turner's database (in MS Access format) was still usable because of the structures built into the relational database and the normalisation employed in populating it. Additionally, the edits that had been made in the Wiki after the ULCC conversion of the database were identifiable in the history records of the wiki and could be extracted.		When Oxford University closed the web host that was running LBT at the end of 2024, '''The Bibliographical Society''' obtained the system files from Oxford and proceeded to analyse how the site had been built over time. Separately, a copy of MLT's original database was obtained. The results of an extensive review was to determine that the 2008 version of Michael Turner's database (in MS Access format) was still usable because of the structures built into the relational database and the normalisation employed in populating it. Additionally, the edits that had been made in the Wiki after the ULCC conversion of the database were identifiable in the history records of the wiki and could be extracted.
	==Wiki Version 2.0==		==Wiki Version 2.0==
	Given the choice between standing up the ULCC version of the data in the wiki or rebuilding from scratch, the Bibliographical Society decided to preserve the centrality of the database and create a transformation script that would pull the data out of the database and construct the pages of a wiki automatically. The Web Group of The Society preferred to reimplement the database using current sustainable technologies. '''David Macfarlane''' led this effort and was able to build a successful replacement for the LBT wiki site by early 2026. The intent is to maintain the data in the database (now in MySQL) and regenerate the wiki pages as and when necessary.		Given the choice between standing up the ULCC version of the data in the wiki or rebuilding from scratch, the Bibliographical Society decided to preserve the centrality of the database and create a transformation script that would pull the data out of the database and construct the pages of a wiki automatically. The Web Group of The Society preferred to reimplement the database using current sustainable technologies. '''David Macfarlane''' led this effort and was able to build a successful replacement for the LBT wiki site by early 2026. Details of the process is available in [[Data Conversion Notes]].

			The intent is to maintain the data in the database (now in MySQL) and regenerate the wiki pages as and when necessary.

	While there are still (at time of writing in early 2026) some portions of the database that do not yet appear in the wiki - such as English Stock, charter signatories, and Livery Companies other than the Stationers' Company - sufficient data are included to make this version publicly available.		While there are still (at time of writing in early 2026) some portions of the database that do not yet appear in the wiki - such as English Stock, charter signatories, and Livery Companies other than the Stationers' Company - sufficient data are included to make this version publicly available.

	==Plans==		==Plans==
	===Release 2.1===		===Release 2.1===

Dmac: /* Plans */

2026-03-08T18:37:11Z

Plans

← Older revision		Revision as of 18:37, 8 March 2026
Line 29:		Line 29:
	* List of books printed by each printer (from ESTC)		* List of books printed by each printer (from ESTC)
	* Links to Wikipedia, VIAF, etc		* Links to Wikipedia, VIAF, etc
	* Images of Printer’s device

	===Release 2.3===		===Release 2.3===

Dmac: /* Plans */

2026-03-01T19:39:25Z

Plans

← Older revision		Revision as of 19:39, 1 March 2026
Line 35:		Line 35:


	If you have research to add to this database or are interested on working on the London Book ~~Trade~~ website, contact us at [mailto:lbt@bibsoc.org.uk "LBT at BibSoc"].		If you have research to add to this database or are interested on working on the London Book Trades website, contact us at [mailto:lbt@bibsoc.org.uk "LBT at BibSoc"].
	</div>		</div>
	[[Category:Front Matter]]		[[Category:Front Matter]]