[lug] Q. on SQL Foreign Keys (PostgreSQL)

[Alan Robertson]

I was sort of kidding (hence the ;-) and the "/me ducks"). But people do
do ETL kinds of things with Neo4j. Joining across thousands of tables to
create a graph sounds like a nightmare. Neo4j has open source licenses.
The commercial level products are under the APL, IIRC. Sometimes people
care about that, and sometimes it's fine. But I haven't kept up with the
commercial level licensing - I use the GPL version.
--
  Alan Robertson
  alanr at unix.sh



On Wed, Aug 23, 2017, at 02:24 PM, Alan Robertson wrote:
> Maybe use Neo4j?  ;-)
> 
> /me ducks...
> 
> --
>   Alan Robertson
>   alanr at unix.sh
> 
> 
> 
> On Wed, Aug 23, 2017, at 01:25 PM, stimits at comcast.net wrote:
>> Hi,
>>  
>> I'm wondering if there is someone I might be able to ask a question
>> off-list about SQL foreign keys (I'm using PostgreSQL, but this
>> should apply to most SQL servers). Basically I'm trying to build an
>> application which will read metadata tables and draw a graphical
>> chart of complex relations (perhaps 1000 tables and almost all
>> interrelated) and having a problem with foreign key descriptions.
>> I've been trying to figure this out for quite some time, but can't
>> wrap my brain around it. I want to know if my idea of how multi-
>> column foreign keys work is correct, or if I need to approach this in
>> a different way. Thanks!>> _________________________________________________
>> Web Page:  http://lug.boulder.co.us
>> Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
>> Join us on IRC: irc.hackingsociety.org port=6667
>> channel=#hackingsociety> _________________________________________________
> Web Page:  http://lug.boulder.co.us
> Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> Join us on IRC: irc.hackingsociety.org port=6667
> channel=#hackingsociety
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lug.boulder.co.us/pipermail/lug/attachments/20170823/f651f778/attachment-0001.html>