apache / age

Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL.
https://age.apache.org
Apache License 2.0
3.03k stars 406 forks source link

Porting AGE to SQLite before MariaDB/MySQL #1773

Closed d4h0 closed 2 months ago

d4h0 commented 5 months ago

Hi,

The overview page states:

Apache AGE® will be compatible with all relational databases in the future development, starting with MariaDB and MySQL.

I'm wondering if there is any chance that the team will port AGE first to SQLite instead.

The reason is, that SQLite is embeddable and there don't seem to be good options for embedded graph databases, yet (there are several good options for server-based graph databases, like the Postgres version of AGE).

As far as I know, SQLite is also by far the most used SQL database engine (measured by installations). SQLite is also popular on edge computing platforms (I believe), so this even might make AGE / graph databases usable there (which would be great).

markgomer commented 5 months ago

@aked21, @eyab, @jrgemignani, this is for your assessment.

mingfang commented 5 months ago

My vote is for pglite https://github.com/electric-sql/pglite pglite brings Postgres to any WASM runtime include web browsers. AGE on the edge/browser would be amazing.

d4h0 commented 5 months ago

Wow, pglite looks pretty impressive. Unfortunately, it only seems to target JavaScript/TypeScript, so it isn't really comparable to SQLite (which probably has clients for most programming languages).

github-actions[bot] commented 3 months ago

This issue is stale because it has been open 60 days with no activity. Remove "Abondoned" label or comment or this will be closed in 14 days.

github-actions[bot] commented 2 months ago

This issue was closed because it has been stalled for further 14 days with no activity.