Bug 257646 – dev-db/sqlite-3.6.10: add spatial USE flag in conjunction with recompiling spatialite

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description kunitoki (Lucio Asnaghi) 2009-02-04 17:30:05 UTC]

There is an experimental project going on which adds spatial ability to SQLite-3. It mainly add some include files and recompiles:

 * 	/usr/lib/libsqlite3.la
 * 	/usr/lib/libsqlite3.a
 * 	/usr/lib/libsqlite3.so
 * 	/usr/lib/libsqlite3.so.0

to add spatial operators and geometry implementation.


Reproducible: Always

Steps to Reproduce:
1.

[Comment 1 kunitoki (Lucio Asnaghi) 2009-02-04 17:32:18 UTC]

Created attachment 180945 [details]
spatialite ebuild

This is an external spatialite ebuild which is ok

BUT IT PRODUCE:

 * Detected file collision(s):
 * 
 * 	/usr/lib/libsqlite3.la
 * 	/usr/lib/libsqlite3.a
 * 	/usr/lib/libsqlite3.so
 * 	/usr/lib/libsqlite3.so.0
 * 
 * Searching all installed packages for file collisions...
 * 
 * Press Ctrl-C to Stop
 * 
 * dev-db/sqlite-3.6.10
 * 	/usr/lib/libsqlite3.a
 * 	/usr/lib/libsqlite3.la
 * 	/usr/lib/libsqlite3.so
 * 	/usr/lib/libsqlite3.so.0

so it would be better to have it included in a experimental sqlite build using USE="spatial"

[Comment 2 kunitoki (Lucio Asnaghi) 2009-02-23 15:50:36 UTC]

Created attachment 182907 [details, diff]
sqlite patch adding readline / rtree support

sqlite patch adding optional readline support (for embedded gentoo builds that do not have readline) and add optional rtree indexing in the database (it is needed for spatial tables)

[Comment 3 Arfrever Frehtes Taifersar Arahesis (RETIRED) 2009-09-11 17:52:36 UTC]

*** Bug 269719 has been marked as a duplicate of this bug. ***

[Comment 4 Arfrever Frehtes Taifersar Arahesis (RETIRED) 2009-09-11 21:18:18 UTC]

I added support for R-trees in dev-db/sqlite-3.6.18.