4 ms·
I like the idea, but after using it, the query apis aren't expressive enough. I wish I could write SQL instead of making 2+ api calls to get the data I want.
by turtlebits 3y ago
I like the idea, but after using it, the query apis aren't expressive enough. I wish I could write SQL instead of making 2+ api calls to get the data I want.
- ako 3y agoDid you try view collections, https://pocketbase.io/docs/collections/#view-collection https://pocketbase.io/docs/collections/#view-collection ?
- dhc02 3y agoI'm no expert, but it seems like raw SQL is supported. From the docs: "It also exposes app.Dao().DB() builder that allows executing various SQL statements (including raw queries)."
- mdnahas 3y agoYes, that's correct. In server-side code, you can write SQL queries. JavaScript API: https://pocketbase.io/docs/js-database/ https://pocketbase.io/docs/js-database/ Go API: https://pocketbase.io/docs/go-database/ https://pocketbase.io/docs/go-database/