Posts in: MySQL / Databases
- NYPHP Con: “Introduction to PDO”
- PDO ships with PHP 5.1. You do not need to install via PECL These are my notes from a presentation by Ilia Alshanetsky. This post may contain inaccuracies, typos, boo-boos, etc. PDO stands for “PHP Data Objects Layer”: A data-access abstraction layer. Common interface for any number of database systems PHP extension Designed to simplify features. Only available to PHP [...] [16 Jun 2006]
- NYPHP Con: “Maximum Velocity MySQL” - Benchmarking and Profiling
- Jay Pipes is the Community Relations Manager, North America for MySQL, Inc. This was a three-hour tutorial about ways to fine-tune your MySQL queries. This is part three of my notes. This post may contain inaccuracies, typos, boo-boos, etc. Jay says his slides will be available on his web site, so be sure to check [...] [14 Jun 2006]
- NYPHP Con: “Maximum Velocity MySQL” - Optimization and coding tips
- With Jay Pipes of MySQL. Jay Pipes is the Community Relations Manager, North America for MySQL, Inc. This was a three-hour tutorial about ways to fine-tune your MySQL queries. This is part two of my notes. This post may contain inaccuracies, typos, boo-boos, etc. Jay says his slides will be available on his web [...] [14 Jun 2006]
- NYPHP Con: “Maximum Velocity MySQL” - Indexes and storage engines
- With Jay Pipes of MySQL. Diversity stats, in case you’re wondering: Men: about 30. Women: 4. People of color: 4. Jay Pipes is the Community Relations Manager, North America for MySQL, Inc. This was a three-hour tutorial about ways to fine-tune your MySQL queries. This is part one of my notes. This post may contain inaccuracies, [...] [14 Jun 2006]
- One more way to use
COUNT(*) - Gavin adds a way to make your COUNT(*) query just a little bit cleaner for use in PHP: SELECT field_name, COUNT(*) AS total FROM table_name WHERE id > 3 GROUP BY field_name ORDER BY total ASC; The ‘AS total’ bit is a big deal because now COUNT(*) will become a key named ‘total’ in the array. So instead [...] [10 Mar 2005]
- Firefox Google searches, Gmail Atom feeds, and COUNT(*)-ing stuff in MySQL
- I found out by accident that you can do a Google “I’m Feeling Lucky” search right from the Firefox address bar. This is not the same as the search box to the right of the address bar.I’m talking about the same place where you type a URI to visit a site. Type in your search [...] [8 Mar 2005]
