Re: Advice for first attempt at web-based database app. - Mailing list pgsql-novice

From Alan Hodgson
Subject Re: Advice for first attempt at web-based database app.
Date
Msg-id 1768011.qXr8DcScB3@skynet.simkin.ca
Whole thread Raw
In response to Advice for first attempt at web-based database app.  (Mike <1100100@gmail.com>)
Responses Re: Advice for first attempt at web-based database app.
List pgsql-novice
On Thursday 17 November 2016 14:02:22 Mike wrote:
> I would like to continue developing the database and interact with it
> via browser.
> I have no experience with web development and currently do not know
> any programming languages; but, I'm familiar with many sysadmin duties
> and general networking.
>
> For now, I would like to start with apache's httpd server hosted
> locally on my linux workstation, but don't know what other parts and
> pieces are needed to make a simple web-based database app.
>
> I'm looking into javascript for its flexibility and brevity; but, I'm
> not sure what other software I need to communicate with the database
> and secure the data when I choose to make it accessible from the
> internet at some point in the future.
>
> What would you suggest to a beginner to build what I've described?
>
> Thank you for your suggestions and advice.
>

1) Pick the language you want to work in.

2) Find a web framework that uses that language. Ie. Laravel or CakePHP if you
choose PHP (lots of options for PHP), or Django for Python, or Rails if you
choose Ruby. You can even use Node.js if you really want to use Javascript.

3) Start with intro tutorials and build pages as needed. Add language
tutorials as needed.

4) Never ever expose it to the public Internet. It takes years and serious
dedicated effort to learn enough about web security to build something that
can be safely exposed to the modern Internet. A good framework can help you
avoid a lot of potential mistakes (ie. simple SQL injections), but certainly
not all. Keep it behind your VPN.


pgsql-novice by date:

Previous
From: Mike
Date:
Subject: Advice for first attempt at web-based database app.
Next
From: Mike
Date:
Subject: Re: Advice for first attempt at web-based database app.