rob215
Its 2018 and I still use this site almost every day. Eventually I'll rebuild it into an HTML5 app. I like music, photography, drones, and welding.
[add to friends|email]
rob215's
feed
Tags
view: column | group | hide
Friends
Invite a Friend
MySQL 
Database programming
- How to back up MySQL databases from the command line in Linux - TechRepublic
- | Dec 28, 2018
- How can I check if a MySQL table exists with PHP? - Stack Overflow
- Even though this isn't the accepted answer, it looks like the best:
if(mysql_query("DESCRIBE [table]")) { - | Jun 14, 2016
- The big, bad thread of "MySQL Best Practices and Other Useful Information" - Dat
- Good stuff in here
- | May 11, 2016
- MySQL: IN Condition
- WHERE some-text-column IN ('aaa','bbb','ccc')
WHERE some-int-column IN (1,2,3) - | May 11, 2016
- mysql - How can I prevent SQL-injection in PHP? - Stack Overflow
- See two answers from user "Your Common Sense"
- | Feb 21, 2016
- The Hitchhiker's Guide to SQL Injection prevention
- | Feb 21, 2016
- MySQL :: MySQL 5.5 Reference Manual :: 2.11.1.1 Changes Affecting Upgrades to 5.
- Upgrading to MySQL 5.5 from earlier versions
- | Dec 23, 2015
- performance - which mysql version to use - 5.1 or 5.5? - Database Administrators
- | Dec 23, 2015
- 10 reasons to migrate to MariaDB (if still using MySQL) - Seravo
- | May 20, 2015
- NoSQL - Wikipedia, the free encyclopedia
- | Jun 5, 2013
- 10 Tips for Optimizing MySQL Queries (That don't suck)
- good article with some basics
- | Sep 16, 2009
- Survive heavy traffic with your webserver
- Good tips to follow for mysql optimization
- | Sep 16, 2009
- Database Abstraction Layers Must Die! (by Jeremy Zawodny)
- The first article I read on abstraction layers
- | Apr 9, 2008
- Annotations to "Five Common PHP database problems" - MySQL-dump
- The second article I read, somewhat related but also lists some schemas I need to read up on.
- | Apr 9, 2008
- Four types of database abstraction layers at Xaprb
- A third article with links to the other articles
- | Apr 9, 2008
- Cheat Sheets - ILoveJackDaniels.com
- A bunch of nice cheat sheets and quick reference charts in PDF format.
- | Feb 26, 2008
- codepoetry - Optimizing a VPS for Getting Dugg
- Notes on Apache and MySQL optimization.
- | May 29, 2007
- Searching with PHP and MySQL
- | Nov 6, 2006
- MySQL 3.23, 4.0, 4.1 Reference Manual
- | May 5, 2006
- Simple Machines - SMF: Free PHP and MySQL forum software
- | May 4, 2006
- Database MySQL Optimize MySQL tables for speed Tutorial
- | May 3, 2006
- | Dec 31, 1969
- | Dec 31, 1969
- | Dec 31, 1969
- | Dec 31, 1969