Re: Recomended front ends?

2019-08-28 Thread Peter J. Holzer
On 2019-08-27 08:16:08 -0700, Adrian Klaver wrote: > Django takes Postgres as it's reference database which makes things easier, > especially when you add in > contrib.postgres(https://docs.djangoproject.com/en/2.2/ref/contrib/postgres/) Looks nice. hp -- _ | Peter J. Holzer| we

Re: Recomended front ends?

2019-08-28 Thread Peter J. Holzer
On 2019-08-27 16:04:02 +0100, Daniele Varrazzo wrote: > Using the Django ORM to create complex queries is a joy (especially > nesting subqueries), Not for me. I usually know what SQL I want to execute. Then I have to convert that SQL into a weird[1] and limited query language composed of method ca

Re: Recomended front ends?

2019-08-27 Thread Adrian Klaver
On 8/27/19 8:04 AM, Daniele Varrazzo wrote: On Sun, Aug 11, 2019 at 7:49 PM Peter J. Holzer wrote: Django lets you use "unmanaged" tables, but it is quite noticeable that this isn't the primary use case. It isn't, but it's the best way to use Django for database-literate people. It's enough

Re: Recomended front ends?

2019-08-27 Thread Daniele Varrazzo
On Sun, Aug 11, 2019 at 7:49 PM Peter J. Holzer wrote: > Django lets you use "unmanaged" tables, but it is quite noticeable that > this isn't the primary use case. It isn't, but it's the best way to use Django for database-literate people. It's enough to ignore the Django sale pitch of the datab

Re: Recomended front ends?

2019-08-11 Thread Peter J. Holzer
On 2019-08-08 10:47:47 -0700, Rich Shepard wrote: > On Thu, 8 Aug 2019, Adrian Klaver wrote: > > Unfortunately it does not: > > https://code.djangoproject.com/wiki/MultipleColumnPrimaryKeys > > > > Given that the issue: > > https://code.djangoproject.com/ticket/373 > > is 14 years old does not ins

Re: Recomended front ends?

2019-08-09 Thread Paolo Saudin
For web/mobile applications we use Mojolicious, https://mojolicious.org witch work pretty well with Postgresql, is written in Perl and has plenty of nice features. Paolo Saudin Il giorno gio 8 ago 2019 alle ore 22:09 DiasCosta ha scritto: > Hi, > After many years of using Oracle Forms and Oracle

Re: Recomended front ends?

2019-08-08 Thread DiasCosta
Hi, After many years of using Oracle Forms and Oracle Reports with Oracle DB, I have been using Lazarus and "Code Typhon" for many years now. Both work with Free Pascal Compiler and both are open source and free. Both have a very good IDE, the code produced is Pascal (very easily readable), and

Re: Recomended front ends?

2019-08-08 Thread Basques, Bob (CI-StPaul)
All, No Web driven, but . . . . we’ve had some success with using LibreOffice(calc) as a frontend. Fairly easy to build forms, etc. Only limited experience so far, but was able to build domain lists from SQL calls, for form pulldown lists, etc. bobb > On Aug 8, 2019, at 2:10 PM, Rich Shep

Re: Recomended front ends?

2019-08-08 Thread Rich Shepard
On Thu, 8 Aug 2019, Tim Clarke wrote: We tried Django without any pleasant results. Tim, That's unexpected and too bad. I'd also caution using MS Access, we're desperate to get away from it. Sharing code has challenges and it is horribly aggressive with caching unless you use un-bound forms

Re: Recomended front ends?

2019-08-08 Thread Andrew Kerber
On Thu, Aug 8, 2019 at 1:30 PM Tim Clarke wrote: > On 08/08/2019 17:55, Stuart McGraw wrote: > > > > 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

Re: Recomended front ends?

2019-08-08 Thread Tim Clarke
On 08/08/2019 17:55, Stuart McGraw wrote: > > 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

Re: Recomended front ends?

2019-08-08 Thread Rich Shepard
On Thu, 8 Aug 2019, Adrian Klaver wrote: Unfortunately it does not: https://code.djangoproject.com/wiki/MultipleColumnPrimaryKeys Given that the issue: https://code.djangoproject.com/ticket/373 is 14 years old does not inspire confidence that it will change anytime soon. Adrian, That's reall

Re: Recomended front ends?

2019-08-08 Thread Adrian Klaver
On 8/8/19 10:34 AM, Rich Shepard wrote: On Thu, 8 Aug 2019, Stuart McGraw wrote: I would be a little cautious about Django. Specifically IIRC it insists that tables have a single-column primary keys. Stuart, I looked seriously at Django and did not encounter that limitation. However, I

Re: Recomended front ends?

2019-08-08 Thread Rich Shepard
On Thu, 8 Aug 2019, Stuart McGraw wrote: I would be a little cautious about Django. Specifically IIRC it insists that tables have a single-column primary keys. Stuart, I looked seriously at Django and did not encounter that limitation. However, I did learn that I'm not a web application de

Re: Recomended front ends?

2019-08-08 Thread Adrian Klaver
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 n

Re: Recomended front ends?

2019-08-08 Thread Stuart McGraw
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 criter

Re: Recomended front ends?

2019-08-08 Thread Tony Shelver
On Wed, 7 Aug 2019 at 20:57, stan wrote: > I am in the process of defining an application for a very small company > that uses Postgresql for the backend DB. This DB will eventually run on a > hosted machine. As you imagine all of the employees have Windows machines > for their normal work asks.

Re: Recomended front ends?

2019-08-08 Thread Tim Clarke
All excellent solutions, may I add Lucee to the list. We call it "the best web development system no-one knows about". Tim Clarke IT Director Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420 On 07/08/2019 21:38, Rich Shepard wrote: > On Wed, 7 Aug 2019, Igor Korot wrote: > >> On top of wh

Re: Recomended front ends?

2019-08-07 Thread Rich Shepard
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

Re: Recomended front ends?

2019-08-07 Thread Igor Korot
Hi, On Wed, Aug 7, 2019 at 1:57 PM stan wrote: > > I am in the process of defining an application for a very small company > that uses Postgresql for the backend DB. This DB will eventually run on a > hosted machine. As you imagine all of the employees have Windows machines > for their normal wor

Re: Recomended front ends?

2019-08-07 Thread Rob Sargent
On 8/7/19 1:38 PM, Adrian Klaver wrote: On 8/7/19 11:57 AM, stan wrote: I am in the process of defining an application for a very small company that uses Postgresql for the backend DB. This DB will eventually run on a hosted machine. As you imagine all of the employees have Windows machines

Re: Recomended front ends?

2019-08-07 Thread Adrian Klaver
On 8/7/19 11:57 AM, stan wrote: I am in the process of defining an application for a very small company that uses Postgresql for the backend DB. This DB will eventually run on a hosted machine. As you imagine all of the employees have Windows machines for their normal work asks. Frankly I am not

Re: Recomended front ends?

2019-08-07 Thread Igor Korot
Hi, On Wed, Aug 7, 2019 at 1:57 PM stan wrote: > > I am in the process of defining an application for a very small company > that uses Postgresql for the backend DB. This DB will eventually run on a > hosted machine. As you imagine all of the employees have Windows machines > for their normal wor

Recomended front ends?

2019-08-07 Thread stan
I am in the process of defining an application for a very small company that uses Postgresql for the backend DB. This DB will eventually run on a hosted machine. As you imagine all of the employees have Windows machines for their normal work asks. Frankly I am not very strong on Windows. so I am wo