Search results

  1. matja

    Bash to search a csv for numbers and copy to a new file?

    sqlite3 script that'll work on any OS: .import 2.csv t2 --csv create table t1(id text); .separator ~ .mode line .import 1.txt t1 .mode csv .output output.csv select t2.* from t2 inner join t1 on t1.id = t2.numbercolumn;
  2. matja

    I need help migrating away from Google Workspace (legacy G Suite) into a regular Gmail :(:(:(

    For Gmail: https://github.com/GAM-team/got-your-back/wiki#Introduction - backup as one user, restore to another user For Drive (including Sheets/Docs) : * Copy: rclone.org * Transfer: folder > share as editor, then transfer ownership The others I don't know - do a Takeout first so you at least...
  3. matja

    How to connect to a ups iec outlets

    You can get multi-way sockets and adaptors with a C14 plug that will connect to most UPS's. Most UPS manufacturers make them too, I have some from APC. Search for "IEC C14 to UK socket"
  4. matja

    XGamma changes, how do I make them last?

    Create a .desktop file in ~/.config/autostart which runs the command you want. cat > ~/.config/autostart/xgamma.desktop [Desktop Entry] Type=Application Name=xgamma Comment=xgamma Exec=xgamma -gamma 1.5 StartupNotify=false Terminal=false Hidden=false (ctrl-D) Most desktop environments have a...
  5. matja

    ASUS 42" ROG Swift PG42UQ

    This makes me laugh about the monitor - huge monitor, tiny little crevice to put all the connectors in. I wonder if the bent cables and wonky connectors are most of people's problems with image corruption, good point.
  6. matja

    Best 10 Gb RJ45 NIC for PCIe x4?

    The best ones are those that work flawlessly, and they're X550 and Mellanox ConnectX-4/5/6 - in my experience :) The Mellanox SFP28 ones are nice - upgrading to 25GBASE-SR later is 40 quid tops for the module.
  7. matja

    ASUS 42" ROG Swift PG42UQ

    Came with V021 , upgraded to V023 after a few days, didn't notice a difference, both worked perfectly for me.
  8. matja

    Asus ROG Swift OLED PG42UQ : Major flaw. Question for owners

    Yeah considering I only just noticed it, and even when I did notice it, I thought it was just because of me squinting (which has a similar effect :D ) - I'm still perfectly happy with the monitor and not going to return it, but I might do the test again before the warranty expires ;)
  9. matja

    Asus ROG Swift OLED PG42UQ : Major flaw. Question for owners

    My PG48UQ does it too, I only noticed it after watching your video and replicating the similar bright scrollbar. Only just noticeable for me on a dark background, not pure black. video
  10. matja

    ASUS 42" ROG Swift PG42UQ

    If anyone has any issues might be a good idea to start a shared Google Sheet or something to collect data points of the issues, including res/frequency/GPU/OS etc, to see if there are any factors in common. Strangely, I haven't noticed the screen refresh message popup any more, I did switch...
  11. matja

    How to clone a Linux system.

    I'd try in a VM with a pair of virtual disks first, to see how it works out first :) sgdisk is part of the gptfdisk package on my distro, not sure about Fedora. It does non-interactive GPT partitioning, useful in scripts. "gdisk" is the interactive version (like fdisk, but more GPT options)...
  12. matja

    How to clone a Linux system.

    Assuming GPT+UEFI boot with default loader path, my usual approach is : source_disk=/dev/sda destination_disk=/dev/sdb # copy GPT partition table sgdisk --replicate=${destination_disk} ${source_disk} sgdisk --randomize-guids ${target_disk} # for every mountpoint of a "real" filesystem findmnt...
  13. matja

    ASUS 42" ROG Swift PG42UQ

    Just left/right side, and corners. No top/bottom option. Just checked the manual - yeah you're right, there's not much there. I made some photos: "PIP/PBP Mode" : * full screen (off) * any corner * side by side (left/right) "PIP/PBP Source" : each part can be any input "Color...
  14. matja

    ASUS 42" ROG Swift PG42UQ

    I used it for a few hours just to see what it was like. Desktop on HDMI and laptop on DisplayPort. PIP: Can change the scaling between a few different sizes. Text is unreadable when its small unless the resolution is also small, not a fault of the monitor of course, but the scaling seems to be...
  15. matja

    ASUS 42" ROG Swift PG42UQ

    My PG48UQ was delivered to Ireland in perfect condition two weeks ago, loving it so far. I wasn't sure if the size would work for me, but having it further away than my old 27" certainly seems easier on the eyes when staring at work all day. Viewing angles are amazing, no colour/brightness...
  16. matja

    In Google Cloud SQL, how can you figure out a date difference?

    * It's `DATE_DIFF`, not `DATEDIFF` (reference: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_diff) * You need to specify what units to return, usually will be `DAY`. The rest looks ok in your query, so I'd guess this should work: SELECT date, DATE_DIFF(date...
  17. matja

    Your CPU History Tree

    MOS 8501 (Commodore 16) Zilog Z80 (ZX Spectrum) Intel 8086 8 MHz (Amstrad PC1512) Intel 80386 SX 16 MHz (Packard Bell 316SX) AMD K6-200 ALR (my first custom build) AMD Athlon Thunderbird AXIA 1000 Intel Pentium Prescott HT 540 3.2 GHz AMD Opteron 170 (40% overclock, with CL2(!) DDR) Intel Core2...
  18. matja

    How to take a full length screenshot of a PDF?

    Quite simple in Linux/*BSD with pdftoppm (poppler) and montage (imagemagick): INPUT_PDF=in.pdf OUTPUT_IMAGE=out.png PIXELS_WIDE=1000 PAGES_WIDE=1 pdftoppm "${INPUT_PDF}" temp montage temp*.ppm -tile ${PAGES_WIDE}x -geometry ${PIXELS_WIDE}x "${OUTPUT_IMAGE}"
  19. matja

    Does Lubuntu 20.04 support SSD?

    Any OS that supports SATA/NVMe will "support SSD" - it has no way to know it's running on a SSD unless it asks for SSD-specific features. You might be thinking of TRIM support which is a feature introduced and used by SSDs - but that doesn't affect free space allocation in a filesystem, it's an...
  20. matja

    Error404 redirect to specific folder depending on current page?

    Which webserver? In nginx this appears to work for me: location ~ ^/(?<dir>.*)/(?<page>[^/]+\.php)$ { try_files /$dir/$page /$dir/index.php =404; include fastcgi_params; } edit: An alternative that works for any server might me to use the "Front Controller Pattern" to redirect all...
Back
Top Bottom