#mysql
#mysql

Ruby on Rails

MySQL Databases and Python - Real Python

MySQL is highly popular for database management, especially for applications needing data access.

The course teaches integration of MySQL with Python for practical application use.

Ruby on Rails

Want Everyone Out of the Database? Here's How the Pros Do It | HackerNoon

Single-user mode is essential for performing critical database tasks without conflicts.

Transitioning back to multi-user mode is crucial after maintenance to restore normal operations.

fromRealpython

fromSitePoint Forums | Web Development & Design Community

Ruby on Rails

MySQL Databases and Python - Real Python

MySQL is highly popular for database management, especially for applications needing data access.

The course teaches integration of MySQL with Python for practical application use.

more#database-management

#php

fromSitePoint Forums | Web Development & Design Community

Web development

Php 7.4 mysqli prepare update not working htmlentities html tags

HTML tags in the description may not be updating due to input handling, not the mysqli prepared statement.

Web development

I created a Private Scheduling webapp. PHP mySQL. I would love some feedback

Seeking feedback on a PHP/mySQL band scheduling webapp.

Looking for UI and code improvement suggestions.

Curious about mobile compatibility, especially on Safari.

fromSitePoint Forums | Web Development & Design Community

JavaScript

Trying to display all records for a specific customer

To fetch all records for a customer, replace 'fetch' with 'fetchAll' in the PHP code.

JavaScript

Populating Spatial data via PHP

Understanding how to properly work with spatial data types in MySQL, especially using Point type for coordinates, is critical for effective database management.

fromO'Reilly Online Learning

7 months ago

JavaScript

PHP For loop with differents IDs

Use fetch_assoc() to iterate through the rows and access IDs directly.

9 months ago

JavaScript

Learning PHP, MySQL & JavaScript, 7th Edition

Learn to build interactive, data-driven websites using core technologies like PHP, MySQL, JavaScript, CSS, HTML5, jQuery, Node.js, and React, even with basic HTML knowledge.

fromSitePoint Forums | Web Development & Design Community

fromSitePoint Forums | Web Development & Design Community

Web development

Php 7.4 mysqli prepare update not working htmlentities html tags

HTML tags in the description may not be updating due to input handling, not the mysqli prepared statement.

Web development

I created a Private Scheduling webapp. PHP mySQL. I would love some feedback

Seeking feedback on a PHP/mySQL band scheduling webapp.

Looking for UI and code improvement suggestions.

Curious about mobile compatibility, especially on Safari.

fromSitePoint Forums | Web Development & Design Community

JavaScript

Trying to display all records for a specific customer

To fetch all records for a customer, replace 'fetch' with 'fetchAll' in the PHP code.

JavaScript

Populating Spatial data via PHP

Understanding how to properly work with spatial data types in MySQL, especially using Point type for coordinates, is critical for effective database management.

fromO'Reilly Online Learning

7 months ago

JavaScript

PHP For loop with differents IDs

Use fetch_assoc() to iterate through the rows and access IDs directly.

9 months ago

JavaScript

Learning PHP, MySQL & JavaScript, 7th Edition

Learn to build interactive, data-driven websites using core technologies like PHP, MySQL, JavaScript, CSS, HTML5, jQuery, Node.js, and React, even with basic HTML knowledge.

more#php

5 years ago

Artificial intelligence

LangChain Promised an Easy AI Interface for MySQL-Here's What It Really Took | HackerNoon

LangChain simplifies the process of querying databases with natural language, opening up access to users without specialized query knowledge.

SQL vs. NoSQL Explained: When to Use Which and Why It Matters to Modern Data Management

SQL databases manage structured data using tables and ensure data integrity through ACID properties.

Data science

SQL vs. NoSQL Explained: When to Use Which and Why It Matters to Modern Data Management

SQL and NoSQL databases are essential for modern data management.

SQL databases utilize predefined schemas and provide robust data integrity through ACID properties.

Scala

Testing MySQL in Spark: Fake It Till You Make It with H2!

MySQL is a reliable, open-source RDBMS ideal for structured data management and integrates with Apache Spark for seamless data operations.

Business intelligence

Uber Achieves Significant Storage Savings with MyRocks Differential Backups

Uber implemented a differential backup system that reduced storage costs by 70% for their databases. This was crucial after migrating to MyRocks.

fromSitePoint Forums | Web Development & Design Community

2 weeks ago

European startups

PlanetScale Vectors Now GA: MySQL's Missing Feature?

PlanetScale's new vector support integrates with MySQL, enhancing data storage and performance while eliminating the need for specialized databases.

Miscellaneous

Select data from a joined table with the newest date

By using a single query with JOIN and GROUP BY in MySQL, you can fetch current data and latest updates efficiently.

Data science

SQL vs. NoSQL Explained: When to Use Which and Why It Matters to Modern Data Management

SQL databases manage structured data using tables and ensure data integrity through ACID properties.

Data science

SQL vs. NoSQL Explained: When to Use Which and Why It Matters to Modern Data Management

SQL and NoSQL databases are essential for modern data management.

SQL databases utilize predefined schemas and provide robust data integrity through ACID properties.

Scala

Testing MySQL in Spark: Fake It Till You Make It with H2!

MySQL is a reliable, open-source RDBMS ideal for structured data management and integrates with Apache Spark for seamless data operations.

Business intelligence

Uber Achieves Significant Storage Savings with MyRocks Differential Backups

Uber implemented a differential backup system that reduced storage costs by 70% for their databases. This was crucial after migrating to MyRocks.

fromSitePoint Forums | Web Development & Design Community

2 weeks ago

European startups

PlanetScale Vectors Now GA: MySQL's Missing Feature?

PlanetScale's new vector support integrates with MySQL, enhancing data storage and performance while eliminating the need for specialized databases.

fromSitePoint Forums | Web Development & Design Community

Miscellaneous

Select data from a joined table with the newest date

By using a single query with JOIN and GROUP BY in MySQL, you can fetch current data and latest updates efficiently.

more#data-management

#sql-query

1 month ago

Miscellaneous

How can I make it get results ordered numerically, descending?

The SQL script for exporting data needs adjustments for proper ordering and syntax.

fromSitePoint Forums | Web Development & Design Community

3 months ago

Miscellaneous

Checking that today's date is the first Monday of the current year

On the first Monday of the year, the date range used in the query may lead to no results due to the start date being after the end date.

fromSitePoint Forums | Web Development & Design Community

1 month ago

Miscellaneous

How can I make it get results ordered numerically, descending?

The SQL script for exporting data needs adjustments for proper ordering and syntax.

fromSitePoint Forums | Web Development & Design Community

3 months ago

Miscellaneous

Checking that today's date is the first Monday of the current year

On the first Monday of the year, the date range used in the query may lead to no results due to the start date being after the end date.

This Code Change Sped Up MySQL Queries from 25 Minutes to 23 Seconds | HackerNoon

Dynamic partitioning in JDBC batch processing requires adjustments to include where_condition for improved performance.

10 months ago

JavaScript

Java JDBC connection string examples

Example JDBC connection strings for popular databases.

Java

This Code Change Sped Up MySQL Queries from 25 Minutes to 23 Seconds | HackerNoon

Dynamic partitioning in JDBC batch processing requires adjustments to include where_condition for improved performance.

fromSitePoint Forums | Web Development & Design Community

10 months ago

JavaScript

Java JDBC connection string examples

Example JDBC connection strings for popular databases.

JavaScript

MariaDB Introduces Open-Source Vector Preview, Aiming to Become Default MySQL Option

MariaDB 11.6 introduces public preview of vector search, aiming to outpace MySQL by offering open-source functionalities.

Digital life

Convert SQL code which works fine on MYSQL to MariaDB

MariaDB requires adjustments to certain SQL functions compared to MySQL.

fromSitePoint Forums | Web Development & Design Community

8 months ago

JavaScript

MariaDB Introduces Open-Source Vector Preview, Aiming to Become Default MySQL Option

MariaDB 11.6 introduces public preview of vector search, aiming to outpace MySQL by offering open-source functionalities.

Digital life

Convert SQL code which works fine on MYSQL to MariaDB

MariaDB requires adjustments to certain SQL functions compared to MySQL.

more#mariadb

DevOps

Runtime-Based Workload Characterization in DBMS Tuning | HackerNoon

Modern database management systems (DBMS) characterize workloads via runtime behavior metrics, enhancing performance analysis.

fromwww.infoq.com

6 months ago

DevOps

Uber Completes Major MySQL Fleet Upgrade, Boosting Performance and Security

Uber upgraded its MySQL database fleet from 5.7 to 8.0 to enhance performance while ensuring minimal disruption and data integrity.

fromDjangosnippets

7 months ago

Python

Python Django CRUD Example Tutorial

The article is a tutorial on CRUD operations in Django with MySQL and Bootstrap.

2 years ago

Scala

A MySQL database backup (mysqldump) shell script

Creating a simple MySQL database backup shell script using mysqldump on Linux servers.