Hi Daniel I've had a few emails with John, and I don't think he's planning on pushing SQLite support at this point in time - he's not a fan of the delta approach for keeping datasets up to date, and so is venturing into other search solutions.
That said, if someone can get his version of Sphinx running with SQLite, then send through patches for Thinking Sphinx, I'll gladly add them in. His patches for TS, from memory, weren't complete - just enough to stop TS from complaining initially, but there's no SQLite versions of function calls. I'd love to have SQLite support in Thinking Sphinx, but that relies on it being relatively easy to install a version of Sphinx that supports SQLite. Also, I've no idea of whether SQLite supports custom functions, because it's likely that will be needed to get everything on par to MySQL and PostgreSQL. Cheers -- Pat e: [email protected] || m: +614 1327 3337 w: http://freelancing-gods.com || t: twitter.com/pat discworld: http://ausdwcon.org || skype: patallan On 19/03/2009, at 3:57 PM, Daniel Bush wrote: > Has anyone used rails + sphinx + sqlite3? > > I was looking at thinking-sphinx rails plugin which looked simple to > deploy but ran into several issues > * sphinx doesn't support sqlite3 > * thinking-sphinx doesn't support sqlite3 > > John Aughey has clones of both projects on github with changes that > go some way to implementing this [1][2] but I'm not sure I'd be > comfortable using in production yet. I haven't tested it out either > because I initially installed the last stable release 0.9.8 of > sphinx [1]. I think there has been some work and mention of sqlite3 > on the sphinx forums but it's hard to get a clear picture of what's > going on because I can't find the sphinx repository - it seems to be > private. > > I'm new to this game but I'm thinking, short of migrating to > postgres (which is not a bad thing but a hassle), I have to index a > sphinx docset xml document generated from sqlite3 instead and use > the riddle client api. My requirements are very modest. > > [1] for sphinx, he has made changes to rc1 0.9.9 for sqlite3.- > http://github.com/aughey/sphinx-sqlite3/tree/master > [2] the sqlite3 changes have not been pulled into freelancing-god's > thinking-sphinx version (AFAICT!) > > -- > Daniel Bush > > http://blog.web17.com.au > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby or Rails Oceania" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rails-oceania?hl=en -~----------~----~----~----~------~----~------~--~---
