From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Stuart McGraw <smcg4191(at)mtneva(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Recomended front ends? |
Date: | 2019-08-08 17:22:09 |
Message-ID: | 8db2657f-529d-7d8c-af63-697f628296c3@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 8/8/19 9:55 AM, Stuart McGraw wrote:
> On 8/7/19 2:38 PM, Rich Shepard wrote:
>> On Wed, 7 Aug 2019, Igor Korot wrote:
>>
>>> On top of what already been said - make sure that the product you are
>>> about to start working on will have its requirements clear and concise.
>>
>> This is a critical process that needs to be developed in depth. One
>> criterion that will guide your choice of UI is whether the database
>> will be
>> accessed only on the LAN or also remotely. For the former, consider using
>> Python3 + psycopg + SQLAlchemy. For the latter, consider a web-based
>> application using Django.
>>
>> HTH,
>>
>> Rich
>
> I would be a little cautious about Django. Last time I checked,
> like many other web frameworks, it treats the database as just another
> component, one that provides data persistence for it, and consequently
> imposes its own constraints the schemas it will work with. Specifically
> IIRC it insists that tables have a single-column primary keys. If the
> client's existing database is already designed this way then that may
> not be a problem but if it has composite PKs then another option may
> be better.
Agreed the single-column PK is an annoyance, though it can be mitigated
with unique_together.
The real annoyance is:
https://docs.djangoproject.com/en/1.11/ref/models/fields/#primary-key
"The primary key field is read-only. If you change the value of the
primary key on an existing object and then save it, a new object will be
created alongside the old one."
That being said I use Django with managed set to False on models and
Sqitch doing the schema changes with no problems. Also Postgres is the
reference database for Django and has a contrib module with Postgres
specific features:
https://docs.djangoproject.com/en/1.11/ref/contrib/postgres/
>
> Flask is another relatively easy to use framework, can be used with or
> without Sqlalchemy but doesn't have the wealth of addons available with
> Django and being simpler requires more work to build the end application.
> There are of course many other framework options (Bottle, Web2Py, etc)
>
> Although it's been a decade plus since I worked with Microsoft products
> I had fairly good luck back then using Microsoft Access / VBA connected
> to a Postgresql backend via ODBC. Even back then MS's frontend development
> tools were way more advanced and easy to use than anything available for
> free in the Linux world. The downside was having to program in VBA but
> things may be much better these days with .NET et.al.
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2019-08-08 17:34:51 | Re: Recomended front ends? |
Previous Message | Stuart McGraw | 2019-08-08 16:55:24 | Re: Recomended front ends? |