Dear All:
What is the preferred database to be used by wikidata? I understand that MySQL is the default database for wikimedia but it is now slowly shifted to MariaDB. What about PostgreSQL?
Best regards HM
Hey,
What is the preferred database to be used by wikidata?
The software behind Wikidata is called Wikibase [0]. As you can see in the requirements section there, it needs MySql, SQLite or PostGres. I am sure master (ie the latest dev version) currently works with the former two, though perhaps not with the later.
I understand that MySQL is the default database for wikimedia but it is
now slowly shifted to MariaDB.
If supports for MariaDB gets added to core and it's as complete as the MySQL support, I'd expect Wikibase to be automatically compatible, esp considering the similarity between the two RDBMS.
[0] https://www.mediawiki.org/wiki/Extension:Wikibase
Cheers
-- Jeroen De Dauw http://www.bn2vs.com Don't panic. Don't be evil. --
On 28.01.2013 15:33, Jeroen De Dauw wrote:
If supports for MariaDB gets added to core and it's as complete as the MySQL support, I'd expect Wikibase to be automatically compatible, esp considering the similarity between the two RDBMS.
I don't think that is necessary. MariaDB is a fork of MySQL, and as far as I know pretty much 100% backwards compatible, except perhaps for low level stuff like supported storage engines, etc. So we might not even see explicit MariaDB support for a while, since it's covered by MySQL support.
-- daniel
On 28/01/2013 14:33, Jeroen De Dauw wrote:
If supports for MariaDB gets added to core and it's as complete as the MySQL support, I'd expect Wikibase to be automatically compatible, esp considering the similarity between the two RDBMS.
If by core you mean MediaWiki core, then it's hard not to be supported seeing how Wikipedia (maybe the other projects as well) already run on MariaDB.
KTC
On Mon, Jan 28, 2013 at 3:46 PM, Katie Chan ktc@ktchan.info wrote:
On 28/01/2013 14:33, Jeroen De Dauw wrote:
If supports for MariaDB gets added to core and it's as complete as the MySQL support, I'd expect Wikibase to be automatically compatible, esp considering the similarity between the two RDBMS.
If by core you mean MediaWiki core, then it's hard not to be supported seeing how Wikipedia (maybe the other projects as well) already run on MariaDB.
Yes, in fact wikidata.org may be served to you with MariaDB now. :) depends on which WMF db server is used to serve your request when you visit.
PostgreSQL is really not supported at all yet for Wikibase. MediaWiki core support for Postgres is also currently broken, while patches for sites schema updates, ORM support are pending on gerrit. This stuff is required for Wikibase to really work and then we need to make sure the extension has all the schema updates.
Katie
KTC
-- Experience is a good school but the fees are high. - Heinrich Heine
______________________________**_________________ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/**mailman/listinfo/wikidata-lhttps://lists.wikimedia.org/mailman/listinfo/wikidata-l
On Mon, Jan 28, 2013 at 10:52 PM, Katie Filbert katie.filbert@wikimedia.dewrote:
PostgreSQL is really not supported at all yet for Wikibase. MediaWiki core support for Postgres is also currently broken, while patches for sites schema updates, ORM support are pending on gerrit.
Look like using PostgreSQL is a no-go for me at the moment for my project. Both MySQL and PostgreSQL are great but the former is being changed to more proprietary and its open-source's future is uncertain. I would urge the MediaWiki development community to consider further on this.
On 28.01.2013 23:33, Hor Meng Yoong wrote:
Look like using PostgreSQL is a no-go for me at the moment for my project. Both MySQL and PostgreSQL are great but the former is being changed to more proprietary and its open-source's future is uncertain. I would urge the MediaWiki development community to consider further on this.
That's precisely why Wikimedia is moving to MariaDB, which is essentially a MySQL fork with the goal to remain open. It's kind of like the StarOffice -> OpenOffice -> LibreOffice thing (actually, involving the same companies, Sun and Oracle).
Try using MariaDB and telling MediaWiki that it's MySQL. From looking at [1], this should Just Work (tm).
-- daniel
[1] https://en.wikipedia.org/wiki/MariaDB
Hor Meng Yoong yoonghm@gmail.com schrieb:
On Mon, Jan 28, 2013 at 10:52 PM, Katie Filbert katie.filbert@wikimedia.dewrote:
PostgreSQL is really not supported at all yet for Wikibase.
MediaWiki
core support for Postgres is also currently broken, while patches for
sites
schema updates, ORM support are pending on gerrit.
Look like using PostgreSQL is a no-go for me at the moment for my project. Both MySQL and PostgreSQL are great but the former is being changed to more proprietary and its open-source's future is uncertain. I would urge the MediaWiki development community to consider further on this.
I would not be that definite. There are some companies which are using MediaWiki and they may also will use WikiBase. They also might have professional Database-Support. Looking at this it could also make sense to support MSSQL or Oracle (in this case it's pitty that Apple doesn't have an own AFAIK).
And no: I'm definitely not a business guy. :=D
Marco