Base

Today I finally caved and purchased the full version of Base, a SQLite database editor for Mac. It's by no means cheap, but after just having used ChatGPT to update a table schema manually via the sqlite3 CLI, I was fed up when I realized I had to to it all again once more, on another table. Bought the In-App Purchase and did it in the GUI app in 1 minute. Can't say it felt great forking over almost €35, but I hope it'll be of use in the future. After all, I convert almost all of my […]

https://oelna.de/blog/4630

Base – oelna.de

The Oops Agent is done. Im finishing up final testing.
It provides true zero-knowledge end-to-end encryption.
Data is encrypted at the source before it ever touches the network.
Even if we were compromised, your data is secure.
#database #buildinpublic #mongodb #postgresql #mysql

How to Prevent UTF8MB4 From Truncating Indexes

Long utf8mb4 keys can exceed index limits.

#mysql #utf8mb4 #index #howto #schema #bug

https://www.youtube.com/watch?v=H8_KHnIP7zk

How to Prevent UTF8MB4 From Truncating Indexes #index

YouTube

How to Delete MySQL Database and User on Ubuntu Linux

The post is a tutorial showing how to delete old MySQL databases and associated user accounts via the Ubuntu command line, a task particularly relevant for those managing websites with content management systems like WordPress. It underlines the permanence and potential risk of these actions and provides step-by-step commands for both dropping databases and user accounts.

https://geekrewind.com/wordpress-tips-removing-mysql-database-and-user-on-ubuntu-16-04-18-04/

Eloquent Guard: как ловить N+1 и медленные запросы в Laravel, не зарываясь в vendor

Проблема N+1 стара как мир. Инструментов много: Debugbar хорош локально, Telescope тяжеловат для продакшена. Мне хотелось решения, которое будет «стучать» в Slack или Telegram именно тогда, когда проблема случилась на проде, и при этом сразу показывать пальцем на виновную строку кода.

https://habr.com/ru/articles/1010822/

#laravel #eloquent #php #sql #mysql #postgresql #database_optimization #database_performance #database_monitoring

Eloquent Guard: как ловить N+1 и медленные запросы в Laravel, не зарываясь в vendor

Проблема N+1 стара как мир. Инструментов много: Debugbar хорош локально, Telescope тяжеловат для продакшена. Мне хотелось решения, которое будет «стучать» в Slack или Telegram именно тогда, когда...

Хабр
UPNP-Server erscheint nicht in VLC › Serverdienste und Dateifreigaben im Netzwerk › Fortgeschrittene Themen › Forum › ubuntuusers.de

How to Install #MySQL 8 on #VPS Server

This article provides a guide for how to install #MySQL 8 on VPS server.

Database Management Systems (DBMSs) are applications designed to store and organize data in an organized fashion, usually as part of an e-commerce or data warehousing application.

One such DBMS is MySQL, an open-source and highly scalable free DBMS that's free and open source; we will cover ...
Continued 👉 https://blog.radwebhosting.com/install-mysql-8-on-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #selfhosting #selfhosted #opensource #database

SMB4K Cloud Server einbinden › Serverdienste und Dateifreigaben im Netzwerk › Fortgeschrittene Themen › Forum › ubuntuusers.de

Effekt bei der Verwendung von Windows-Freigaben › Serverdienste und Dateifreigaben im Netzwerk › Fortgeschrittene Themen › Forum › ubuntuusers.de

How to Prevent Full Table Scan on Partitioned Tables

Missing partition key = scan all.

#mysql #partition #fullscan #performance #howto #query

https://www.youtube.com/watch?v=RYWiIYKHBy0

How to Prevent Full Table Scan on Partitioned Tables #partition

YouTube