Live data from Hacker News

Agens Graph – PostgreSQL Based Graph Database

agensgraph.com

11–20 of 47 posts

Re: Agens Graph – PostgreSQL Based Graph Database

#11
Heh Heh Heh

Back in the early days PostgreSQL was a NoSQL database called Postgres, using a query language called POSTQUEL.

Then SQL was added, becoming PostgreSQL.

With Agens Graph adding an optional non-SQL query language back to it, it seems like it's gone a full circle. Hopefully on an upward slope though. :)

If anyone's interested in the pre-SQL Postgres, there's some info here: https://www.postgresql.org/about/history/

Re: Agens Graph – PostgreSQL Based Graph Database

#12
post #5
post #2

Wondering if anyone has experience with it... there's a lot of competition in graph database market, curious to see if this is worth investing time in.

There isn't a lot of competition in the "free/libre database" market though. The only serious players are Jena/Fuseki (an RDF store) and Janus (a graph store).

There is also Cayley (https://github.com/cayleygraph/cayley) which supports more query languages, including GraphQL, and multiple backend stores.

Re: Agens Graph – PostgreSQL Based Graph Database

#13
post #5
post #2

Wondering if anyone has experience with it... there's a lot of competition in graph database market, curious to see if this is worth investing time in.

There isn't a lot of competition in the "free/libre database" market though. The only serious players are Jena/Fuseki (an RDF store) and Janus (a graph store).

There's also https://github.com/postgraphql/postgraphql

Re: Agens Graph – PostgreSQL Based Graph Database

#14

Heh Heh Heh Back in the early days PostgreSQL was a NoSQL database called Postgres, using a query language called POSTQUEL. Then SQL was added, becoming PostgreSQL. With Agens Graph adding an optional non-SQL query language back to it, it seems like it's gone a full circle. Hopefully on an upward slope though. :) If anyone's interested in the pre-SQL Postgres, there's some info here: https://www.postgresql.org/about/…

NoSQL refers to non-relational DBMSes, not a literal lack of SQL... QUEL is, if anything, closer to relational algebra than SQL is.

https://en.wikipedia.org/wiki/QUEL_query_languages

QUEL is a better language (more consistent), and SQL won not on technical grounds, but because Larry Ellison is a better salesman than Michael Stonebraker.

Re: Agens Graph – PostgreSQL Based Graph Database

#15
post #14

Heh Heh Heh Back in the early days PostgreSQL was a NoSQL database called Postgres, using a query language called POSTQUEL. Then SQL was added, becoming PostgreSQL. With Agens Graph adding an optional non-SQL query language back to it, it seems like it's gone a full circle. Hopefully on an upward slope though. :) If anyone's interested in the pre-SQL Postgres, there's some info here: https://www.postgresql.org/about/…

NoSQL refers to non-relational DBMSes, not a literal lack of SQL... QUEL is, if anything, closer to relational algebra than SQL is. https://en.wikipedia.org/wiki/QUEL_query_languages QUEL is a better language (more consistent), and SQL won not on technical grounds, but because Larry Ellison is a better salesman than Michael Stonebraker.

Yeah, I wondered if anyone was going to be pedantic about that. ;)

Re: Agens Graph – PostgreSQL Based Graph Database

#18
post #14

Earlier quoted context omitted.

NoSQL refers to non-relational DBMSes, not a literal lack of SQL... QUEL is, if anything, closer to relational algebra than SQL is. https://en.wikipedia.org/wiki/QUEL_query_languages QUEL is a better language (more consistent), and SQL won not on technical grounds, but because Larry Ellison is a better salesman than Michael Stonebraker.

Yeah, I wondered if anyone was going to be pedantic about that. ;)

I would call that "interesting" instead of "pedantic"

Re: Agens Graph – PostgreSQL Based Graph Database

#19
post #12
post #5

Earlier quoted context omitted.

There isn't a lot of competition in the "free/libre database" market though. The only serious players are Jena/Fuseki (an RDF store) and Janus (a graph store).

There is also Cayley ( https://github.com/cayleygraph/cayley ) which supports more query languages, including GraphQL, and multiple backend stores.

Cayley is cool! A 20% project from Google iirc

Re: Agens Graph – PostgreSQL Based Graph Database

#20

This is awesome. So many of the problems in legacy projects that I've had to deal with have been from trying to shoehorn a graph business process into a tree database.

A "graph business process" is borderline content free. All business processes can be expressed by graphs. What is a graph? A dynamic data structure. That is it. So what is a "tree database"? A graph database with a bias for a specific ordering of its nodes. Does that make a tree database a query result (path traversal) in a graph database? The confusion of it all. So imho one uses a "graph database" when (a) the doma…

You seem to know a hell of a lot about me and my particular problems from one, simple message. Tell me, oh great and powerful wizard, how does one acquire such awesome powers of wild-ass, baseless extrapolation?
Post reply on HN