• 0 Posts
  • 17 Comments
Joined 1 year ago
cake
Cake day: October 10th, 2023

help-circle

  • How are you planning on querying the data? I would plan your columns and indexes based on that answer. I’m going to assume arbitrary time ranges.

    Just indexing a standard datetime column should be sufficient but that’s going to depend on a few things. Like you’re not accessing date ranges 10,000 times per second (website data source). Or you’re not inserting 100,000 records per second. Even then you might be able to get away with it if you want to throw more hardware at it.

    The answer to most of database design questions at larger scales depends on the scale. If you need to query this date once for a report you do it in a spreadsheet. If you are building the next Facebook api then you shard the crap out of it into a time series database and add layers of caching.

    My suggestion is to build it simple first and test. Don’t make assumptions about scale before you have data to back it up…







  • A lot of this is personal preference but I will suggest the following strategy. Mount all of your drives into subfolders of /mnt or /media (/mnt is usually used for more permanent storage but either is fine). Then symlink various folders on the system to this mount point. Like maybe you want your home folder downloads on one of these drives so /home/spawnsalot/Downloads is symlinkef to /mnt/drive1/Downloads.

    This lets you pick and choose various places across your system that are actually on the additional drives but also the ability to see everything on the drives in one place.

    Game installation location completely depends on the game itself. Some might install to /usr/bin, others to /opt, etc. You might have to dig around a little after install, move the folder, then symlink it like nothing ever happened.










  • If it were me and I was intending to automate this I would probably do the following. Set up each test distro as a VirtualBox image and take a snapshot so I could easily roll back. Then I would write a script for each distro that downloaded the package, installed and launched the app. I would then probably query the window system to make sure the gui showed up, wait a period of time if I had to and take a screenshot.

    This can probably all be done as a set of bash scripts.