Sigmoid Social

Mehmet Hakan SatmanMySQL Shell for VS Code (from Oracle) works like a charm!It's very easy to create SQL notebooks<a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> <a href="https://fosstodon.org/tags/VSCode" class="mention hashtag" rel="nofollow noopener" target="_blank">#VSCode</a> <a href="https://marketplace.visualstudio.com/items?itemName=Oracle.mysql-shell-for-vs-code" rel="nofollow noopener" translate="no" target="_blank">https://marketplace.visualstudio.com/items?itemName=Oracle.mysql-shell-for-vs-code</a>

AskUbuntuZoneminder installation error <a href="https://ubuntu.social/tags/softwareinstallation" class="mention hashtag" rel="nofollow noopener" target="_blank">#softwareinstallation</a> <a href="https://ubuntu.social/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#mysql</a> <a href="https://ubuntu.social/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://ubuntu.social/tags/zoneminder" class="mention hashtag" rel="nofollow noopener" target="_blank">#zoneminder</a><a href="https://askubuntu.com/q/1554647/612" rel="nofollow noopener" translate="no" target="_blank">https://askubuntu.com/q/1554647/612</a>

CubeRootOfTrue<a href="https://mathstodon.xyz/@MartinEscardo" class="u-url mention" rel="nofollow noopener" target="_blank">@MartinEscardo</a> This is true. I'm suggesting that this is not just a computer engineering thing. I'm saying that at base, nature itself is non-binary, and we are non-binary, and we abstract things we don't understand into black and white distinctions to make them easier to understand. It's fast and efficient to ignore certain problems. There are still problems with binary logic.Did you know that SQL is one of the few computer languages to use 3-valued logic? Databases are highly exposed to the problems of inconsistent or missing information. But we can use binary logic to simulate 3-valued logic (MySQL uses the paraconsistent logic LP by Graham Priest, but you can use that to create a fully relevant implication as in RM3, it's just a longer expression)<a href="https://mathstodon.xyz/tags/rm3" class="mention hashtag" rel="nofollow noopener" target="_blank">#rm3</a> <a href="https://mathstodon.xyz/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#mysql</a> <a href="https://mathstodon.xyz/tags/relevance" class="mention hashtag" rel="nofollow noopener" target="_blank">#relevance</a> <a href="https://mathstodon.xyz/tags/paraconsistent" class="mention hashtag" rel="nofollow noopener" target="_blank">#paraconsistent</a>

BLACKVOID ⚫️Doing a test <a href="https://mastodon.social/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#mysql</a> to <a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> migration for my <a href="https://mastodon.social/tags/mattermost" class="mention hashtag" rel="nofollow noopener" target="_blank">#mattermost</a> instance. No pressure…With version 11, that will be mandatory so might as well do it now. Nothing like running migration tools in <a href="https://mastodon.social/tags/docker" class="mention hashtag" rel="nofollow noopener" target="_blank">#docker</a> as well ;). Let’s see how this will end up. <a href="https://mastodon.social/tags/chat" class="mention hashtag" rel="nofollow noopener" target="_blank">#chat</a> <a href="https://mastodon.social/tags/selfhosting" class="mention hashtag" rel="nofollow noopener" target="_blank">#selfhosting</a> <a href="https://mastodon.social/tags/selfhosted" class="mention hashtag" rel="nofollow noopener" target="_blank">#selfhosted</a>

LinuxiacMariaDB 12.0 open-source RDBMS is out, fixing InnoDB and replication issues, while adding Fedora 42, RHEL 10, and Debian 13 package support. <a href="https://linuxiac.com/mariadb-12-0-lands-with-innodb-fixes-and-expanded-platform-support/" rel="nofollow noopener" translate="no" target="_blank">https://linuxiac.com/mariadb-12-0-lands-with-innodb-fixes-and-expanded-platform-support/</a><a href="https://mastodon.social/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#mariadb</a> <a href="https://mastodon.social/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#mysql</a> <a href="https://mastodon.social/tags/opensource" class="mention hashtag" rel="nofollow noopener" target="_blank">#opensource</a> <a href="https://mastodon.social/tags/rdbms" class="mention hashtag" rel="nofollow noopener" target="_blank">#rdbms</a> <a href="https://mastodon.social/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#databases</a>

Tokyo Outsider (337ppm)2/2 ...The top of the exported file has these lines: CREATE DATABASE IF NOT EXISTS `databaseName` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */; USE `databaseName`;If I change "databaseName" to a different name, is that enough for it to restore everything from the export file to a new database of a different name?<a href="https://mas.to/tags/backups" class="mention hashtag" rel="nofollow noopener" target="_blank">#backups</a> <a href="https://mas.to/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#databases</a> <a href="https://mas.to/tags/InnoDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#InnoDB</a> <a href="https://mas.to/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> <a href="https://mas.to/tags/MySQL8" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL8</a> <a href="https://mas.to/tags/MySQLworkbench" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQLworkbench</a>

Andrii Kuznietsov🛢️ MyDumper - інструмент для резервного копіювання баз даних MySQL з підтримкою багатопоточності та узгоджених бекапів.Ключові можливості: 🔸mydumper - експорт узгоджених резервних копій <a href="https://social.kyiv.dcomm.net.ua/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> 🔸 myloader - швидкий багатопоточний імпорт бекапів 🔸 Оптимізована робота з великими базами даних🔗 <a href="https://github.com/mydumper/mydumper" rel="nofollow noopener" translate="no" target="_blank">https://github.com/mydumper/mydumper</a>

Alvin Ashcraft 🐿️O’Reilly SQL and Databases eBook Bundle | Humble Bundle.<a href="https://www.humblebundle.com/books/sql-and-databases-oreilly-books?partner=morningdew" rel="nofollow noopener" translate="no" target="_blank">https://www.humblebundle.com/books/sql-and-databases-oreilly-books?partner=morningdew</a> <a href="https://hachyderm.io/tags/books" class="mention hashtag" rel="nofollow noopener" target="_blank">#books</a> <a href="https://hachyderm.io/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlserver</a> <a href="https://hachyderm.io/tags/data" class="mention hashtag" rel="nofollow noopener" target="_blank">#data</a> <a href="https://hachyderm.io/tags/ref" class="mention hashtag" rel="nofollow noopener" target="_blank">#ref</a> <a href="https://hachyderm.io/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://hachyderm.io/tags/humblebundle" class="mention hashtag" rel="nofollow noopener" target="_blank">#humblebundle</a> <a href="https://hachyderm.io/tags/ebook" class="mention hashtag" rel="nofollow noopener" target="_blank">#ebook</a> <a href="https://hachyderm.io/tags/deals" class="mention hashtag" rel="nofollow noopener" target="_blank">#deals</a> <a href="https://hachyderm.io/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#mysql</a>

0x0<a href="https://hachyderm.io/tags/AskFedi" class="mention hashtag" rel="nofollow noopener" target="_blank">#AskFedi</a> how do you implement <a href="https://hachyderm.io/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> migrations (both schema or data changes) in your app? Say, the new version needs a new table or a new register in an existing table?Can the end-user access that data or is it encrypted?Boosts appreciated. <a href="https://hachyderm.io/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> <a href="https://hachyderm.io/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#MariaDB</a> <a href="https://hachyderm.io/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#Postgres</a> <a href="https://hachyderm.io/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> <a href="https://hachyderm.io/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a> <a href="https://hachyderm.io/tags/C" class="mention hashtag" rel="nofollow noopener" target="_blank">#C</a> <a href="https://hachyderm.io/tags/Cpp" class="mention hashtag" rel="nofollow noopener" target="_blank">#Cpp</a>

MathzyFirst steps into coming out of my comfort zone in IT and learning some new web stuff - just in case our contract is not renewed next April.Installed MySQL on my Linux PC. Took a bit of a faff with terminal commands and permissions, but finally got it working with MySQL Workbench as a GUI.I'm still not sure about the backend though? Do I go for Python or JavaScript? Both languages seem to be in demand at the moment.<a href="https://mastodon.green/tags/Linux" class="mention hashtag" rel="nofollow noopener" target="_blank">#Linux</a> <a href="https://mastodon.green/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> <a href="https://mastodon.green/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#Python</a> <a href="https://mastodon.green/tags/JavaScript" class="mention hashtag" rel="nofollow noopener" target="_blank">#JavaScript</a>

mortDatabase collates are ridiculous. Why would I want to *globally* configure a database's ordering rules? Either I care about presenting locale-appropriate orderings, in which case I need that to be configured PER APPLICATION USER, or I don't care, in which care just use whatever makes the most sense for performance/simplicity (probably ordering by byte value). I don't understand the use case for database-global collate settings. <a href="https://floss.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgresql</a> <a href="https://floss.social/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://floss.social/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#mysql</a> <a href="https://floss.social/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#databases</a> <a href="https://floss.social/tags/rdbms" class="mention hashtag" rel="nofollow noopener" target="_blank">#rdbms</a> <a href="https://floss.social/tags/programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#programming</a>

michabbb<a href="https://social.vivaldi.net/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> Generated Columns & Views in <a href="https://social.vivaldi.net/tags/Laravel" class="mention hashtag" rel="nofollow noopener" target="_blank">#Laravel</a> <a href="https://social.vivaldi.net/tags/php" class="mention hashtag" rel="nofollow noopener" target="_blank">#php</a> <a href="https://social.vivaldi.net/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#mysql</a> <a href="https://social.vivaldi.net/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://social.vivaldi.net/tags/performance" class="mention hashtag" rel="nofollow noopener" target="_blank">#performance</a> 🗄️🔧 Generated columns automatically calculate values from other columns using <a href="https://social.vivaldi.net/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> expressions - available as virtual (computed on query) or stored (saved to disk) ⚡ Unlike <a href="https://social.vivaldi.net/tags/Laravel" class="mention hashtag" rel="nofollow noopener" target="_blank">#Laravel</a> accessors, generated columns enable filtering, sorting & indexing at database level for superior performance 🔍 Example: Convert full_name accessor to generated column using CONCAT(first_name, ' ', last_name) in migrations🧵 👇

KarlHas your OS ever refused to install the MariaDB client package or the MySQL client package due to a conflict with the other?It feels like it should be possible to have both, but unfortunately I have yet to see a solution for this. For a subset of these cases, all that you want is just to have the client tools such as the mariadb/ mysql CLI and the mariadb-dumper/ mysqldumper backup programs co-existing on the same OS. (I.e. you don't care about the static/dynamic libmariadbclient/libmysqlclient libs etc). So, I decided to write up my solutions for this: <a href="https://dbdemon.com/installing_mariadb_and_mysql_clients_on_same_unix_host/" rel="nofollow noopener" translate="no" target="_blank">https://dbdemon.com/installing_mariadb_and_mysql_clients_on_same_unix_host/</a><a href="https://mastodon.bsd.cafe/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#mariadb</a> <a href="https://mastodon.bsd.cafe/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#mysql</a> <a href="https://mastodon.bsd.cafe/tags/pkg" class="mention hashtag" rel="nofollow noopener" target="_blank">#pkg</a> <a href="https://mastodon.bsd.cafe/tags/rpm" class="mention hashtag" rel="nofollow noopener" target="_blank">#rpm</a> <a href="https://mastodon.bsd.cafe/tags/packaging" class="mention hashtag" rel="nofollow noopener" target="_blank">#packaging</a>

House Panther :verified_paw:If anyone decided to set up <a href="https://goblackcat.social/tags/Nextcloud" class="mention hashtag" rel="nofollow noopener" target="_blank">#Nextcloud</a>, I've learned that it runs so much better on <a href="https://goblackcat.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> than <a href="https://goblackcat.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> or <a href="https://goblackcat.social/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#MariaDB</a>.

PaulGot Cobra working in Go for my db2xlsx project which exports a MySQL / MariaDB database structure to an Excel file.Benefits:Simplifies the parsing Allows for sub commands Supports mandatory argumentsThree issues closed as a result, and I'll be able to tackle two of the others based on the groundwork laid.<a href="https://github.com/godev-uk/db2xlsx" rel="nofollow noopener" translate="no" target="_blank">https://github.com/godev-uk/db2xlsx</a><a href="https://social.xk7.net/tags/golang" class="mention hashtag" rel="nofollow noopener" target="_blank">#golang</a> <a href="https://social.xk7.net/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> <a href="https://social.xk7.net/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#MariaDB</a>

Juan Bitsyo aprendí bases de datos a la mala, pero he ido mejorando mis conocimientos alrededor de ellas, comencé con <a href="https://mastodon.mx/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#mysql</a> y he pasado por varios dbms

Nextcloud 📱☁️💻Speaker confirmed for <a href="https://mastodon.xyz/tags/NextcloudConf25" class="mention hashtag" rel="nofollow noopener" target="_blank">#NextcloudConf25</a>! 🎤 Michael “Monty” Widenius, creator of <a href="https://mastodon.xyz/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> and co-founder of <a href="https://mastodon.xyz/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#MariaDB</a>, will be joining us in Berlin! Decades of <a href="https://mastodon.xyz/tags/OpenSource" class="mention hashtag" rel="nofollow noopener" target="_blank">#OpenSource</a> wisdom, from a true pioneer. 📅 Sept 27–28 📍 Berlin, Germany Tickets: <a href="https://nextcloud.com/conference-2025/" rel="nofollow noopener" translate="no" target="_blank">https://nextcloud.com/conference-2025/</a>

PaulToday's fun challenge:Can't export a MySQL database using MariaDB mysqldump because the tools have now diverged too farCan't install the MySQL mysqldump because it conflicts with the MariaDB oneCan't use the Docker MySQL image because it doesn't allow interaction (to provide the password)Can't use the Docker MySQL image with an environment variable because that's ignored when redirecting output to a file<a href="https://social.xk7.net/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> <a href="https://social.xk7.net/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#MariaDB</a>

Jon IppolitoPHP turned 30 last month. Why does this language that powers 75% of the web—including Facebook, Wikipedia, and WordPress—have such staying power? Find out by registering for this fall's DIG 540, UMaine's online course in building cultural databases.<a href="https://DigitalCuration.UMaine.edu" rel="nofollow noopener" translate="no" target="_blank">https://DigitalCuration.UMaine.edu</a><a href="https://digipres.club/tags/Archives" class="mention hashtag" rel="nofollow noopener" target="_blank">#Archives</a> <a href="https://digipres.club/tags/Collections" class="mention hashtag" rel="nofollow noopener" target="_blank">#Collections</a> <a href="https://digipres.club/tags/Data" class="mention hashtag" rel="nofollow noopener" target="_blank">#Data</a> <a href="https://digipres.club/tags/DigitalHumanities" class="mention hashtag" rel="nofollow noopener" target="_blank">#DigitalHumanities</a> <a href="https://digipres.club/tags/GLAM" class="mention hashtag" rel="nofollow noopener" target="_blank">#GLAM</a> <a href="https://digipres.club/tags/Libraries" class="mention hashtag" rel="nofollow noopener" target="_blank">#Libraries</a> <a href="https://digipres.club/tags/Museums" class="mention hashtag" rel="nofollow noopener" target="_blank">#Museums</a> <a href="https://digipres.club/tags/PHP" class="mention hashtag" rel="nofollow noopener" target="_blank">#PHP</a> <a href="https://digipres.club/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a>

:rss: Hacker NewsShow HN: DataRamen, a Fast SQL Explorer with Automatic Joins and Data Navigation <a href="https://dataramen.xyz/" rel="nofollow noopener" translate="no" target="_blank">https://dataramen.xyz/</a> <a href="https://rss-mstdn.studiofreesia.com/tags/ycombinator" class="mention hashtag" rel="nofollow noopener" target="_blank">#ycombinator</a> <a href="https://rss-mstdn.studiofreesia.com/tags/database_navigation_tool" class="mention hashtag" rel="nofollow noopener" target="_blank">#database_navigation_tool</a> <a href="https://rss-mstdn.studiofreesia.com/tags/no_code_sql_tool" class="mention hashtag" rel="nofollow noopener" target="_blank">#no_code_sql_tool</a> <a href="https://rss-mstdn.studiofreesia.com/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#mysql</a> <a href="https://rss-mstdn.studiofreesia.com/tags/postgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgreSQL</a> <a href="https://rss-mstdn.studiofreesia.com/tags/easy_data_access" class="mention hashtag" rel="nofollow noopener" target="_blank">#easy_data_access</a>

Recent searches

Search options

Administered by:

Server stats:

#mysql