Skip Navigation

User banner

Otto

@ otto @programming.dev

Posts
54
Comments
27
Joined
2 yr. ago

  • Stop using MySQL in 2026, it is not true open source

    Jump

  • Could the XZ backdoor have been detected with better Git and Debian packaging practices?

    Jump

  • There was a bunch of luck involved that Andres Freund detected this. Give more time, it would have ended up in stable releases eventually if not detected.

  • Fireship’s latest vid spreading the Linux desktop to 500k+ viewers

    Jump

  • Exactly. I don't use Omarchy, but I think it is good someone did a polished distro for a specific use case, and some web dev Windows users will surely find it more appealing than a generic distro where they need to figure out a lot of stuff from scratch.

  • Linux @lemmy.world
    Otto @programming.dev

    Fireship’s vid about Omarchy spreading the Linux desktop to 500k+ viewers

  • Linux @programming.dev
    Otto @programming.dev

    Fireship’s latest vid spreading the Linux desktop to 500k+ viewers

  • Selfhosted @lemmy.world
    Otto @programming.dev

    Zero-configuration TLS and password management best practices in MariaDB 11.8

    optimizedbyotto.com /post/zero-configuration-tls-mariadb-11.8/

  • Which open alternative apps list is the best?

    Jump

  • To me it is hard to find the best apps in their directory as they don't have a good ranking system. The other sites that rank by GitHub stars do a pretty good job of surfacing what are the truly most popular and successful apps.

  • MariaDB 11.8's zero-configuration TLS requires no manual setup

    Jump

  • TLS is good *only' if you are also validating those certs. And that is what MariaDB 11.8 is now doing.

  • Selfhosted @lemmy.world
    Otto @programming.dev

    Which open alternative apps list is the best?

  • Sysadmin @lemmy.world
    Otto @programming.dev

    MariaDB 11.8's zero-configuration TLS requires no manual setup

    optimizedbyotto.com /post/zero-configuration-tls-mariadb-11.8/
  • Web Development @programming.dev
    Otto @programming.dev

    MariaDB Cloud launched with "Serverless tier is free forever for experimenting and small development projects"

    mariadb.com /products/cloud/

  • I got hooked on browsing openalternative.co is "Most Popular" list

    Jump

  • I got hooked on browsing openalternative.co is "Most Popular" list

    Jump

  • I got hooked on browsing openalternative.co is "Most Popular" list

    Jump
  • Selfhosted @lemmy.world
    Otto @programming.dev

    I got hooked on browsing openalternative.co's "Most Popular" list

    openalternative.co
  • Technology @lemmy.world
    Otto @programming.dev

    I got hooked on browsing openalternative.co is "Most Popular" list

    openalternative.co
  • Technology @lemmy.ml
    Otto @programming.dev

    I got hooked on browsing openalternative.co is "Most Popular" list

  • MariaDB / MySQL @programming.dev
    Otto @programming.dev

    How to use new PARSEC password authentication method in MariaDB?

  • MariaDB / MySQL @lemmy.ml
    Otto @programming.dev

    How to use new PARSEC password authentication method in MariaDB?

  • MariaDB 11.8 LTS Released

    Jump

  • "Unicode as default character set" - finally, nice!

  • MariaDB 11.8 LTS is now officially available (GitHub Link)

    Jump

  • MariaDB 11.8 LTS is now officially available

    Jump

  • MariaDB 11.8 LTS released, has vector support, automatic TLS and more

    Jump

  • What do users of MariaDB in Debian want to see in future versions?

    Jump

  • Stategies for scaling out MySQL/MariaDB when database gets too large for a single host?

    Jump

  • I am asking for general strategies, not for a solution to a specific case.

  • What to do when a MySQL/MariaDB database gets too large for a single host?

    Jump

  • By UV 3000 you probably don't mean the ultraviolet lamp that is the first page of Google is full of when searching with this term..? I doubt UV - whatever it is - is a common approach.

  • What do users of MariaDB in Debian want to see in future versions?

    Jump

  • What do you mean a default user? You can just run 'mariadb' to access to console with the same user that had permissions to run 'apt install'.

    For your actual application you need to plan what database name to use, what user, what permissions it needs, potentially remote connection and TLS etc. This indeed is some work and could perhaps be automated a bit, but it also needs sysadmin to make some decisions.

  • What do users of MariaDB in Debian/Ubuntu want to see in future versions?

    Jump

  • Yes, increasing the InnoDB buffer pool to use all available memory is the most important configuration change a sysadmin can do. But in order to do it, you need to know if the host is dedicated to one MariaDB instance or if there are multiple servers on the same host. Otherwise you would just have processes each hogging more memory when they can and not giving it up to others.

    I could think about having a dialog during the installation that asks something like "Is host dedicated to this MariaDB instance? If yes, automatically configure it to use most of the system RAM available."

  • What do users of MariaDB in Ubuntu want to see in future versions?

    Jump

  • MariaDB supports Galera clustering out-of-the-box, and also traditional primary/replica setups. But you need to have something that spans multiple hosts to monitor and manage it, and that is outside of what a single-host OS package management system can do.

  • What local LLMs are you using to create embeddings for RAG?

    Jump

  • You mean ollama? There are so many options, any favorites?