Suchergebnisse für „MySQL“
Web scripts usually do one thing at a time which is quite good as long as there is not too much to do. But serving thousands of request per minute with thousands of source code lines per request starts getting challenging. Bon Jovi asked for help for web scripts some time ago by writing his song "(Whos gonna) work for the working man". Well, there are little chances that he had something else in mind, but who cares.
Typical Perl scripts (and others running as CGI-scripts) run and exit once they're done, but this isn't very efficient with medium or high request counts. Persistent solutions like FCGI and ModPerl avoid the additional interpreter loading and compiling phases, but start being challenging if any source file is changed.
DBI is the universal Perl database interface but it's using a so-called DBD driver module for each database type. I've been searching but didn't find a DBD module fitting my needs and so I started writing a new one.
Da schreibt man ganz ahnungslos an einem Blog-Post und plötzlich ist der Strom weg. Nicht bei mir, nein beim Server. Der Schock kam nach dem Reboot: Alle Blogartikel weg! Hilfe!
mySQL Date Bug: `date` >= '2012-03-01 00:00:00' is not the same as `date` >= '2012-3-01 00:00:00'
Mär 04
I'm loving it! Really, mySQL is an interesting creature. It's full of surprises and you never know what it'll do. There seems to be a date bug which took me only about an hour to find.
SQL hat viele Nachteile, aber einer der größten ist die Unsinnige Aufteilung zwischen der Erstellung und Veränderung eines Datensatzes. mySQL macht es dem genervten Programmiere mit MyISAM auch nicht leichter, denn Row-Locks oder Transaktionen werden nicht unterstützt. Aber ich schweife ab...
Huston, we have a problem. Our company's headquarter isn't in Huston, but anyway... we got inconsistent data between some mySQL tables. There is a cron job fixing such problems but usually only very few records need assistance, much less than 10 a week. Updating the script to find the newly discovery differences was less than a hour, but running it turned out impossible.
Software Developers need to think straight forward: Line 2 is executed after line 1, never before. But straight forward code isn't always good.
"Never change a running system" ist einer der Pfeiler, auf denen die IT-Welt erbaut ist. Jeder der schon einmal mit einem Computer zu tun hatte weiß, dass sich dieser Grundsatz nicht immer befolgen lässt, so auch heute Morgen.
It happend to PerlMonks, Sony and many others: A plain text password table was stolen from the database. Read this carefully to not become the next one on that list.
