[annotator-dev] Annotator store for MySQL

johnny jiang johnny.nan.jiang at gmail.com
Fri Oct 19 10:26:35 UTC 2012


Hi folks,

Here you go all the files required to get the annotator datastore working
with MySQL.

Please refer to readme.txt for instructions, please feel free to let me
know if any questions.

Kind regards,
Johnny

On Wed, Oct 17, 2012 at 4:17 AM, Randall Leeds <tilgovi at hypothes.is> wrote:

> On Tue, Oct 16, 2012 at 7:06 AM, Rufus Pollock <rufus.pollock at okfn.org>
> wrote:
> > Definitely interested. If we could use SQLAlchemy for this (we had an
> > sql version before) then we should be able to switch the exact RDBMS
> > pretty easily!
>
> Very interested as well.
>
> >
> > Rufus
> >
> > On 16 October 2012 12:53, johnny jiang <johnny.nan.jiang at gmail.com>
> wrote:
> >> Hi guys,
> >>
> >> Recently we've completed migrating Annotator store from elasticsearch +
> >> python to MySQL (still needs elasticsearch and python, just use MySQL as
> >> data store), I was wondering if anyone is interested in it so I'm happy
> to
> >> share it?
> >>
> >> Kind regards,
> >> Johnny
> >>
> >>
> >> _______________________________________________
> >> annotator-dev mailing list
> >> annotator-dev at lists.okfn.org
> >> http://lists.okfn.org/mailman/listinfo/annotator-dev
> >>
> >
> >
> >
> > --
> > Co-Founder, Open Knowledge Foundation
> > Promoting Open Knowledge in a Digital Age
> > http://www.okfn.org/ - http://blog.okfn.org/
> >
> > _______________________________________________
> > annotator-dev mailing list
> > annotator-dev at lists.okfn.org
> > http://lists.okfn.org/mailman/listinfo/annotator-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/annotator-dev/attachments/20121019/f4d2941a/attachment-0002.html>
-------------- next part --------------
(1)

run Annotation.sql on your database

(2)

configure your mysql in store.py on line 13

(3)

install python mysqldb

apt-get install python-mysqldb





-------------- next part --------------
A non-text attachment was scrubbed...
Name: annotation.sql
Type: application/octet-stream
Size: 2794 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/annotator-dev/attachments/20121019/f4d2941a/attachment-0008.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: store.py
Type: application/octet-stream
Size: 7928 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/annotator-dev/attachments/20121019/f4d2941a/attachment-0009.obj>


More information about the annotator-dev mailing list