RDBMS databases

Hi,

This is my first post here so forgive my silliness.
Can I use Squidex with RDBMS databases (ex. MSSQL or MySQL)?

Using MongoDB isn’t the best option for me because I want to use Squidex in my projects as a backend instead of inventing the wheel and create a new website whenever I want.

It is not possible yet, but there is a task for that: https://trello.com/c/UZYDfNTw/20-support-for-other-databases

1 Like

@Sebastian i think this is useful too, any plans to have this as a feature request soon ?

Hi abomani.

I don’t know yet. Fortunately there are not so many stores and repositories that need to be handled, but I see two problems.

  1. How to translate all the deep queries for the content database to RDMS/SQL?

  2. I need somebody to really care about SQL implementation. The cloud is running with MongoDB and I see errors relatively soon, but this would not be the case with SQL. Either somebody has to take care or we need very good integration tests.

@Sebastian i know it’s a pain, not easy to implement as this implementation require having a deep understanding of Squidex Architecture and it’s data layer.

Where can i have a look into the data layer that are using deep queries ?

Most repositories are very easy, except the ContentRepository: https://github.com/Squidex/squidex/blob/master/src/Squidex.Domain.Apps.Entities.MongoDb/Contents/MongoContentRepository.cs

I am working on a refactoring of the query system. The new system translates OData queries to a custom format, which is much, much easier to handle. Should be very valuable for this task.

Sorry i was traveling, i just looked into ContentRepository but i have no experience with mongodb so it would be very hard for my self to help in translating it.

I am working on a refactoring of the query system
your doing a great job mate, squidex is getting more enterprise.

What is Enterprise? :smiley:

Btw: The refactoring is ready