All geek questions in one place

Recommended language for modifying MySQL database

I have a rather large MySQL database with various pieces of text. I need to slightly modify approximately 90% of all records using standard string manipulation algorithms and some regular expressions.

All my current database manipulation scripts are the PHP interfaces for the website. Language / technology recommendations for this?

Support for JSON encoding / decoding plus.

+3
source share
2 answers

Php works great with the command line, and if you have shared libraries that already use your database, you can reuse them.

+2
source

, run-once script, , , .

/ , /API, sysadmins/production, , .

Perl-DBI-Mysql , PHP | Python, , , , Ruby + Mysql. Perl , DBI , regex perl .

+1

Source: https://habr.com/ru/post/1734505/

More articles:


All Articles