Database Data Storage

I’m creating an MDT (mobile data terminal), which is a system that allows a police officer to view data about a certain player.

Such data may include:

  • name
  • account age
  • user ID
  • license plates/owned cars

I could either use Trello as a database and retrieve information from there, or I could use datastores.


Trello

Pros

  1. Easily accessible offline
  2. Actual interface to work with

Cons

  1. Harder to add new entries (i.e. if someone commits two crimes, how do I handle that? Add “case IDs”? Add comments to player cards?)
  2. Not scalable – large boards with high card counts lag quickly

DataStores

Pros

  1. Easier to scale
  2. No need to make calls to the Trello API or create a bot account to access boards (security concern)

Cons

  1. Not accessible offline

I’m seeking advice on what others think will work best for the MDT. I look forward to all suggestions, and will consider all of them.

From experience, databases are always meant to be accessed online because having an accurate offline database could be extensive in terms of storage if your game would become famous in the future. Also do note that Trello is not meant for data storage and should not be used to replace actual database services. I could see a potential discord integration, however this is also not a platform for these kinds of use cases and may lead to discord account termination.

You’re better off using the data store service provided by roblox or other data storage services that are reliable and do not have severe Http limitations. Please note that external database services are not free and you’d have to settle that concern on your end.

Another option you could go for is your own database in your home, this is completely under your control and you may customise to your desire, however this would require maintenance and usually costs several thousands to keep up in the long run. I don’t know anyone who has resorted to this, I’d only recommend this to devoted developers who have knowledge on web development as creating the environment is quite complex.

3 Likes

Trello is not a database, use datastores

5 Likes