Posts Tagged mysql
Upgrading Redmine From 8.6 to 9.3
After more than a year of using Redmine to help us manage our projects it was time to upgrade. Redmine helps us manage our bug lists, wish lists, and to do lists. It helps us communicate with our clients effectively and efficiently using a web based media in a consistent format that is easy to use for both our developers and our clients. However, during the past year there have been several changes including the significant upgrades that came out in v9.x some months back. Our busy schedule kept us from upgrading as each new release came out, and sadly we had fallen far behind. This past weekend we decided it was time to upgrade. The notes below record some of the problems we ran into and outlines how we resolved them. If ...
0 Comment | Posted in Project Management,Redmine,Task Management,Web Apps,applications,blog
April 25, 2010
Easy Documentation for Git, MySQL, PHP, et cetera
This is what I do on my box to quickly find documentation, which you guys may find helpful. Especially those of you on Linux---although you could do this on Windows too. Most package managers make available '-doc' packages, like php-doc, mysql-doc, and so on. Install these for all the major software you use. Next, install 'screen'. Now put this is your Bash config: # Displays various types of documentation. function doc() { case "$1" in 'llvm') screen -t 'LLVM Documentation' w3m /usr/share/doc/llvm-doc/html/index.html ;; 'erlang') screen -t 'Erlang Documentation' firefox /usr/share/doc/erlang-doc-html/html/doc/index.html ;; 'python') screen -t 'Python Documentation' w3m /usr/share/doc/python3-doc/html/index.html ;; 'php') screen -t 'PHP Documentation' w3m /usr/share/doc/php-doc/html/index.html ;; 'ghc') firefox /usr/share/doc/ghc6-doc/index.html & ;; 'postgresql') screen -t 'PostgreSQL Documentation' w3m /usr/share/doc/postgresql-doc-8.4/html/index.html ;; 'mysql') screen -t 'MySQL Documentation' w3m /usr/share/doc/mysql-doc-5.0/refman-5.0-en.html-chapter/index.html ;; 'apache') screen -t 'Apache Documentation' w3m /usr/share/doc/apache2-doc/manual/index.html ;; 'j') screen -t 'J Documentation' w3m ~/Software/j602/help/index.htm ;; 'lua') screen -t 'Lua Documentation' w3m /usr/share/doc/lua5.1-doc/doc/index.html ;; 'git') ...
0 Comment | Posted in Tips & Tricks,blog
January 22, 2010
Powerful Data Insertion Features in MySQL
There are several powerful techniques for getting your data into a MySQL database. MySQL supports non-standard extensions to SQL, giving you more flexibility in certain situations. If you want to take full advantage of MySQL, keep these tips in mind. The Problem Say you need to shove some new data into a table. Naturally, you want to INSERT. But it so happens that if the data is already there, you want to UPDATE the existing data. You don't care if you have to INSERT or UPDATE - you just want the new data in the table. You decide do one of two things. You might try DELETE FROM yourtable WHERE key='yourkey'; INSERT INTO yourtable (key, data1, data2) VALUES ('yourkey', 1, 2); This is simple and effective. You could also check to see if the record already exists, and if so, UPDATE. What you really wish you had is an "INSERT OR UPDATE" command. Allow me ...
Issues With MySQL
If I had my choice I'd ALWAYS choose PostgreSQL over MySQL every time. It is a stronger, more reliable, more robust database engine without question. So why do I even think about MySQL, ever? Because I have to. It is my job to know technology and, unfortunately for the industry at large, MySQL is the defacto standard for nearly every open source web application in existence. The very predominance of MySQL does not make it better, just a necessary evil that we have to deal with every day. Unfortunately the pure power of numbers often forces us to create new systems in MySQL just for the sake of simplicity on our client systems. The Complaints List So why do I dislike MySQL so much? There are a number of reasons. Granted, MySQL has done a good job in the ...