Staff Software Engineer, Back-end (Identity Engineering) at Affirm

Affirm is hiring Staff Software Engineer, Back-end (Identity Engineering)

The Go-based π—’π—Όπ—½π˜€ π—”π—΄π—²π—»π˜ is functional. You can get it and use it, but I still keep it in beta.

It handles zero-knowledge, end-to-end encryption so sensitive data never touches my servers.

Initial tests are successful. I’m moving into a heavy stress-testing phase. In this business, "it works" isn't enough. I’d rather delay a release than rush a "good enough" version. Reliability is the only metric that matters.

#buildinpublic #mongodb #postgresql #mysql #database #backup

πŸš€ **FromDual MyEnv 3.0.0 is LIVE!**

The ultimate multi-instance database environment just got better. Now with enhanced **PostgreSQL** support plus compatibility with the latest platforms:

βœ… Red Hat 10
βœ… Ubuntu 24.04
βœ… Debian 13
βœ… MySQL 8.4
βœ… MariaDB 11.8

Manage your **MariaDB, MySQL & PostgreSQL** instances like a pro.

πŸ“₯ **Download:** https://support.fromdual.com/admin/public/download.php

πŸ“– **Release notes:** https://www.fromdual.com/blog/myenv-release-notes/fromdual-environment-myenv-3.0.0-has-been-released/

#DatabaseManagement #MySQL #MariaDB #PostgreSQL #DevOps #OpenSource

πŸš€ **FromDual MyEnv 3.0.0 ist LIVE!**

Die ultimative Datenbankumgebung fΓΌr mehrere Instanzen ist jetzt noch besser. Mit verbesserter **PostgreSQL**-UnterstΓΌtzung und KompatibilitΓ€t mit den neuesten Plattformen:

βœ… Red Hat 10
βœ… Ubuntu 24.04
βœ… Debian 13
βœ… MySQL 8.4
βœ… MariaDB 11.8

Verwalten Sie Ihre **MariaDB-, MySQL- und PostgreSQL-**Instanzen wie ein Profi.

πŸ“₯ **Download:** https://support.fromdual.com/admin/public/download.php
πŸ“– **Installationsanleitung:** https://support.fromdual.com/documentation/myenv/myenv.html#installation-guide
πŸ“– **Release notes:** https://www.fromdual.com/blog/myenv-release-notes/fromdual-environment-myenv-3.0.0-has-been-released/

#Datenbankverwaltung #MySQL #MariaDB #PostgreSQL #DevOps #OpenSource

Database Workbench - the new Data Type Assistant

YouTube

We have moved now our #MyEnv repository from #GitHub to #Codeberg. Let's see how it is there...

https://codeberg.org/FromDual/MyEnv

MyEnv is our environment to run and operate several #MariaDB, #MySQL or #PostgreSQL database instances on the same machine (multi-instance-set-up).

MyEnv

FromDual myEnv is an environment to run and operate several MariaDB, MySQL or PostgreSQL instances on the same machine. More details you can find here: https://www.fromdual.com/software/fromdual-myenv/

Codeberg.org

The wp_usermeta table is a good example of how not to use a tabular #database like #MySQL. Please do not design your #databases this way.

If you or an add-on to your software needs to add more data fields, the correct way to do so is to either ALTER TABLE ADD COLUMN or (for add-ons that don't wish to disturb the core application's tables) to CREATE a related TABLE (perhaps in a separate schema, if using a database like #PostgreSQL that supports such a notion).

#WordPress #programming

How to Avoid Leading Wildcards That Kill Indexes

LIKE '%text' forces a full table scan.

#mysql #like #index #performance #howto #search

https://www.youtube.com/watch?v=HYdQSccv-AI

How to Avoid Leading Wildcards That Kill Indexes #howto

YouTube
totday I will be testing what happens if you tel #SqlAlhemy to add a record to #MySql that already exists. Or adds that same record with one extra keyValue pair.
#linux
It doesnt say in the docs, or I couldnt find it
#sql