Thanks Pat and Julio. I really should pony up some code with regards sqlite3 and sphinx but I'm just not up to it at the moment.
With regards custom functions in sqlite, I'm not sure sqlite3 has stored procedures, but it does have triggers at least. For instance someone wrote a set of triggers to maintain foreign key integrity: http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers . I was also looking at its C api and 'sqlite3_create_function()' - section 4 of http://www.sqlite.org/cintro.html . Anyway, I'll leave it there for the moment. Cheers. -- Daniel Bush http://blog.web17.com.au 2009/3/19 Julio Cesar Ody <[email protected]> > > Have a look at this > > http://nutrun.com/weblog/distributed-key-value-store-indexing/ > > I found it when I was thinking of a way to get CouchDB into Sphinx. > Never got around to *actually* make it happen though. > > This of course doesn't have much to do with TS itself. And in your > case (Daniel), you'd have to basically pipe every single row you have > through ActiveRecord and then onto Sphinx, which might not perform so > well. It's a solution though. It can be made to work. > > > On Thu, Mar 19, 2009 at 4:37 PM, Pat Allan <[email protected]> > wrote: > > > > 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 > >> > >> > >> > >> > > > > > > > > > > > > > > -- Daniel Bush http://blog.web17.com.au http://github.com/danielbush http://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 -~----------~----~----~----~------~----~------~--~---
