Background Info about the database in use

[Epiphanius]

What type of database is used?
What data volumes can still be handled with it?
Where are the most likely limitations?
Maximum size of a node?
How is a new sub-node implemented in the DB?
Thanks!

[m1k3s0]

Hi @Epiphanius, the database is sqlite so it has all of the limitations listed here: https://www.sqlite.org/limits.html. You can even query the database with other tools such as DB Browser for SQLite.

This is probably of interest to you:

Every database consists of one or more "pages". Within a single database, every page is the same size, but different databases can have page sizes that are powers of two between 512 and 65536, inclusive. The maximum size of a database file is 4294967294 pages. At the maximum page size of 65536 bytes, this translates into a maximum database size of approximately 2.8e+14 bytes (281 terabytes, or 256 tebibytes, or 281474 gigabytes, or 262143 gibibytes).

There is a node table in the CT database with a "txt" column for the content. The file type is TEXT which theoretically doesn't have a limit but by default it's set to 1 billion bytes.

Sub nodes are tracked in a "children" table where each row tracks the node ID and the parent node ID. I've attached the DB schema as a reference.
schema.pdf

[Epiphanius]

Great, yes, I could access my cherries with DB Browser. Thank you!

[m1k3s0]

@giuspen out of curiosity, why do attachments go in the image table?

[mockmock1]

IMHO it's a generic table used to contain PNG and attachments and avoid to create another table just for attachments.

[Epiphanius]

What are the benefits of using a database, wen you are only working with one dimension or one Datasheet?