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

[stimits at comcast.net]

It sounds like Neo4j is an actual database, rather than a tool to map other people's database (though it looks like something I would put on a PostgreSQL wish list).
 
I specifically have data from other people's applications for which the applications evolved over time and the original interface to install the data was lost. The same data is used, but only direct SQL edit is now possible on part of that data. I need to be able to map out some load orders from some XML files in order to correctly edit that sample data for real world use, and secondarily create a working interface after figuring out what is missing. The database in use is PostgreSQL, so if Neo4j can map this, I'm all for it. It seems though that I would have to dump PostgreSQL...which isn't really an alternative. Plus this is all free work and free software running on Linux, no money is available for purchasing commercial licensing or third party support.
 
----- Original Message -----From: Alan Robertson <alanr at unix.sh>To: lug at lug.boulder.co.usSent: Wed, 23 Aug 2017 20:24:51 -0000 (UTC)Subject: Re: [lug] Q. on SQL Foreign Keys (PostgreSQL)



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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lug.boulder.co.us/pipermail/lug/attachments/20170823/a62fb09d/attachment.html>