eupolicy.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
This Mastodon server is a friendly and respectful discussion space for people working in areas related to EU policy. When you request to create an account, please tell us something about you.

Server stats:

192
active users

#mysql

2 posts2 participants0 posts today
Karl<p>Do you want MySQL with the best possible performance? Then stick to version 5.6, as long as you don't mind it's been EOL for 12 years. 5.7 also has better performance than newer versions, although not as good as 5.6. Some performance regressions are just not being fixed. </p><p><a href="https://smalldatum.blogspot.com/2025/08/sysbench-for-mysql-56-thru-94-on-small.html" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">smalldatum.blogspot.com/2025/0</span><span class="invisible">8/sysbench-for-mysql-56-thru-94-on-small.html</span></a></p><p>^^ Veteran database performance guru, Mark Callaghan, former tech lead for MySQL at Facebook and Google, is now an independent consultant who blogs about database benchmarking.</p><p>(For my own account as a MariaDB fanboy I must add that another option could be migrating to MariaDB which is a plug-in replacement for MySQL 5.6, as MariaDB has done a better job at avoiding and fixing performance regressions.) </p><p><a href="https://mastodon.bsd.cafe/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql</span></a> <a href="https://mastodon.bsd.cafe/tags/benchmarking" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>benchmarking</span></a></p>
Jon Ippolito<p>Feel like your collection website could be better but don't know the necessary tools? A few seats left in UMaine's online course in Digital Collections and Exhibitions starting 3 Sep, which teaches&nbsp; the fundamentals of getting your records in a database and putting them online <a href="https://DigitalCuration.UMaine.edu" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">DigitalCuration.UMaine.edu</span><span class="invisible"></span></a></p><p><a href="https://digipres.club/tags/Archives" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Archives</span></a> <a href="https://digipres.club/tags/Collections" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Collections</span></a> <a href="https://digipres.club/tags/Data" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Data</span></a> <a href="https://digipres.club/tags/DigitalCuration" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DigitalCuration</span></a> <a href="https://digipres.club/tags/Digitization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Digitization</span></a> <a href="https://digipres.club/tags/Museums" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Museums</span></a> <a href="https://digipres.club/tags/OnlineLearning" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OnlineLearning</span></a> <br><a href="https://digipres.club/tags/Archives" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Archives</span></a> <a href="https://digipres.club/tags/Collections" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Collections</span></a> <a href="https://digipres.club/tags/DigitalCuration" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DigitalCuration</span></a> <a href="https://digipres.club/tags/Digitization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Digitization</span></a> <a href="https://digipres.club/tags/GLAM" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GLAM</span></a> <a href="https://digipres.club/tags/Museums" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Museums</span></a> <a href="https://digipres.club/tags/OnlineLearning" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OnlineLearning</span></a> <a href="https://digipres.club/tags/PHP" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PHP</span></a> <a href="https://digipres.club/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> <a href="https://digipres.club/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Database</span></a></p>
CubeRootOfTrue<p><span class="h-card" translate="no"><a href="https://mathstodon.xyz/@MartinEscardo" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>MartinEscardo</span></a></span> 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.</p><p>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)</p><p><a href="https://mathstodon.xyz/tags/rm3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>rm3</span></a> <a href="https://mathstodon.xyz/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql</span></a> <a href="https://mathstodon.xyz/tags/relevance" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>relevance</span></a> <a href="https://mathstodon.xyz/tags/paraconsistent" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>paraconsistent</span></a></p>
BLACKVOID ⚫️<p>Doing a test <a href="https://mastodon.social/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql</span></a> to <a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgres</span></a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database</span></a> migration for my <a href="https://mastodon.social/tags/mattermost" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mattermost</span></a> instance. No pressure…</p><p>With version 11, that will be mandatory so might as well do it now. </p><p>Nothing like running migration tools in <a href="https://mastodon.social/tags/docker" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>docker</span></a> as well ;). </p><p>Let’s see how this will end up. </p><p><a href="https://mastodon.social/tags/chat" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>chat</span></a> <a href="https://mastodon.social/tags/selfhosting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>selfhosting</span></a> <a href="https://mastodon.social/tags/selfhosted" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>selfhosted</span></a></p>
Kamalavelan<p><span class="h-card" translate="no"><a href="https://mastodon.social/@patrickleavy" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>patrickleavy</span></a></span> Yeah doing that should be enough, but reading the docs they are specifying <a href="https://mastodon.xyz/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> as the 'only' supported version so would be better to specify it as mysql:8.4. I do run <a href="https://mastodon.xyz/tags/ghost" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ghost</span></a> on <a href="https://mastodon.xyz/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a> (due to lesser RAM) but I am anticipating some trouble for the version upgrade.</p>
Tokyo Outsider (337ppm)<p>2/2 ...</p><p>The top of the exported file has these lines: </p><p>CREATE DATABASE IF NOT EXISTS `databaseName` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;<br>USE `databaseName`;</p><p>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?</p><p><a href="https://mas.to/tags/backups" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>backups</span></a> <a href="https://mas.to/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>databases</span></a> <a href="https://mas.to/tags/InnoDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>InnoDB</span></a> <a href="https://mas.to/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> <a href="https://mas.to/tags/MySQL8" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL8</span></a> <a href="https://mas.to/tags/MySQLworkbench" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQLworkbench</span></a></p>
0x0<p><a href="https://hachyderm.io/tags/AskFedi" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>AskFedi</span></a> how do you implement <a href="https://hachyderm.io/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database</span></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?</p><p>Can the end-user access that data or is it encrypted?</p><p>Boosts appreciated. <br><a href="https://hachyderm.io/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> <a href="https://hachyderm.io/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a> <a href="https://hachyderm.io/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Postgres</span></a> <a href="https://hachyderm.io/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> <a href="https://hachyderm.io/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLite</span></a> <a href="https://hachyderm.io/tags/C" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>C</span></a> <a href="https://hachyderm.io/tags/Cpp" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Cpp</span></a></p>
Karl<p>Has your OS ever refused to install the MariaDB client package or the MySQL client package due to a conflict with the other?</p><p>It feels like it should be possible to have both, but unfortunately I have yet to see a solution for this. </p><p>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). </p><p>So, I decided to write up my solutions for this: <br><a href="https://dbdemon.com/installing_mariadb_and_mysql_clients_on_same_unix_host/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dbdemon.com/installing_mariadb</span><span class="invisible">_and_mysql_clients_on_same_unix_host/</span></a></p><p><a href="https://mastodon.bsd.cafe/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a> <a href="https://mastodon.bsd.cafe/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql</span></a> <a href="https://mastodon.bsd.cafe/tags/pkg" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pkg</span></a> <a href="https://mastodon.bsd.cafe/tags/rpm" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>rpm</span></a> <a href="https://mastodon.bsd.cafe/tags/packaging" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>packaging</span></a></p>
House Panther :verified_paw:<p>If anyone decided to set up <a href="https://goblackcat.social/tags/Nextcloud" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Nextcloud</span></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">#<span>PostgreSQL</span></a> than <a href="https://goblackcat.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> or <a href="https://goblackcat.social/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a>.</p>
Paul<p>Got Cobra working in Go for my db2xlsx project which exports a MySQL / MariaDB database structure to an Excel file.</p><p>Benefits:</p><p>Simplifies the parsing<br>Allows for sub commands<br>Supports mandatory arguments</p><p>Three issues closed as a result, and I'll be able to tackle two of the others based on the groundwork laid.</p><p><a href="https://github.com/godev-uk/db2xlsx" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">github.com/godev-uk/db2xlsx</span><span class="invisible"></span></a></p><p><a href="https://social.xk7.net/tags/golang" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>golang</span></a> <a href="https://social.xk7.net/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> <a href="https://social.xk7.net/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a></p>
Nextcloud 📱☁️💻<p>Speaker confirmed for <a href="https://mastodon.xyz/tags/NextcloudConf25" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NextcloudConf25</span></a>! </p><p> 🎤 Michael “Monty” Widenius, creator of <a href="https://mastodon.xyz/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> and co-founder of <a href="https://mastodon.xyz/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a>, will be joining us in Berlin! </p><p> Decades of <a href="https://mastodon.xyz/tags/OpenSource" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenSource</span></a> wisdom, from a true pioneer. <br> 📅 Sept 27–28 <br> 📍 Berlin, Germany </p><p> Tickets: <a href="https://nextcloud.com/conference-2025/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">nextcloud.com/conference-2025/</span><span class="invisible"></span></a></p>
Paul<p>Today's fun challenge:</p><p>Can't export a MySQL database using MariaDB mysqldump because the tools have now diverged too far</p><p>Can't install the MySQL mysqldump because it conflicts with the MariaDB one</p><p>Can't use the Docker MySQL image because it doesn't allow interaction (to provide the password)</p><p>Can't use the Docker MySQL image with an environment variable because that's ignored when redirecting output to a file</p><p><a href="https://social.xk7.net/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> <a href="https://social.xk7.net/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a></p>
{:ok, "Joel Jucá"}<p>I've used <a href="https://functional.cafe/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> before (last time was 2016, I think), but today I'm mostly onto <a href="https://functional.cafe/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Postgres</span></a> (and sometimes, <a href="https://functional.cafe/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLite</span></a>). I know PG is superior to MySQL is pretty much all aspect I could think of, but still, it seems that MySQL still has a quite big user base.</p><p>What's the catch? What am I missing here? Why would someone use MySQL over Postgres to build smt since Postgres [apparently] is better than MySQL in every single possible aspect?</p><p>It's a honest question. Please help me understand it – and perhaps, consider modern MySQL/MariaDB in next projects. :)</p>
Paul<p>TIL: The MySQL Docker image restarts the server after the initial data import, which means if you have enabled the query log using an SQL query it gets reset to being disabled.</p><p>If you enable the query log in the config file, this logs every query of the import.</p><p>So you have to:</p><p>1. Enable in config.<br>2. Disable using query before import.<br>3. When the server is restarted, the query log will be enabled.</p><p><a href="https://social.xk7.net/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a></p>
Sushil Kumar<p>Better experience and fast, secure way to create a connection with MariaDB.</p><p> // Config.php</p><p>$mariadb = ini_get('pdo_mysql.default_socket'); </p><p>$pdo = new PDO("mysql:unix_socket=$mariadb;dbname=test", 'root', '');</p><p>if($pdo){<br> echo "Database connection success!";<br>} </p><p><a href="https://mastodon.social/tags/php" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>php</span></a> <a href="https://mastodon.social/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a> <a href="https://mastodon.social/tags/pdo" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pdo</span></a> <a href="https://mastodon.social/tags/socket" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>socket</span></a> <a href="https://mastodon.social/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql</span></a> <a href="https://mastodon.social/tags/mysqli" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysqli</span></a> <a href="https://mastodon.social/tags/mysqlpdo" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysqlpdo</span></a></p>
Mike Lopez<p>Want smoother user experience in your PHP apps? Learn how I implement MySQL pagination without the bloat. Clean, scalable, and dev-friendly.<br><a href="https://mikelopez.com/blog/1118" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">mikelopez.com/blog/1118</span><span class="invisible"></span></a><br><a href="https://mastodon.social/tags/PHP" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PHP</span></a> <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> <a href="https://mastodon.social/tags/DevLife" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DevLife</span></a> <a href="https://mastodon.social/tags/Pagination" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Pagination</span></a> <a href="https://mastodon.social/tags/WebDevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>WebDevelopment</span></a> <a href="https://mastodon.social/tags/BasicPHP" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>BasicPHP</span></a></p>
SpaceLifeForm<p><span class="h-card" translate="no"><a href="https://infosec.exchange/@Tarah" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>Tarah</span></a></span> </p><p>The problems may have been there longer than reported.</p><p><a href="https://iu.service-now.com/status?id=iu_service_status&amp;service=BSN0001072&amp;date=2025-03-12" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">iu.service-now.com/status?id=i</span><span class="invisible">u_service_status&amp;service=BSN0001072&amp;date=2025-03-12</span></a></p><p><a href="https://infosec.exchange/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a></p>
Yasser Elgammal<p>Hey! I’m Yasser Elgammal a backend developer passionate about building clean, scalable solutions with Laravel</p><p>I share code, ideas, and open-source projects.</p><p>Check out my work on GitHub and let’s connect!<br><a href="https://github.com/YasserElgammal" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">github.com/YasserElgammal</span><span class="invisible"></span></a></p><p><a href="https://phpc.social/tags/github" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>github</span></a> <a href="https://phpc.social/tags/php" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>php</span></a> <a href="https://phpc.social/tags/laravel" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>laravel</span></a> <a href="https://phpc.social/tags/backend" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>backend</span></a> <br><a href="https://phpc.social/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql</span></a></p>
comrad 🇪🇺<p>Aktuell laufen in der Oracle University zwei Event an denen man kostenlos sein Wissen rund um Cloud, Datenbanken, DevOps aufbessern kann. Außerdem kann man kostenlose Voucher für Zertifizierungen erhalten.</p><p>Zum einen veranstaltet <a href="https://mastodon.social/tags/Oracle" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Oracle</span></a> erneut das Race To Certification-Event (bis Ende Oktober) und zum anderen findet im Rahmen des 30. Jubiläums von <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> ein ähnliches Event mit Kursen und Zertifikaten statt (bis Ende Juli)</p><p><a href="https://education.oracle.com/race-to-certification-2025" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">education.oracle.com/race-to-c</span><span class="invisible">ertification-2025</span></a></p><p><a href="https://education.oracle.com/mysql-promo" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">education.oracle.com/mysql-pro</span><span class="invisible">mo</span></a></p><p><a href="https://mastodon.social/tags/RaceToCertification" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>RaceToCertification</span></a></p>
Frazer Clement<p>History : Ericsson Review article about <a href="https://discuss.systems/tags/NdbCluster" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NdbCluster</span></a> development at Ericsson. Starts at page 167 (pdf page 179) 1997 volume 4 <br><a href="https://discuss.systems/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> <a href="https://discuss.systems/tags/DistributedSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DistributedSQL</span></a></p><p><a href="https://www.ericsson.com/4ac5c3/assets/local/about-ericsson/ericsson-history/lme-review/documents/da2011-35598-ericsson_review_vol_74_1997.pdf" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">ericsson.com/4ac5c3/assets/loc</span><span class="invisible">al/about-ericsson/ericsson-history/lme-review/documents/da2011-35598-ericsson_review_vol_74_1997.pdf</span></a></p>