Robert Giordano

Welcome to my Linkatopia. I like music, photography, drones, and welding. I'm currently rebuilding this entire site, and adding more cool features. See the blog!



Recent Posts

recent 25  |  50  |  100  |  favorite  |  all


MySQL 5.7 Reference Manual :: 12.20.3 MySQL Handling of GROUP BY

See changes in 5.7 that affect queries with GROUP BY

  | Oct 12, 2021

MySQL Performance: MyISAM vs InnoDB | Liquid Web

"Should I use InnoDB with WordPress, Magento or Joomla Sites? The short answer here is yes, in most cases."
See the rest of this article for details

  | Apr 16, 2021

Have the tables turned on NoSQL? - Stack Overflow Blog

Interesting comparison

  | Jan 21, 2021

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

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

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

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


Tags

less  |  more          column  |  group

2012 | 3d | 3d modeling | 3D Printing | 808 camera | A900 | Abandoned | Address Book | adobe | Advertising | affiliates | After Effects | agencies | alchemy | amazon | Android | animals | animation | Anime | Answers | antispam | Apache | apple | Architecture | Art | Articles | Artists | ASP | astrology | Atari | audio | automotive | backup | Banking | batteries | Blackberry | Blender | Blogs | Books | Books to read | Bridges | Business | business cards | cabinets | cad | calculators | Cameras | canon | Carpentry | Cars | CDR | Censorship | Chile Peppers | Chrome | cleaners | Clothing | Coffee | color | comcast | Comics | Communities | Computers | Condiments | conspiracy | Copyright | Covid | Covid19 | CPanel | credit cards | CSS | D200 | D800 | data recovery | DBeyer | DCMA | decor | Dell R710 | design tools | designers | DeviantArt | Dictionaries | Directories | DIY | Doctor Who | Domain Names | downloads | Dreaming | DVD | earplugs | Ebay | ebooks | ECommerce | economics | Edgar Allan Poe | Educational | Elden Ring | electronics | Email | engineering | Environmental | Epson 7600 | EV | EVO | Evony | F150 | Fiction | filmmaking | firefox | Flash | florida | Foamcore | Fonts | Food | Fort Lauderdale | Forums | Forza | Free Music | FreeBSD | fun | Funny | Furniture | Games | Gaming | GIFs | gimp | Glidecam | gmail | Google | gopro | Government | gps | graphics | Greedy Banks | Gun Control | guns | hackers | Hardware | Hats | HDR | Health | History | Hosting | Hotels | htaccess | Hurricane Stuff | hurricanes | Icons | IM Clients | Instagram | Interesting | Internet | Intervalometer | iOS | iPhone | IRL | iTunes | Ivermectin | Jenna Kellen | Jobs | Keyboards | kitchen | language | laptop bags | LED kits | LED lights | Legal | Legal Advice | Lenses | LG | Light Bulbs | Linkatopia | Linux | Literature | Local | Logic | LOL | lyrics | Mac | Mac OSX | Manjaro | Marketing | math | MBTI | me | Media | military | Misc | Mobile | mobile rack | Modeling | Movies | Movies to Watch | Music | Music Info | Music Resources | Myspace | MySQL | NASA | Nature | networks | News | nikon | numbers | nyc | obs | Occult | old | Online Orders | Open office | Orbital | panorama | paypal | People | personality | pet accessories | pets | Philosophy | phone numbers | phone spam | Photography | Photoshop | poetry | pokemon | Politics | Pompano Beach | Premiere | Printing | prius | PS3 | psychology | publishing | PWA | QR Codes | quadcopters | Quantum physics | Quotes | Raw Food | rc | Real Estate | Recipes | Reddit | Reference | regulator78xx | Rentals | repair | Restaurants | reviews | RSS | safety | scanning | schools | Science | Scion xD | scooters | screenplays | Search | Serial Killers | servers | services | shoes | Shopping | sleep | socks | Software | Solar Power | Solitaire | solo | Steampunk | Stock Music | Stock Photos | storage | streaming | Strippers | svg | Syma X1 | tattoo | technology | television | tesla | Textures | Tile Mosaic | Timelapse | Tools | touch screen | Toys | traffic signals | trailers | Trails | Travel | tshirts | Tutorials | twitch | Twitter | ufos | ultra | underwater | Unix | urbex | Utilities | Vegan | Vegetarian | vehicles | Video | Video Editing | Vintage | Vitamin C | wallpaper | weapons | Weather | Web Awards | Web Design | Web Dev | Web Standards | Web Telephony | WiFi | Wikipedia | Wildlife | windows | Windows server | wire | women | Wordlists | wordpress | WTC | YouTube |

Friends

This user's friend list is private.


CLOSE

 

 Saving...