Ringo De Smet · @ringods
153 followers · 270 posts · Server hachyderm.io
Rick Wong – Tech & code  · @ryguw
170 followers · 232 posts · Server fosstodon.org
Critical Silence · @CriticalSilence
1 followers · 26 posts · Server social.tchncs.de

It was surprisingly fast done to get this little fella talking to my . Now two of them are up and send encoded humidity and temperature.
And I am stucking since hours at this stuff getting it right into database. Better not to start a war, but I really dont like python.
So much code, so small knowlegde...

#esp01 #raspberry #json #python #mysql

Last updated 1 year ago

Matt Stenson · @matts
89 followers · 343 posts · Server mstdn.social

RDS now supports blue/green deployments. This should make upgrading servers from mysql 5.7 to 8.0 much easier.

docs.aws.amazon.com/AmazonRDS/

#RDS #mysql #AWS

Last updated 1 year ago

gresakg · @gresakg
4 followers · 23 posts · Server social.vivaldi.net

Has anyone ever thought of putting some order in queries? To insert one post in , wordpress does more than 100 sql queries. I've seen queries with litteraly 1000s of items in the IN clause! I allways knew it was bad, but I couldn't imagine it's that bad

#wordpress #sql #bbpress #php #mysql

Last updated 1 year ago

Mathew Attlee · @codeinabox
41 followers · 122 posts · Server hachyderm.io

In trying to port an existing site that utilised date functions including MONTH and YEAR over to the ORM, I am finding the latter is not so great at querying by date judging by issues such as this, which despite all the requests for it is still open after two years github.com/prisma/prisma/issue

#mysql #prisma

Last updated 1 year ago

Mike :nixos: · @codemonkeymike
750 followers · 1853 posts · Server fosstodon.org

Calling all / / web devs.

Dashboards for really busy accounts are painfully slow.. (like 20 seconds plus)

I assumed it was database (and i'm sure it partly was), but even after I aggressively cached queries, i'm still getting slow page loads even with 0.5 seconds of DB.

Other accounts are fine. What should I test?

#php #mysql #CodeIgniter

Last updated 1 year ago

AskUbuntu · @askubuntu
231 followers · 1776 posts · Server ubuntu.social

Install specific PHP version on Ubuntu 22.04

askubuntu.com/q/1484599/612

#server #apache2 #mysql #php

Last updated 1 year ago

DSP · @dsp
2 followers · 12 posts · Server india.goonj.xyz

Forget My S.Q.L and My Sequel. I call it `My School` Database!!!

#mysql

Last updated 1 year ago

· @laravista
14 followers · 255 posts · Server mastodon.melroy.org
:rss: gihyo.jp · @gihyo
25 followers · 96 posts · Server rss-mstdn.studiofreesia.com
Major Hayden 🤠 :prami: · @major
1462 followers · 122 posts · Server social.lol

A fateful move from MariaDB to MySQL for my Ghost blog put me on a path to a database collation train wreck. 😱

Here's how I diagnosed it, engaged upstream developers, and eventually figured out it was my problem all along:

major.io/p/ghost-db-migration-

#ghost #blog #mariadb #mysql #database

Last updated 1 year ago

Elix · @elix
1 followers · 17 posts · Server witter.cz

Po letech, po dlouhých letech mi něco v přestalo fungovat... Nejen, že mi nejde nahodit nejde ani server, ve /var/log zmizeli logy... Ale jsem rád, je to poprvé po dlouhých letech. Konečně můžu řešit, že něco nefunguje 😏😁

#linux #apache2 #mysql

Last updated 1 year ago

ティー · @tea33331
4 followers · 19 posts · Server mstdn.jp
:rss: gihyo.jp · @gihyo
25 followers · 85 posts · Server rss-mstdn.studiofreesia.com
PolyScale · @polyscale
1 followers · 17 posts · Server fosstodon.org

Have a use case that requires multiple cache configurations for the same database? PolyScale now supports multi-cache invalidation. docs.polyscale.ai/how-does-it-

#postgresql #postgres #mysql #caching

Last updated 1 year ago

JR · @jriou
42 followers · 10 posts · Server hachyderm.io

Since 8.0.27, a new Group Replication communication stack has appeared 🛸

Until this version, Group Replication used its own protocol and port (33061) to talk to other nodes: XCOM.

After this version, the recommended stack is MYSQL which uses the same port and protocol as clients.

Since MySQL Shell 8.0.30, the MYSQL communication stack is now the default option to create an InnoDB cluster ⚠️

dev.mysql.com/doc/mysql-shell/

#mysql

Last updated 1 year ago

partizan · @partizan
169 followers · 13836 posts · Server mstdn.social

Anyone using -allauth with , please note this issue when upgrading to latest allauth version.

github.com/pennersr/django-all

#mysql #Django

Last updated 1 year ago

Sebastian Helzle · @sebobo
68 followers · 484 posts · Server neos.social

Spent more time than expected to optimize COUNT queries in in the last two weeks.
This was very surprising to me as I mostly work with and .
But I achieved a speed-up of 150-550% in parts of my customers application with small adjustments and not using the ORM.
Happy but somehow also disappointed that this is necessary.

Here is one blog post I found that explains some of the reasons and solutions:
cybertec-postgresql.com/en/pos

#PostgreSQL #mysql #mariadb #neoscms

Last updated 1 year ago