SurrealDB

[girish]

@Odonno You should be able to create repos on gitlab now (under your name). Once it's pushed, can you let me know? I will then move it under the cloudron organization.

[Odonno]

I have created the project here https://git.cloudron.io/Odonno/surrealdb-app

I have started to write tests but I don't how it can work. I have this error for the first test...

[girish]

@Odonno It seems the license on the package is BSL. We try to keep the package source code as proper opensource licenses . Note that surrealdb itself can be BSL, this is not a problem. The license in the repo only on the license of the package. This allows us (cloudron team) to continue to provide updates to the package reliably.

[Odonno]

@girish Ok, this is done. As long as it does not violate the SurrealDB license, I suppose it's ok.

[girish]

@Odonno Ok, I have forked it into our namespace - https://git.cloudron.io/cloudron/surrealdb-app . You should also be a maintainer of the repo.

So, the next step, is to get the tests working . Then, we will take a look into getting it published. Thanks for all the work!

[Odonno]

@girish Thank you. I can write the required tests. I am just stuck with the first one in error...

[girish]

@Odonno The message is just saying, you have to run cloudron build first before you can run cloudron install . Maybe you changed the repo directory or something? When that happens, it "forgets" the previous cloudron build image information.

[Odonno]

@girish Ah yes, that explains why. I don't know how it keeps track of the correct docker image. I suppose there is a key-value store somewhere.

Well, I finished to write a pretty good set of e2e tests. I think it is ready. Thank you for your help.

[girish]

@Odonno indeed, the key value store is in ~/.cloudron.json

[Odonno]

@girish Good to know! So, what's the next step?

[girish]

@Odonno we will have to find the time to review and publish the package.

[Odonno]

Any update on this @girish ?

[girish]

@Odonno haven't found the time yet. We are still working on getting a few apps updated before we start looking into new ones.

[Odonno]

@girish Very good practice indeed.

I have updated to the latest release 1.2.0. Gonna need that really really soon. But I suppose I can stick with my currently built local docker image.

[Odonno]

Updated to 1.3.0

[Odonno]

Updated to 1.4.0

[Odonno]

Updated to 1.5.0

[LoudLemur]

Any news on this?

[girish]

I looked into this today. The file backend of surrealdb uses RocksDB - https://github.com/surrealdb/surrealdb/blob/bf702b0d67c63884dfa7fa567482858ce87315a5/lib/src/api/engine/any/mod.rs#L274C60-L274C67 . From what I have read, it is not safe to backups rocksdb by just using file copy . See https://github.com/surrealdb/surrealdb/issues/1681 and https://github.com/facebook/rocksdb/wiki/How-to-backup-RocksDB . This makes sense since it's a database .

I think we have to implement backup/restore flow into Cloudron to publish databases. This is why we also don't have PostgreSQL, MySQL, MongoDB etc as "apps" . Currently, there is no provision to backup and restore them when they are deployed as apps.

A separate issue is that this app has no real frontend . The app just redirects to surrealdb.com when clicked.

[Odonno]

Thank you for looking into this @girish

I have some questions/notes:

1. PocketBase is also a database. How is that you can support it and can't for other database?
2. Note that SurrealDB can run on SurrealKV, a custom-tailored KV store. I will try to make it work with backups if that's possible.
3. Yes, the main route is currently a redirect to the home page of the project website. We are currently working on embedding a web UI inside the db. So, this issue will be solved soon.

Will get back to you once everything is settled.