Graph-Style Relationships in SurrealDB

Подписаться 4,7 тыс.

Просмотров 3,5 тыс.

50% 1

👉 Exploring Graph-Style Relationships in SurrealDB with Data Evangelist Alexander Fridriksson.
SurrealDB:
🌍 SurrealDB Website: surrealdb.com/
👉 SurrealDB GitHub: github.com/sur...
🐦 SurrealDB Twitter: / surrealdb
👨‍💻 SurrealDB LinkedIn: / surrealdb
👉 SurrealDB Discord: / discord
📸 SurrealDB Instagram: / surrealdb
👚 Shop the merch: surrealdb.store/
What is SurrealDB?
SurrealDB is an end-to-end cloud-native database designed for modern applications, including web, mobile, serverless, Jamstack, backend, and traditional applications. With SurrealDB, you can simplify your database and API infrastructure, reduce development time, and build secure, performant apps quickly and cost-effectively.
👉 Get started with SurrealDB: sdb.li/getstarted
Key features of SurrealDB:
⭐ Reduces development time: SurrealDB simplifies your database and API stack by removing the need for most server-side components, allowing you to build secure, performant apps faster and cheaper.
⭐ Real-time collaborative API backend service: SurrealDB functions as both a database and an API backend service, enabling real-time collaboration.
⭐ Support for multiple querying languages: SurrealDB supports SQL querying from client devices, GraphQL, ACID transactions, WebSocket connections, structured and unstructured data, graph querying, full-text indexing, and geospatial querying.
⭐ Granular access control: SurrealDB provides row-level permissions-based access control, giving you the ability to manage data access with precision.

Наука

Опубликовано:

7 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 22

@marc9937 5 месяцев назад

This short-form video series content is amazing! Keep it up!💪

@SurrealDB 5 месяцев назад

Many thanks for the feedback. Stay tuned for more content!

@jeffg4686 5 месяцев назад

Oh yeah - as someone whose spend a lot of time in relational databases, this is PLEASANT

@gariklaw 5 месяцев назад

Yes! Show us how it's done 🙏 Looking forward to more to come

@SurrealDB 5 месяцев назад

Thanks for the comment. Stay tuned for the next video.

@TidusUltimate 5 месяцев назад

Really nice job. Love this kinda content. Short, concise and very helpful. Cheers my dude

@SurrealDB 5 месяцев назад

Thank you for the feedback.

@DaggieBlanqx 5 месяцев назад

Great content. Thank you.

@SurrealDB 4 месяца назад

Glad you enjoyed it!

@FarofWell 5 месяцев назад

Like!

@casperon7 5 месяцев назад

Awesome stuff, would be great if you could cover define schemafull;

@SurrealDB 4 месяца назад

Thanks, we value your suggestion. This has been fed into our team for consideration.

@Cadambank 2 месяца назад

Hey man, I have a question. For the last query you had written, along with what products where purchased at the end can we get also how many times those products were purchased? How would you modify the query for that?

@SurrealDB 2 месяца назад

My first instinct would be to do this: SELECT array::len(->order->productproduct) AS number_of_products, ->order->productproduct.name AS product_names FROM person:00g8os512h0k7l19p05g Since array::len is not an agg function just gets the length of the products array it doesn't need a group by and you can get both in one query. If you'd need to use an agg function I'm pretty sure you'd need to do two queries, one for the agg function and one for non agg product list.

@user-qr4jf4tv2x 5 месяцев назад

i know we can set additional fields during relate statement.. to me the relate table generated kinda looks like a fact table should i treat it that way? or keep it only with simple in and out i guess i was looking for a single in then multi out.

@SurrealDB 5 месяцев назад

Whether its a dim or fact table depends on how you want to model your data. You can only have a single in and out for each query, but the table can have many in's and out's depending again on how you want to model your data.

@user-qr4jf4tv2x 4 месяца назад

@@SurrealDB i see so there not really a preferred way but only on the devs preference.. thank you

@AnimeZone247 Месяц назад

@@SurrealDBis there a way to subscribe to graphs, so I can get realtime notifications of database changes?

@SurrealDB Месяц назад

Hi @@AnimeZone247 , yes, you have three options for that. You can use a Live Query (surrealdb.com/docs/surrealdb/surrealql/statements/live), custom events (surrealdb.com/docs/surrealdb/surrealql/statements/define/event) or Change Feeds (surrealdb.com/docs/surrealdb/surrealql/statements/define/table#using-changefeed-clause).

@jeffg4686 5 месяцев назад

when do we get text-to-surrealql?

@SurrealDB 5 месяцев назад

Hi, thanks for your question. Text to surrealQL is not currently on our roadmap. But, you can checkout the awesome surreal repo where you can find most of SurrealDB’s community projects: github.com/surrealdb/surrealdb

@jeffg4686 5 месяцев назад

@@SurrealDB = wrong answer...