tmat256

joined 1 year ago
[–] [email protected] 11 points 2 months ago (1 children)

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

[–] [email protected] 6 points 3 months ago

American Chestnut. Have a few seedlings we planted in the front yard. Super excited to be part of the process of restoring them

[–] [email protected] 7 points 3 months ago (1 children)

I have these for some raspberry pis around the house and they work great: https://www.adafruit.com/product/3785

[–] [email protected] 7 points 3 months ago

Going home and relaxing. It's been a physically demanding week and my body could use a break

[–] [email protected] 7 points 4 months ago

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

[–] [email protected] 4 points 4 months ago (1 children)

The second icon looks like the Kirac vault pass rewards one. You have to open the chest in the vault for that to go away. Not sure about the first one though.

[–] [email protected] 10 points 5 months ago (1 children)

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.

[–] [email protected] 1 points 5 months ago

It's a work provided device. It was either that or Windows, so it was really the only option. I might try out some tiling options for it, not sure how upset IT will be about that though...

[–] [email protected] 3 points 5 months ago

It's also incredibly useful as a failsafe in a helper method where you need the argument to be a string but someone might pass in something that is sort of a string. Lets you be a little more flexible in how your method gets called

[–] [email protected] 3 points 5 months ago

Couldn't you use painter's tape? Unless your glue joint is thin, it won't matter if some of the oil seeps past the tape. Pre-finishing is way easier than finishing after final assembly.

[–] [email protected] 18 points 5 months ago (4 children)

I spent years using i3 as my main machine and I loved everything about it. Fast forward to now where I have to use a Mac. Most of the time I'm in a terminal with tmux so it's fine but any time I have to deal with a gui element that is under something else I get more and more upset.

[–] [email protected] 7 points 6 months ago

I've had buttons stop working. The mechanism inside that registers the click is a mechanical switch and they eventually die

view more: next ›