calendar
May 2012 M T W T F S S « Feb 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 recent comments
Category Archives: mysql
mediawiki news, aka recent changes
The list of changes in mediawiki is presented in a SpecialPage called Recentchanges, quite extensive and usefulbut which looks awful, with all wiki codes. Modifying the special page is a temp solution (it would be overwritten with an upgrade). Hereby you can find the first of a series of two posts on how to do it. First, the SQL part. Continue reading
Posted in mediawiki, mysql
Tagged create article, edit article, recent changes, upload file, user joins, wiki news
Leave a comment
some 21 mysql best practices to follow share this on…
working with views in mysql – phpmyadmin
By default, phpmyadmin does not allow to create views. Last may 2009, version 3.1.5 was launched included a new feature: Create View. When you enter a SQL query, for example like this one or this one, you will find a … Continue reading
mailing list of mediawiki users
The behavior of Users table in mediawiki When registering in a mediawiki installation, users are not obliged to give their names or emails, they just need to write a user and password. But if they decide to give name and … Continue reading
Oracle will improve MySQL… to fight SQL Server and Microsoft. share this on…
new articles in mediawiki
In mediawiki, we can have stats about the total of articles and revisions throught the special page Special:Statistics. You can even have a look at the revision table, but there is no field about when an article was created (though you can always have a look at the history of each page), and thus no direct way to know how many of them were created each week or month. With this sql code you can get the list of new articles in mediawiki for up to 2010. Continue reading
Posted in mediawiki, mysql, statistics
Tagged diagram, monthly, new articles, page history, revision
Leave a comment