Re: [grinnellplans-dev] Digest for grinnellplans-development@googlegroups.com - 13 Messages in 1 Topic

[CM Lubinski]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, 21 Jul 2012 04:12:47 +0000
grinnellplan...@googlegroups.com wrote:

> CM, how many hours of work do you think is it to set up Solr with an
> initial not-updated-live dump of plans?

Here's the use case I've had for Solr: Full text search on the
name/city/ein of all federally-accredited charities (~800k entries.)
Adding all these entries to the db from scratch takes <5 minutes.
In this app, querying occurs via ajax completion (JS hits web app, web
app hits solr,) but it's wicked fast.

Using Solr is very straight-forward for simple searches and I can write
a quick walk-through of the easy stuff if you'd like. To get up and
running, you need to:
1. Get a java server running (e.g. tomcat, glassfish, jetty, etc.)
2. Add the solr war
3. Configure solr (simple -- you'll have a user_id and the plan body,
searching on the body.) I can send an example config if you'd like.
4. Configure the java server to only be accessible locally (again, I
can send an example config for tomcat)
5. Export the db into CSV (simplest)
6. Import into Solr

All-in-all, maybe 2 hours for a new dev to setup and grok the basic
flow.

I haven't looked at PHP integration, but I'm sure there are several
libraries that would make querying and updating from the web app easy.
Let me know if you are interested in going down this road.

Thanks,
CM Lubinski
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAlAKOXoACgkQfzi1OiZiJLC/QACfbCynoqXfR81sK1pSuDiqfve2
I1UAn05xtJO7Mbpd9ID08M7sg9YcxT28
=ewcL
-----END PGP SIGNATURE-----