Query regarding features support.

[jenish2014]

First of all Thank you, to the creators of EdgeDB. I've started using it in my personal projects and it has improved development experience by many fold.

I apologize in advance if any of these questions has been asked. I didn't encounter any of these queries while searching.

My query is, weather EdgeDB supports below features or will it support in future:

1. Intermediate table in Many-to-Many relations like in Django where, through-model in M2M has fields.

2. Postgresql has plethora of functions for myriad of use cases. Now EdgeDB may not implement all of them, So, is there going to be support for custom function where developer can add these function as they need on there own? e.g: Django provides custom lookup.

3. Query and Result Caching.

4. Input Sanitization or escaping untrusted Data.

5. Window Function, Partition and Ranking.

6. CTE, Views and Materialized Views.

Again, Thank you for creating EdgeDB it is a wonderful piece of Software.

[elprans]

1. Intermediate table in Many-to-Many relations like in Django where, through-model in M2M has fields.

Use multi links (with properties if you need relation fields)

2. Postgresql has plethora of functions for myriad of use cases. Now EdgeDB may not implement all of them, So, is there going to be support for custom function where developer can add these function as they need on there own? e.g: Django provides custom lookup.

EdgeDB implements the majority of commonly used Postgres functions (thought the names can be different). User-defined functions are also supported.

3. Query and Result Caching.

EdgeDB does not implement query result caching at the moment.

4. Input Sanitization or escaping untrusted Data.

EdgeDB implements server-side parameter binding which is immune to injection vulnerabilities by design.

5. Window Function, Partition and Ranking.

Basic partitioning can be implemented with GROUP, support for window functions is a work in progress.

6. CTE, Views and Materialized Views.

CTE == WITH in EdgeDB
Views == 'alias' in EdgeDB

Materialized views are not supported yet.

Again, Thank you for creating EdgeDB it is a wonderful piece of Software.

❤️

[jenish2014]

Hi, Thank you for clarifying my queries.

Quick question: is there going to be a Password Type?

[elprans]

Not sure what you mean, can you clarify the question please?

[jenish2014]

A scalar or object type for storing Password.

[elprans]

You mean a type that automatically hashes passwords? This is normally the application responsibility, not the database's. We can add hashing functions though to make it easier.

[jenish2014]

Ok, cool!