Re: web facing static text db

Path	csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail
From	Chris Angelico <rosuav@gmail.com>
Newsgroups	comp.lang.python
Subject	Re: web facing static text db
Date	Sat, 30 Apr 2016 09:23:30 +1000
Lines	18
Message-ID	<mailman.233.1461972213.32212.python-list@python.org> (permalink)
References	<CADjSo4QJdxFP0nG1dwGZzRN8xKOSoiwdzRW3E0_SxBi65GcJdQ@mail.gmail.com> <CADjSo4TuRB6Fx4ExK9Z+HYMfTfwPAr6wEqAArnwTNza6dje9bQ@mail.gmail.com> <CAPTjJmpzPphezNPUDg=6aocdC5jjKbysBc28Ft46O+pCWByHrA@mail.gmail.com>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
X-Trace	news.uni-berlin.de YS2H/0GqI1QPe/k3IVzs9gJpJ+X5ZbGk5X4j59k55Lfw==
Return-Path	<rosuav@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.001
X-Spam-Evidence	'H': 1.00; 'S': 0.00; 'received:209.85.223': 0.03; 'static': 0.03; 'subject:text': 0.04; 'frontend': 0.07; 'postgresql': 0.07; 'cc:addr:python-list': 0.09; 'lookup': 0.09; 'matched': 0.09; 'python': 0.10; '(about': 0.16; '2016': 0.16; 'decent': 0.16; 'from:addr:rosuav': 0.16; 'from:name:chris angelico': 0.16; 'lookups': 0.16; 'received:io': 0.16; 'received:psf.io': 0.16; 'required:': 0.16; 'wrote:': 0.16; 'deployment': 0.18; 'module,': 0.18; 'cc:2**0': 0.20; 'cc:addr:python.org': 0.20; 'am,': 0.23; 'matching': 0.23; 'sat,': 0.23; 'words': 0.24; 'header:In-Reply-To:1': 0.24; 'message- id:@mail.gmail.com': 0.27; 'yesterday': 0.27; '100000': 0.29; 'search.': 0.29; 'received:google.com': 0.35; 'text': 0.35; 'something': 0.35; 'received:209.85': 0.36; '(i.e.': 0.36; 'framework': 0.36; 'subject:: ': 0.37; 'front': 0.38; 'received:209': 0.38; 'data': 0.39; 'your': 0.60; 'documents': 0.61; 'engine': 0.62; '30,': 0.63; 'python-list': 0.66; 'facilities': 0.72; 'chrisa': 0.84; 'delete,': 0.84; 'to:none': 0.91
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:cc; bh=WgRfADRVhM9hG+htUpUzrkEFBat1WYa0ltyI+yLZnsY=; b=pA/tv2CIrbf1+1FJ9I1pOxNTEo50uraI+fdQXAcxHlGsFaVNVTNOpcRQ/zD4edpBdc bD0dp8HcQ7gVtOiPQqF7TW7zj/pcV9XxKQnODDja+aoisEF1ZPoM66m9pSinsBkDO1s7 y3EGM3sknoYDSYUbVJf0sJDAwKKqgQBB+WZTuUW4eSVt3w6GwxU/a/fQzcDAaPUKJrjB kmru+hdNvnFkR0x7MEqV/Zn28rVN7yEKcHoeogcwkdOBPz1pHKPdirL8i6jVDOG0PWTj tSRNyb1/RO/I6hDXPN18yx/CEqvIAd5sdBO4FNCb2NVwxbncP6eWC6OBmUsmRd4x/OxO ritQ==
X-Google-DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:cc; bh=WgRfADRVhM9hG+htUpUzrkEFBat1WYa0ltyI+yLZnsY=; b=ijfhk9Hnis+Z/LaHYQWWICqPfon8vU2n7zDOLzqAc6EyBbykldCOioBpsHg9GIanqt iKvvWPsnn72Drbp/7WnBxFuVsxcydWcQhWD8P0UTuUeR9GjdtzZIXPUVksyKpWPH7AFf MjqRskCJS7B8qCm5D4tSXNbepPuCJsGZdPzUl41QOM63lqsXb58sbf92W/GrHZgNHPxH zdFi9O8oOwXpKi2fbbt0ipl2eNe5HVjOJ+6XML4rqY69yR94sae0KEyxY/MZatdsBkfT SX/BxMOOEGmxBDJRNQdqPrGn85JGqUIJI6wzKbgvI3pdlr7TzQo0g1DivEc8wpiplHLc w0IA==
X-Gm-Message-State	AOPr4FVnLoRxDmrK2e1oksvLIvoI4TLx3T5XXaaj50iEObKE6wJ6MsqGMRuknPfcDU9bMVaM21lPao5+/4KalA==
X-Received	by 10.107.18.232 with SMTP id 101mr26056537ios.157.1461972210818; Fri, 29 Apr 2016 16:23:30 -0700 (PDT)
In-Reply-To	<CADjSo4TuRB6Fx4ExK9Z+HYMfTfwPAr6wEqAArnwTNza6dje9bQ@mail.gmail.com>
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.22
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
X-Mailman-Original-Message-ID	<CAPTjJmpzPphezNPUDg=6aocdC5jjKbysBc28Ft46O+pCWByHrA@mail.gmail.com>
X-Mailman-Original-References	<CADjSo4QJdxFP0nG1dwGZzRN8xKOSoiwdzRW3E0_SxBi65GcJdQ@mail.gmail.com> <CADjSo4TuRB6Fx4ExK9Z+HYMfTfwPAr6wEqAArnwTNza6dje9bQ@mail.gmail.com>
Xref	csiph.com comp.lang.python:107869

Show key headers only | View raw

On Sat, Apr 30, 2016 at 8:29 AM, Fetchinson . via Python-list
<python-list@python.org> wrote:
> * store text documents (about 100000 pages)
> * the data set is static (i.e. only lookups are performed, no delete,
> no edit, no addition)
> * only one operation required: lookup of pages by matching words in them
> * very simple web frontend for querying the words to be matched
> * no authentication or authorization, frontend completely public
> * deployment at webfaction
> * deadline: yesterday :)
>
> Which web framework and db engine would you recommend?

PostgreSQL has decent facilities for text search. You can access that
from Python using the psycopg2 module, and use something like Flask to
help you put together your front end.

ChrisA

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: web facing static text db Chris Angelico <rosuav@gmail.com> - 2016-04-30 09:23 +1000

csiph-web