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 -~----------~----~----~----~------~----~------~--~---
