From: Fernando C. - I. <ca...@fi...> - 2007-10-02 11:59:17
|
Hello. We have patched a SMW 07 sources to work with Postgresql. This version also has patched to work in spanish. Seems to be work for us, but I think that someone else can be test it. How can we publish the patched version? (an the patch for SMW_InlineQueries...) Thanks. Fernando Carpani. Sebastian Beceiro. |
From: Markus <ma...@ai...> - 2007-10-09 07:59:40
|
On Dienstag, 2. Oktober 2007, Fernando Carpani - INCO wrote: > Hello. > We have patched a SMW 07 sources to work with Postgresql. This version > also has patched to work in spanish. > Seems to be work for us, but I think that someone else can be test it. > > How can we publish the patched version? (an the patch for > SMW_InlineQueries...) Is the patched version still doing everything that SMW0.7 did? Then we coul= d=20 publish it as SMW0.7.1 or SMW0.7postgresql. But of course it would be even= =20 better to have the upcoming stable SMW1.0 working for you as well. The major problem here is that SMW0.7 used a completely different way to=20 access the DB than SMW1.0. So a patch will not help for the new version tha= t=20 we want to publish *soon*. What would help, though, would be a short overview on the major=20 incompatibilities and problems you encountered. Could we jsut fix them in S= VN=20 without getting problems with MySQL? Also, SMW1.0 allows to exchange the=20 storage implementation completely. So one could also (if all fails) fork th= e=20 current storage implementation and make one for Postgresql that is choosabl= e=20 during install. The new SQL-statements we use are all contained in [1], so feel free to hav= e a=20 look. No other SQL occurs in SMW1.0 anywhere else. Cheers, Markus [1]=20 http://svn.wikimedia.org/svnroot/mediawiki/trunk/extensions/SemanticMediaWi= ki/includes/storage/SMW_SQLStore.php > > Thanks. > Fernando Carpani. > Sebastian Beceiro. > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user =2D-=20 Markus Kr=F6tzsch Institut AIFB, Univers=E4t Karlsruhe (TH), 76128 Karlsruhe phone +49 (0)721 608 7362 fax +49 (0)721 608 5998 ma...@ai... www http://korrekt.org |
From: ulim <uli.mueller@GMX.CH> - 2007-10-11 11:59:33
|
Are there any news on this? I could not find the patch in SVN. Fernando and Sebastian would you be willing to mail me the patch or - better - make it available to the public. Thanks, Uli=20 Markus Kr=C3=B6tzsch wrote: >=20 > On Dienstag, 2. Oktober 2007, Fernando Carpani - INCO wrote: >> Hello. >> We have patched a SMW 07 sources to work with Postgresql. This version >> also has patched to work in spanish. >> Seems to be work for us, but I think that someone else can be test it. >> >> How can we publish the patched version? (an the patch for >> SMW_InlineQueries...) >=20 > Is the patched version still doing everything that SMW0.7 did? Then we > could=20 > publish it as SMW0.7.1 or SMW0.7postgresql. But of course it would be eve= n=20 > better to have the upcoming stable SMW1.0 working for you as well. >=20 > The major problem here is that SMW0.7 used a completely different way to= =20 > access the DB than SMW1.0. So a patch will not help for the new version > that=20 > we want to publish *soon*. >=20 > What would help, though, would be a short overview on the major=20 > incompatibilities and problems you encountered. Could we jsut fix them in > SVN=20 > without getting problems with MySQL? Also, SMW1.0 allows to exchange the= =20 > storage implementation completely. So one could also (if all fails) fork > the=20 > current storage implementation and make one for Postgresql that is > choosable=20 > during install. >=20 > The new SQL-statements we use are all contained in [1], so feel free to > have a=20 > look. No other SQL occurs in SMW1.0 anywhere else. >=20 > Cheers, >=20 > Markus >=20 > [1]=20 > http://svn.wikimedia.org/svnroot/mediawiki/trunk/extensions/SemanticMedia= Wiki/includes/storage/SMW_SQLStore.php >=20 >> >> Thanks. >> Fernando Carpani. >> Sebastian Beceiro. >> >> ------------------------------------------------------------------------= - >> This SF.net email is sponsored by: Microsoft >> Defy all challenges. Microsoft(R) Visual Studio 2005. >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >> _______________________________________________ >> Semediawiki-user mailing list >> Sem...@li... >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >=20 >=20 >=20 > --=20 > Markus Kr=C3=B6tzsch > Institut AIFB, Univers=C3=A4t Karlsruhe (TH), 76128 Karlsruhe > phone +49 (0)721 608 7362 fax +49 (0)721 608 5998 > ma...@ai... www http://korrekt.org >=20 > =20 > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user >=20 >=20 --=20 View this message in context: http://www.nabble.com/SMW-0.7-seems-to-be-wor= k-in-postgresql-tf4554482.html#a13154301 Sent from the Semantic Mediawiki - User mailing list archive at Nabble.com. |
From: Fernando C. - I. <ca...@fi...> - 2007-10-12 14:04:25
|
Hello. My reply is merged with the old text.... Markus Krötzsch wrote: >On Dienstag, 2. Oktober 2007, Fernando Carpani - INCO wrote: > > >>Hello. >>We have patched a SMW 07 sources to work with Postgresql. This version >>also has patched to work in spanish. >>Seems to be work for us, but I think that someone else can be test it. >> >>How can we publish the patched version? (an the patch for >>SMW_InlineQueries...) >> >> > >Is the patched version still doing everything that SMW0.7 did? Then we could >publish it as SMW0.7.1 or SMW0.7postgresql. But of course it would be even >better to have the upcoming stable SMW1.0 working for you as well. > > > Until we can see, yes, do the same.... but.. :-) always is posible introduce a bug... >The major problem here is that SMW0.7 used a completely different way to >access the DB than SMW1.0. So a patch will not help for the new version that >we want to publish *soon*. > > I understand. We are thinking in work with 1.0 ... >What would help, though, would be a short overview on the major >incompatibilities and problems you encountered. Could we jsut fix them in SVN >without getting problems with MySQL? Also, SMW1.0 allows to exchange the >storage implementation completely. So one could also (if all fails) fork the >current storage implementation and make one for Postgresql that is choosable >during install. > > > OK. We are writing an internal report of that work and here will be something about that. Quickly, in my mind: * The index creation in the original version, were made with "alte table add index" or something similar. I think that this forms is not standard. We change by a create index. * I don't remember if the creation of serial fields was a trouble. I think that Postgresql use sequences like Oracle and not Serial attributes... but I'll see that again The details of that and other little things are for Sebastian. >The new SQL-statements we use are all contained in [1], so feel free to have a >look. No other SQL occurs in SMW1.0 anywhere else. > > > We'll see that. >Cheers, > >Markus > >[1] >http://svn.wikimedia.org/svnroot/mediawiki/trunk/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore.php > > > >>Thanks. >>Fernando Carpani. >>Sebastian Beceiro. >> >>------------------------------------------------------------------------- >>This SF.net email is sponsored by: Microsoft >>Defy all challenges. Microsoft(R) Visual Studio 2005. >>http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >>_______________________________________________ >>Semediawiki-user mailing list >>Sem...@li... >>https://lists.sourceforge.net/lists/listinfo/semediawiki-user >> >> > > > > > Bye !! FDO. |
From: Markus <ma...@ai...> - 2007-10-13 10:02:05
|
On Freitag, 12. Oktober 2007, Fernando Carpani - INCO wrote: <snip> > > We'll see that. OK, great. Please contact us if you have questions. The whole table and ind= ex=20 creation again is fairly local (see setup()), if this turns out to be most= =20 critical. =2D- Markus > > >Cheers, > > > >Markus > > > >[1] > >http://svn.wikimedia.org/svnroot/mediawiki/trunk/extensions/SemanticMedi= aW > >iki/includes/storage/SMW_SQLStore.php > > > >>Thanks. > >>Fernando Carpani. > >>Sebastian Beceiro. > >> > >>-----------------------------------------------------------------------= =2D- > >>This SF.net email is sponsored by: Microsoft > >>Defy all challenges. Microsoft(R) Visual Studio 2005. > >>http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > >>_______________________________________________ > >>Semediawiki-user mailing list > >>Sem...@li... > >>https://lists.sourceforge.net/lists/listinfo/semediawiki-user > > Bye !! > FDO. =2D-=20 Markus Kr=F6tzsch Institut AIFB, Univers=E4t Karlsruhe (TH), 76128 Karlsruhe phone +49 (0)721 608 7362 fax +49 (0)721 608 5998 ma...@ai... www http://korrekt.org |