On Thu, Jun 22, 2006 at 09:16:59AM +0200, Davide Alberani wrote:
> > It has been tested with Postgresql 8 and Sqlite 3. The tables/indexes
> > are created successfully.
>
> Very good!
> Anyway - you won't believe it! - MySQL (AKA "il buco col database
> intorno") has a problem: it categorically refuses to create an index
> over a TEXT (or BLOB) column.
> To tell the truth this is one of its very few behaviors that seems
> reasonable.
>
> I suppose that the only workaround is to set a limit to the length of
> the index, and hope this doesn't break postgres/sqlite/otherDB. :-/
It's not a problem with pgsql and sqlite. It's a feature supported for mysql
only.
> > 1) There's a bug in sqlobject 0.7.0 that prevents creation of
> > indexes. index.py:137 in _get_name of course it is self.kw['name']
> > instead of kw['name']
>
> Yep; I have it already fixed in my 0.8dev-r1631 - I don't remember
> if I've fixed it manually and/or if I've opened a bug report.
Seen the other reply, I've opened a bug ticket on sourceforge.
> > 2) A question: are indexes on AkaNames:name, AkaNames:imdbIndex,
> > AkaTitle:title, AkaTitle:imdbIndex, AkaTitle:kind,
> > AkaTitle:productionYear needed? I've disabled them, so if they are
> > needed let me know and I'll enable them.
>
> I think they are superfluous and can be removed.
Seen you've done that.
Now I'm going to do a test of the current setup using PostgreSQL and SQLite.
I'll report the results.
--
Giuseppe "Cowo" Corbelli ~\/~ My software: http://cowo.yoda2000.net
-<! windoze: no need of an hammer to crash it! !>-
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Imdbpy-devel mailing list
Imdbpy-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
