jtvjan's recent activity

  1. Comment on It’s time to get back into RSS in ~tech

    jtvjan
    Link
    I recently switched to Thunderbird for RSS. It's really nice having all your daily reads (mail, feeds, netnews) in one place.

    I recently switched to Thunderbird for RSS. It's really nice having all your daily reads (mail, feeds, netnews) in one place.

    4 votes
  2. Comment on Where do you get news specifically for your own country? in ~talk

    jtvjan
    Link
    I watch the 8 P.M. NOS (Dutch Broadcasting Foundation) news every day. They are required by law to be impartial, so I think it's good enough to be my main source of news. A not-so-fun fact: The 8...

    I watch the 8 P.M. NOS (Dutch Broadcasting Foundation) news every day. They are required by law to be impartial, so I think it's good enough to be my main source of news.

    A not-so-fun fact: The 8 P.M. news has been broadcasted uninterrupted every day since 1969, except on the 29th of January 2015, where it was replaced by the text 'Please wait', because a man with a fake pistol entered the studio building and demanded to be broadcast. Here is a video: https://youtu.be/dgyJ8nYzkME

    4 votes
  3. Comment on [RESOLVED] Create new SQLite database with PHP? in ~comp

    jtvjan
    Link Parent
    Sorry, I meant to say to write ':memory:' as a file name. An empty string instead creates a temporary on-disk database. This is mentioned in the PHP manual. The idea is that if this test succeeds,...

    I've never even heard of this before.

    Sorry, I meant to say to write ':memory:' as a file name. An empty string instead creates a temporary on-disk database. This is mentioned in the PHP manual. The idea is that if this test succeeds, we know that there's nothing wrong with the installation of PHP or SQLite.

    I don't know what you mean by 'world-writable' path.

    Every file on UNIX systems such as Mac OS X have three sets of permissions. One for the user owning the file, one for the group owning the file, and one for all users, called "world". Most directories are marked as readable and writable by their user and group, and only readable by everyone else. However, the /tmp/ directory is usually writable by everyone. If creating a database in that directory succeeds, we can check which user created it (the web server is ran as a special user for security resons), and then create a database in the proper location (e.g. /var/db/), owned by the web server user.

    5 votes
  4. Comment on [RESOLVED] Create new SQLite database with PHP? in ~comp

    jtvjan
    Link
    That snippet works fine for me on Debian. Does it work for you if you change mysqlitedb.db to an empty string to use an in-memory database? What about a world-writable path like /tmp/mydb.sqlite3?...

    That snippet works fine for me on Debian. Does it work for you if you change mysqlitedb.db to an empty string to use an in-memory database? What about a world-writable path like /tmp/mydb.sqlite3? If it does, that would indicate the user running the PHP scripts doesn't have permission to write to the current directory. See which user created that database using the command ls -l /tmp/mydb.sqlite3.

    6 votes
  5. Comment on What programming/technical projects have you been working on? in ~comp

    jtvjan
    Link Parent
    How are you going about learning it?

    How are you going about learning it?

    3 votes
  6. Comment on The laptop market is in an atrocious state in ~tech

    jtvjan
    (edited )
    Link
    Yup, dealing with Bumble "the OSS driver is slower than internal graphics but the proprietary driver segfaults" Bee is such a hassle, but I probably wouldn't be able to get reasonable battery life...

    And there’s an Nvidia optimus GPU, which is just, ugh.

    Yup, dealing with Bumble "the OSS driver is slower than internal graphics but the proprietary driver segfaults" Bee is such a hassle, but I probably wouldn't be able to get reasonable battery life otherwise.

    Edit: damn you autocorrect

    4 votes
  7. Comment on Is Catalina a good upgrade yet? in ~tech

    jtvjan
    Link Parent
    They had to keep using Bash 3.2 (2006) since versions after that are licensed under GPLv3. Zsh is licensed more permissively. There's a pretty big chance you won't have to update your...

    They had to keep using Bash 3.2 (2006) since versions after that are licensed under GPLv3. Zsh is licensed more permissively. There's a pretty big chance you won't have to update your documentation as Zsh has very similar syntax to Bash.

    8 votes
  8. Comment on Why it's already 2020 in ~misc

    jtvjan
    Link Parent
    There's an add-on called SponsorBlock which will automatically skip past ads. The timings for when ads start and end are crowdsourced. I've yet to come across a video where someone hasn't added...

    There's an add-on called SponsorBlock which will automatically skip past ads. The timings for when ads start and end are crowdsourced. I've yet to come across a video where someone hasn't added them already.

    7 votes
  9. Comment on Old mobile websites? in ~tech

    jtvjan
    Link
    Reddit has an even older version of their mobile site if you add .mobile to the end of your URL.

    Reddit has an even older version of their mobile site if you add .mobile to the end of your URL.

    16 votes
  10. Comment on <deleted topic> in ~tech

    jtvjan
    Link Parent
    FrancoKernel has the WireGuard module built-in. It's so fast that I tend to forget I have it turned on.

    FrancoKernel has the WireGuard module built-in. It's so fast that I tend to forget I have it turned on.

  11. Comment on Microbrowsers are everywhere in ~tech

    jtvjan
    Link
    What is a "progressive video experience"? Isn't streaming the only common way to deliver video on the web today?

    Use <meta property="og:video* with progressive (not streaming) video experiences.

    What is a "progressive video experience"? Isn't streaming the only common way to deliver video on the web today?

    4 votes
  12. Comment on Lost piece of gaming history uncovered in ~games

    jtvjan
    (edited )
    Link
    For context, here are the relevant parts from the previous two episodes: https://youtu.be/nB12ILnm5eM?t=428 https://youtu.be/CpVaMFQgGoQ?t=1407 The short clip shown around 8:20 looks way beyond...

    For context, here are the relevant parts from the previous two episodes: https://youtu.be/nB12ILnm5eM?t=428 https://youtu.be/CpVaMFQgGoQ?t=1407

    The short clip shown around 8:20 looks way beyond what NES hardware is capable of, so I think this is just going to turn out to be promotion for some retro-style platformer.

    edit: The game's developer is called Thom Glunt, he shared the game's boxart on Twitter. Also, a (subtitled) reaction video from a Russian YouTuber.

    3 votes
  13. Comment on Why is Instagram deleting the accounts of hundreds of porn stars? in ~tech

    jtvjan
    Link Parent
    Instagram + thot. Thot (that hoe over there) is derogatory slang meaning "promiscuous woman". It refers to women that post suggestive photos of themselves on Instagram.

    Instagram + thot. Thot (that hoe over there) is derogatory slang meaning "promiscuous woman". It refers to women that post suggestive photos of themselves on Instagram.

    5 votes
  14. Comment on Six ways Mario Kart Tour triggers you into gambling your money in ~games.game_design

    jtvjan
    Link Parent
    I would still call it pay-to-win as you can increase your chances of winning by paying. The further you get in the game the more points you need to get all five stars and to rank high. By paying...

    I would still call it pay-to-win as you can increase your chances of winning by paying. The further you get in the game the more points you need to get all five stars and to rank high. By paying you can obtain more gems, which allow you to "fire the pipe", and each time you do that there's a chance of getting a rare item with high base stats, which affect how many points you'll end up with at the end of a race. However, I wouldn't consider this problematic as the game is single player only, so you're really just paying for a chance to switch the game to easy mode. If these stats carry over to multiplayer when it comes out it would be, since then a paying player could win out over a more skilled player. (or in Mario Kart's case, a luckier player)

    2 votes
  15. Comment on [Request] Emacs/readline-like keys on text fields in ~tildes

    jtvjan
    Link
    I don't think Tildes should change or add keybindings for editing text. It would be better to implement this at the browser or add-on level.

    I don't think Tildes should change or add keybindings for editing text. It would be better to implement this at the browser or add-on level.

    16 votes
  16. Comment on Unofficial Weekly Discussion #4 - What is your most "thinking outside the box", "pie in the sky", and/or "out there" idea for Tildes? in ~tildes

    jtvjan
    Link Parent
    Maybe that could be implemented using PMs? If the user starts their comment with a slash, and then a bot's username, the comment is instead sent to the bot as a PM with a link to the comment or...

    Maybe that could be implemented using PMs? If the user starts their comment with a slash, and then a bot's username, the comment is instead sent to the bot as a PM with a link to the comment or submission it is in reply to. But there would probably have to be something in the UI indicating that it's going to do this, and a way to escape it.

    3 votes
  17. Comment on noclip.website - A website that lets you view famous levels from all kinds of games in 3D in ~games

    jtvjan
    Link Parent
    Yes. I remember playing the "dogfight" mode on that minigame a few months ago, but there's also an "island flyover" mode where you have to find all the points of interest.

    Yes. I remember playing the "dogfight" mode on that minigame a few months ago, but there's also an "island flyover" mode where you have to find all the points of interest.

    1 vote
  18. Comment on noclip.website - A website that lets you view famous levels from all kinds of games in 3D in ~games

    jtvjan
    Link
    I'm kind of worried about the legality of the site, since it hosts models and textures from games that are still copyrighted. Let's hope they'll let it slide. My favorite model has to be Wuhu...

    I'm kind of worried about the legality of the site, since it hosts models and textures from games that are still copyrighted. Let's hope they'll let it slide.

    My favorite model has to be Wuhu Island. You see bits and pieces of it when playing minigames in Wii Fit and Wii Sports Resort, but you never get to freely explore the full island. Being able to fly around lets you see all the details you'll never get to see with the prebaked camera angles in the games.

    9 votes
  19. Comment on Do you ride your local public transit system? in ~talk

    jtvjan
    Link Parent
    Could you rephrase your question?

    Could you rephrase your question?

    1 vote
  20. Comment on John W. Campbell Award Is Renamed After Winner Criticizes Him in ~books

    jtvjan
    Link
    It is now called the Astounding Award for Best New Writer, after the previous name of the Analog Science Fiction and Fact magazine (Astounding Stories of Super-Science). It was previously called...

    It is now called the Astounding Award for Best New Writer, after the previous name of the Analog Science Fiction and Fact magazine (Astounding Stories of Super-Science). It was previously called John W. Campbell Award for Best New Writer.

    2 votes