3 ms·
Analytic queries are not the primary intended use of EdgeQL. It would be doable, since EgdeQL is compiled SQL within the edgedb server, but this compilation dep
by aerzen 3y ago
Analytic queries are not the primary intended use of EdgeQL. It would be doable, since EgdeQL is compiled SQL within the edgedb server, but this compilation depends on the schema of the database - quite heavily actually. It expects specific table and column names, so it would not work for an arbitrary database that you have.
It would be possible however, to take an empty postgres instance, hook edgedb server to it, apply your schema and insert all the data.
- 1st1 3y ago> Analytic queries are not the primary intended use of EdgeQL You can write analytic queries with EdgeQL now, albeit we do need to add support of windowing. While we certainly prioritize usefulness of EdgeQL for the kind of efficient data fetch operations you need when you build apps and services, the language itself was designed with a goal of becoming equally good for analytics too. We'll get there.