Databases

[lexman]

• [x] implementation of postgres resources
• [x] implement other resources than tables : views, sotred procedures... What about indexes ?
• [ ] implement sub bloc from tables with filters. eg sqlite://mydb.sqlite/tables/users?country=FR. This works only if resources do not overlap
• [ ] tutorial how to work with databases : don't hesitate to duplicate data. But you can avoid it with joins, and patch data with views

[lexman]

New use case : create the database before populate it.

Usualy, you make a database for a project called my_project, and allow write access to user my_project. But you need to be admin to create the database. So, to complete the uses case, postgres resources needs : [ ] a database postgres resource like pg://servername:5432/database_name/ [ ] authentication like pg://admin_name@servername:5432/database_name/anything . Password should not be in the url, be configured on the system, for example with a .pgpass file.