Does this website have an "unlimited" database? I was wondering how long DMs, chat-logs, and questions are kept in the system. Does the old stuff get deleted after a certain time or does this website have a big enough database to store everything? If so really cool!

Question

ryley · Answer

For as long as i've been here most of my chats are still there, i don;t think they delete but i can check!

ryley · Answer

No they don't delete! i went and checked and i have chats in my backup acc from 5 months ago when i came here!

lawsontatianna · Answer

hi how are u doing  my  name is baby

NoodlesAndRiceYT · Answer

I have dms still from a year ago, they dont automatically delete in the system.

Echofire · Answer

I am sure the limit these servers or whatever stores data is astronomical.

Timmyspu · Answer

It does have a big enough data base. I am aware of this because if it did not there would have been questions and conversations in the dm's deleted by now. The dms they will stay there for as long as you have your account. So basically unlimited.

I would ask @angle if she gets on today or @ultrilliam because they were the onese who set all of that stuff up.

Ultrilliam · Answer

To answer the question, no the database isn't unlimited, however it does not delete any DMs or Questions or Chats. There is no auto-deletion because there is no need for auto deletion. Attachments to questions take up WAY more space than the database, after all. One thing that is true is that the more data there is, the slower specific data can be accessed without proper optimization, which I've put work into making sure is there. So all in all, if something were to be deleted, it would be attachments (which we've actually had to do in the past, we deleted all attachments larger than 20mb, many many years ago), but that seems unlikely now, while back then we had to contend with the cost of adding more storage space vs dealing with it short-term. Now we have a lot more space, and even a backup server incase anything ever goes wrong.

Ultrilliam · Answer

If you're curious on the more specifics of the database and how it interfaces with the website, lets use the example of the replies we are using now. A reply in the database consists of: DB ID, the Question ID it was posted under, the ID of the reply itself, the poster of the reply, the reply itself (in plaintext), the reply date, an array of attachment references (the DB does not store the attachment, but rather has a internal link to the attachment that gets turned into the link on the site), the users mentioned, and finally the drawings (The drawings are SVGs, which can be turned into plaintext by mathematical equations!). All of this data is then rendered onto the site in the form you see it in, but in the database it's all plaintext key-value's

Sherixn · Answer

@ultrilliam wrote:

If you're curious on the more specifics of the database and how it interfaces with the website, lets use the example of the replies we are using now. A reply in the database consists of: DB ID, the Question ID it was posted under, the ID of the reply itself, the poster of the reply, the reply itself (in plaintext), the reply date, an array of attachment references (the DB does not store the attachment, but rather has a internal link to the attachment that gets turned into the link on the site), the users mentioned, and finally the drawings (The drawings are SVGs, which can be turned into plaintext by mathematical equations!). All of this data is then rendered onto the site in the form you see it in, but in the database it's all plaintext key-value's

Okay, tysm!!! (: