Editing User:Jukeboksi/Blog/2017

== December ==
* Should really look into what [[Wikidata]] currently offers and to what extent the [[Consumerium:Metrics]] can be calculated using only data from wikidata. [https://www.cambridgesemantics.com/blog/semantic-university/learn-sparql/sparql-by-example/ This intro to SPRQL by Cambridge Semantics] is a good place to start. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 22:33, 29 December 2017 (EET)

* Upgraded the [[Mediawiki]] that powers this [[development wiki]] to latest version 1.30.0 from 1.29.1. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 16:34, 13 December 2017 (EET)
* Made, verified and distributed backups of both production machines. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 15:25, 13 December 2017 (EET) 

== October ==
* Made, verified and distributed backups of both production machines. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 18:27, 12 October 2017 (EEST)
* Upgraded Hubzilla, Friendica and GNU social to latest production minor version. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 19:03, 12 October 2017 (EEST)
* Upgraded this [[Mediawiki]] to 1.29.1. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 20:12, 12 October 2017 (EEST)

== August ==
* Made and verified backups of both production machines yesterday. Updated the [[diaspora]]* pod to 0.7.0.0. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 16:14, 21 August 2017 (EEST)
 

== June ==
* Should try to figure out what this means https://opencorporates.com/info/licence. They have a database of over a hundred million companies and we would probably try to use them as a data source if their license is good to copyleft. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 13:55, 26 June 2017 (EEST)
* [[Friendica]] upgraded to 2.5.2 'Asparagus'. Also all other social media brought to up-to-date. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 21:22, 20 June 2017 (EEST)
* Made, verified and distributed backups of both production servers. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 21:15, 20 June 2017 (EEST)
* The user database of this [[Development Wiki]] is 68k rows long and out of those maybe 150-200 are real people and the rest just automatically registered in the crapflooding incidents of the turn of the decade before introducing [[CAPTCHA]] deterrent. This really speaks against using this botnet filled user database from being the [[mw:Extension:CentralAuth]]-one[[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 17:27, 15 June 2017 (EEST)
* The Björneborg hosting guys have released their new [[w:OpenStack]] based cloud platform: https://tavu.io/ It has better services with approximately the same prices as the old VPS infra has. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 21:21, 1 June 2017 (EEST)
* Going to get on cracking on enabling [[mw:Extension:CentralAuth]] so we can move on to create an actual content wiki with [[Semantic MediaWiki]] enabled. [[User:Jubtoxi|Juboxi]] ([[User talk:Juboxi|talk]]) 19:28, 1 June 2017 (EEST)
* Reinstalling laptop Kubuntu 17.04 again. This time gave it 16GB swap to see if it will actually start and run at reasonable speed with the wikidata.org complete dump to load into BlazeGraph that wants to register 17.2GB RAM so if I try with nothing much else running it should be able to start. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 14:46, 1 June 2017 (EEST)

== May ==
* Made and verified backups of both production servers. Upgraded [[diaspora]]* to 0.6.6.0 [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 19:11, 31 May 2017 (EEST)
* Added the new competition to [[lists of price comparison services]]. Also doing a manual sweep of all links for stale or acquisitioned/mergered ones. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 13:09, 21 May 2017 (EEST)
* I will go through the most important [[Consumerium list of lists|lists]] for changes and removed. Also going to harvest the [[Wikipedia]] categories again for any additions. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 12:55, 20 May 2017 (EEST)
:: <font color="green">Removals and changes DONE!</font> [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 17:48, 22 May 2017 (EEST)
* I am going to try to make at least 5 [[SPARQL]] queries per week on the [[Wikidata]] endpoint that reveal something of interest for Consumerium services. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 12:50, 20 May 2017 (EEST)
* Installed [https://github.com/wikimedia/wikidata-query-rdf/blob/master/docs/getting-started.md wikidata-query-rdf] but that wanted to reserve 17.2GB of RAM which I don't have. Need to look into starting with smaller set of datasets than the complete Wikidata.org graph database. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 14:50, 16 May 2017 (EEST)
* Installed [https://wiki.blazegraph.com/wiki/index.php/Main_Page Blazegraph] on the storage server and on my laptop and both start up fine. Blazegraph enjoys ample memory I hear so I will probably try to load the [[Wikidata]] complete dataset (135GB !) without running out of diskspace. WMF uses Blazegraph for their query points. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 14:00, 16 May 2017 (EEST) 
[[File:Blazegraph-up-and-running-on-localhost.png|thumb|center|600px|[https://www.blazegraph.com/ Blazegraph] is what WMF uses for Wikidata services. Can handle up to 50 gigaedges per machine and is well extendable over many machines]]
* Bought a VPS with 1TB disk from the hosting guys in Lithuania to explore the different semantic data sets out there. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 00:27, 16 May 2017 (EEST)
* Migrated the Esbo machine from MySQL to MariaDB [https://mariadb.com/resources/blog/how-migrate-mysql-mariadb-linux-five-steps (mariadb.com:s five step guide)]. Stop mysqld with 'sudo mysqladmin stop' and issue the 'sudo apt install mariadb-server' and answer 'Yes' to the prompt apt gives you. 
* Need to book some tickets so will use that as an opportunity to catch up on developments in the [[Lists of price comparison services]] and update accordingly. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 16:52, 13 May 2017 (EEST)
* Upgraded this [[Development Wiki]] to 1.28.2. Lemme know if something seems broken. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 16:02, 13 May 2017 (EEST)
* Something seemed slightly wrong with the [[GNU social]] upgrade from 1.2.0-beta4 to 1.2.0-beta5. Turned out that 1.2.0-beta4 is the production version and 1.2.0-beta5 is currently the nightly builds so there was no upgrade. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 15:19, 13 May 2017 (EEST) updated [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 17:43, 13 May 2017 (EEST)
* Upgraded [[Hubzilla]] to version 2.2. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 15:15, 13 May 2017 (EEST)
* Upgraded [[Friendica]] to Friendica 'Asparagus' 3.5.1. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 15:14, 13 May 2017 (EEST)
* Made and verified backups of all databases and all relevant static files of Consumerium and Consumium. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 15:13, 13 May 2017 (EEST)

== April ==
* Made and verified backups twice in April (also of Consumium free social) [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 20:52, 12 May 2017 (EEST)

== March ==
* Consumerium.org renewed till 2020. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 12:17, 9 March 2017 (EET)

== February ==
* Paid server. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 14:24, 25 February 2017 (EET)

== Backups ==
* Made and verified backups. [[User:Juboxi|Juboxi]] ([[User talk:Juboxi|talk]]) 13:42, 23 February 2017 (EET)