• 0 Posts
  • 27 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…





  • My workflow for editing css mostly revolves around playing around with the live css directly in the browser until it looks the way I want it to then making those changes in the file and reloading to make sure it’s correct. The immediate feedback of seeing the changes happen makes it rather pleasant



  • 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.