Re: need advice for simple web development tools

From: Steve Midgley <science(at)misuse(dot)org>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Michael Moore <michaeljmoore(at)gmail(dot)com>, postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: need advice for simple web development tools
Date: 2016-03-28 23:27:32
Message-ID: CAJexoSLRJZfme=EPgyqotGeL_Ny9zUesVg_cGVAT2HwqkFn=Sg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Mar 28, 2016 at 3:58 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 03/28/2016 03:51 PM, Michael Moore wrote:
>
>> I want to create some web page screens with postgres as the db. It is
>> just for simple prototyping. I don't need scalability or high
>> performance. I just want the simplest possible environment to toss up
>> some quick web pages with postgres data. Hopefully no app server or
>> middle tier.
>> What should I be looking at?
>>
>
> Since you are using a database I am assuming you want the pages to be at
> least somewhat dynamic e.g. respond to user input. If this is the case that
> would tend to point to some sort of middle tier to negotiate between the
> Web server and the database.
>
> So some questions:
>
> 1) What exactly are you trying to achieve in terms of interaction between
> the user and the data?
>
> 2) What language(s) do you want to work in?
>
> Thanks,
>> Mike
>>
>
> A lot depends on your answers to Mike's questions - and depending on your
language preferences there are lots of very good options out there. I
personally like Ruby on Rails for setting up interactive websites based on
Postgres very quickly. There's a lot of scaffolding to help you out - a
friend of mine built a pretty full featured mobile site with almost no
coding ability.

But if your dynamic data and user interface needs are lower, then consider
WordPress or Drupal. The problem with these is their data models are highly
abstracted, so while they use Postgres for persistence, your data won't be
easily visible in their tables.

Steve

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message David Binney 2016-03-28 23:41:51 Re: need advice for simple web development tools
Previous Message Adrian Klaver 2016-03-28 22:58:09 Re: need advice for simple web development tools