Re: [Wikitech-l] Better non-MySQL db support

here would be a *choice* of indexes (e.g. if you can support this index, use it, otherwise, do this one), but that's a SMOP once we encounter that case I suppose. :) -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 0x14964AC8

Re: [Wikitech-l] Better non-MySQL db support

t; discussion and add them to the RFC page. Excellent, thank you for that link. That mirrors a lot of my thinking. I'm going to take a fresh look at my data type issues with that page as a guideline. -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 0x14964AC8 signatur

Re: [Wikitech-l] Better non-MySQL db support

anyway, as just needing an index hint for MySQL does mean the same is needed on Oracle, and vice-versa. So you'd already have a very database specific argument for each query anyway, such that you would never have to worry if other dbs had the same index. -- Greg Sabino Mullane g...@endpoi

Re: [Wikitech-l] Better non-MySQL db support

s, but as they are not referenced directly, that should not be a problem. I'm happy to dig out my notes if anyone wants some examples of the type mapping issues. I think an abstract tables.sql is a good general approach, but getting from here to there is going to require a lot of work slogg

Re: [Wikitech-l] Can we kill DBO_TRX? It seems evil!

r. In an ideal world, the MySQL code would do that too instead of relying on insert ignore. -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 0x14964AC8 pgpQYxSZRh5Qd.pgp Description: PGP signature ___ Wikitech-l mailing list

Re: [Wikitech-l] Commits IDs, change IDs, legacy change IDs, oh my!

t; un-merged commits > - Commit SHA-1s for deployment log entries and follow-ups to merged commits +1. SHA-1 should be the rule, anything else should be the exception. -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 0x14964AC8 pgp8nsfTSa2iO.pgp Description

Re: [Wikitech-l] Abstract schema work

s in PHP: > > http://www.doctrine-project.org/ Yeah, it is interesting, but severe overkill for what we are looking at here. I'm also loath to add another dependency, which I'm sure at the end of the day we are going to have to [monkey] patch anyway. -- Greg Sabino Mullane g...

Re: [Wikitech-l] Abstract schema work

trouble to customize than rolling our own. -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 0x14964AC8 pgp34vzs1lnrz.pgp Description: PGP signature ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wiki

Re: [Wikitech-l] Abstract schema work

ch database-in-question). The only question in my mind at the moment is do we also copy all the comments to each tables.sql (see maintenance/tables.sql), no comments (see oracle|postgres/tables.sql) or something in the middle (see mssql/tables.sql)? -- Greg Sabino Mullane g...@endpoint.com

Re: [Wikitech-l] Abstract schema work

elsewhere is great for the core code, but not so great for fast-n-furious early prototyping of a big feature. Perhaps we can add it to gerrit once everyone thinks we have a mostly stable prototype? Thanks for all the feedback. I will post here when I add a branch and/or create an RFC page. --

[Wikitech-l] Abstract schema work

st (wikitech) due to the higher traffic. Thanks. -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 0x14964AC8 pgpBh1CQPb4Gn.pgp Description: PGP signature ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.w

[Wikitech-l] Replying to gerrit comments

* I now show up as a reviewer, which is odd * It calls up a new page, so I cannot see the comment I am replying to Not a big deal, but I am wondering if there is a better way. -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 0x14964AC8 pgpPdmOKBSv8y.pgp Descri

Re: [Wikitech-l] Database dump of Bugzilla (John Du Hart)

re happens to be extraordinarily popular (e.g. Windows, Word). -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 0x14964AC8 pgpweTlE0WYaB.pgp Description: PGP signature ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Re: [Wikitech-l] Adding MD5 / SHA1 column to revision table

about? I'm also of the opinion that we should just store things as CHAR(32), unless someone thinks space is really at that much of a premium. The big advantage of 32 chars (i.e. 0-9a-f aka hexadecimal ) is that it's a standard way to represent things, making use of common tools (e.g.

Re: [Wikitech-l] Re quests about log system

erface is less broken than the JSON one. :) -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 0x14964AC8 pgpbXVHgDRmHG.pgp Description: PGP signature ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia

Re: [Wikitech-l] Size of DB/table of enwiki after import into MySQL

ll be happily using Windows on our desktops. If all that mattered was technical superiority, we'd be running BeOS. :) Frankly, the choice of using PHP as the language for MediaWiki has probably caused more problems over the years than the choice of database backend. :) -- Greg Sabino Mullane g.

Re: [Wikitech-l] Size of DB/table of enwiki after import into MySQL

ls are also just because someone said "any reason not to... " > and "it should provide better performance" :) Great, so we can close the thread and agree that we'll move everything over to Oracle in the near future. :) -- Greg Sabino Mullane g...@endpoint.com End Point

Re: [Wikitech-l] Size of DB/table of enwiki after import into MySQL

andle DDL, some that do not. > P.P.S. Anyone running PG in production on a big website? Yep. Course, you might also want to define "big" I'll resist the urge to say too much more on this thread right now, and go back to watching from the sidelines. -- Greg Sabino Mullane g.

Re: [Wikitech-l] DBMS where join+limit works?

=0.014..0.043 rows=12 loops=4) Index Cond: (tag_summary.ts_rc_id = recentchanges.rc_id) Total runtime: 0.559 ms -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 0x14964AC8 signature.asc Description: OpenPGP digital signature ___ Wik

Re: [Wikitech-l] IBM DB2 patch for MediaWiki

). It might be helpful if you took the relevant surrounding code (e.g. where $set is defined) and rewrote it in the newly proposed system so we can see exactly what you are talking about. -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 0x14964AC8 signature.asc Descriptio