Re: [GENERAL] CRM where pg is a first class citizen? - Mailing list pgsql-general

From Rich Shepard
Subject Re: [GENERAL] CRM where pg is a first class citizen?
Date
Msg-id alpine.LNX.2.11.1612131430590.4933@localhost
Whole thread Raw
In response to Re: [GENERAL] CRM where pg is a first class citizen?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: [GENERAL] CRM where pg is a first class citizen?
List pgsql-general
On Tue, 13 Dec 2016, Adrian Klaver wrote:

> This killed the community(Open Source) edition going forward:
> https://community.sugarcrm.com/thread/18434

   I'd like to comment regarding this paragraph from the above-referenced
blog post:

"In the course of the past five years, we have surveyed tens of thousands of
Sugar Community Edition users and found that we see two types of users of
Sugar Community Edition: 1) developers that wish to build on an open source
CRM platform, and 2) users, generally first time CRM users, that are looking
for a free/inexpensive CRM solution. We don’t believe that the current Sugar
Community Edition serves both audiences effectively. We envision an open
source solution targeted exclusively for developers. And, we also envision a
simpler way for first-time CRM users to find and use CRM."

   This is an interesting perspective, but not surprising for a large
for-profit corporation like SugarCRM.

   I'm an environmental consultant sole practitioner and have been looking
for years for a postgres-supporting CRM that I could use. There is none.
Every business is different and has different needs. This is why a generic
CRM like Sugar that tries to fit every business regardless of type or size
forces its customers to fit into their generic model rather than supporting
a developer _and_ end-user framework that can be customized for each
business's specific needs and way of working.

   That's why I'm developing my own using PyQt5, Python3, psychpg2, and
postgres-9.6.

   The django example I mentioned in an earlier post is written for software
companies; so is a PHP-based one (XRMS) that was abandoned a decade ago.
Product providers are different from service providers and small companies
(or solo practitioners). Neither fit my needs.

   I have the postgres schema that works for me and am willing to share it
with others because of this thread. I had not planned on putting it on
GitHub, but see no reason not to do so if there's interest by others. I'm
starting to learn PyQt5 and Python3 after a decade of wxPython use with
Python2 and am just about ready to start creating the UI.

Rich







pgsql-general by date:

Previous
From: Jovi Federici
Date:
Subject: Re: [GENERAL] Install doesnt set SuperUser PW
Next
From: Jovi Federici
Date:
Subject: Re: [GENERAL] Install doesnt set SuperUser PW